| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConditions |
1 | A904 | Appl./AgreemntNo/Divis./Contr. no./RemBusTrCt/Version/Status | 7 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
2 | A905 | Appl./AgreemntNo/Contr. no./RemBusTrCt/Version/Status | 6 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
TOPIncentive and Commission Management ICM |
3 | CACS00_B_VAR_INV | Variants for Commission Case Participants | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
4 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
5 | CACS00_DOCINV | Participant in Commission Document | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
6 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
7 | CACS00_DOCSE | Commission Document, Settlement | 8 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
8 | CACS00_INV | Commission Case Participants | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
9 | CACS00_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
10 | CACS00_SUMRE | Totals Table for Remuneration | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
11 | CACS00_SUMSE | Totals Table for Settlement | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
12 | CACS25_SESHD | Settlement Schedule Header | 16 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
13 | CACS25_SESIT | Settlement Schedule Item | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
14 | CACSCS_DFKKCOH | Aggregation Container | 7 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
15 | CACS_BUCAGR | Commission: Agreement Bundle | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
16 | CACS_CTBU_WA | Work Regions for Commission Contract | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
17 | CACS_CTCOREX | Correspondence Enhancement | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
18 | CACS_CTRTBU | Commission Contract | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
19 | CACS_CTRTCORR | ICM: Assignment of Correspondence Types to Contract | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
20 | CACS_DET_VARIANT | Characteristics of Determination Variant | 21 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
21 | CACS_DOCRE | Expected Commission (Remuneration) | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
22 | CACS_EMCLJO | Calculation Information for Clerk | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
23 | CACS_EMSTMJO | Settlement Information for Clerk | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
24 | CACS_PRAGR | Indiv. Payment Release Agreement for Commission Contract | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
25 | CACS_PS_GRP | Assignment of Group Contract to Partnership | 4 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
26 | CACS_REMAJO | Flat-Rate Remuneration: Calculation Log | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
27 | CACS_REMARU | Flat-Rate Remuneration Rule | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
28 | CACS_RESRULE | Reserves Rule | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
29 | CACS_RETAGR | Individual Retention Agreement in Commission Contract | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
30 | CACS_RET_ATIME | Retention: Last access time-spot in process | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
31 | CACS_RI_IT | Run Administration Items | 6 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
32 | CACS_RI_IT_PRD | Run Administration Detail with Period | 6 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
33 | CACS_SEGAGR | Agreement for The Assignment of Segments | 8 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
34 | CACS_SESAGR | (Individual) Settlement Schedule Agreement in CommnContract | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
35 | CACS_SESJO | Settlement Schedule Run Log | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
36 | CACS_SETTL_LOCK | Locked Business Partners for Contracts | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
37 | CACS_SETT_LCK | Individual Contract for Settlement Locks for FT Approval | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
38 | CACS_STL_CLS | Next Open Period | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
39 | CACS_STMAGR | Individual Settlement Agreement (Obsolete) | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
40 | CACS_STMRU | Individual Settlement Rule | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
41 | CACS_STMTJO | Settlement run log | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
42 | CACS_TGACV | Target Agreements: Indiv. Actual/Correction/Target Values | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
43 | CACS_TGAGR | Target Agreements: Individual Rules for Target Agreements | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
44 | CACS_TGLOG | Obsolete (Target Agreements: Log) | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
45 | CACS_TGRIND | Target Agreements: Individual Target Rules | 4 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
46 | CACS_TGRIND_AES | Target Agreements: Individual Target Rules for AES | 4 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
47 | CACS_TRICAJO | Commission Case Trigger: Log | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
48 | CACS_TRIGCAS | Rule for Cause of Additional Commission Case | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
49 | CACS_WARAGR | Individual Guarantee Agreement (Obsolete) | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
50 | CACS_WARJO | Guarantee Calculation Log | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
51 | CACS_WARRU | Individual Guarantee Agreement | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
52 | TCACS_PCINV | Participation Construction: Participants Template | 7 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
53 | YCRM01_B_VAR_INV | Variants for Commission Case Participants | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
54 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
55 | YCRM01_DOCINV | Participant in Commission Document | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
56 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 38 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
57 | YCRM01_DOCSE | Commission Document: Due Dates | 8 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
58 | YCRM01_INV | Commission Case Participants | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
59 | YCRM01_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
60 | YCRM01_SESHD | Settlement Schedule Header | 16 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
61 | YCRM01_SESIT | Settlement Schedule Item | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
62 | YCRM01_SUMRE | Remuneration Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
63 | YCRM01_SUMRE02 | Commissions: Reference Totals Table for Compensation | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
64 | YCRM01_SUMRE92 | Commissions: Total Commission Basis | 7 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
65 | YCRM01_SUMSE | Due Date Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
66 | YHITEC_B_VAR_INV | Variants for Commission Case Participants | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
67 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
68 | YHITEC_DOCINV | Participant in Commission Document | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
69 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 21 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
70 | YHITEC_DOCSE | Commission Document: Due Dates | 8 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
71 | YHITEC_INV | Commission Case Participants | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
72 | YHITEC_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
73 | YHITEC_SUMRE | Remuneration Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
74 | YHITEC_SUMSE | Due Date Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
75 | YSVMA_B_VAR_INV | Variants for Commission Case Participants | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
76 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
77 | YSVMA_DOCINV | Participant in Commission Document | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
78 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
79 | YSVMA_DOCSE | Commission Document: Due Dates | 8 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
80 | YSVMA_INV | Commission Case Participants | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
81 | YSVMA_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
82 | YSVMA_SESHD | Settlement Schedule Header | 16 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
83 | YSVMA_SESIT | Settlement Schedule Item | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
84 | YSVMA_SUMRE | Remuneration Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
85 | YSVMA_SUMRE01 | Commissions: Reference Totals Table for Compensation | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
86 | YSVMA_SUMSE | Due Date Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
87 | YTEL01_B_VAR_INV | Variants for Commission Case Participants | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
88 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
89 | YTEL01_DOCINV | Participant in Commission Document | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
90 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 35 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
91 | YTEL01_DOCSE | Commission Document: Due Dates | 25 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
92 | YTEL01_INV | Commission Case Participants | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
93 | YTEL01_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
94 | YTEL01_SUMRE | Remuneration Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
95 | YTEL01_SUMSE | Due Date Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
96 | YTEL01_SUMSE02 | Reference Table for Settlement | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
97 | YTEL01_SUMVA02 | Reference Totals Table for Valuation (TELUS) | 6 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
98 | YTEL05_B_VAR_INV | Variants for Commission Case Participants | 17 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
99 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
100 | YTEL05_DOCINV | Participant in Commission Document | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
101 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 29 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
102 | YTEL05_DOCSE | Commission Document: Due Dates | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
103 | YTEL05_INV | Commission Case Participants | 13 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
104 | YTEL05_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
105 | YTEL05_SESHD | Settlement Schedule Header | 16 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
106 | YTEL05_SESIT | Settlement Schedule Item | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
107 | YTEL05_SUMRE | Remuneration Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
108 | YTEL05_SUMSE | Due Date Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
109 | ZICMAG_B_VAR_INV | Variants for Commission Case Participants | 15 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
110 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 18 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
111 | ZICMAG_DOCINV | Participant in Commission Document | 9 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
112 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 13 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
113 | ZICMAG_DOCSE | Commission Document: Due Dates | 8 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
114 | ZICMAG_INV | Commission Case Participants | 11 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
115 | ZICMAG_LIN | Variant Commissions | 14 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
116 | ZICMAG_SUMRE | Remuneration Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
117 | ZICMAG_SUMSE | Due Date Totals for Contract Account Display | 2 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |
118 | ZZBG_T_REGION | YSVMA Region for Targets | 3 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | | |