| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
2 | CACS00_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
3 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
4 | CACS00_B_VAR_OBJ | Variants for Commission Case Object Data | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
5 | CACS00_DOCOBJ | Commission Document: Object Data | 6 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
6 | CACS00_DOCVA | Commission Document, Valuation | 13 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
7 | CACS00_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
8 | CACS00_OBJ | Commission Case Object Data | 7 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
9 | CACS00_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
10 | CACS00_SUMVA | Totals Table for Valuation | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
11 | YCRM01_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
12 | YCRM01_B_VAR_ACT | Variants for Commission Case Activities | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
13 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
14 | YCRM01_B_VAR_OBJ | Variants for Commission Case Object Data | 58 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
15 | YCRM01_DOCOBJ | Commission Document: Object Data | 6 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
16 | YCRM01_DOCVA | Commission Document, Valuation | 41 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
17 | YCRM01_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
18 | YCRM01_OBJ | Commission Case Object Data | 54 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
19 | YCRM01_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
20 | YCRM01_SUMVA | Valuation Totals for Contract Account Display | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
21 | YHITEC_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
22 | YHITEC_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
23 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
24 | YHITEC_B_VAR_OBJ | Variants for Commission Case Object Data | 22 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
25 | YHITEC_DOCOBJ | Commission Document: Object Data | 6 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
26 | YHITEC_DOCVA | Commission Document, Valuation | 22 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
27 | YHITEC_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
28 | YHITEC_OBJ | Commission Case Object Data | 18 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
29 | YHITEC_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
30 | YHITEC_SUMVA | Valuation Totals for Contract Account Display | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
31 | YSVMA_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
32 | YSVMA_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
33 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
34 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 26 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
35 | YSVMA_DOCOBJ | Commission Document: Object Data | 18 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
36 | YSVMA_DOCVA | Commission Document, Valuation | 18 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
37 | YSVMA_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
38 | YSVMA_OBJ | Commission Case Object Data | 18 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
39 | YSVMA_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
40 | YSVMA_SUMVA | Valuation Totals for Contract Account Display | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
41 | YTEL01_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
42 | YTEL01_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
43 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
44 | YTEL01_B_VAR_OBJ | Variants for Commission Case Object Data | 46 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
45 | YTEL01_DOCOBJ | Commission Document: Object Data | 6 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
46 | YTEL01_DOCVA | Commission Document, Valuation | 44 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
47 | YTEL01_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
48 | YTEL01_OBJ | Commission Case Object Data | 42 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
49 | YTEL01_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
50 | YTEL01_SUMVA | Valuation Totals for Contract Account Display | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
51 | YTEL05_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
52 | YTEL05_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
53 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
54 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 44 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
55 | YTEL05_DOCOBJ | Commission Document: Object Data | 6 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
56 | YTEL05_DOCVA | Commission Document, Valuation | 28 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
57 | YTEL05_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
58 | YTEL05_OBJ | Commission Case Object Data | 37 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
59 | YTEL05_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
60 | YTEL05_SUMVA | Valuation Totals for Contract Account Display | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
61 | ZICMAG_ACT | Commission Case Activities | 11 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
62 | ZICMAG_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
63 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 16 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
64 | ZICMAG_B_VAR_OBJ | Variants for Commission Case Object Data | 14 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
65 | ZICMAG_DOCOBJ | Commission Document: Object Data | 6 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
66 | ZICMAG_DOCVA | Commission Document, Valuation | 15 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
67 | ZICMAG_LIN | Variant Commissions | 12 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
68 | ZICMAG_OBJ | Commission Case Object Data | 10 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
69 | ZICMAG_OBJHIST | Change History of Subobjects That Trigger Commission | 2 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |
70 | ZICMAG_SUMVA | Valuation Totals for Contract Account Display | 3 | TRI_OBJ_ID | Identification of Triggering Subobject | nvarchar | 12 | 0 | | |