AUCTVIEW
This view is deprecated and is provided for backward compatibility only.
Column Descriptions:
Name | 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. |