| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F4106 | Item Base Price File | 27 | BP | APRS | Approval Status | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 2 | F4072 | Price Adjustment Detail | 29 | AD | APRS | Approval Status | Character | UDC | 1 | 0 |
| 3 | F4072P | Price Adjustment Detail Purge | 30 | AD | APRS | Approval Status | Character | UDC | 1 | 0 |
| 4 | F4072W | Price Adjustment Detail Work File | 29 | AD | APRS | Approval Status | Character | UDC | 1 | 0 |
| 5 | F4073 | Free Goods Master File | 18 | FG | APRS | Approval Status | Character | UDC | 1 | 0 |
| 6 | F4073P | Free Goods Master File Purge | 19 | FG | APRS | Approval Status | Character | UDC | 1 | 0 |
| 7 | F4075 | Price Variable Table | 7 | VB | APRS | Approval Status | Character | UDC | 1 | 0 |
| 8 | F4076 | Price Formula Master | 3 | FM | APRS | Approval Status | Character | UDC | 1 | 0 |
| 9 | F4077 | Rebate Thresholds | 26 | RT | APRS | Approval Status | Character | UDC | 1 | 0 |
| 10 | F4077P | Rebate Thresholds Purge | 27 | RT | APRS | Approval Status | Character | UDC | 1 | 0 |
| 11 | F4511W | Pricing Structure View | 61 | AP | APRS | Approval Status | 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 45 / AS (Approval Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Active | | Y |
| 2 | 1 | Pending | | Y |
| 3 | 2 | Pending Delete | | Y |
| 4 | 3 | Rejected | | Y |
| 5 | 4 | Superceded | | Y |
| 6 | 5 | Cancelled / Deleted | | Y |
