WebSphere Commerce database table: AUCTVIEW

This view is a join of the AUCTION and AUCTSTREL tables. The join is based on AUCT_ID. For column descriptions, refer to either the AUCTION or AUCTSTREL tables.

Column Descriptions
Column Name Column Type Description
REFCODE CHAR(36) NOT NULL From the AUCTION table.
AUTYPE CHAR(4) NOT NULL From the AUCTION table.
AUSTATUS CHAR(4) NOT NULL From the AUCTION table.
AUQUANT DOUBLE NOT NULL From the AUCTION table.
QUANTSCALE INTEGER From the AUCTION table.
RESRVPRICE DECIMAL (20,5) From the AUCTION table.
OPENPRICE DECIMAL (20,5) From the AUCTION table.
CURRPRICE DECIMAL (20,5) From the AUCTION table.
CURRQUANT DOUBLE From the AUCTION table.
CLOSEPR CHAR(4) From the AUCTION table.
CURRENCY CHAR(4) From the AUCTION table.
PAYMETHODS CHAR(254) From the AUCTION table.
CLOSETYPE INTEGER From the AUCTION table.
RULEPAGE VARCHAR(254) From the AUCTION table.
STARTTIME TIMESTAMP From the AUCTION table.
ENDTIME TIMESTAMP From the AUCTION table.
REALENDTIME TIMESTAMP From the AUCTION table.
DURATION TIMESTAMP From the AUCTION table.
DEPOSIT DECIMAL (20,5) From the AUCTION table.
BESTBID_ID BIGINT From the AUCTION table.
HIGHBID_ID BIGINT From the AUCTION table.
LOCKFLAG INTEGER From the AUCTION table.
UPDATETIME TIMESTAMP From the AUCTION table.
LASTBKTIME TIMESTAMP From the AUCTION table.
PRECEDENCE INTEGER From the AUCTION table.
SUPPLIER_ID BIGINT From the AUCTION table.
FIELD1 BIGINT From the AUCTION table.
FIELD2 BIGINT From the AUCTION table.
FIELD3 DECIMAL (20,5) From the AUCTION table.
FIELD4 DECIMAL (20,5) From the AUCTION table.
FIELD5 VARCHAR(254) From the AUCTION table.
FIELD6 VARCHAR(254) From the AUCTION table.
ITEMPAGE VARCHAR(254) From the AUCTSTRREL auction-store relationship table.
AUCT_ID BIGINT NOT NULL From the AUCTION table.
RETRACT_BID INTEGER From the AUCTION table.
ADMIN_ID BIGINT From the AUCTION table.
OWNER_ID BIGINT NOT NULL From the AUCTION table.
FFMCENTER_ID INTEGER From the AUCTION table.
CATENTRY_ID BIGINT NOT NULL From the AUCTION table.
BIDRULE_ID BIGINT From the AUCTION table.
MBRGRP_ID BIGINT From the AUCTION table.
STORE_ID INTEGER NOT NULL From the AUCTSTRREL auction-store relationship table.
DURDAYS INTEGER From the AUCTION table.
REFPRICE DECIMAL (20,5) From the AUCTION table.
STATE INTEGER From the AUCTION table.
INVRSRVID BIGINT Inventory reservation ID.
AUCPAYINFO_ID BIGINT Reserved for IBM internal use.
AUCMODE CHAR(4) Reserved for IBM internal use.
PRICELIMIT DECIMAL (20,5) Reserved for IBM internal use.
QUANTLIMIT DOUBLE Reserved for IBM internal use.
DURLENGTH INTEGER Reserved for IBM internal use.
Related reference