| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCHD | Commission Document Header | 9 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
2 | CACS00_DOCVA | Commission Document, Valuation | 8 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
3 | CACS00_SUMRE | Totals Table for Remuneration | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
4 | CACS00_SUMVA | Totals Table for Valuation | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
5 | YCRM01_DOCHD | Commission Document Header | 9 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
6 | YCRM01_DOCVA | Commission Document, Valuation | 36 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
7 | YCRM01_SUMRE | Remuneration Totals for Contract Account Display | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
8 | YCRM01_SUMRE02 | Commissions: Reference Totals Table for Compensation | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
9 | YCRM01_SUMRE92 | Commissions: Total Commission Basis | 4 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
10 | YCRM01_SUMVA | Valuation Totals for Contract Account Display | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
11 | YCRM01_SUMVA91 | Commissions: Reference Totals Table for Valuation | 3 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
12 | YHITEC_DOCHD | Commission Document Header | 7 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
13 | YHITEC_DOCVA | Commission Document, Valuation | 17 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
14 | YHITEC_SUMRE | Remuneration Totals for Contract Account Display | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
15 | YHITEC_SUMVA | Valuation Totals for Contract Account Display | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
16 | YSVMA_DOCHD | Commission Document Header | 17 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
17 | YSVMA_DOCVA | Commission Document, Valuation | 13 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
18 | YSVMA_SUMRE | Remuneration Totals for Contract Account Display | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
19 | YSVMA_SUMRE01 | Commissions: Reference Totals Table for Compensation | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
20 | YSVMA_SUMVA | Valuation Totals for Contract Account Display | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
21 | YTEL01_DOCHD | Commission Document Header | 7 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
22 | YTEL01_DOCVA | Commission Document, Valuation | 39 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
23 | YTEL01_SUMRE | Remuneration Totals for Contract Account Display | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
24 | YTEL01_SUMRE04 | Commissions: Totals Table for Compensation (Scale Base) | 7 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
25 | YTEL01_SUMVA | Valuation Totals for Contract Account Display | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
26 | YTEL01_SUMVA02 | Reference Totals Table for Valuation (TELUS) | 4 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
27 | YTEL01_SUMVA03 | Reference Totals Table for Valuation (TELUS) | 4 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
28 | YTEL05_DOCHD | Commission Document Header | 17 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
29 | YTEL05_DOCVA | Commission Document, Valuation | 23 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
30 | YTEL05_SUMRE | Remuneration Totals for Contract Account Display | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
31 | YTEL05_SUMVA | Valuation Totals for Contract Account Display | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
32 | ZICMAG_DOCHD | Commission Document Header | 7 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
33 | ZICMAG_DOCVA | Commission Document, Valuation | 10 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
34 | ZICMAG_SUMRE | Remuneration Totals for Contract Account Display | 5 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |
35 | ZICMAG_SUMVA | Valuation Totals for Contract Account Display | 6 | POST_MONTH | Period in Posting Year | nvarchar | 2 | 0 | | |