AUCTIONLOG

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

Column Descriptions:

NameTypeDescription
AUCT_IDBIGINT NOT NULLReserved for HCL internal use.
ACTIONTIMETIMESTAMP NOT NULLReserved for HCL internal use.
ACTIONTYPEINTEGERReserved for HCL internal use.
AUCPAYINFO_IDBIGINTReserved for HCL internal use.
OWNER_IDBIGINTReserved for HCL internal use.
ADMIN_IDBIGINTReserved for HCL internal use.
MBRGRP_IDBIGINTReserved for HCL internal use.
FFMCENTER_IDINTEGERReserved for HCL internal use.
ACTIONMSGVARCHAR (254)Reserved for HCL internal use.
REFCODECHAR (36)Reserved for HCL internal use.
CATENTRY_IDBIGINTReserved for HCL internal use.
AUTYPECHAR (4)Reserved for HCL internal use.
AUSTATUSCHAR (4)Reserved for HCL internal use.
AUQUANTDOUBLEReserved 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.
DURATIONTIMESTAMPReserved for HCL internal use.
DEPOSITDECIMAL (20,5)Reserved for HCL internal use.
BESTBID_IDBIGINTReserved for HCL internal use.
LOCKFLAGINTEGERReserved for HCL internal use.
HIGHBID_IDBIGINTReserved for HCL internal use.
UPDATETIMETIMESTAMPReserved for HCL internal use.
LASTBKTIMETIMESTAMPReserved for HCL internal use.
REALENDTIMETIMESTAMPReserved for HCL internal use.
PRECEDENCEINTEGERReserved for HCL internal use.
FIELD1BIGINTReserved for HCL internal use.
RETRACT_BIDINTEGERReserved for HCL internal use.
FIELD2BIGINTReserved 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.
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_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