| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConditions |
1 | A611 | Sun.Vine Commission Rates | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
2 | A612 | Sun.Vine - Contingency Rate | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
3 | A802 | Appl./AgreemntNo/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
4 | A803 | Appl./AgreemntNo/Busi. Type/Segment/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
5 | A840 | Appl./AgreemntNo/Branch/Module/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
6 | A841 | Appl./AgreemntNo/Branch/AgreeCat/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
7 | A844 | Appl./AgreemntNo/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
8 | A845 | Rateplan Traffic Voice and Data Usage - YTEL05 | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
9 | A846 | Traffic Type Traffic Voice and Data Usage - YTEL05 | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
10 | A870 | Appl./AgreemntNo/Std.Con.No/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
11 | A871 | Monthly Incentive Target | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
12 | A872 | Monthly Transaction Target | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
13 | A873 | YTD Accelerator | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
14 | A896 | Complex Target | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
15 | A904 | Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
16 | A905 | Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status | 5 | P_CTRT_XL | Agreement Number Including Contract Type Indicator | nvarchar | 21 | 0 | | |
TOPIncentive and Commission Management ICM |
17 | A195 | A195 | 5 | P_CTRT_XL | Número del acuerdo inclusive indicador tp.contrato | nvarchar | 21 | 0 | | |
18 | A196 | A196 | 5 | P_CTRT_XL | Número del acuerdo inclusive indicador tp.contrato | nvarchar | 21 | 0 | | |