WebSphere Commerce database table: AUCTBIDVW
This view is a join of the AUCTVIEW and BID tables. The join is based on AUCT_ID and STORE_ID. For column descriptions, refer to either the AUCTVIEW or BID tables.
Column Descriptions Column Name Column Type Description AUCT_ID BIGINT NOT NULL From the AUCTVIEW table. AUREFCODE CHAR(36) NOT NULL From the AUCTVIEW table. REFCODE CHAR(36) NOT NULL From the AUCTVIEW table. AUTYPE CHAR(4) NOT NULL From the AUCTVIEW table. AUSTATUS CHAR(4) NOT NULL From the AUCTVIEW table. AUQUANT DOUBLE NOT NULL From the AUCTVIEW table. QUANTSCALE INTEGER From the AUCTVIEW table. RESRVPRICE DECIMAL (20,5) From the AUCTVIEW table. OPENPRICE DECIMAL (20,5) From the AUCTVIEW table. CURRPRICE DECIMAL (20,5) From the AUCTVIEW table. CURRQUANT DOUBLE From the AUCTVIEW table. CLOSEPR CHAR(4) From the AUCTVIEW table. CURRENCY CHAR(4) From the AUCTVIEW table. PAYMETHODS CHAR(254) From the AUCTVIEW table. CLOSETYPE INTEGER From the AUCTVIEW table. RULEPAGE VARCHAR(254) From the AUCTVIEW table. ITEMPAGE VARCHAR(254) From the AUCTVIEW table. STARTTIME TIMESTAMP From the AUCTVIEW table. ENDTIME TIMESTAMP From the AUCTVIEW table. REALENDTIME TIMESTAMP From the AUCTVIEW table. DURATION TIMESTAMP From the AUCTVIEW table. DEPOSIT DECIMAL (20,5) From the AUCTVIEW table. BESTBID_ID BIGINT From the AUCTVIEW table. HIGHBID_ID BIGINT From the AUCTVIEW table. LOCKFLAG INTEGER From the AUCTVIEW table. UPDATETIME TIMESTAMP From the AUCTVIEW table. LASTBKTIME TIMESTAMP From the AUCTVIEW table. PRECEDENCE INTEGER From the AUCTVIEW table. SUPPLIER_ID BIGINT From the AUCTVIEW table. BID_ID BIGINT NOT NULL From the BID table. BIDQUANT DOUBLE NOT NULL From the BID table. BIDPRICE DECIMAL (20,5) NOT NULL From the BID table. BIDTIME TIMESTAMP NOT NULL From the BID table. WINOPT CHAR(4) NOT NULL From the BID table. BIDSTATUS CHAR(4) NOT NULL From the BID table. PAYTYPE CHAR(64) NOT NULL From the BID table. ENCRYPT INTEGER NOT NULL From the BID table. DEVICE VARCHAR(64) NOT NULL From the BID table. EXPDATE TIMESTAMP NOT NULL From the BID table. AUTOBID_ID BIGINT From the BID table. BIDROOT BIGINT From the BID table. BKNAME VARCHAR(254) From the BID table. SHIPTO_ID BIGINT From the BID table. SHIPMODE INTEGER From the BID table. WINPRICE DECIMAL (20,5) From the BID table. WINQUANT DOUBLE From the BID table. BIDMSG VARCHAR(254) From the BID table. ADMIN_ID BIGINT From the AUCTVIEW table. OWNER_ID BIGINT NOT NULL From the AUCTVIEW table. STORE_ID INTEGER From the BID table. FIELD2 DECIMAL (20,5) From the AUCTVIEW table. FIELD1 BIGINT From the AUCTVIEW table. FIELD3 VARCHAR(254) From the AUCTVIEW table.