| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS00_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
2 | CACS00_DOCRE | Commission Document, Remuneration and Liability | 38 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
3 | CACS00_DOCSE | Commission Document, Settlement | 14 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
4 | CACS00_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
5 | CACS00_SUMRE | Totals Table for Remuneration | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
6 | CACS00_SUMSE | Totals Table for Settlement | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
7 | CACS25_SESHD | Settlement Schedule Header | 9 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
8 | CACS_CHRETY | Accountable Remuneration Types | 8 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
9 | CACS_COMB_NOTI | Combination of Noti rule with Remu type and Ret rule | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
10 | CACS_DOCRE | Expected Commission (Remuneration) | 10 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
11 | CACS_EMCLJO | Calculation Information for Clerk | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
12 | CACS_NOT_COMB | Combination of Noti rule with Remu type and Ret rule | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
13 | CACS_REMAJO | Flat-Rate Remuneration: Calculation Log | 9 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
14 | CACS_REMARU | Flat-Rate Remuneration Rule | 10 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
15 | CACS_REMSTM | Remuneration settlement | 8 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
16 | CACS_SESJO | Settlement Schedule Run Log | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
17 | CACS_SETT_LCK | Individual Contract for Settlement Locks for FT Approval | 7 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
18 | CACS_STCRERU | Rule Characteristics for Flat-Rate Agreements in Std Ctrct | 8 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
19 | CACS_STCWARRU | Rule Characteristics for Guarantee Agreement in Std.Contract | 8 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
20 | CACS_STRERU | Standard Ruling for Flat-Rate Remunerations | 7 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
21 | CACS_STWARRU | Rule Characteristics for Guarantee Agreement | 7 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
22 | CACS_S_NOT_CO | Combination of Noti rule with Remu type and Ret rule | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
23 | CACS_WARJO | Guarantee Calculation Log | 9 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
24 | CACS_WARRU | Individual Guarantee Agreement | 10 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
25 | TCACS_ELTDOCREV | Automatic Deactivation of ELT Document | 6 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
26 | TCACS_ELTNEGENT | Transfer Negative Entitlements in ELT | 6 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
27 | TCACS_ELTPOSTNEG | Transfer Reversal Posting in ELT | 6 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
28 | TCACS_ELTREM | ELT: Attributes of Remuneration Type | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
29 | TCACS_FILTER11 | Filter: Remuneration Types | 8 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
30 | TCACS_NOTREM | Assignment: Notification Rule - Remuneration Type | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
31 | TCACS_NOTREM_T | Assignment: Notification Rule - Remun.Type Text Table | 5 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
32 | TCACS_PORTREM | Portal / Hide Remuneration Types | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
33 | TCACS_REM | Commission Remuneration Types | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
34 | TCACS_REM_T | Commissions: Remuneration Types | 4 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
35 | TCACS_RETREM | Assignment of Remun.Type to Retention Rule Characteristics | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
36 | TCACS_SETT_LCK | Configuration Table for Settlement Locks for FT Approval | 7 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
37 | YCRM01_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
38 | YCRM01_DOCRE | Commission Document, Remuneration and Liability | 65 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
39 | YCRM01_DOCSE | Commission Document: Due Dates | 14 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
40 | YCRM01_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
41 | YCRM01_SESHD | Settlement Schedule Header | 9 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
42 | YCRM01_SUMRE | Remuneration Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
43 | YCRM01_SUMRE02 | Commissions: Reference Totals Table for Compensation | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
44 | YCRM01_SUMRE92 | Commissions: Total Commission Basis | 6 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
45 | YCRM01_SUMSE | Due Date Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
46 | YHITEC_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
47 | YHITEC_DOCRE | Commission Document, Remuneration and Liability | 48 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
48 | YHITEC_DOCSE | Commission Document: Due Dates | 14 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
49 | YHITEC_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
50 | YHITEC_SUMRE | Remuneration Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
51 | YHITEC_SUMSE | Due Date Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
52 | YSVMA_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
53 | YSVMA_DOCRE | Commission Document, Remuneration and Liability | 42 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
54 | YSVMA_DOCSE | Commission Document: Due Dates | 14 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
55 | YSVMA_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
56 | YSVMA_SESHD | Settlement Schedule Header | 9 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
57 | YSVMA_SUMRE | Remuneration Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
58 | YSVMA_SUMRE01 | Commissions: Reference Totals Table for Compensation | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
59 | YSVMA_SUMSE | Due Date Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
60 | YTEL01_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
61 | YTEL01_DOCRE | Commission Document, Remuneration and Liability | 62 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
62 | YTEL01_DOCSE | Commission Document: Due Dates | 31 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
63 | YTEL01_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
64 | YTEL01_SUMRE | Remuneration Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
65 | YTEL01_SUMRE04 | Commissions: Totals Table for Compensation (Scale Base) | 2 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
66 | YTEL01_SUMSE | Due Date Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
67 | YTEL01_SUMSE02 | Reference Table for Settlement | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
68 | YTEL05_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
69 | YTEL05_DOCRE | Commission Document, Remuneration and Liability | 56 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
70 | YTEL05_DOCSE | Commission Document: Due Dates | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
71 | YTEL05_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
72 | YTEL05_SESHD | Settlement Schedule Header | 9 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
73 | YTEL05_SUMRE | Remuneration Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
74 | YTEL05_SUMSE | Due Date Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
75 | ZICMAG_B_VAR_LIN | Variants for Alternative Commission | 20 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
76 | ZICMAG_DOCRE | Commission Document, Remuneration and Liability | 40 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
77 | ZICMAG_DOCSE | Commission Document: Due Dates | 14 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
78 | ZICMAG_LIN | Variant Commissions | 16 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
79 | ZICMAG_SUMRE | Remuneration Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |
80 | ZICMAG_SUMSE | Due Date Totals for Contract Account Display | 3 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | | |