| 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 |
TOP42: Sales Management |
9 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 123 | ZD | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
10 | F42UI130 | Commitment Work File | 57 | ZC | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
TOP42B: Sales Order Entry |
11 | F49299 | S.O. Detail Tag Ledger File | 102 | UD | CMDM | Commitment Date Method | Character | UDC | 1 | 0 |
TOP46: Warehouse Management |
12 | 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.