PROBINSTSSO_BIDLN_INDEXSSO_VNDR_INDEXSSO_FIXSSOD_AWARD(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 | SSO_FIX |
Number(3,0) | SMALLINT NOT NULL | Fix the award |
| 5 | SSO_VNDR_QTY | Number(17,6) | DECIMAL(16,6) NOT NULL | Award Quantity |
| 6 | AUC_PRICE | Number(17,5) | DECIMAL(16,5) NOT NULL | Event Start price |
| 7 | AUC_AWARD_PRICE | Number(16,4) | DECIMAL(15,4) NOT NULL | Total Awarded Price |
| 8 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |