| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B85 | Weigh Tag Master | 62 | WT | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
TOP40: Inventory/OP Base |
2 | F40500 | Commodity Structure Definitions | 1 | CC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
3 | F40510 | UNSPSC and Commodity Structure Relationship | 4 | UC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
4 | F40520 | Supplier and Commodity Structure Relationship | 3 | SC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
5 | F40530 | Supplier Commodity Structure Cross Reference | 5 | SX | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
6 | F40540 | Item and Commodity Structure Relationship | 2 | IC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
7 | F40551 | G/L Account and Commodity Structure Relationship | 4 | GL | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
TOP43: Procurement |
8 | F4311 | Purchase Order Detail File | 213 | PD | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
9 | F4311Z | Purchase Order Generator File | 234 | PW | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
10 | F43199 | P.O. Detail Ledger File - Flexible Version | 214 | OL | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
TOP43C: Contracts |
11 | F43C01 | Contract Header | 22 | CH | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
12 | F43C010 | Contract Header Profile | 32 | HP | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
13 | F43C10 | Contract Block | 11 | CB | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
14 | F43C100 | Contract Block Profile | 20 | BP | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
15 | F43C11 | Contract Detail | 12 | CD | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
16 | F43C110 | Contract Harvest Profile | 8 | DP | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
TOP43E: Requisition Self Service |
17 | F43E09 | F43E09 - Approvals Activity Table | 19 | AA | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
18 | F43E095 | Approval Authority (Commodity/BU) | 1 | AC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
19 | F43E11 | Requisition Detail | 33 | RD | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
20 | F43E20 | Shopping Cart Detail | 6 | SC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
21 | F43E20WF | eReq - Shopping Cart Work File | 5 | SW | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
TOP43Q: Strategic Sourcing |
22 | F43Q10 | Event Header | 59 | EH | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
23 | F43Q11 | Event Detail | 52 | ED | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
24 | F43Q21 | Event Detail Bid Questions | 40 | ED | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
25 | F43Q41 | Response Line | 14 | RB | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
26 | F43Q60 | Bid Questions | 2 | BQ | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
27 | F43Q61 | Bid Question List Values | 2 | BV | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |
28 | F43Q62 | Bid Question Price Component | 2 | BC | CMDCDE | Commodity Code | String | Generic Edit | 15 | 0 |