| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP37: Quality Management |
1 | F3703 | Non-Conforming Material | 19 | QE | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
2 | F3711 | Test Results | 65 | TR | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
3 | F3711Z1 | Test Results Unedited Transaction Table | 78 | SZ | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
4 | F37900 | Certificate of Analysis (COA) Extract | 65 | TR | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
TOP38: Agreement Management |
5 | F38111 | Agreements Transaction Ledger | 24 | DZ | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
TOP40: Inventory/OP Base |
6 | F49211 | Sales Order Detail File - Tag File | 6 | UD | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
7 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 19 | S1 | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
8 | F49219 | Sales Order Detail - Tag History File | 6 | UD | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
TOP41B: Bulk Stock Management |
9 | F41511 | Bulk Product Transaction File | 73 | PA | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
TOP42: Sales Management |
10 | F42565 | Invoice Print File | 107 | IW | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
TOP42B: Sales Order Entry |
11 | F49299 | S.O. Detail Tag Ledger File | 6 | UD | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |
TOP49: Transportation Management |
12 | F4902 | Vehicle Current Load | 5 | TV | TRP | Trip Number | Numeric | Generic Edit | 8 | 0 |