| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F4201Z1 | Sales Order Header Unedited Transaction File | 143 | SY | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| TOP42: Sales Management |
| 2 | F4201 | Sales Order Header File | 133 | SH | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 3 | F4201 | Sales Order Header File | 132 | SH | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 4 | F42019 | Sales Order Header History File | 133 | SH | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 5 | F42019 | Sales Order Header History File | 132 | SH | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 6 | F4211 | Sales Order Detail File | 250 | SD | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 7 | F42119 | Sales Order History File | 250 | SD | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 8 | F42199 | S.O. Detail Ledger File | 250 | SL | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 9 | F42UI01 | SO Header Cache File (MBF) | 172 | ZH | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 10 | F42UI11 | SO Detail Cache File (MBF) | 181 | ZD | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| TOP42B: Sales Order Entry |
| 11 | F4211CZ1 | Sales Order Detail Unedited Transaction File - CRM | 18 | CZ | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 12 | F42420 | Audit Log Transaction | 110 | AL | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 13 | F47012T | EDI Purchase Order Detail Tag - Inbound | 63 | UZ | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 14 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 63 | UZ | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| TOP47: Electronic Commerce |
| 15 | F47011 | EDI Purchase Order Header - Inbound | 146 | SY | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 16 | F47131 | EDI Purchase Order Change Header - Inbound | 143 | SY | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| TOP90CB: CRM Sales Force Automation |
| 17 | F90CB020 | Opportunity Table | 11 | OT | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 18 | F90CB06B | Opportunity_For_Forecast Table | 12 | OF | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
| 19 | F90CB06Z | Opportunity for Forecast WTF | 13 | ZF | SHCCIDLN | Ship To Cust Contact Line Num ID | Numeric | Generic Edit | 5 | 0 |
