| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAuthentication and SSO |
| 1 | USR01 | User master record (runtime data) | 12 | HNAME | Default host user name | nvarchar | 12 | 0 | | |
| TOPCapacity Evaluations |
| 2 | TCY08 | Option profiles | 17 | HNAME | Name of hierarchy | nvarchar | 10 | 0 | | |
| TOPCapacity Leveling |
| 3 | TCY34 | Evaluation profile for capacity leveling | 6 | HNAME | Name of hierarchy | nvarchar | 10 | 0 | | |
| TOPPatient Accounting |
| 4 | TNM20HT | IS-H MM: Hierarchy for material input facility (texts) | 4 | HNAME | IS-H: Text of length 80 | nvarchar | 80 | 0 | | |
| TOPReporting |
| 5 | MCSHIERB | Tree for general hierarchy | 3 | HNAME | Hierarchy name of the general hierarchies | nvarchar | 10 | 0 | | |
| 6 | MCSHIERBT | Texts for general hierarchy tree | 4 | HNAME | Hierarchy name of the general hierarchies | nvarchar | 10 | 0 | | |
| 7 | MCSHIERK | Header of general hierarchy | 3 | HNAME | Hierarchy name of the general hierarchies | nvarchar | 10 | 0 | | |
| TOPSecure Network Communications |
| 8 | SNCSYSACL | SNC Access Control List (ACL): Systems | 4 | HNAME | SNC: Hash value for canonical names | nvarchar | 32 | 0 | | |
| 9 | USRACL | SNC Access Control List (ACL): User | 6 | HNAME | SNC: Hash value for canonical names | nvarchar | 32 | 0 | | |
| 10 | USRACLEXT | Extended SNC Access Control List (ACL) for Users | 6 | HNAME | SNC: Hash value for canonical names | nvarchar | 32 | 0 | | |
| TOPWithout Description |
| 11 | RSROLEHIERARCHY | Role hierarchy | 1 | HNAME | Hierarchy name | nvarchar | 30 | 0 | | |
