| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N1DFO | IS-H*MED: Dispensing Form | 10 | LIDAT | Date of Last Import - External Catalog Type | nvarchar | 8 | 0 | | |
| 2 | N1MEK | IS-H*MED: Master Data Medications - Catalogs | 10 | LIDAT | Date of Last Import - External Catalog Type | nvarchar | 8 | 0 | | |
| 3 | N1MEP | OBSOLETE: Master Data Medication - Catalog Positions | 15 | LIDAT | Date of Last Import - External Catalog Type | nvarchar | 8 | 0 | | |
| 4 | N1MEPSTFZ | IS-H*MED: Medication - Substance Assignment | 13 | LIDAT | Date of Last Import - External Catalog Type | nvarchar | 8 | 0 | | |
| 5 | N1STF | IS-H*MED: Master Data of Medication Substances | 12 | LIDAT | Date of Last Import - External Catalog Type | nvarchar | 8 | 0 | | |
| 6 | N1STFTYP | IS-H*MED: Substance Types | 11 | LIDAT | Date of Last Import - External Catalog Type | nvarchar | 8 | 0 | | |
