| 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 | 144 | SY | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| TOP42: Sales Management |
| 2 | F4201 | Sales Order Header File | 129 | SH | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 3 | F42019 | Sales Order Header History File | 129 | SH | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 4 | F4211 | Sales Order Detail File | 246 | SD | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 5 | F42119 | Sales Order History File | 246 | SD | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 6 | F42199 | S.O. Detail Ledger File | 247 | SL | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 7 | F42UI01 | SO Header Cache File (MBF) | 168 | ZH | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 8 | F42UI11 | SO Detail Cache File (MBF) | 177 | ZD | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| TOP42B: Sales Order Entry |
| 9 | F4211CZ1 | Sales Order Detail Unedited Transaction File - CRM | 17 | CZ | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 10 | F42420 | Audit Log Transaction | 106 | AL | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 11 | F47012T | EDI Purchase Order Detail Tag - Inbound | 60 | UZ | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 12 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 60 | UZ | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| TOP47: Electronic Commerce |
| 13 | F47011 | EDI Purchase Order Header - Inbound | 147 | SY | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
| 14 | F47131 | EDI Purchase Order Change Header - Inbound | 144 | SY | SPATTN | Ship To Attention | String | Generic Edit | 50 | 0 |
