| 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 | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
2 | CACS00_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
3 | CACS00_B_VAR_ACT | Variants for Commission Case Activities | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
4 | CACS00_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
5 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
6 | CACS00_B_VAR_OBJ | Variants for Commission Case Object Data | 9 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
7 | CACS00_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
8 | CACS00_DOCVA | Commission Document, Valuation | 12 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
9 | CACS00_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
10 | CACS00_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
11 | CACS00_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
12 | CACS00_SUMVA | Totals Table for Valuation | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
13 | CACS_FFLTIT | Fulfillment Level Item | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
14 | TCACS_ACT_CHAR | Comn.: Activity Type Characteristic | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
15 | TCACS_PCACT | Participation Construction: Activities Template | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
16 | TCACS_TRME | Triggering Method (incl. Assignment to Activity Types) | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
17 | TCACS_TRME_T | Names of Triggering Methods | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
18 | TCACS_VAL | Comn.: Valuation Types | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
19 | YCRM01_ACT | Commission Case Activities | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
20 | YCRM01_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
21 | YCRM01_B_VAR_ACT | Variants for Commission Case Activities | 15 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
22 | YCRM01_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
23 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
24 | YCRM01_B_VAR_OBJ | Variants for Commission Case Object Data | 56 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
25 | YCRM01_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
26 | YCRM01_DOCVA | Commission Document, Valuation | 40 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
27 | YCRM01_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
28 | YCRM01_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
29 | YCRM01_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
30 | YCRM01_SELTAB90 | YCRM01_SELTAB90 | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
31 | YCRM01_SELTAB98 | YCRM01_SELTAB98 Role | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
32 | YCRM01_SELTABC0 | YCRM01_SELTAB90 | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
33 | YCRM01_SELTABC8 | YCRM01_SELTAB98 Role | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
34 | YCRM01_SUMVA | Valuation Totals for Contract Account Display | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
35 | YHITEC_ACT | Commission Case Activities | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
36 | YHITEC_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
37 | YHITEC_B_VAR_ACT | Variants for Commission Case Activities | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
38 | YHITEC_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
39 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
40 | YHITEC_B_VAR_OBJ | Variants for Commission Case Object Data | 20 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
41 | YHITEC_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
42 | YHITEC_DOCVA | Commission Document, Valuation | 21 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
43 | YHITEC_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
44 | YHITEC_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
45 | YHITEC_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
46 | YHITEC_SELTAB90 | YCRM01_SELTAB90 | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
47 | YHITEC_SELTAB98 | YCRM01_SELTAB98 Role | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
48 | YHITEC_SUMVA | Valuation Totals for Contract Account Display | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
49 | YSVMA_ACT | Commission Case Activities | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
50 | YSVMA_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
51 | YSVMA_B_VAR_ACT | Variants for Commission Case Activities | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
52 | YSVMA_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
53 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
54 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 24 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
55 | YSVMA_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
56 | YSVMA_DOCVA | Commission Document, Valuation | 17 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
57 | YSVMA_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
58 | YSVMA_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
59 | YSVMA_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
60 | YSVMA_SELTAB01 | Selection Table CACS00_SELTAB01 | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
61 | YSVMA_SUMVA | Valuation Totals for Contract Account Display | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
62 | YTEL01_ACT | Commission Case Activities | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
63 | YTEL01_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
64 | YTEL01_B_VAR_ACT | Variants for Commission Case Activities | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
65 | YTEL01_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
66 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
67 | YTEL01_B_VAR_OBJ | Variants for Commission Case Object Data | 44 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
68 | YTEL01_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
69 | YTEL01_DOCVA | Commission Document, Valuation | 43 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
70 | YTEL01_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
71 | YTEL01_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
72 | YTEL01_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
73 | YTEL01_SUMVA | Valuation Totals for Contract Account Display | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
74 | YTEL01_SUMVA02 | Reference Totals Table for Valuation (TELUS) | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
75 | YTEL01_SUMVA03 | Reference Totals Table for Valuation (TELUS) | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
76 | YTEL05_ACT | Commission Case Activities | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
77 | YTEL05_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
78 | YTEL05_B_VAR_ACT | Variants for Commission Case Activities | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
79 | YTEL05_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
80 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
81 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 42 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
82 | YTEL05_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
83 | YTEL05_DOCVA | Commission Document, Valuation | 27 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
84 | YTEL05_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
85 | YTEL05_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
86 | YTEL05_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
87 | YTEL05_SELTAB01 | Selection Table CACS00_SELTAB01 | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
88 | YTEL05_SELTAB90 | YCRM01_SELTAB90 | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
89 | YTEL05_SELTAB98 | YCRM01_SELTAB98 Role | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
90 | YTEL05_SELTABC0 | YCRM01_SELTAB90 | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
91 | YTEL05_SELTABC8 | YCRM01_SELTAB98 Role | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
92 | YTEL05_SUMVA | Valuation Totals for Contract Account Display | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
93 | ZICMAG_ACT | Commission Case Activities | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
94 | ZICMAG_BDL | Rebundling Order for Triggering Subobjects | 6 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
95 | ZICMAG_B_VAR_ACT | Variants for Commission Case Activities | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
96 | ZICMAG_B_VAR_BDL | Variants for Bundling | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
97 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
98 | ZICMAG_B_VAR_OBJ | Variants for Commission Case Object Data | 12 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
99 | ZICMAG_DOCOBJ | Commission Document: Object Data | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
100 | ZICMAG_DOCVA | Commission Document, Valuation | 14 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
101 | ZICMAG_LIN | Variant Commissions | 10 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
102 | ZICMAG_OBJ | Commission Case Object Data | 5 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
103 | ZICMAG_OBJHIST | Change History of Subobjects That Trigger Commission | 4 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
104 | ZICMAG_SELTAB01 | Selektionstab. CACS00_SELTAB01 | 3 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |
105 | ZICMAG_SUMVA | Valuation Totals for Contract Account Display | 2 | TRI_OBJ_TYPE | Triggering Subobject Type | nvarchar | 5 | 0 | | |