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