| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 40: 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 |
| 45: Advanced Pricing | ||||||||||
| 6 | F4071 | Price Adjustment Type | 5 | AT | PRFR | Preference Type | String | UDC | 2 | 0 |
| 7 | F4511W | Pricing Structure View | 10 | AP | PRFR | Preference Type | String | UDC | 2 | 0 |
| 8 | F4574 | Key Reference Table | 69 | KR | 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.
UDC 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 |