| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPConditions |
1 | A870 | Appl./AgreemntNo/Std.Con.No/Version/Status | 6 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
TOPIncentive and Commission Management ICM |
2 | CACS_CASSGN | Combination Assignment for Commission Contract | 8 | CTRTST_ID | Filter of Standard Commission Contract for Determination | nvarchar | 20 | 0 | | |
3 | CACS_CTRTBU | Commission Contract | 5 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
4 | CACS_CTRTST | Standard Commission Contract | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
5 | CACS_CTRTSTI | Elements of Standard Commission Contract | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
6 | CACS_CTRTSTT | Standard Commission Contract: Texts | 4 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
7 | CACS_DET_VARIANT | Characteristics of Determination Variant | 22 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
8 | CACS_STAGASS | Link of Standard Agreements to Standard Contracts | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
9 | CACS_STATASS | Links of Agreement Types to Standard Contracts | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
10 | CACS_STCRERU | Rule Characteristics for Flat-Rate Agreements in Std Ctrct | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
11 | CACS_STCWARRU | Rule Characteristics for Guarantee Agreement in Std.Contract | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
12 | CACS_STDCTR | ICM: Standard Contract: Header Data | 3 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |
13 | CACS_STDCTRT | Text Table for Table CACS_STDCTR | 4 | CTRTST_ID | Number of Standard Commission Contract | nvarchar | 20 | 0 | | |