| 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.
TOPUDC 40R / CD (Card Number) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | M380 | Initial/Spot Purchase | | N |
| 3 | M381 | Raw Material | | N |
| 4 | M382 | Steel | | N |
| 5 | M390 | North America Parts | | N |
| 6 | M391 | Supplemental | | N |
| 7 | M394 | Supply Parts | | N |
| 8 | M395 | Transportation | | N |
| 9 | M621 | Tier 1 of Direct Supply | | N |
| 10 | M622 | Tier 2 of Direct Supply | | N |
| 11 | M640 | Office Supplies | | N |
| 12 | MA02 | Returns | | N |
| 13 | MD99 | MD's Supply | | N |
