| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40711 | Preference Values Definition | 3 | PD | APTYPE | Advanced Preference Type | String | UDC | 2 | 0 |
| 2 | F40741 | Preference Adjustment History | 13 | PH | APTYPE | Advanced Preference Type | String | UDC | 2 | 0 |
| TOP45: Advanced Pricing |
| 3 | F4071 | Price Adjustment Type | 54 | AT | APTYPE | Advanced 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 / AP (Advanced Preference Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | blank | | N |
| 2 | 01 | Order Header Defaults | | Y |
| 3 | 02 | Order Detail Defaults | | Y |
| 4 | 03 | Delivery Date | | Y |
| 5 | 04 | Print Message | 1 | Y |
| 6 | 05 | Inventory Commitment | | Y |
| 7 | 12 | Document Set | 1 | Y |
| 8 | 13 | Options and Equipment | 1 | Y |
| 9 | 14 | Customer Freight | | Y |
| 10 | 15 | Carrier | | Y |
| 11 | 16 | Mode of Transport | | Y |
| 12 | 17 | Extended Terms | | Y |
| 13 | 18 | Sales Price Based On Date | | Y |
| 14 | 19 | Gross Profit Margin Target | | Y |
| 15 | 21 | Sales Commission | 1 | Y |
| 16 | 22 | Order Prep Days | | Y |
| 17 | 23 | Advanced Lot | | Y |
| 18 | 24 | Next Order Status | | Y |
| 19 | 25 | Grade and Potency | | Y |
| 20 | 26 | Demand Scheduling | | Y |
| 21 | 27 | Scheduling Fences | | Y |
| 22 | 28 | Forecast Days | | Y |
| 23 | 29 | Promise Code | | Y |
| 24 | 30 | Missing Confirmation | | Y |
| 25 | 31 | Net Variance Tolerance | | Y |
| 26 | 32 | Round to Standard Pack | | Y |
| 27 | 33 | Acknowledgement Notification | | Y |
| 28 | 34 | ASN Tracking Workflow | | Y |
| 29 | 35 | Message Notification | | Y |
| 30 | 36 | EDI Adv Ship Notice Version | | Y |
| 31 | 37 | Labels | | Y |
| 32 | 38 | Label Serial Numbers | | Y |
| 33 | 39 | Carton Label | | Y |
| 34 | 40 | Customer Ledger Generic Match | | Y |
