| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP45: Advanced Pricing |
| 1 | F45715 | Adjustment Balances | 22 | AB | FVMD | Factor Value Method | Character | UDC | 1 | 0 |
| 2 | F4575 | Ship and Debit History | 33 | AH | FVMD | Factor Value Method | Character | UDC | 1 | 0 |
| 3 | F4575TMP | Ship and Debit History - Temp Table | 33 | AH | FVMD | Factor Value Method | Character | UDC | 1 | 0 |
| 4 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 113 | Z1 | FVMD | Factor Value Method | 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 / BC (Basis Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 0 | % of New Base Price | | Y |
| 2 | 1 | % of Base Price | | Y |
| 3 | 2 | % of Current Net Price | | Y |
| 4 | 3 | % of Cost | | Y |
| 5 | 4 | Cost Plus Amount | | Y |
| 6 | 5 | Add on Amount | | Y |
| 7 | 6 | Add on Variable Amount | | Y |
| 8 | 7 | Add on Formula Amount | | Y |
| 9 | 8 | Add on User Program Amount | | Y |
| 10 | 9 | Gross Profit Margin | | Y |
