| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | N1ME_THREC_LB | Medication: Link Module Data for Therapy Recommendation | 2 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| TOPClinical System |
| 2 | N2DOKREF | IS-H*MED: External data ref./Link table for param. docs | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 3 | N2MATREF | IS-H*MED: Reference table for material external data (N2FM) | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 4 | N2MIREF | IS-H*MED: Reference data table for MED-Image coupling | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 5 | N2PMDBLOB | Cluster Table for Link Objects | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 6 | N2PMDBTFE_LSAVE | IS-H*MED: Data for Link Element BTE Editor (PMD) | 2 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 7 | N2PMDETEXT | PMD: Enhanced Text | 2 | REFKEY | PMD: Reference by GUUID | nvarchar | 32 | 0 | | |
| 8 | N2PMDHTML_LSAVE | IS-H*MED: Link Element HTML Viewer (PMD) Data | 2 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 9 | N2PMDTEXT | Cluster Table for PMD Endless Texts | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 10 | N2REFDIA | IS-H*MED: External data ref. table for NDIA (diagnoses) | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| 11 | N2TEAMREF | IS-H*MED: Ref table for team ext. data modules (N2F2) | 3 | REFKEY | Reference Key of a Referenced Object | nvarchar | 20 | 0 | | |
| TOPIntercompany Data Exchange |
| 12 | EIDESWTDOCATTR | Attribute for Activity | 3 | REFKEY | Switch Document Reference, Unique Key | nvarchar | 22 | 0 | | |
| 13 | EIDESWTDOCREF | Switch Document Reference | 3 | REFKEY | Switch Document Reference, Unique Key | nvarchar | 22 | 0 | | |
| TOPLocalization |
| 14 | J_1BNFLIN | Nota Fiscal line items | 20 | REFKEY | Reference to source document | nvarchar | 35 | 0 | | |
| 15 | J_1B_CIAP_OBJECT | CIAP document data | 58 | REFKEY | Reference to source document | nvarchar | 35 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 16 | JKSDQMSG | Quality Notification | 8 | REFKEY | Object key | nvarchar | 70 | 0 | | |
| TOPTime Sheet |
| 17 | CATSOFFTRANSKEY | Table of CATS Offline Transaction Keys | 7 | REFKEY | Transaction Key for CATS Offline Applications | varbinary | 16 | 0 | | |
