| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40070 | Preference Master File | 1 | PF | PRFR | Preference Type | String | UDC | 2 | 0 |
2 | F40071 | Customer Preference Groups | 2 | CU | PRFR | Preference Type | String | UDC | 2 | 0 |
3 | F40072 | Item Preference Groups | 2 | GI | PRFR | Preference Type | String | UDC | 2 | 0 |
4 | F40073 | Preference Hierarchy File | 1 | HY | PRFR | Preference Type | String | UDC | 2 | 0 |
5 | F40300R | Preference Resolution History - Master | 2 | PM | PRFR | Preference Type | String | UDC | 2 | 0 |
TOP45: Advanced Pricing |
6 | F4071 | Price Adjustment Type | 5 | AT | PRFR | Preference Type | String | UDC | 2 | 0 |
7 | F4071P | Price Adjustment Type Purge | 6 | AT | PRFR | Preference Type | String | UDC | 2 | 0 |
8 | F4511W | Pricing Structure View | 10 | AP | PRFR | Preference Type | String | UDC | 2 | 0 |
9 | F4574 | Key Reference Table | 69 | KR | PRFR | Preference Type | String | UDC | 2 | 0 |
TOP75I: India |
10 | F75I357 | Consignment Header | 12 | CH | PRFR | Preference Type | String | UDC | 2 | 0 |
11 | F75I3571 | Consignment - Work Orders | 13 | CW | PRFR | Preference Type | String | UDC | 2 | 0 |
12 | F75I3572 | Consignment - Stock Transfers | 16 | CS | PRFR | Preference Type | String | UDC | 2 | 0 |
13 | F75I3573 | Consignment - Order Items | 17 | CO | PRFR | Preference Type | String | UDC | 2 | 0 |
14 | F75I3574 | Consignment - Issues/Receipts Transactions | 27 | CT | PRFR | Preference Type | String | UDC | 2 | 0 |
15 | F75I3575 | Consignment - Work Order Part List Items - Balances | 10 | CP | PRFR | Preference Type | String | UDC | 2 | 0 |
16 | F75I3576 | Stock Transfer - Work Orders | 15 | SW | PRFR | Preference Type | String | UDC | 2 | 0 |
17 | F75I380 | Excise - RG-1 - Transaction File - IND | 34 | RG | PRFR | Preference Type | String | UDC | 2 | 0 |
18 | F75I3901 | Work With Consignment - IND -43 | 29 | CO | PRFR | Preference Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 40 / PR (Preference Profiles) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | 01 | Payment Terms | 1 | Y |
2 | 02 | Pricing Unit of Measure | 1 | Y |
3 | 03 | Revenue Business Unit | 1 | Y |
4 | 04 | End Use | 1 | Y |
5 | 05 | Print Messages | 1 | Y |
6 | 06 | Inventory Commitment | 1 | Y |
7 | 07 | Product Allocations | 1 | Y |
8 | 08 | Grade and Potency | 1 | Y |
9 | 09 | Delivery Date | 1 | Y |
10 | 10 | Line of Business | 1 | Y |
11 | 11 | User Defined Price Code 1 | 1 | Y |
12 | 12 | User Defined Price Code 2 | 1 | Y |
13 | 13 | User Defined Price Code 3 | 1 | Y |
14 | 14 | Price Adjustment Schedule | | Y |
15 | 15 | Invoice Cycle | | Y |
16 | 16 | Order Preparation Days | | Y |
17 | 17 | Pricing Preferences | | N |
18 | 18 | Quality Management | 1 | Y |
19 | 21 | Receiving Locations | | N |
20 | 22 | Shipping Locations | | N |
21 | 29 | Document Distribution | | Y |
22 | 30 | Document Set | | Y |
23 | 31 | Options and Equipment | | Y |
24 | 32 | Customer Freight | | Y |
25 | 33 | Carrier | | Y |
26 | 34 | Mode of Transport | | Y |
27 | 38 | Payment Terms (Branch) | | N |
28 | 39 | Product Allocation (Branch) | | N |
29 | 41 | Next Order Status | | Y |
30 | 44 | Sales Commission | | N |
31 | 45 | Customer Currency | | N |
32 | 47 | Pricing UOM (Branch) | | N |
33 | 49 | Revenue Business Unit (Branch) | | N |
34 | 51 | Base Price | | Y |
35 | 17 | Container Deposit/Rental | | |