AUCTIONLOG

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
AUCT_IDBIGINT NOT NULLReserved for IBM internal use.
ACTIONTIMETIMESTAMP NOT NULLReserved for IBM internal use.
ACTIONTYPEINTEGERReserved for IBM internal use.
AUCPAYINFO_IDBIGINTReserved for IBM internal use.
OWNER_IDBIGINTReserved for IBM internal use.
ADMIN_IDBIGINTReserved for IBM internal use.
MBRGRP_IDBIGINTReserved for IBM internal use.
FFMCENTER_IDINTEGERReserved for IBM internal use.
ACTIONMSGVARCHAR (254)Reserved for IBM internal use.
REFCODECHAR (36)Reserved for IBM internal use.
CATENTRY_IDBIGINTReserved for IBM internal use.
AUTYPECHAR (4)Reserved for IBM internal use.
AUSTATUSCHAR (4)Reserved for IBM internal use.
AUQUANTDOUBLEReserved for IBM internal use.
BIDRULE_IDBIGINTReserved for IBM internal use.
QUANTSCALEINTEGERReserved for IBM internal use.
RESRVPRICEDECIMAL (20,5)Reserved for IBM internal use.
OPENPRICEDECIMAL (20,5)Reserved for IBM internal use.
CURRPRICEDECIMAL (20,5)Reserved for IBM internal use.
CURRQUANTDOUBLEReserved for IBM internal use.
CLOSEPRCHAR (4)Reserved for IBM internal use.
CURRENCYCHAR (4)Reserved for IBM internal use.
PAYMETHODSCHAR (254)Reserved for IBM internal use.
CLOSETYPEINTEGERReserved for IBM internal use.
RULEPAGEVARCHAR (254)Reserved for IBM internal use.
STARTTIMETIMESTAMPReserved for IBM internal use.
ENDTIMETIMESTAMPReserved for IBM internal use.
DURATIONTIMESTAMPReserved for IBM internal use.
DEPOSITDECIMAL (20,5)Reserved for IBM internal use.
BESTBID_IDBIGINTReserved for IBM internal use.
LOCKFLAGINTEGERReserved for IBM internal use.
HIGHBID_IDBIGINTReserved for IBM internal use.
UPDATETIMETIMESTAMPReserved for IBM internal use.
LASTBKTIMETIMESTAMPReserved for IBM internal use.
REALENDTIMETIMESTAMPReserved for IBM internal use.
PRECEDENCEINTEGERReserved for IBM internal use.
FIELD1BIGINTReserved for IBM internal use.
RETRACT_BIDINTEGERReserved for IBM internal use.
FIELD2BIGINTReserved for IBM internal use.
FIELD3DECIMAL (20,5)Reserved for IBM internal use.
FIELD4DECIMAL (20,5)Reserved for IBM internal use.
FIELD5VARCHAR (254)Reserved for IBM internal use.
FIELD6VARCHAR (254)Reserved for IBM internal use.
SUPPLIER_IDBIGINTReserved for IBM internal use.
DURDAYSINTEGERReserved for IBM internal use.
REFPRICEDECIMAL (20,5)Reserved for IBM internal use.
STATEINTEGERReserved for IBM internal use.
INVRSRVIDBIGINTReserved for IBM internal use.
AUCMODECHAR (4)Reserved for IBM internal use.
PRICELIMITDECIMAL (20,5)Reserved for IBM internal use.
QUANTLIMITDOUBLEReserved for IBM internal use.
DURLENGTHINTEGERReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>AUCT_ID+ACTIONTIMEPrimary Key
I0000461ADMIN_IDNon-Unique Index
I0000462FFMCENTER_IDNon-Unique Index
I0000463OWNER_IDNon-Unique Index
I0000464MBRGRP_IDNon-Unique Index
I0001238AUCPAYINFO_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_87AUCPAYINFO_IDAUCPAYINFOAUCPAYINFO_IDCascade
F_88MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_89FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_90OWNER_IDMEMBERMEMBER_IDCascade
F_91ADMIN_IDMEMBERMEMBER_IDCascade