| 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 | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
2 | CACS00_B_VAR_ACT | Variants for Commission Case Activities | 18 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
3 | CACS00_B_VAR_INV | Variants for Commission Case Participants | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
4 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
5 | CACS00_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
6 | CACS00_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
7 | CACS00_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
8 | CACS00_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
9 | CACS00_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
10 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
11 | CACS00_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
12 | CACS00_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
13 | CACS00_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
14 | CACS00_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
15 | CACS00_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
16 | CACS42_DOCSHA | Commission Document: Complex Distribution Ratios | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
17 | YCRM01_ACT | Commission Case Activities | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
18 | YCRM01_B_VAR_ACT | Variants for Commission Case Activities | 19 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
19 | YCRM01_B_VAR_INV | Variants for Commission Case Participants | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
20 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
21 | YCRM01_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
22 | YCRM01_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
23 | YCRM01_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
24 | YCRM01_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
25 | YCRM01_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
26 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 36 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
27 | YCRM01_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
28 | YCRM01_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
29 | YCRM01_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
30 | YCRM01_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
31 | YCRM01_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
32 | YHITEC_ACT | Commission Case Activities | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
33 | YHITEC_B_VAR_ACT | Variants for Commission Case Activities | 18 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
34 | YHITEC_B_VAR_INV | Variants for Commission Case Participants | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
35 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
36 | YHITEC_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
37 | YHITEC_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
38 | YHITEC_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
39 | YHITEC_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
40 | YHITEC_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
41 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 19 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
42 | YHITEC_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
43 | YHITEC_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
44 | YHITEC_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
45 | YHITEC_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
46 | YHITEC_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
47 | YSVMA_ACT | Commission Case Activities | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
48 | YSVMA_B_VAR_ACT | Variants for Commission Case Activities | 18 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
49 | YSVMA_B_VAR_INV | Variants for Commission Case Participants | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
50 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
51 | YSVMA_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
52 | YSVMA_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
53 | YSVMA_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
54 | YSVMA_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
55 | YSVMA_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
56 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 13 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
57 | YSVMA_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
58 | YSVMA_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
59 | YSVMA_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
60 | YSVMA_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
61 | YSVMA_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
62 | YTEL01_ACT | Commission Case Activities | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
63 | YTEL01_B_VAR_ACT | Variants for Commission Case Activities | 18 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
64 | YTEL01_B_VAR_INV | Variants for Commission Case Participants | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
65 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
66 | YTEL01_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
67 | YTEL01_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
68 | YTEL01_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
69 | YTEL01_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
70 | YTEL01_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
71 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 33 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
72 | YTEL01_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
73 | YTEL01_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
74 | YTEL01_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
75 | YTEL01_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
76 | YTEL01_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
77 | YTEL05_ACT | Commission Case Activities | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
78 | YTEL05_B_VAR_ACT | Variants for Commission Case Activities | 18 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
79 | YTEL05_B_VAR_INV | Variants for Commission Case Participants | 11 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
80 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
81 | YTEL05_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
82 | YTEL05_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
83 | YTEL05_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
84 | YTEL05_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
85 | YTEL05_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
86 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 27 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
87 | YTEL05_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
88 | YTEL05_DOCSHA | Commission Document: Complex Distribution Ratios | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
89 | YTEL05_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
90 | YTEL05_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
91 | YTEL05_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
92 | YTEL05_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
93 | ZICMAG_ACT | Commission Case Activities | 14 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
94 | ZICMAG_B_VAR_ACT | Variants for Commission Case Activities | 18 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
95 | ZICMAG_B_VAR_INV | Variants for Commission Case Participants | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
96 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 29 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
97 | ZICMAG_B_VAR_PAR | Variants for Commission Case Participant | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
98 | ZICMAG_B_VAR_REL | Variants for Participant Relations | 9 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
99 | ZICMAG_DOCACT | Commission Document: Activities | 8 | PART_POS | Reference to a Participation in a Commission Case | nvarchar | 4 | 0 | | |
100 | ZICMAG_DOCINV | Participant in Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
101 | ZICMAG_DOCPAR | Participation of Commission Document | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
102 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 11 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
103 | ZICMAG_DOCREL | Commission Document: Relationships Between Participants | 4 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
104 | ZICMAG_INV | Commission Case Participants | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
105 | ZICMAG_LIN | Variant Commissions | 25 | PART_POS | Participation Item in a Commission Case (Special Commission) | nvarchar | 4 | 0 | | |
106 | ZICMAG_PAR | Commission Case Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |
107 | ZICMAG_REL | Participant Relations in a Commission Participation | 5 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | | |