| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIncentive and Commission Management ICM |
| 1 | TCACS_ACTT | Activity: Text | 5 | DESCRIPT_SH | Activity Description | nvarchar | 30 | 0 | | |
| 2 | TCACS_ADDT | Additional Indicator Text | 5 | DESCRIPT_SH | Additional Indicator Name | nvarchar | 30 | 0 | | |
| 3 | TCACS_BDLTPT | Contract Bundle Type: Texts | 5 | DESCRIPT_SH | Description | nvarchar | 30 | 0 | | |
| 4 | TCACS_CTRTPT | Commission Contract Type: Texts | 5 | DESCRIPT_SH | Short Name of Standard Commission Contract | nvarchar | 30 | 0 | | |
| 5 | TCACS_CVGRBT | Grouping for Version Comparison Contract Bundle: Texts | 5 | DESCRIPT_SH | Grouping for Change Documents | nvarchar | 20 | 0 | | |
| 6 | TCACS_CVGRPT | Grouping for Version Comparison: Texts | 5 | DESCRIPT_SH | Grouping for Change Documents | nvarchar | 20 | 0 | | |
| 7 | TCACS_FITYPT | Dispatcher of Commission Interface: Filter Information Types | 6 | DESCRIPT_SH | Short Description for Filter Information Type | nvarchar | 30 | 0 | | |
| 8 | TCACS_ITITLET | Internal Title: Texts | 5 | DESCRIPT_SH | Internal Title Description | nvarchar | 30 | 0 | | |
| 9 | TCACS_KOARTT | Correspondence Type: Texts | 5 | DESCRIPT_SH | Name of Commission-Specific Correspondence Type | nvarchar | 30 | 0 | | |
| 10 | TCACS_NRRBDT | Contract Bundle - Number Ranges: Texts | 5 | DESCRIPT_SH | Number Range Issuing Category | nvarchar | 30 | 0 | | |
| 11 | TCACS_NRRCTT | Texts: Commission Contract Number Ranges | 5 | DESCRIPT_SH | Number Range Issuing Category | nvarchar | 30 | 0 | | |
| 12 | TCACS_STMTYT | Name: Settlement Type | 5 | DESCRIPT_SH | Settlement Type | nvarchar | 30 | 0 | | |
| 13 | TCACS_TERMDT | Notice Date: Texts | 4 | DESCRIPT_SH | Name of Cancellation Date | nvarchar | 30 | 0 | | |
| 14 | TCACS_TOFNT | Period of Notice: Texts | 4 | DESCRIPT_SH | Description of Notice Period | nvarchar | 30 | 0 | | |
| 15 | TCACS_WORKAT | Work Region: Texts | 5 | DESCRIPT_SH | Name of Work Region | nvarchar | 30 | 0 | | |
