| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | TNC301XI | IS-H EDI: Sender Communication Specs (Institution-Specific) | 6 | ID1 | IS-H EDI: Hospital/Institution Number (External Code) | nvarchar | 10 | 0 | | |
| TOPData Collection |
| 2 | TKCHH | SAP-EIS: Hierarchy header | 4 | ID1 | Hierarchy key: Component 1 | nvarchar | 32 | 0 | | |
| 3 | TKCHHT | SAP-EIS: Texts for hierarchy header | 5 | ID1 | Hierarchy key: Component 1 | nvarchar | 32 | 0 | | |
| 4 | TKCHW | SAP-EIS: Hierarchy data | 4 | ID1 | Hierarchy key: Component 1 | nvarchar | 32 | 0 | | |
| TOPGermany |
| 5 | T5D4X_ZERTR | Certificate Request - Admin. Contrib. Statmt Certificates | 24 | ID1 | Checkbox | nvarchar | 1 | 0 | | |
| TOPMaintenance Orders |
| 6 | /MRSS/D_LINK | Link Table for the Scheduling Engine | 3 | ID1 | Resource GUID | varbinary | 16 | 0 | | |
| TOPPerformance Monitors TCC |
| 7 | GVD_LOCK | Copy of GV$LOCK | 7 | ID1 | Oracle monitoring: Lock identifier #1 (depends on type) | decimal | 22 | 0 | | |
| TOPTariffs, Duties and Permits |
| 8 | OIH_J1B_TCI | Brazilian Tax Calculation Commands Items | 6 | ID1 | Single-Character Indicator | nvarchar | 1 | 0 | | |
| TOPWorkforce Management Core |
| 9 | WFDST_LINK | Link Table for the Scheduling Engine | 3 | ID1 | Character field, length 32 | nvarchar | 32 | 0 | | |
