| 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.