Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Contract Accounts Receivable and Payable | ||||||||||
1 | DFKKPNBKA | Prenotification data (latest) | 34 | RTCOD | Prenotification: Return Code | nvarchar | 5 | 0 | ||
2 | DFKKPNBKH | Prenotification data (history) | 34 | RTCOD | Prenotification: Return Code | nvarchar | 5 | 0 | ||
3 | DFKKURE | Update Run: Defective Data Records | 33 | RTCOD | Prenotification: Return Code | nvarchar | 5 | 0 | ||
Public Sector | ||||||||||
4 | T7MXPBS20 | Loan type (PS) | 4 | RTCOD | Retention Code issued by loan institutions | nvarchar | 3 | 0 |