| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
2 | CACS00_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
3 | CACS00_DOCHD | Commission Document Header | 51 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
4 | CACS00_DOCINV | Participant in Commission Document | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
5 | CACS00_DOCOBJ | Commission Document: Object Data | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
6 | CACS00_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
7 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
8 | CACS00_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
9 | CACS00_DOCSE | Commission Document, Settlement | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
10 | CACS00_DOCVA | Commission Document, Valuation | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
11 | CACS42_DOCSHA | Commission Document: Complex Distribution Ratios | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
12 | CACS_DOCHD | Expected Commission (Remuneration) | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
13 | CACS_DOCRE | Expected Commission (Remuneration) | 22 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
14 | TCACS_VALSTAT2 | Allowed Status Combinations Process/Item | 2 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
15 | TCACS_VALSTAT2_T | Allowed Status Combinations Process/Item | 3 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
16 | TCACS_VALTARG2 | Allowed Target/Status Combinations Process/Version | 2 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
17 | YCRM01_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
18 | YCRM01_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
19 | YCRM01_DOCHD | Commission Document Header | 51 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
20 | YCRM01_DOCINV | Participant in Commission Document | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
21 | YCRM01_DOCOBJ | Commission Document: Object Data | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
22 | YCRM01_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
23 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 34 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
24 | YCRM01_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
25 | YCRM01_DOCSE | Commission Document: Due Dates | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
26 | YCRM01_DOCVA | Commission Document, Valuation | 34 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
27 | YHITEC_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
28 | YHITEC_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
29 | YHITEC_DOCHD | Commission Document Header | 52 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
30 | YHITEC_DOCINV | Participant in Commission Document | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
31 | YHITEC_DOCOBJ | Commission Document: Object Data | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
32 | YHITEC_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
33 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 17 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
34 | YHITEC_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
35 | YHITEC_DOCSE | Commission Document: Due Dates | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
36 | YHITEC_DOCVA | Commission Document, Valuation | 15 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
37 | YSVMA_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
38 | YSVMA_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
39 | YSVMA_DOCHD | Commission Document Header | 59 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
40 | YSVMA_DOCINV | Participant in Commission Document | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
41 | YSVMA_DOCOBJ | Commission Document: Object Data | 20 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
42 | YSVMA_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
43 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 11 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
44 | YSVMA_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
45 | YSVMA_DOCSE | Commission Document: Due Dates | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
46 | YSVMA_DOCVA | Commission Document, Valuation | 11 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
47 | YTEL01_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
48 | YTEL01_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
49 | YTEL01_DOCHD | Commission Document Header | 52 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
50 | YTEL01_DOCINV | Participant in Commission Document | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
51 | YTEL01_DOCOBJ | Commission Document: Object Data | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
52 | YTEL01_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
53 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 31 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
54 | YTEL01_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
55 | YTEL01_DOCSE | Commission Document: Due Dates | 23 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
56 | YTEL01_DOCVA | Commission Document, Valuation | 37 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
57 | YTEL05_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
58 | YTEL05_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
59 | YTEL05_DOCHD | Commission Document Header | 59 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
60 | YTEL05_DOCINV | Participant in Commission Document | 9 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
61 | YTEL05_DOCOBJ | Commission Document: Object Data | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
62 | YTEL05_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
63 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 25 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
64 | YTEL05_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
65 | YTEL05_DOCSE | Commission Document: Due Dates | 12 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
66 | YTEL05_DOCSHA | Commission Document: Complex Distribution Ratios | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
67 | YTEL05_DOCVA | Commission Document, Valuation | 21 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
68 | ZICMAG_DOCACT | Commission Document: Activities | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
69 | ZICMAG_DOCDT | Comn: Detail Items for Remuneration Rows | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
70 | ZICMAG_DOCHD | Commission Document Header | 52 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
71 | ZICMAG_DOCINV | Participant in Commission Document | 7 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
72 | ZICMAG_DOCOBJ | Commission Document: Object Data | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
73 | ZICMAG_DOCPAR | Participation of Commission Document | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
74 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 9 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
75 | ZICMAG_DOCREL | Commission Document: Relationships Between Participants | 10 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
76 | ZICMAG_DOCSE | Commission Document: Due Dates | 6 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |
77 | ZICMAG_DOCVA | Commission Document, Valuation | 8 | STATUS_POS | Status of Object/Subobject | nvarchar | 1 | 0 | | |