| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCapacity Evaluations |
| 1 | TCYP | Profile detailed list: Criteria grouping | 9 | SORT_DOWN | Sort in descending order | nvarchar | 1 | 0 | | |
| 2 | TCYS | Profile detailed list: Sort criteria | 9 | SORT_DOWN | Sort in descending order | nvarchar | 1 | 0 | | |
| TOPInformation System |
| 3 | TCNA | Project Information System: Summarization Criteria (Aggr.) | 9 | SORT_DOWN | Sort in descending order | nvarchar | 1 | 0 | | |
| 4 | TCNP | Project Info System: Grouping Criteria | 9 | SORT_DOWN | Sort in descending order | nvarchar | 1 | 0 | | |
| 5 | TCNS | Project Info System: Sort Criteria | 9 | SORT_DOWN | Sort in descending order | nvarchar | 1 | 0 | | |
| TOPPersonnel Time Management |
| 6 | TPT_ESS_FSEL_TC | Field Selection for Table Control | 12 | SORT_DOWN | Indicator: Sort in Descending Order | nvarchar | 1 | 0 | | |
| 7 | TPT_FIELD_SEL_C | Field Selection: Customizing | 14 | SORT_DOWN | Indicator: Sort in Descending Order | nvarchar | 1 | 0 | | |
| TOPProduction Orders |
| 8 | TCOPS | Field selection profile | 8 | SORT_DOWN | Sort descending | nvarchar | 1 | 0 | | |
| TOPShift Planning |
| 9 | T77EH | Shift Planning: Proposal Lists for Assignments | 5 | SORT_DOWN | Sort descending | nvarchar | 1 | 0 | | |
