| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS_BUCAGR | Commission: Agreement Bundle | 18 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
2 | CACS_CHRETY | Accountable Remuneration Types | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
3 | CACS_CTRTSTI | Elements of Standard Commission Contract | 6 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
4 | CACS_DET_VARIANT | Characteristics of Determination Variant | 23 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
5 | CACS_PRAGRRU | Assignment of Standard Payment Release Agreement | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
6 | CACS_REMSTM | Remuneration settlement | 6 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
7 | CACS_STAGASS | Link of Standard Agreements to Standard Contracts | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
8 | CACS_STATASS | Links of Agreement Types to Standard Contracts | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
9 | CACS_STCAGR | Standard agreement for commission contract | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
10 | CACS_STCAGRT | Name: Standard Agreement for Commission Contract | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
11 | CACS_STCAGR_B | Standard Agreement for Commission Contract - Backup | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
12 | CACS_STCRERU | Rule Characteristics for Flat-Rate Agreements in Std Ctrct | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
13 | CACS_STCWARRU | Rule Characteristics for Guarantee Agreement in Std.Contract | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
14 | CACS_STRERU | Standard Ruling for Flat-Rate Remunerations | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
15 | CACS_STRERUT | Name: Standard Ruling for Flat-Rate Remunerations | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
16 | CACS_STSESRU | Standard Settlement Schedule Agreement | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
17 | CACS_STSESRUT | Name of Standard Settlement Schedule Agreement | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
18 | CACS_STSTMRU | Standard Settlement Ruling | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
19 | CACS_STSTMT | Name: Standard Settlment Ruling | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
20 | CACS_STTCRU | Standard Rules for Commission Case Triggers | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
21 | CACS_STTCRUT | Name: Standard Rules for Commission Case Triggers | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
22 | CACS_STTGAGR | Tgt Agmts: Assignment of Target Types to Standard Agreements | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
23 | CACS_STWARRU | Rule Characteristics for Guarantee Agreement | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
24 | CACS_STWART | Name: Rule Characteristics for Guarantee Agreement | 5 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
25 | TCACS_AGRTYP | Agreement Types for Each Application | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
26 | TCACS_CTTAGR | Which Agreement Types Are Allowed for Each Contract Type? | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
27 | TCACS_OFFRULING | Comn: Remuneration Clearing Regulation | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
28 | TCACS_OFFRULIN_B | Comn: Remuneration Clearing Regulation | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
29 | TCACS_RETREM | Assignment of Remun.Type to Retention Rule Characteristics | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
30 | TCACS_SC_UI_ADM | Standard Contract: UI Enhancement Using Subroadmaps | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
31 | TCACS_SC_UI_WDAB | Standard Contract: UI Enhancement Using Subroadmaps WDABAP | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
32 | TCACS_SETT_LCK | Configuration Table for Settlement Locks for FT Approval | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
33 | TCACS_SETT_LCKT | Text Table for Settlement Lock Configuration | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
34 | TCACS_STRETRU | Characteristic Attributes of Retention Rule | 3 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |
35 | TCACS_STRETRUT | Name of Characteristic Attributes of Retention Rule | 4 | AGR_TYP | Agreement Type | nvarchar | 2 | 0 | | |