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