| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40241 | UNSPSC Commodity Code | 1 | CD | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
2 | F40243 | Commodity Relationship | 4 | CR | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
3 | F40510 | UNSPSC and Commodity Structure Relationship | 1 | UC | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
4 | F40540 | Item and Commodity Structure Relationship | 3 | IC | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
TOP43: Procurement |
5 | F4311 | Purchase Order Detail File | 212 | PD | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
6 | F4311Z | Purchase Order Generator File | 233 | PW | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
7 | F43199 | P.O. Detail Ledger File - Flexible Version | 215 | OL | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
TOP43E: Requisition Self Service |
8 | F43E11 | Requisition Detail | 16 | RD | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
9 | F43E20 | Shopping Cart Detail | 17 | SC | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |
10 | F43E20WF | eReq - Shopping Cart Work File | 14 | SW | UNSPSC | UNSPSC Commodity Code | String | Generic Edit | 8 | 0 |