| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP37: Quality Management |
| 1 | F40318 | Preference Profile - Quality Management | 8 | QC | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| TOP40: Inventory/OP Base |
| 2 | F40301 | Preference Profile - Payment Terms | 8 | PT | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 3 | F40301R | Preference Resolution Ledger - Payment Terms | 10 | PT | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 4 | F40302 | Preference Profile - Unit of Measure | 8 | PU | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 5 | F40302R | Preference Resolution Ledger - Pricing Unit Of Measure | 10 | PU | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 6 | F40303 | Preference Profile - Revenue Cost Center | 8 | RV | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 7 | F40303R | Preference Resolution Ledger - Revenue Business Unit | 10 | RV | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 8 | F40304 | Preference Profile - End Use | 8 | PE | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 9 | F40304R | Preference Resolution Ledger - End Use | 10 | PE | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 10 | F40305 | Preference Profile - Print Messages | 8 | RM | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 11 | F40305R | Preference Resolution Ledger - Print Messages | 10 | RM | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 12 | F40306 | Preference Profile - Inventory Sourcing | 8 | SR | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 13 | F40307 | Preference Profile - Product Allocations | 8 | LA | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 14 | F40308 | Preference Profile - Grade and Potency | 8 | GS | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 15 | F40308R | Preference Resolution Ledger - Grade and Potency | 10 | GS | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 16 | F40309 | Preference Profile - Delivery Date | 8 | DY | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 17 | F40309R | Preference Resolution Ledger - Delivery Date | 10 | DY | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 18 | F40310 | Preference Profile - Line of Business | 8 | LB | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 19 | F40310R | Preference Resolution Ledger - Line Of Business | 10 | LB | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 20 | F40311 | Preference Profile - Price Code 1 | 8 | P1 | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 21 | F40311R | Preference Resolution Ledger - User Defined Price Code #1 | 10 | P1 | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 22 | F40312 | Preference Profile - Price Code 2 | 8 | P2 | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 23 | F40312R | Preference Resolution Ledger - User Defined Price Code #2 | 10 | P2 | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 24 | F40313 | Preference Profile - Price Code 3 | 8 | P3 | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 25 | F40313R | Preference Resolution Ledger - User Defined Price Code #3 | 10 | P3 | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 26 | F40314 | Preference Profile - Price Adjustment Schedule | 8 | PJ | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 27 | F40314R | Preference Resolution Ledger - Price Adjustment Schedule | 10 | PJ | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 28 | F40315 | Preference Profile - Invoice Cycling | 8 | PI | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 29 | F40315R | Preference Resolution Ledger - Invoice Cycle | 10 | PI | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 30 | F40316 | Preference Profile - Order Preparation | 8 | OP | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 31 | F40316R | Preference Resolution Ledger - Order Preparation Days | 10 | OP | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 32 | F40318R | Preference Resolution Ledger - Quality Management | 10 | QC | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 33 | F40320 | Preference Profile - Multi Shipping/Receiving Locations | 8 | LP | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 34 | F40320R | Preference Resolution Ledger - Multi ShiP/Rec Locations | 9 | LP | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 35 | F40329 | Preference Profile - Document Distribution | 8 | DD | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 36 | F40330 | Preference Profile - Document Set | 8 | DG | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 37 | F40331 | Preference Profile - Options and Equipment | 8 | OE | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 38 | F40332 | Preference Profile - Customer Freight | 8 | CF | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 39 | F40333 | Preference Profile - Carrier | 8 | CA | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 40 | F40334 | Preference Profile - Mode of Transport | 8 | MT | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 41 | F40338 | Preference Profile - Payment Terms (Branch) | 8 | PT | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 42 | F40338R | Preference Resolution Ledger - Payment Terms (Branch) | 10 | PT | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 43 | F40339 | Preference Profile - Product Allocations (Branch) | 8 | LA | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 44 | F40341 | Preference Profile - Next Order Status | 8 | NS | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 45 | F40341R | Preference Resolution Ledger - Next Order Status | 10 | NS | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 46 | F40344 | Preference Profile - Sales Commission | 8 | SA | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 47 | F40344R | Preference Resolution Ledger - Sales Commission | 10 | SA | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 48 | F40345 | Preference Profile - Customer Currency | 8 | CR | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 49 | F40345R | Preference Resolution Ledger - Customer Currency | 10 | CR | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 50 | F40347 | Preference Profile - Pricing UOM (Branch) | 8 | RI | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 51 | F40347R | Preference Resolution Ledger - Pricing UOM (Branch) | 10 | RI | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 52 | F40349 | Preference Profile - Revenue Business Unit (Branch) | 8 | RV | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 53 | F40349R | Preference Resolution Ledger - Revenue Bus Unit (Branch) | 10 | RV | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 54 | F40350 | Preference Profiles - Conatiner Deposit/Rental | 8 | OQ | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| 55 | F40UI17 | Allocation Work File | 18 | ZG | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
| TOP89: Conversion Programs |
| 56 | F40344A | Temporay Preference Profile - Sales Commission | 8 | SA | MXQ | Quantity - Thru | Numeric | Generic Edit | 15 | 0 |
