| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | YCRM01_B_VAR_CAS | Variants for Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
2 | YHITEC_B_VAR_CAS | Variants for Commission Case | 9 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
3 | YHITEC_CAS | Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
4 | YHITEC_DOCHD | Commission Document Header | 8 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
5 | YSVMA_B_VAR_CAS | Variants for Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
6 | YSVMA_CAS | Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
7 | YSVMA_DOCHD | Commission Document Header | 4 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
8 | YTEL01_B_VAR_CAS | Variants for Commission Case | 9 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
9 | YTEL01_CAS | Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
10 | YTEL01_DOCHD | Commission Document Header | 8 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
11 | YTEL05_B_VAR_CAS | Variants for Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
12 | YTEL05_CAS | Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
13 | YTEL05_DOCHD | Commission Document Header | 4 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
14 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 9 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
15 | ZICMAG_CAS | Commission Case | 5 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |
16 | ZICMAG_DOCHD | Commission Document Header | 8 | CLC_DATE | Effective Date of a Document/Case (Effective Status) | nvarchar | 8 | 0 | | |