| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_B_VAR_CAS | Variants for Commission Case | 34 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
2 | CACS00_B_VAR_OBJ | Variants for Commission Case Object Data | 20 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
3 | CACS00_CAS | Commission Case | 30 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
4 | CACS00_DOCHD | Commission Document Header | 28 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
5 | CACS00_DOCOBJ | Commission Document: Object Data | 12 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
6 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 36 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
7 | CACS00_DOCSE | Commission Document, Settlement | 20 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
8 | CACS00_DOCVA | Commission Document, Valuation | 21 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
9 | CACS00_OBJ | Commission Case Object Data | 16 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
10 | CACS00_SUMRE | Totals Table for Remuneration | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
11 | CACS00_SUMSE | Totals Table for Settlement | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
12 | CACS00_SUMVA | Totals Table for Valuation | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
13 | CACS25_SESIT | Settlement Schedule Item | 16 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
14 | CACS_DOCRE | Expected Commission (Remuneration) | 13 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
15 | TCACS_GLOB | Global Settings of Application for Each Client | 4 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
16 | TCACS_OTC03_OD | OTC 03 (Liability), Object-Specific Parameters | 8 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
17 | YCRM01_B_VAR_CAS | Variants for Commission Case | 42 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
18 | YCRM01_B_VAR_OBJ | Variants for Commission Case Object Data | 67 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
19 | YCRM01_CAS | Commission Case | 30 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
20 | YCRM01_DOCHD | Commission Document Header | 28 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
21 | YCRM01_DOCOBJ | Commission Document: Object Data | 12 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
22 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 63 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
23 | YCRM01_DOCSE | Commission Document: Due Dates | 20 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
24 | YCRM01_DOCVA | Commission Document, Valuation | 49 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
25 | YCRM01_OBJ | Commission Case Object Data | 63 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
26 | YCRM01_SESIT | Settlement Schedule Item | 16 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
27 | YCRM01_SUMRE | Remuneration Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
28 | YCRM01_SUMSE | Due Date Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
29 | YCRM01_SUMVA | Valuation Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
30 | YCRM01_SUMVA91 | Commissions: Reference Totals Table for Valuation | 4 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
31 | YHITEC_B_VAR_CAS | Variants for Commission Case | 27 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
32 | YHITEC_CAS | Commission Case | 23 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
33 | YHITEC_DOCHD | Commission Document Header | 29 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
34 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 46 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
35 | YHITEC_DOCSE | Commission Document: Due Dates | 20 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
36 | YHITEC_DOCVA | Commission Document, Valuation | 30 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
37 | YHITEC_SUMRE | Remuneration Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
38 | YHITEC_SUMSE | Due Date Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
39 | YHITEC_SUMVA | Valuation Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
40 | YSVMA_B_VAR_CAS | Variants for Commission Case | 42 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
41 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 35 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
42 | YSVMA_CAS | Commission Case | 38 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
43 | YSVMA_DOCHD | Commission Document Header | 36 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
44 | YSVMA_DOCOBJ | Commission Document: Object Data | 24 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
45 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 40 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
46 | YSVMA_DOCSE | Commission Document: Due Dates | 20 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
47 | YSVMA_DOCVA | Commission Document, Valuation | 26 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
48 | YSVMA_OBJ | Commission Case Object Data | 27 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
49 | YSVMA_SESIT | Settlement Schedule Item | 16 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
50 | YSVMA_SUMRE | Remuneration Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
51 | YSVMA_SUMRE01 | Commissions: Reference Totals Table for Compensation | 6 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
52 | YSVMA_SUMSE | Due Date Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
53 | YSVMA_SUMVA | Valuation Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
54 | YTEL01_B_VAR_CAS | Variants for Commission Case | 27 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
55 | YTEL01_CAS | Commission Case | 23 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
56 | YTEL01_DOCHD | Commission Document Header | 29 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
57 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 60 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
58 | YTEL01_DOCSE | Commission Document: Due Dates | 37 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
59 | YTEL01_DOCVA | Commission Document, Valuation | 52 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
60 | YTEL01_SUMRE | Remuneration Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
61 | YTEL01_SUMRE04 | Commissions: Totals Table for Compensation (Scale Base) | 8 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
62 | YTEL01_SUMSE | Due Date Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
63 | YTEL01_SUMVA | Valuation Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
64 | YTEL01_SUMVA02 | Reference Totals Table for Valuation (TELUS) | 8 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
65 | YTEL01_SUMVA03 | Reference Totals Table for Valuation (TELUS) | 5 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
66 | YTEL05_B_VAR_CAS | Variants for Commission Case | 42 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
67 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 53 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
68 | YTEL05_CAS | Commission Case | 38 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
69 | YTEL05_DOCHD | Commission Document Header | 36 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
70 | YTEL05_DOCOBJ | Commission Document: Object Data | 12 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
71 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 54 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
72 | YTEL05_DOCSE | Commission Document: Due Dates | 26 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
73 | YTEL05_DOCVA | Commission Document, Valuation | 36 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
74 | YTEL05_OBJ | Commission Case Object Data | 46 | LED_CURR | Currency Key of Transaction in Object Area | nvarchar | 5 | 0 | | |
75 | YTEL05_SESIT | Settlement Schedule Item | 16 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
76 | YTEL05_SUMRE | Remuneration Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
77 | YTEL05_SUMRE01 | Commissions: Reference Totals Table for Compensation | 2 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
78 | YTEL05_SUMRE91 | Commissions: Reference Totals Table for Compensation | 2 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
79 | YTEL05_SUMSE | Due Date Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
80 | YTEL05_SUMSE01 | Commissions: Reference Totals Table for Settlement | 2 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
81 | YTEL05_SUMSE91 | Commissions: Reference Totals Table for Settlement | 2 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
82 | YTEL05_SUMVA | Valuation Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
83 | YTEL05_SUMVA01 | Commissions: Reference Totals Table for Valuation | 2 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
84 | YTEL05_SUMVA91 | Commissions: Reference Totals Table for Valuation | 2 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
85 | ZICMAG_B_VAR_CAS | Variants for Commission Case | 27 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
86 | ZICMAG_CAS | Commission Case | 23 | LED_CURR | Currency Key for the Transaction | nvarchar | 5 | 0 | | |
87 | ZICMAG_DOCHD | Commission Document Header | 29 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
88 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 38 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
89 | ZICMAG_DOCSE | Commission Document: Due Dates | 20 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
90 | ZICMAG_DOCVA | Commission Document, Valuation | 23 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
91 | ZICMAG_SUMRE | Remuneration Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
92 | ZICMAG_SUMSE | Due Date Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |
93 | ZICMAG_SUMVA | Valuation Totals for Contract Account Display | 7 | LED_CURR | Currency Key | nvarchar | 5 | 0 | | |