| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | T7OM15T | Passport Type Text Table | 4 | PSTXT | Passport Type Text | nvarchar | 50 | 0 | | |
| 2 | T7QA65T | Passport Type Text Table | 4 | PSTXT | Passport Type Text | nvarchar | 50 | 0 | | |
| 3 | T7SA50T | Passport Type Text Table | 4 | PSTXT | Passport Type Text | nvarchar | 50 | 0 | | |
| TOPMaintenance Program Definition |
| 4 | MPDITEM | Maintenance Plan Items | 4 | PSTXT | Item Short Text | nvarchar | 40 | 0 | | |
| 5 | MPDPSD | MPD: MPD and MP header data | 26 | PSTXT | Item Short Text | nvarchar | 40 | 0 | | |
| TOPMaintenance Task Lists |
| 6 | MPOS | Maintenance item | 6 | PSTXT | Item Short Text | nvarchar | 40 | 0 | | |
| TOPMalaysia |
| 7 | T5LMB | Text for Personnel Area grouping for SOCSO (Malaysia) | 4 | PSTXT | Text for personnel area grouping for SOCSO (Malaysia) | nvarchar | 20 | 0 | | |
| TOPPortugal |
| 8 | T5PPS | HR-PT: Pay scale types additional information | 4 | PSTXT | Collective agreement type description | nvarchar | 128 | 0 | | |
| 9 | T5PSC | HR-PT: Pay scale types additional information | 10 | PSTXT | Collective agreement type description | nvarchar | 128 | 0 | | |
| 10 | T5PST | HR-PT: text table for additional information wage types | 6 | PSTXT | Collective agreement type description | nvarchar | 128 | 0 | | |
| TOPRetail Pricing |
| 11 | TWPST | Sales Price Calculations: Pricing Strategies (Texts) | 4 | PSTXT | Description | nvarchar | 40 | 0 | | |
