| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_DOCVA | Commission Document, Valuation | 20 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
2 | CACS00_SUMVA | Totals Table for Valuation | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
3 | YCRM01_DOCVA | Commission Document, Valuation | 48 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
4 | YCRM01_SUMVA | Valuation Totals for Contract Account Display | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
5 | YCRM01_SUMVA91 | Commissions: Reference Totals Table for Valuation | 5 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
6 | YHITEC_DOCVA | Commission Document, Valuation | 29 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
7 | YHITEC_SUMVA | Valuation Totals for Contract Account Display | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
8 | YSVMA_DOCVA | Commission Document, Valuation | 25 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
9 | YSVMA_SUMVA | Valuation Totals for Contract Account Display | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
10 | YTEL01_DOCVA | Commission Document, Valuation | 51 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
11 | YTEL01_SUMVA | Valuation Totals for Contract Account Display | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
12 | YTEL01_SUMVA02 | Reference Totals Table for Valuation (TELUS) | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
13 | YTEL01_SUMVA03 | Reference Totals Table for Valuation (TELUS) | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
14 | YTEL05_DOCVA | Commission Document, Valuation | 35 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
15 | YTEL05_SUMVA | Valuation Totals for Contract Account Display | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
16 | YTEL05_SUMVA01 | Commissions: Reference Totals Table for Valuation | 3 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
17 | YTEL05_SUMVA91 | Commissions: Reference Totals Table for Valuation | 3 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
18 | ZICMAG_DOCVA | Commission Document, Valuation | 22 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |
19 | ZICMAG_SUMVA | Valuation Totals for Contract Account Display | 9 | DVALUE_AMNT | Valuation Amount Change in Commission Model Currency | decimal | 15 | 2 | | |