| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP04: Accounts Payable |
1 | F0411Z1 | Voucher Transactions - Batch Upload | 95 | VL | UM | Unit of Measure | String | UDC | 2 | 0 |
TOP05T: Time Entry |
2 | F06116Z1 | Employee Transactions - Batch File | 44 | VL | UM | Unit of Measure | String | UDC | 2 | 0 |
TOP40: Inventory/OP Base |
3 | F4011Z | Batch Receiver File - Order Details | 162 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
4 | F4012ZW | WF - Destination Quantity | 38 | SP | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
5 | F4211Z1 | Sales Order Detail Unedited Transaction File | 149 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP42: Sales Management |
6 | F4020 | Freight/Additional Charges Rate Information | 25 | AR | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
7 | F4211 | Sales Order Detail File | 136 | SD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
8 | F42119 | Sales Order History File | 136 | SD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
9 | F42199 | S.O. Detail Ledger File | 136 | SL | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
10 | F42UI11 | SO Detail Cache File (MBF) | 95 | ZD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
11 | F42UI521 | Pick Slips Detail File | 107 | S9 | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP42B: Sales Order Entry |
12 | F42420 | Audit Log Transaction | 81 | AL | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP43: Procurement |
13 | F43080 | Approvals Fields Constants | 118 | PD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
14 | F4311 | Purchase Order Detail File | 114 | PD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
15 | F4311Z | Purchase Order Generator File | 118 | PW | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
16 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 127 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
17 | F43199 | P.O. Detail Ledger File - Flexible Version | 114 | OL | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP43Q: Strategic Sourcing |
18 | F43Q11 | Event Detail | 38 | ED | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP46: Warehouse Management |
19 | F4942Z1 | Work File for F4942 | 32 | SY | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP47: Electronic Commerce |
20 | F47012 | EDI Purchase Order Detail - Inbound | 163 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
21 | F47017 | EDI Purchase Order Detail - Outbound | 128 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
22 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 128 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
23 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 163 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
24 | F47032 | EDI Shipping Notice Detail - Inbound | 96 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
25 | F47037 | EDI Shipping Notice Detail - Outbound | 145 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
26 | F470371 | EDI Shipping Notice Detail - Outbound | 166 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
27 | F47047 | EDI Invoice Detail (Sales) - Outbound | 163 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
28 | F47072 | EDI Receiving Advice Detail - Inbound | 129 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
29 | F47077 | EDI Receiving Advice Detail - Outbound | 129 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
30 | F47092 | EDI Request for Quote Detail - Inbound | 163 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
31 | F47097 | EDI Request for Quote Detail - Outbound | 128 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
32 | F47102 | EDI Response to RFQ Detail - Inbound | 128 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
33 | F47107 | EDI Response to RFQ Detail - Outbound | 163 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
34 | F47132 | EDI Purchase Order Change Detail - Inbound | 164 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
35 | F47137 | EDI Purchase Order Change Detail - Outbound | 129 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
36 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 130 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
37 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 165 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
38 | F47157 | EDI Shipping Schedule Detail - Outbound | 137 | SZ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP49: Transportation Management |
39 | F49002 | Transportation Constants | 10 | TX | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
40 | F49010 | Vehicle Master (Conversion from World File) | 24 | VM | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
41 | F49025 | Connected Vehicles (Conversion from World File) | 5 | CV | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
42 | F4930 | Vehicle Master | 15 | VM | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
43 | F4931 | Vehicle Type | 13 | VG | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
44 | F4935 | Connected Vehicle Header | 12 | VH | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
45 | F4941 | Shipment Routing Steps | 22 | RS | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
46 | F4942 | Shipment Detail | 10 | IS | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
47 | F4952 | Routing Restrictions | 11 | RE | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
48 | F4960 | Load Header | 52 | TM | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
49 | F4961 | Load Legs | 10 | LL | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
50 | F4962 | Load Compartments | 17 | TE | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
51 | F49621 | Load Compartment Detail | 21 | TD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
52 | F49633 | Load In-Transit Confirmed Quantities | 11 | IQ | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
53 | F49634 | Load In-Transit Confirmed Quantities Detail | 9 | QD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
54 | F4971 | Freight Rate Definition | 43 | RD | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
55 | F4981 | Freight Audit History | 23 | FH | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
56 | F49T10 | Sales Order Release Staging Table | 26 | OR | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
57 | F49T100 | Procurement Freight Request staging table | 16 | OB | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP74: EMEA Localization |
58 | F7420033 | Sales Document Line (Print Info) - COMM - 42 | 20 | PI | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
59 | F7430030 | Legal Document Header (Print Info) - COMM - 03B | 21 | PI | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP76A: Argentina |
60 | F76A0209 | Header & Footer Invoice/ShipmentNote History WF - ARG - 76A | 57 | HF | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
61 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 57 | HF | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
62 | F76AUI20 | Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A | 57 | HF | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP76H: Chile |
63 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 42 | PI | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
64 | F76H3B38 | Shipment Guide Line (Print Info) - CHI - 03B - 76H | 15 | PI | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
TOP89: Conversion Programs |
65 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 114 | OL | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |
66 | F49711 | OBSOLETE - Freight Rate Definition - Tag File | 4 | RV | VLUM | Volume Unit of Measure | String | UDC | 2 | 0 |