AUCTION

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

Column Descriptions:

NameTypeDescription
AUCT_IDBIGINT NOT NULLReserved for IBM internal use.
REFCODECHAR (36) NOT NULLReserved for IBM internal use.
AUCPAYINFO_IDBIGINTReserved for IBM internal use.
OWNER_IDBIGINT NOT NULLReserved for IBM internal use.
CATENTRY_IDBIGINT NOT NULLReserved for IBM internal use.
ADMIN_IDBIGINTReserved for IBM internal use.
FFMCENTER_IDINTEGERReserved for IBM internal use.
AUTYPECHAR (4) NOT NULLReserved for IBM internal use.
AUSTATUSCHAR (4) NOT NULLReserved for IBM internal use.
AUQUANTDOUBLE NOT NULLReserved 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.
REALENDTIMETIMESTAMPReserved for IBM internal use.
DURATIONTIMESTAMPReserved for IBM internal use.
DEPOSITDECIMAL (20,5)Reserved for IBM internal use.
BESTBID_IDBIGINTReserved for IBM internal use.
HIGHBID_IDBIGINTReserved for IBM internal use.
LOCKFLAGINTEGERReserved for IBM internal use.
UPDATETIMETIMESTAMPReserved for IBM internal use.
LASTBKTIMETIMESTAMPReserved for IBM internal use.
PRECEDENCEINTEGERReserved for IBM internal use.
FIELD1BIGINTReserved for IBM internal use.
FIELD2BIGINTReserved for IBM internal use.
RETRACT_BIDINTEGERReserved 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.
MBRGRP_IDBIGINTReserved 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_IDPrimary Key
I0000022REFCODEUnique Index
I0000023ENDTIMENon-Unique Index
I0000024REFPRICENon-Unique Index
I0000025STATENon-Unique Index
I0000026AUTYPENon-Unique Index
I0000027AUSTATUSNon-Unique Index
I0000028LOCKFLAGNon-Unique Index
I0000029UPDATETIMENon-Unique Index
I0000030LASTBKTIMENon-Unique Index
I0000031STARTTIMENon-Unique Index
I0000455BIDRULE_IDNon-Unique Index
I0000456ADMIN_IDNon-Unique Index
I0000457OWNER_IDNon-Unique Index
I0000458FFMCENTER_IDNon-Unique Index
I0000459CATENTRY_IDNon-Unique Index
I0000460MBRGRP_IDNon-Unique Index
I0001237AUCPAYINFO_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_80AUCPAYINFO_IDAUCPAYINFOAUCPAYINFO_IDCascade
F_81BIDRULE_IDCONTRLRULERULE_IDCascade
F_82MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_83CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_84FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_85OWNER_IDMEMBERMEMBER_IDCascade
F_86ADMIN_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_112AUCT_IDBIDAUCT_IDCascade
F_457AUCT_IDMEMBRAUCTAUCT_IDCascade
F_78AUCT_IDAUCTDESCAUCT_IDCascade
F_92AUCT_IDAUCTSTRRELAUCT_IDCascade
F_98AUCT_IDAUTOBIDAUCT_IDCascade