| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F4104 | Item Cross Reference File | 30 | IV | CARDNO | Card Number | String | UDC | 4 | 0 |
| 2 | F49211 | Sales Order Detail File - Tag File | 144 | UD | CARDNO | Card Number | String | UDC | 4 | 0 |
| 3 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 159 | S1 | CARDNO | Card Number | String | UDC | 4 | 0 |
| 4 | F49219 | Sales Order Detail - Tag History File | 117 | UD | CARDNO | Card Number | String | UDC | 4 | 0 |
| TOP40R: Demand Scheduling |
| 5 | F40R11 | Demand Detail | 89 | DD | CARDNO | Card Number | String | UDC | 4 | 0 |
| 6 | F40R41 | Demand History | 95 | DI | CARDNO | Card Number | String | UDC | 4 | 0 |
| 7 | F47172 | EDI Demand Detail | 98 | ED | CARDNO | Card Number | String | UDC | 4 | 0 |
| TOP42: Sales Management |
| 8 | F42565 | Invoice Print File | 179 | IW | CARDNO | Card Number | String | UDC | 4 | 0 |
| 9 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 130 | ZD | CARDNO | Card Number | String | UDC | 4 | 0 |
| TOP47: Electronic Commerce |
| 10 | F470371 | EDI Shipping Notice Detail - Outbound | 244 | SZ | CARDNO | Card Number | String | UDC | 4 | 0 |
| 11 | F470472 | EDI Invoice Expanded Detail (Sales) | 82 | S6 | CARDNO | Card Number | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
