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