PROBINSTSSO_BIDLN_INDEXSSO_VNDR_INDEXAUC_TIER_NBRSSO_BID_PRICE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | SSO_BIDLN_INDEX |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Line Index |
| 3 | SSO_VNDR_INDEX |
Number(10,0) | DECIMAL(10) NOT NULL | Supplier Index |
| 4 | AUC_TIER_NBR |
Number(5,0) | INTEGER NOT NULL | Tier Number |
| 5 | AUC_BID_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Bid Quantity |
| 6 | AUC_BID_QTY_1 | Number(16,4) | DECIMAL(15,4) NOT NULL | Bid Quantity |
| 7 | AUC_PRICE | Number(17,5) | DECIMAL(16,5) NOT NULL | Event Start price |
| 8 | AUC_SCORE | Number(9,5) | DECIMAL(8,5) NOT NULL | Score |
| 9 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |