| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
2 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 45 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
3 | CACS00_DOCSE | Commission Document, Settlement | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
4 | CACS00_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
5 | CACS00_SUMRE | Totals Table for Remuneration | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
6 | CACS00_SUMSE | Totals Table for Settlement | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
7 | CACS25_SESIT | Settlement Schedule Item | 18 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
8 | CACS_DOCRE | Expected Commission (Remuneration) | 18 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
9 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
10 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 72 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
11 | YCRM01_DOCSE | Commission Document: Due Dates | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
12 | YCRM01_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
13 | YCRM01_SESIT | Settlement Schedule Item | 18 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
14 | YCRM01_SUMRE | Remuneration Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
15 | YCRM01_SUMSE | Due Date Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
16 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
17 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 55 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
18 | YHITEC_DOCSE | Commission Document: Due Dates | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
19 | YHITEC_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
20 | YHITEC_SUMRE | Remuneration Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
21 | YHITEC_SUMSE | Due Date Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
22 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
23 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 49 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
24 | YSVMA_DOCSE | Commission Document: Due Dates | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
25 | YSVMA_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
26 | YSVMA_SESIT | Settlement Schedule Item | 18 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
27 | YSVMA_SUMRE | Remuneration Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
28 | YSVMA_SUMSE | Due Date Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
29 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
30 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 69 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
31 | YTEL01_DOCSE | Commission Document: Due Dates | 39 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
32 | YTEL01_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
33 | YTEL01_SUMRE | Remuneration Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
34 | YTEL01_SUMSE | Due Date Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
35 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
36 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 63 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
37 | YTEL05_DOCSE | Commission Document: Due Dates | 28 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
38 | YTEL05_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
39 | YTEL05_SESIT | Settlement Schedule Item | 18 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
40 | YTEL05_SUMRE | Remuneration Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
41 | YTEL05_SUMSE | Due Date Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
42 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 26 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
43 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 47 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
44 | ZICMAG_DOCSE | Commission Document: Due Dates | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
45 | ZICMAG_LIN | Variant Commissions | 22 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
46 | ZICMAG_SUMRE | Remuneration Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |
47 | ZICMAG_SUMSE | Due Date Totals for Contract Account Display | 8 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | | |