| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConditions |
1 | A600 | IDES_Global Agreement for Valuation, depend on the Catagory | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
2 | A610 | Valuation for Campaign | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
3 | A611 | Sun.Vine Commission Rates | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
4 | A612 | Sun.Vine - Contingency Rate | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
5 | A631 | Appl./Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
6 | A802 | Appl./AgreemntNo/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
7 | A803 | Appl./AgreemntNo/Busi. Type/Segment/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
8 | A840 | Appl./AgreemntNo/Branch/Module/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
9 | A841 | Appl./AgreemntNo/Branch/AgreeCat/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
10 | A844 | Appl./AgreemntNo/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
11 | A845 | Rateplan Traffic Voice and Data Usage - YTEL05 | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
12 | A846 | Traffic Type Traffic Voice and Data Usage - YTEL05 | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
13 | A850 | Branch dependent valuation | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
14 | A851 | Branch and Agreement category dependent valuation | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
15 | A860 | Appl./Class/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
16 | A870 | Appl./AgreemntNo/Std.Con.No/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
17 | A871 | Monthly Incentive Target | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
18 | A872 | Monthly Transaction Target | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
19 | A873 | YTD Accelerator | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
20 | A880 | Appl./Rate Plan/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
21 | A881 | YTEL01 - Product Multiplier | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
22 | A882 | YTEL01 - Term Multiplier | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
23 | A883 | YTEL01 - Discount Multiplier | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
24 | A884 | YTEL01 - Listprice Multiplier | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
25 | A885 | YTEL01 - Margin Multiplier | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
26 | A896 | Complex Target | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
27 | A904 | Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
28 | A905 | Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status | 4 | P_CACSAPPL | Commission Application (ICM) | nvarchar | 6 | 0 | | |
TOPIncentive and Commission Management ICM |
29 | A194 | A194 | 4 | P_CACSAPPL | Aplicación de comisión (ICM) | nvarchar | 6 | 0 | | |
30 | A195 | A195 | 4 | P_CACSAPPL | Aplicación de comisión (ICM) | nvarchar | 6 | 0 | | |
31 | A196 | A196 | 4 | P_CACSAPPL | Aplicación de comisión (ICM) | nvarchar | 6 | 0 | | |
32 | A197 | A197 | 4 | P_CACSAPPL | Aplicación de comisión (ICM) | nvarchar | 6 | 0 | | |
33 | A198 | A198 | 4 | P_CACSAPPL | Aplicación de comisión (ICM) | nvarchar | 6 | 0 | | |