| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIncentive and Commission Management ICM |
| 1 | CACS_TGACV | Target Agreements: Indiv. Actual/Correction/Target Values | 4 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 2 | CACS_TGRATV | Target Agreements: Generic Actual/Target Values | 4 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 3 | TCACS_TGA | Tgt Agrmts: Assign Elementary to Complex Target Types | 4 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 4 | TCACS_TGS | Target Agreements: Elementary Target Types | 3 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 5 | TCACS_TGST | Target Agreements: Texts for Elementary Target Type | 4 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 6 | TCACS_TGSV | Tgt Agrmts: Permitted Units/Currencies for Element.Tgt Types | 3 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 7 | YSVMA_B_VAR_OBJ | Variants for Commission Case Object Data | 9 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 8 | YSVMA_DOCOBJ | Commission Document: Object Data | 16 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 9 | YSVMA_DOCVA | Commission Document, Valuation | 9 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 10 | YTEL05_B_VAR_OBJ | Variants for Commission Case Object Data | 21 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 11 | YTEL05_DOCVA | Commission Document, Valuation | 18 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
| 12 | YTEL05_OBJ | Commission Case Object Data | 18 | STGTTYPE | Target Agreements: Elementary Target Types | nvarchar | 4 | 0 | | |
