| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCRE01 | Do Not Use! Enhancement Data Remuneration Lines | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
2 | CACS00_DOCSE01 | Do Not Use! Enhancement Data Settlement Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
3 | CACS00_DOCVA01 | Do Not Use! Enhancement Data Evaluation Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
4 | CACS00_SUMRE01 | Commissions: Reference Totals Table for Compensation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
5 | CACS00_SUMSE01 | Commissions: Reference Totals Table for Settlement | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
6 | CACS00_SUMVA01 | Commissions: Reference Totals Table for Valuation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
7 | YCRM01_DOCRE91 | Do Not Use! Enhancement Data Remuneration Lines | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
8 | YCRM01_DOCSE91 | Do Not Use! Enhancement Data Settlement Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
9 | YCRM01_DOCVA91 | Do Not Use! Enhancement Data Evaluation Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
10 | YCRM01_SUMRE02 | Commissions: Reference Totals Table for Compensation | 9 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
11 | YCRM01_SUMRE91 | Commissions: Reference Totals Table for Compensation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
12 | YCRM01_SUMRE92 | Commissions: Total Commission Basis | 9 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
13 | YCRM01_SUMSE91 | Commissions: Reference Totals Table for Settlement | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
14 | YCRM01_SUMVA91 | Commissions: Reference Totals Table for Valuation | 6 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
15 | YHITEC_DOCRE91 | Do Not Use! Enhancement Data Remuneration Lines | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
16 | YHITEC_DOCSE91 | Do Not Use! Enhancement Data Settlement Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
17 | YHITEC_DOCVA91 | Do Not Use! Enhancement Data Evaluation Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
18 | YHITEC_SUMRE91 | Commissions: Reference Totals Table for Compensation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
19 | YHITEC_SUMSE91 | Commissions: Reference Totals Table for Settlement | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
20 | YHITEC_SUMVA91 | Commissions: Reference Totals Table for Valuation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
21 | YSVMA_SUMRE01 | Commissions: Reference Totals Table for Compensation | 7 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
22 | YTEL01_DOCRE01 | Do Not Use! Enhancement Data Remuneration Lines | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
23 | YTEL01_DOCSE01 | Do Not Use! Enhancement Data Settlement Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
24 | YTEL01_DOCVA01 | Do Not Use! Enhancement Data Evaluation Rows | 5 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
25 | YTEL01_SUMRE01 | Commissions: Reference Totals Table for Compensation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
26 | YTEL01_SUMRE03 | Reference Table for Compensation | 4 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
27 | YTEL01_SUMRE04 | Commissions: Totals Table for Compensation (Scale Base) | 10 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
28 | YTEL01_SUMSE01 | Commissions: Reference Totals Table for Settlement | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
29 | YTEL01_SUMSE02 | Reference Table for Settlement | 8 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
30 | YTEL01_SUMVA01 | Commissions: Reference Totals Table for Valuation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
31 | YTEL01_SUMVA02 | Reference Totals Table for Valuation (TELUS) | 10 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
32 | YTEL01_SUMVA03 | Reference Totals Table for Valuation (TELUS) | 10 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
33 | YTEL05_SUMRE01 | Commissions: Reference Totals Table for Compensation | 4 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
34 | YTEL05_SUMRE02 | Commissions: Reference Totals Table for Compensation | 2 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
35 | YTEL05_SUMRE91 | Commissions: Reference Totals Table for Compensation | 3 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
36 | YTEL05_SUMSE01 | Commissions: Reference Totals Table for Settlement | 4 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
37 | YTEL05_SUMSE91 | Commissions: Reference Totals Table for Settlement | 4 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
38 | YTEL05_SUMVA01 | Commissions: Reference Totals Table for Valuation | 4 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |
39 | YTEL05_SUMVA91 | Commissions: Reference Totals Table for Valuation | 4 | CACSDUMMY | Numerical Dummy Field | decimal | 10 | 0 | | |