| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40320 | Preference Profile - Multi Shipping/Receiving Locations | 34 | LP | EQTY | Container Code | String | UDC | 5 | 0 |
2 | F40320R | Preference Resolution Ledger - Multi ShiP/Rec Locations | 35 | LP | EQTY | Container Code | String | UDC | 5 | 0 |
3 | F4100 | Location Master | 23 | LM | EQTY | Container Code | String | UDC | 5 | 0 |
TOP40R: Demand Scheduling |
4 | F47UI002 | ASN Extract Packaging Work File | 43 | SP | EQTY | Container Code | String | UDC | 5 | 0 |
TOP41: Inventory Management |
5 | F4101 | Item Master | 146 | IM | EQTY | Container Code | String | UDC | 5 | 0 |
6 | F4101P | Item Master Packaging | 27 | IM | EQTY | Container Code | String | UDC | 5 | 0 |
7 | F4101T | Item Master Tag File | 18 | IM | EQTY | Container Code | String | UDC | 5 | 0 |
8 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 151 | SZ | EQTY | Container Code | String | UDC | 5 | 0 |
TOP42: Sales Management |
9 | F4216 | SO Pack Confirm Detail | 13 | XD | EQTY | Container Code | String | UDC | 5 | 0 |
TOP46: Warehouse Management |
10 | F46011 | Item Unit Of Measure Definition | 20 | IQ | EQTY | Container Code | String | UDC | 5 | 0 |
11 | F46013 | Carton Recommendation Rules | 5 | EQ | EQTY | Container Code | String | UDC | 5 | 0 |
12 | F460131 | Standard Pack Recommendation Rules | 8 | SP | EQTY | Container Code | String | UDC | 5 | 0 |
13 | F46024 | Location Capacity | 6 | LC | EQTY | Container Code | String | UDC | 5 | 0 |
14 | F46026 | Allowed Containers by Location | 3 | AC | EQTY | Container Code | String | UDC | 5 | 0 |
15 | F46091 | Container and Carton Codes | 2 | ID | EQTY | Container Code | String | UDC | 5 | 0 |
16 | F46091T | Container and Carton Codes Tag File | 1 | ID | EQTY | Container Code | String | UDC | 5 | 0 |
17 | F46098 | Container Bill of Material | 2 | CB | EQTY | Container Code | String | UDC | 5 | 0 |
18 | F4611 | Warehouse Suggestions | 58 | R2 | EQTY | Container Code | String | UDC | 5 | 0 |
19 | F4611PU | Warehouse Suggestions - Purged | 57 | R2 | EQTY | Container Code | String | UDC | 5 | 0 |
20 | F4611Z1 | Unedited Suggestion Table | 70 | SZ | EQTY | Container Code | String | UDC | 5 | 0 |
21 | F4615 | Carton Recommendations | 5 | CR | EQTY | Container Code | String | UDC | 5 | 0 |
22 | F4620 | Carton Detail Information | 33 | CD | EQTY | Container Code | String | UDC | 5 | 0 |
23 | F4622 | Unusable Label Numbers | 5 | UL | EQTY | Container Code | String | UDC | 5 | 0 |
24 | F46UI15 | Carton Recommendations - Work File | 5 | RC | EQTY | Container Code | String | UDC | 5 | 0 |
TOP46L: License Plating |
25 | F46L001 | License Plate Numbering Constants | 7 | CL | EQTY | Container Code | String | UDC | 5 | 0 |
26 | F46L10 | License Plate Master | 4 | LM | EQTY | Container Code | String | UDC | 5 | 0 |
27 | F46L99 | License Plate History | 30 | LM | EQTY | Container Code | String | UDC | 5 | 0 |
28 | F46LUI02 | Work Table for Manual Build UOM Structure | 6 | LP | EQTY | Container Code | String | UDC | 5 | 0 |
29 | F46LUI03 | Assign/Remove Child LP Work File | 10 | WF | EQTY | Container Code | String | UDC | 5 | 0 |
TOP47: Electronic Commerce |
30 | F470375 | EDI ASN Packaging Detail | 21 | AK | EQTY | Container Code | String | UDC | 5 | 0 |
TOP49: Transportation Management |
31 | F49111 | Carton Detail Shipment Workfile | 12 | CD | EQTY | Container Code | String | UDC | 5 | 0 |
32 | F49140 | SSCC Print Label Workfile | 29 | BW | EQTY | Container Code | String | UDC | 5 | 0 |
33 | F49141 | Packing List Workfile | 22 | PW | EQTY | Container Code | String | UDC | 5 | 0 |
34 | F4943 | Shipment Pieces | 4 | SP | EQTY | Container Code | String | UDC | 5 | 0 |
TOP89: Conversion Programs |
35 | F4101TT | Temp Table Merge Xe F4101T to E9 F4101 | 17 | IX | EQTY | Container Code | String | UDC | 5 | 0 |
36 | F470375T | EDI ASN Packaging Detail Tag Table | 8 | AK | EQTY | Container Code | String | UDC | 5 | 0 |