| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F40711 | Preference Values Definition | 1 | PD | PA04 | Target Application | Character | UDC | 1 | 0 |
| 2 | F40UI74 | Price Adjustment History Work File | 77 | AW | PA04 | Target Application | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 3 | F4074 | Price Adjustment Ledger File | 66 | AL | PA04 | Target Application | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 4 | F4071 | Price Adjustment Type | 18 | AT | PA04 | Target Application | Character | UDC | 1 | 0 |
| 5 | F4511W | Pricing Structure View | 23 | AP | PA04 | Target Application | Character | UDC | 1 | 0 |
| 6 | F4575 | Ship and Debit History | 1 | AH | PA04 | Target Application | Character | UDC | 1 | 0 |
| 7 | F4575TMP | Ship and Debit History - Temp Table | 1 | AH | PA04 | Target Application | Character | UDC | 1 | 0 |
| 8 | F4576 | Ship and Debit Claims | 7 | AC | PA04 | Target Application | Character | UDC | 1 | 0 |
| 9 | F4576TMP | Ship and Debit Claims- Temp Table | 7 | AC | PA04 | Target Application | Character | UDC | 1 | 0 |
| 10 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 20 | Z1 | PA04 | Target Application | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 40 / TA (Target Application) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Sales Order Management | | N |
| 2 | 1 | Procurement | | N |
| 3 | 2 | Customer Service Management | | N |
| 4 | 3 | Ship and Debit | | N |
| 5 | 4 | Sales Order/S&WM/Procurement | | Y |
| 6 | 5 | Advanced Preferences | | Y |
