| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T241Z | User profile text table | 4 | GTEXT | User group description | nvarchar | 20 | 0 | | |
| 2 | T5C1O_EX | Cantons/Municipalities/Postcodes | 9 | GTEXT | Municipality text | nvarchar | 30 | 0 | | |
| 3 | T691C | Credit management group names | 5 | GTEXT | Name of the group | nvarchar | 30 | 0 | | |
| TOPBasic Functions |
| 4 | T000K | Group | 2 | GTEXT | Group name | nvarchar | 30 | 0 | | |
| TOPCanada |
| 5 | T5KE1_T | Text Table for Group Types | 5 | GTEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
| 6 | T5KE2_T | Text Table for Designated Groups | 6 | GTEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
| TOPCentral Field Selection |
| 7 | TFAWG | Field selection: Group texts | 5 | GTEXT | Field selection: Group of modified fields | nvarchar | 40 | 0 | | |
| TOPClinical System |
| 8 | N2GT | IS-H*MED: Classification areas catalog | 5 | GTEXT | Text of Classification Area Catalog Entry | nvarchar | 80 | 0 | | |
| TOPCross-Application Objects in HR |
| 9 | T705X | Names of Groupings for Subsystem Connection | 4 | GTEXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
| TOPFinancial Accounting |
| 10 | TGSBT | Business Area Names | 4 | GTEXT | Business area description | nvarchar | 30 | 0 | | |
| TOPLogical Database Builder |
| 11 | RSDSQGT | Functional Group Texts in Selection Views | 6 | GTEXT | Functional group text | nvarchar | 24 | 0 | | |
| TOPNorway |
| 12 | T5VA4 | Norwegian absence valuation segment definition - text | 4 | GTEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
| 13 | T5VS3 | Tax code granularity - Text table | 5 | GTEXT | Text, 40 Characters Long | nvarchar | 40 | 0 | | |
| TOPPatient Management |
| 14 | TNR01T | IS-H: Report Control: Texts for Groups | 4 | GTEXT | IS-H: Report control: Texts on the groups | nvarchar | 30 | 0 | | |
| TOPPayroll General Parts |
| 15 | T512G | Supplementary Group Texts | 9 | GTEXT | Line in Form | nvarchar | 255 | 0 | | |
| TOPPersonnel Administration |
| 16 | T518C | Education/Training Categories | 4 | GTEXT | Education/training category text | nvarchar | 25 | 0 | | |
| TOPPersonnel Time Management |
| 17 | T555G | [OBSOLETE; NOW USE T705H] Att./Absence Reasons Subssys. Text | 7 | GTEXT | Text for Attendance/Absence Reason | nvarchar | 30 | 0 | | |
| 18 | T705H | Attendance/Absence Reason Texts for Subsystem | 7 | GTEXT | Text for Attendance/Absence Reason | nvarchar | 30 | 0 | | |
| 19 | T705L | Indicator: Attendance/Absence Reason | 4 | GTEXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
| 20 | T705M | Indicator: External Wage Types Grouping | 4 | GTEXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
| TOPPublic Sector |
| 21 | T5D5E | Supplementary Pension Public Sector: Table of Notfctn Reason | 9 | GTEXT | Description of Notification Reason | nvarchar | 45 | 0 | | |
| TOPShipping |
| 22 | TVPODGT | TEXT: Reason for Variance in POD | 4 | GTEXT | Text (30 Characters) | nvarchar | 30 | 0 | | |
| TOPStaffing |
| 23 | T777G | Health Examinations | 5 | GTEXT | Health Examination Name | nvarchar | 25 | 0 | | |
| TOPSwitzerland |
| 24 | T5C1O | Cantons/Municipalities (CH) | 6 | GTEXT | Municipality text | nvarchar | 30 | 0 | | |
