| 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 | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 2 | A610 | Valuation for Campaign | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 3 | A611 | Sun.Vine Commission Rates | 13 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 4 | A612 | Sun.Vine - Contingency Rate | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 5 | A631 | Appl./Version/Status | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 6 | A802 | Appl./AgreemntNo/Version/Status | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 7 | A803 | Appl./AgreemntNo/Busi. Type/Segment/Version/Status | 11 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 8 | A840 | Appl./AgreemntNo/Branch/Module/Version/Status | 11 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 9 | A841 | Appl./AgreemntNo/Branch/AgreeCat/Version/Status | 11 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 10 | A844 | Appl./AgreemntNo/Version/Status | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 11 | A845 | Rateplan Traffic Voice and Data Usage - YTEL05 | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 12 | A846 | Traffic Type Traffic Voice and Data Usage - YTEL05 | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 13 | A850 | Branch dependent valuation | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 14 | A851 | Branch and Agreement category dependent valuation | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 15 | A860 | Appl./Class/Version/Status | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 16 | A870 | Appl./AgreemntNo/Std.Con.No/Version/Status | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 17 | A871 | Monthly Incentive Target | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 18 | A872 | Monthly Transaction Target | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 19 | A873 | YTD Accelerator | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 20 | A880 | Appl./Rate Plan/Version/Status | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 21 | A881 | YTEL01 - Product Multiplier | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 22 | A882 | YTEL01 - Term Multiplier | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 23 | A883 | YTEL01 - Discount Multiplier | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 24 | A884 | YTEL01 - Listprice Multiplier | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 25 | A885 | YTEL01 - Margin Multiplier | 9 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 26 | A896 | Complex Target | 10 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 27 | A904 | Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status | 12 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| 28 | A905 | Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status | 11 | P_STATE | Condition Record Status | nvarchar | 1 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 29 | A194 | A194 | 10 | P_STATE | Status registro condición | nvarchar | 1 | 0 | | |
| 30 | A195 | A195 | 10 | P_STATE | Status registro condición | nvarchar | 1 | 0 | | |
| 31 | A196 | A196 | 11 | P_STATE | Status registro condición | nvarchar | 1 | 0 | | |
| 32 | A197 | A197 | 10 | P_STATE | Status registro condición | nvarchar | 1 | 0 | | |
| 33 | A198 | A198 | 9 | P_STATE | Status registro condición | nvarchar | 1 | 0 | | |
