| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP34A: Advanced Planning & Scheduling |
| 1 | F34A40 | APS Integration Group Setup Table | 18 | N0 | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP40: Inventory/OP Base |
| 2 | F40320 | Preference Profile - Multi Shipping/Receiving Locations | 33 | LP | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 3 | F40320R | Preference Resolution Ledger - Multi ShiP/Rec Locations | 34 | LP | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP41: Inventory Management |
| 4 | F4101 | Item Master | 23 | IM | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 5 | F4101C | Item Category Codes | 25 | IM | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 6 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 38 | SZ | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 7 | F4102 | Item Branch File | 20 | IB | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 8 | F41UI001 | Inventory Transactions Detail File | 64 | IT | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP41F: Apparel Management |
| 9 | FCW08 | Category Codes Work File | 23 | WK | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 10 | FCW10 | Item Branch Work File | 48 | WB | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 11 | FCW96 | Material Analysis | 30 | WO | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 12 | FCW97 | Grouping Messages | 30 | GM | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP46: Warehouse Management |
| 13 | F46011 | Item Unit Of Measure Definition | 2 | IQ | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 14 | F46013 | Carton Recommendation Rules | 3 | EQ | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 15 | F460131 | Standard Pack Recommendation Rules | 5 | SP | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 16 | F46024 | Location Capacity | 3 | LC | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 17 | F4611 | Warehouse Suggestions | 83 | R2 | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 18 | F4611PU | Warehouse Suggestions - Purged | 82 | R2 | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| 19 | F4611Z1 | Unedited Suggestion Table | 94 | SZ | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP46L: License Plating |
| 20 | F46LUI01 | Assign/Remove Items To LP Work File | 41 | WF | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP47: Electronic Commerce |
| 21 | F47082 | EDI Price Sales Catalog Detail - Inbound | 37 | FY | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOP89: Conversion Programs |
| 22 | F46011T | OBSOLETE - Item Unit Of Measure Definition Tag File | 2 | IQ | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
| TOPF30L: DFM Line Design |
| 23 | FF30L501 | DFM Item Definition Master | 23 | IB | PRP6 | Group - Item Dimension | String | UDC | 6 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
