AUCTION

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

Column Descriptions:

NameTypeDescription
AUCT_IDBIGINT NOT NULLReserved for HCL internal use.
REFCODECHAR (36) NOT NULLReserved for HCL internal use.
AUCPAYINFO_IDBIGINTReserved for HCL internal use.
OWNER_IDBIGINT NOT NULLReserved for HCL internal use.
CATENTRY_IDBIGINT NOT NULLReserved for HCL internal use.
ADMIN_IDBIGINTReserved for HCL internal use.
FFMCENTER_IDINTEGERReserved for HCL internal use.
AUTYPECHAR (4) NOT NULLReserved for HCL internal use.
AUSTATUSCHAR (4) NOT NULLReserved for HCL internal use.
AUQUANTDOUBLE NOT NULLReserved for HCL internal use.
BIDRULE_IDBIGINTReserved for HCL internal use.
QUANTSCALEINTEGERReserved for HCL internal use.
RESRVPRICEDECIMAL (20,5)Reserved for HCL internal use.
OPENPRICEDECIMAL (20,5)Reserved for HCL internal use.
CURRPRICEDECIMAL (20,5)Reserved for HCL internal use.
CURRQUANTDOUBLEReserved for HCL internal use.
CLOSEPRCHAR (4)Reserved for HCL internal use.
CURRENCYCHAR (4)Reserved for HCL internal use.
PAYMETHODSCHAR (254)Reserved for HCL internal use.
CLOSETYPEINTEGERReserved for HCL internal use.
RULEPAGEVARCHAR (254)Reserved for HCL internal use.
STARTTIMETIMESTAMPReserved for HCL internal use.
ENDTIMETIMESTAMPReserved for HCL internal use.
REALENDTIMETIMESTAMPReserved for HCL internal use.
DURATIONTIMESTAMPReserved for HCL internal use.
DEPOSITDECIMAL (20,5)Reserved for HCL internal use.
BESTBID_IDBIGINTReserved for HCL internal use.
HIGHBID_IDBIGINTReserved for HCL internal use.
LOCKFLAGINTEGERReserved for HCL internal use.
UPDATETIMETIMESTAMPReserved for HCL internal use.
LASTBKTIMETIMESTAMPReserved for HCL internal use.
PRECEDENCEINTEGERReserved for HCL internal use.
FIELD1BIGINTReserved for HCL internal use.
FIELD2BIGINTReserved for HCL internal use.
RETRACT_BIDINTEGERReserved for HCL internal use.
FIELD3DECIMAL (20,5)Reserved for HCL internal use.
FIELD4DECIMAL (20,5)Reserved for HCL internal use.
FIELD5VARCHAR (254)Reserved for HCL internal use.
MBRGRP_IDBIGINTReserved for HCL internal use.
FIELD6VARCHAR (254)Reserved for HCL internal use.
SUPPLIER_IDBIGINTReserved for HCL internal use.
DURDAYSINTEGERReserved for HCL internal use.
REFPRICEDECIMAL (20,5)Reserved for HCL internal use.
STATEINTEGERReserved for HCL internal use.
INVRSRVIDBIGINTReserved for HCL internal use.
AUCMODECHAR (4)Reserved for HCL internal use.
PRICELIMITDECIMAL (20,5)Reserved for HCL internal use.
QUANTLIMITDOUBLEReserved for HCL internal use.
DURLENGTHINTEGERReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL 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