| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 15 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
2 | CACS00_DOCVA | Commission Document, Valuation | 9 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
3 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 42 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
4 | YCRM01_DOCVA | Commission Document, Valuation | 37 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
5 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 25 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
6 | YHITEC_DOCVA | Commission Document, Valuation | 18 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
7 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 19 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
8 | YSVMA_DOCVA | Commission Document, Valuation | 14 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
9 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 39 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
10 | YTEL01_DOCVA | Commission Document, Valuation | 40 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
11 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 33 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
12 | YTEL05_DOCVA | Commission Document, Valuation | 24 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
13 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 17 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
14 | ZICMAG_DOCVA | Commission Document, Valuation | 11 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |