| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP17: Customer Service Management |
1 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 110 | WS | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP40: Inventory/OP Base |
2 | F30026 | Item Cost Component Add-Ons | 9 | IE | LOTG | Lot Grade | String | UDC | 3 | 0 |
3 | F4106 | Item Base Price File | 10 | BP | LOTG | Lot Grade | String | UDC | 3 | 0 |
4 | F4108 | Lot Master | 14 | IO | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP41: Inventory Management |
5 | F4105 | Item Cost File | 7 | CO | LOTG | Lot Grade | String | UDC | 3 | 0 |
6 | F4105Z1 | Unedited Transaction Table - Item Cost | 20 | SZ | LOTG | Lot Grade | String | UDC | 3 | 0 |
7 | F4111 | Item Ledger File | 16 | IL | LOTG | Lot Grade | String | UDC | 3 | 0 |
8 | F41UI001 | Inventory Transactions Detail File | 34 | IT | LOTG | Lot Grade | String | UDC | 3 | 0 |
9 | F41UI002 | Inventory Transactions Batch File | 13 | TI | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP41F: Apparel Management |
10 | FCW11 | Item Base Price File Work File | 9 | WP | LOTG | Lot Grade | String | UDC | 3 | 0 |
11 | FCW12 | Item Cost File Work File | 7 | WC | LOTG | Lot Grade | String | UDC | 3 | 0 |
12 | FCW22 | Lot Master Work File | 14 | WL | LOTG | Lot Grade | String | UDC | 3 | 0 |
13 | FCW65 | Work Order Header for Style Items | 81 | OF | LOTG | Lot Grade | String | UDC | 3 | 0 |
14 | FCW85 | Item Cost Component Add Ons Work File | 10 | IE | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP43: Procurement |
15 | F43121 | Purchase Order Receiver File | 20 | PR | LOTG | Lot Grade | String | UDC | 3 | 0 |
16 | F43121Z | Receiver workfile | 25 | PW | LOTG | Lot Grade | String | UDC | 3 | 0 |
17 | F43121Z1 | Receipts Unedited Transaction Table | 37 | SZ | LOTG | Lot Grade | String | UDC | 3 | 0 |
18 | F4314Z | Voucher Match Selection File | 119 | PN | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP45: Advanced Pricing |
19 | F4574 | Key Reference Table | 11 | KR | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP46: Warehouse Management |
20 | F4611 | Warehouse Suggestions | 56 | R2 | LOTG | Lot Grade | String | UDC | 3 | 0 |
21 | F4611PU | Warehouse Suggestions - Purged | 55 | R2 | LOTG | Lot Grade | String | UDC | 3 | 0 |
22 | F4611Z1 | Unedited Suggestion Table | 68 | SZ | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP47: Electronic Commerce |
23 | F47082 | EDI Price Sales Catalog Detail - Inbound | 65 | FY | LOTG | Lot Grade | String | UDC | 3 | 0 |
24 | F47122 | EDI Product Activity Data Detail - Inbound | 35 | MJ | LOTG | Lot Grade | String | UDC | 3 | 0 |
25 | F47127 | EDI Product Activity Data Detail - Outbound | 35 | MJ | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP48: Work Order Processing |
26 | F4801 | Work Order Master File | 91 | WA | LOTG | Lot Grade | String | UDC | 3 | 0 |
27 | F4801S | Purge - Work Order Master file | 91 | WA | LOTG | Lot Grade | String | UDC | 3 | 0 |
28 | F4801Z1 | Outbound Work Order Header | 110 | SY | LOTG | Lot Grade | String | UDC | 3 | 0 |
29 | F48UI001 | X4801 Master Business Function Workfile | 94 | WA | LOTG | Lot Grade | String | UDC | 3 | 0 |
TOP76H: Chile |
30 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 16 | AL | LOTG | Lot Grade | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.