| 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 | 141 | SY | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| TOP42: Sales Management |
| 2 | F4201 | Sales Order Header File | 132 | SH | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 3 | F42019 | Sales Order Header History File | 132 | SH | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 4 | F4211 | Sales Order Detail File | 249 | SD | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 5 | F42119 | Sales Order History File | 249 | SD | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 6 | F42199 | S.O. Detail Ledger File | 249 | SL | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 7 | F42UI01 | SO Header Cache File (MBF) | 171 | ZH | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 8 | F42UI11 | SO Detail Cache File (MBF) | 180 | ZD | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| TOP42B: Sales Order Entry |
| 9 | F4211CZ1 | Sales Order Detail Unedited Transaction File - CRM | 16 | CZ | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 10 | F42420 | Audit Log Transaction | 109 | AL | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 11 | F47012T | EDI Purchase Order Detail Tag - Inbound | 61 | UZ | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 12 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 61 | UZ | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| TOP47: Electronic Commerce |
| 13 | F47011 | EDI Purchase Order Header - Inbound | 144 | SY | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 14 | F47131 | EDI Purchase Order Change Header - Inbound | 141 | SY | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| TOP90CB: CRM Sales Force Automation |
| 15 | F90CB020 | Opportunity Table | 9 | OT | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 16 | F90CB06B | Opportunity_For_Forecast Table | 10 | OF | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
| 17 | F90CB06Z | Opportunity for Forecast WTF | 11 | ZF | CCIDLN | Customer Contact Line Number ID | Numeric | Generic Edit | 5 | 0 |
