| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACSCD_DOCCD_HD | Settlement to FS-CD: Reference Document Header | 6 | PAYREFID | Reference Number for Payment System | nvarchar | 10 | 0 | | |
2 | CACSFA_DOCFA_HD | Settlement to FI-CA: Reference Document Header | 6 | PAYREFID | Reference Number for Payment System | nvarchar | 10 | 0 | | |
3 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 11 | PAYREFID | Reference Number for Payment System | nvarchar | 10 | 0 | | |
4 | CACSHR_DOCHR_HD | Settlement to PY: Reference Document Header | 7 | PAYREFID | Reference Number for Payment System | nvarchar | 10 | 0 | | |
5 | CACS_STL_REF_D | Settlement Document Reference - Detail | 6 | PAYREFID | Reference Number for Payment System | nvarchar | 10 | 0 | | |
6 | CACS_STL_REF_P | Settlement Document Reference - Splitting | 5 | PAYREFID | Reference Number for Payment System | nvarchar | 10 | 0 | | |