AUCTVIEW

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

Column Descriptions:

NameTypeDescription
REFCODECHAR (36) NOT NULLFrom the AUCTION table.
AUTYPECHAR (4) NOT NULLFrom the AUCTION table.
AUSTATUSCHAR (4) NOT NULLFrom the AUCTION table.
AUQUANTDOUBLE NOT NULLFrom the AUCTION table.
QUANTSCALEINTEGERFrom the AUCTION table.
RESRVPRICEDECIMAL (20,5)From the AUCTION table.
OPENPRICEDECIMAL (20,5)From the AUCTION table.
CURRPRICEDECIMAL (20,5)From the AUCTION table.
CURRQUANTDOUBLEFrom the AUCTION table.
CLOSEPRCHAR (4)From the AUCTION table.
CURRENCYCHAR (4)From the AUCTION table.
PAYMETHODSCHAR (254)From the AUCTION table.
CLOSETYPEINTEGERFrom the AUCTION table.
RULEPAGEVARCHAR (254)From the AUCTION table.
STARTTIMETIMESTAMPFrom the AUCTION table.
ENDTIMETIMESTAMPFrom the AUCTION table.
REALENDTIMETIMESTAMPFrom the AUCTION table.
DURATIONTIMESTAMPFrom the AUCTION table.
DEPOSITDECIMAL (20,5)From the AUCTION table.
BESTBID_IDBIGINTFrom the AUCTION table.
HIGHBID_IDBIGINTFrom the AUCTION table.
LOCKFLAGINTEGERFrom the AUCTION table.
UPDATETIMETIMESTAMPFrom the AUCTION table.
LASTBKTIMETIMESTAMPFrom the AUCTION table.
PRECEDENCEINTEGERFrom the AUCTION table.
SUPPLIER_IDBIGINTFrom the AUCTION table.
FIELD1BIGINTFrom the AUCTION table.
FIELD2BIGINTFrom the AUCTION table.
FIELD3DECIMAL (20,5)From the AUCTION table.
FIELD4DECIMAL (20,5)From the AUCTION table.
FIELD5VARCHAR (254)From the AUCTION table.
FIELD6VARCHAR (254)From the AUCTION table.
ITEMPAGEVARCHAR (254)From the AUCTSTRREL auction-store relationship table.
AUCT_IDBIGINT NOT NULLFrom the AUCTION table.
RETRACT_BIDINTEGERFrom the AUCTION table.
ADMIN_IDBIGINTFrom the AUCTION table.
OWNER_IDBIGINT NOT NULLFrom the AUCTION table.
FFMCENTER_IDINTEGERFrom the AUCTION table.
CATENTRY_IDBIGINT NOT NULLFrom the AUCTION table.
BIDRULE_IDBIGINTFrom the AUCTION table.
MBRGRP_IDBIGINTFrom the AUCTION table.
STORE_IDINTEGER NOT NULLFrom the AUCTSTRREL auction-store relationship table.
DURDAYSINTEGERFrom the AUCTION table.
REFPRICEDECIMAL (20,5)From the AUCTION table.
STATEINTEGERFrom the AUCTION table.
INVRSRVIDBIGINTInventory reservation ID.
AUCPAYINFO_IDBIGINTReserved 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.