| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_B_VAR_CAS | Variants for Commission Case | 38 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
2 | CACS00_CAS | Commission Case | 34 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
3 | CACS00_DOCHD | Commission Document Header | 31 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
4 | CACS25_SESHD | Settlement Schedule Header | 20 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
5 | YCRM01_B_VAR_CAS | Variants for Commission Case | 46 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
6 | YCRM01_CAS | Commission Case | 34 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
7 | YCRM01_DOCHD | Commission Document Header | 31 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
8 | YCRM01_SESHD | Settlement Schedule Header | 20 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
9 | YHITEC_B_VAR_CAS | Variants for Commission Case | 31 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
10 | YHITEC_CAS | Commission Case | 27 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
11 | YHITEC_DOCHD | Commission Document Header | 32 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
12 | YSVMA_B_VAR_CAS | Variants for Commission Case | 46 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
13 | YSVMA_CAS | Commission Case | 42 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
14 | YSVMA_DOCHD | Commission Document Header | 39 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
15 | YSVMA_SESHD | Settlement Schedule Header | 20 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
16 | YTEL01_B_VAR_CAS | Variants for Commission Case | 31 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
17 | YTEL01_CAS | Commission Case | 27 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
18 | YTEL01_DOCHD | Commission Document Header | 32 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
19 | YTEL05_B_VAR_CAS | Variants for Commission Case | 46 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
20 | YTEL05_CAS | Commission Case | 42 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
21 | YTEL05_DOCHD | Commission Document Header | 39 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
22 | YTEL05_SESHD | Settlement Schedule Header | 20 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
23 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 31 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
24 | ZICMAG_CAS | Commission Case | 27 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |
25 | ZICMAG_DOCHD | Commission Document Header | 32 | TRI_BUSCASE_TYP | Commission Triggering Business Case in Operational System | nvarchar | 3 | 0 | | |