| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP45: Advanced Pricing |
| 1 | F4575 | Ship and Debit History | 28 | AH | SCNT | Status Code - Next | String | UDC | 2 | 0 |
| 2 | F4575TMP | Ship and Debit History - Temp Table | 28 | AH | SCNT | Status Code - Next | String | UDC | 2 | 0 |
| 3 | F4576 | Ship and Debit Claims | 22 | AC | SCNT | Status Code - Next | String | UDC | 2 | 0 |
| 4 | F4576TMP | Ship and Debit Claims- Temp Table | 22 | AC | SCNT | Status Code - Next | String | UDC | 2 | 0 |
| 5 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 35 | Z1 | SCNT | Status Code - Next | 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 45 / SC (Claim Status Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 00 | Agreement Status 01-38 | | Y |
| 2 | 10 | Agreement Assignment | | Y |
| 3 | 15 | Agreement Reassigned | | Y |
| 4 | 20 | Agreement Finalization | | Y |
| 5 | 29 | Claim Created/Agreement Closed | | Y |
| 6 | 39 | Claim Status 40-99 | | Y |
| 7 | 40 | Claim Creation | | Y |
| 8 | 45 | Internal Approval | | Y |
| 9 | 50 | Claim Submission | | Y |
| 10 | 55 | Claim Acknowledgement | | Y |
| 11 | 60 | Claim Approved by Supplier | | Y |
| 12 | 65 | Claim Applied | | Y |
| 13 | 80 | Claim Rejected by Supplier | | Y |
| 14 | 90 | Claim Closed | | Y |
| 15 | 99 | Claim Canceled | | Y |
