| 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 | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
2 | CACS00_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
3 | CACS00_B_VAR_ACT | Variants for Commission Case Activities | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
4 | CACS00_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
5 | CACS00_B_VAR_CAS | Variants for Commission Case | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
6 | CACS00_B_VAR_INV | Variants for Commission Case Participants | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
7 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
8 | CACS00_B_VAR_OBJ | Variants for Commission Case Object Data | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
9 | CACS00_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
10 | CACS00_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
11 | CACS00_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
12 | CACS00_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
13 | CACS00_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
14 | CACS00_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
15 | CACS00_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
16 | CACS00_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
17 | CACS00_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
18 | CACSCP_RCP_BUFF | RCP: Buffer Table for RCP Processing | 3 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
19 | CACSCP_RCP_CASE | RCP: Initial Commission Cases | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
20 | CACSCP_RCP_WL | RCP: Worklist | 4 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
21 | CACS_BUFFLOG | Commissions: Log Table of Commission Objects | 4 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
22 | CACS_COILOG | Recording of the Keys of Records Processed with COI | 4 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
23 | CACS_EDTPROT | Commissions: Log for EDT Interface Supply | 7 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
24 | CACS_TGLOG | Obsolete (Target Agreements: Log) | 9 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
25 | CACS_WFCAS | Commission Case: Workflow Characteristics for Pending Cases | 3 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
26 | TCACS_CATT01 | Directory of Commission Cases to be Tested Automatically | 4 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
27 | TCACS_CATT01T | Directory of Commission Cases to be Tested Automatically | 5 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
28 | YCRM01_ACT | Commission Case Activities | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
29 | YCRM01_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
30 | YCRM01_B_VAR_ACT | Variants for Commission Case Activities | 7 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
31 | YCRM01_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
32 | YCRM01_B_VAR_CAS | Variants for Commission Case | 14 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
33 | YCRM01_B_VAR_INV | Variants for Commission Case Participants | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
34 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
35 | YCRM01_B_VAR_OBJ | Variants for Commission Case Object Data | 53 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
36 | YCRM01_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
37 | YCRM01_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
38 | YCRM01_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
39 | YCRM01_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
40 | YCRM01_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
41 | YCRM01_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
42 | YCRM01_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
43 | YCRM01_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
44 | YCRM01_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
45 | YHITEC_ACT | Commission Case Activities | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
46 | YHITEC_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
47 | YHITEC_B_VAR_ACT | Variants for Commission Case Activities | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
48 | YHITEC_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
49 | YHITEC_B_VAR_CAS | Variants for Commission Case | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
50 | YHITEC_B_VAR_INV | Variants for Commission Case Participants | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
51 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
52 | YHITEC_B_VAR_OBJ | Variants for Commission Case Object Data | 17 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
53 | YHITEC_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
54 | YHITEC_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
55 | YHITEC_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
56 | YHITEC_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
57 | YHITEC_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
58 | YHITEC_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
59 | YHITEC_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
60 | YHITEC_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
61 | YHITEC_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
62 | YSVMA_ACT | Commission Case Activities | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
63 | YSVMA_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
64 | YSVMA_B_VAR_ACT | Variants for Commission Case Activities | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
65 | YSVMA_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
66 | YSVMA_B_VAR_CAS | Variants for Commission Case | 14 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
67 | YSVMA_B_VAR_INV | Variants for Commission Case Participants | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
68 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
69 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 21 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
70 | YSVMA_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
71 | YSVMA_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
72 | YSVMA_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
73 | YSVMA_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
74 | YSVMA_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
75 | YSVMA_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
76 | YSVMA_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
77 | YSVMA_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
78 | YSVMA_RCP_BUFF | RCP: Buffer Table for RCP Processing | 3 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
79 | YSVMA_RCP_CASE | RCP: Initial Commission Cases | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
80 | YSVMA_RCP_WL | RCP: Worklist | 4 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
81 | YSVMA_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
82 | YTEL01_ACT | Commission Case Activities | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
83 | YTEL01_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
84 | YTEL01_B_VAR_ACT | Variants for Commission Case Activities | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
85 | YTEL01_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
86 | YTEL01_B_VAR_CAS | Variants for Commission Case | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
87 | YTEL01_B_VAR_INV | Variants for Commission Case Participants | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
88 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
89 | YTEL01_B_VAR_OBJ | Variants for Commission Case Object Data | 41 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
90 | YTEL01_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
91 | YTEL01_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
92 | YTEL01_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
93 | YTEL01_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
94 | YTEL01_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
95 | YTEL01_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
96 | YTEL01_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
97 | YTEL01_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
98 | YTEL01_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
99 | YTEL05_ACT | Commission Case Activities | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
100 | YTEL05_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
101 | YTEL05_B_VAR_ACT | Variants for Commission Case Activities | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
102 | YTEL05_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
103 | YTEL05_B_VAR_CAS | Variants for Commission Case | 14 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
104 | YTEL05_B_VAR_INV | Variants for Commission Case Participants | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
105 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
106 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 39 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
107 | YTEL05_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
108 | YTEL05_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
109 | YTEL05_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
110 | YTEL05_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
111 | YTEL05_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
112 | YTEL05_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
113 | YTEL05_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
114 | YTEL05_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
115 | YTEL05_RCP_BUFF | RCP: Buffer Table for RCP Processing | 3 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
116 | YTEL05_RCP_CASE | RCP: Initial Commission Cases | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
117 | YTEL05_RCP_WL | RCP: Worklist | 4 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
118 | YTEL05_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
119 | ZICMAG_ACT | Commission Case Activities | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
120 | ZICMAG_BDL | Rebundling Order for Triggering Subobjects | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
121 | ZICMAG_B_VAR_ACT | Variants for Commission Case Activities | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
122 | ZICMAG_B_VAR_BDL | Variants for Bundling | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
123 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
124 | ZICMAG_B_VAR_INV | Variants for Commission Case Participants | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
125 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
126 | ZICMAG_B_VAR_OBJ | Variants for Commission Case Object Data | 9 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
127 | ZICMAG_B_VAR_PAR | Variants for Commission Case Participant | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
128 | ZICMAG_B_VAR_REL | Variants for Participant Relations | 6 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
129 | ZICMAG_CAS | Commission Case | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
130 | ZICMAG_INV | Commission Case Participants | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
131 | ZICMAG_LIN | Variant Commissions | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
132 | ZICMAG_OBJ | Commission Case Object Data | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
133 | ZICMAG_OBJHIST | Change History of Subobjects That Trigger Commission | 8 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
134 | ZICMAG_PAR | Commission Case Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |
135 | ZICMAG_REL | Participant Relations in a Commission Participation | 2 | IMPORT_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | | |