| 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 | 41 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
2 | CACS00_CAS | Commission Case | 37 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
3 | CACS00_DOCHD | Commission Document Header | 34 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
4 | CACS_STTCRU | Standard Rules for Commission Case Triggers | 7 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
5 | CACS_TRICAJO | Commission Case Trigger: Log | 9 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
6 | CACS_TRIGCAS | Rule for Cause of Additional Commission Case | 9 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
7 | TCACS_ASGRL | Assignment Role for Segment Assignment | 5 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
8 | TCACS_TGT | Target Agreements: Complex Target Type | 6 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
9 | TCACS_TRCAS | Trigger for Additional Commission Case | 3 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
10 | TCACS_TRCAST | Name: Cause of Additional Commission Case | 4 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
11 | YCRM01_B_VAR_CAS | Variants for Commission Case | 49 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
12 | YCRM01_CAS | Commission Case | 37 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
13 | YCRM01_DOCHD | Commission Document Header | 34 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
14 | YHITEC_B_VAR_CAS | Variants for Commission Case | 34 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
15 | YHITEC_CAS | Commission Case | 30 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
16 | YHITEC_DOCHD | Commission Document Header | 35 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
17 | YSVMA_B_VAR_CAS | Variants for Commission Case | 49 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
18 | YSVMA_CAS | Commission Case | 45 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
19 | YSVMA_DOCHD | Commission Document Header | 42 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
20 | YTEL01_B_VAR_CAS | Variants for Commission Case | 34 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
21 | YTEL01_CAS | Commission Case | 30 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
22 | YTEL01_DOCHD | Commission Document Header | 35 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
23 | YTEL05_B_VAR_CAS | Variants for Commission Case | 49 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
24 | YTEL05_CAS | Commission Case | 45 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
25 | YTEL05_DOCHD | Commission Document Header | 42 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
26 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 34 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
27 | ZICMAG_CAS | Commission Case | 30 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |
28 | ZICMAG_DOCHD | Commission Document Header | 35 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | | |