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. |