| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_B_VAR_INV | Variants for Commission Case Participants | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
2 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
3 | CACS00_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
4 | CACS00_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
5 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
6 | CACS00_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
7 | CACS00_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
8 | CACS00_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
9 | CACS00_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
10 | CACS42_DOCSHA | Commission Document: Complex Distribution Ratios | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
11 | TCACS_PCINV | Participation Construction: Participants Template | 4 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
12 | YCRM01_B_VAR_INV | Variants for Commission Case Participants | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
13 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
14 | YCRM01_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
15 | YCRM01_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
16 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 37 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
17 | YCRM01_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
18 | YCRM01_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
19 | YCRM01_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
20 | YCRM01_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
21 | YHITEC_B_VAR_INV | Variants for Commission Case Participants | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
22 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
23 | YHITEC_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
24 | YHITEC_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
25 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 20 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
26 | YHITEC_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
27 | YHITEC_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
28 | YHITEC_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
29 | YHITEC_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
30 | YSVMA_B_VAR_INV | Variants for Commission Case Participants | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
31 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
32 | YSVMA_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
33 | YSVMA_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
34 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 14 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
35 | YSVMA_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
36 | YSVMA_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
37 | YSVMA_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
38 | YSVMA_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
39 | YTEL01_B_VAR_INV | Variants for Commission Case Participants | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
40 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
41 | YTEL01_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
42 | YTEL01_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
43 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 34 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
44 | YTEL01_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
45 | YTEL01_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
46 | YTEL01_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
47 | YTEL01_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
48 | YTEL05_B_VAR_INV | Variants for Commission Case Participants | 12 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
49 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
50 | YTEL05_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
51 | YTEL05_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
52 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 28 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
53 | YTEL05_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
54 | YTEL05_DOCSHA | Commission Document: Complex Distribution Ratios | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
55 | YTEL05_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
56 | YTEL05_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
57 | YTEL05_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
58 | ZICMAG_B_VAR_INV | Variants for Commission Case Participants | 10 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
59 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 28 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
60 | ZICMAG_B_VAR_REL | Variants for Participant Relations | 13 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
61 | ZICMAG_DOCINV | Participant in Commission Document | 5 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
62 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 12 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
63 | ZICMAG_DOCREL | Commission Document: Relationships Between Participants | 8 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
64 | ZICMAG_INV | Commission Case Participants | 6 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |
65 | ZICMAG_LIN | Variant Commissions | 24 | INV_POS | Participant Position in a Participation (Special Commission) | nvarchar | 4 | 0 | | |
66 | ZICMAG_REL | Participant Relations in a Commission Participation | 9 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | | |