| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPConditions |
| 1 | A896 | Complex Target | 6 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 2 | CACS_STTGAGR | Tgt Agmts: Assignment of Target Types to Standard Agreements | 5 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 3 | CACS_TGLOG | Obsolete (Target Agreements: Log) | 4 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 4 | CACS_TGRCV | Target Agreement: Target Rule Classification Values | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 5 | CACS_TGRIND | Target Agreements: Individual Target Rules | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 6 | CACS_TGRIND_AES | Target Agreements: Individual Target Rules for AES | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 7 | CACS_TGRULE | Target Agreements: Generic Target Rules | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 8 | CACS_TGRULE_AES | Target Agreements: Generic Target Rules for AES | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 9 | TCACS_TGA | Tgt Agrmts: Assign Elementary to Complex Target Types | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 10 | TCACS_TGT | Target Agreements: Complex Target Type | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 11 | TCACS_TGTCLA | Target Agreements: Target Type Classification Assignments | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 12 | TCACS_TGTPORT | Hide Complex and Related Elementary Target Types (Portal) | 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 13 | TCACS_TGTT | Target Agreement: Target Type Texts | 4 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 14 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 11 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 15 | YSVMA_DOCOBJ | Commission Document: Object Data | 17 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 16 | YSVMA_DOCVA | Commission Document, Valuation | 8 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 17 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 23 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 18 | YTEL05_DOCVA | Commission Document, Valuation | 8 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
| 19 | YTEL05_OBJ | Commission Case Object Data | 19 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | | |
