| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40306 | Preference Profile - Inventory Sourcing | 30 | SR | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 2 | F49211 | Sales Order Detail File - Tag File | 102 | UD | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 3 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 121 | S1 | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 4 | F49219 | Sales Order Detail - Tag History File | 79 | UD | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 5 | F4101 | Item Master | 162 | IM | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 6 | F4101A | Item File | 109 | IM | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 7 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 213 | SZ | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 8 | F4102 | Item Branch File | 136 | IB | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| TOP41F: Apparel Management |
| 9 | FCW09 | Item Revisions Work File | 49 | WR | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| 10 | FCW10 | Item Branch Work File | 107 | WB | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 11 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 123 | ZD | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| TOP42B: Sales Order Entry |
| 12 | F49299 | S.O. Detail Tag Ledger File | 102 | UD | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
| TOP46: Warehouse Management |
| 13 | F4600 | Warehouse Requests | 95 | R1 | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
