| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACS_COMB_NOTI | Combination of Noti rule with Remu type and Ret rule | 5 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
2 | CACS_NOT_COMB | Combination of Noti rule with Remu type and Ret rule | 5 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
3 | CACS_RETAGR | Individual Retention Agreement in Commission Contract | 6 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
4 | CACS_RET_ATIME | Retention: Last access time-spot in process | 4 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
5 | CACS_STCWARRU | Rule Characteristics for Guarantee Agreement in Std.Contract | 16 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
6 | CACS_STWARRU | Rule Characteristics for Guarantee Agreement | 15 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
7 | CACS_S_NOT_CO | Combination of Noti rule with Remu type and Ret rule | 5 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
8 | TCACS_NOTRET | Assignment: Notification Rule - Retention Rule | 4 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
9 | TCACS_NOTRET_T | Assignment: Notification Rule - Retention Rule Text Table | 5 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
10 | TCACS_RETREM | Assignment of Remun.Type to Retention Rule Characteristics | 6 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
11 | TCACS_RETRU | Retention Rule | 3 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
12 | TCACS_RETRUT | Name of Retention Rule | 4 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
13 | TCACS_STRETRU | Characteristic Attributes of Retention Rule | 5 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |
14 | TCACS_STRETRUT | Name of Characteristic Attributes of Retention Rule | 6 | RETRU_ID | Identification of Retention Rule | nvarchar | 4 | 0 | | |