| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FIBKRUD_CMO_HD | Consolidated MO header | 5 | EXTKEY | External key of Memo Order | nvarchar | 50 | 0 | | |
2 | FIBKRUD_MEMORDER | Memo Order for Banking RU | 5 | EXTKEY | External key of Memo Order | nvarchar | 50 | 0 | | |
TOPBasic Data |
3 | NC301 | IS-HCM: Order Table Data Transmission for EDI | 28 | EXTKEY | External Key for Identifying Messages | nvarchar | 20 | 0 | | |
4 | NC301S | IS-HCM: EDI Status Management | 41 | EXTKEY | External Key for Identifying Messages | nvarchar | 20 | 0 | | |
5 | NC301T | IS-H EDI Temporary Storage for Old EDI Msg. Status Records | 41 | EXTKEY | External Key for Identifying Messages | nvarchar | 20 | 0 | | |
TOPClinical System |
6 | N1BDCC | IS-H*MED: External Drug Basic Catalog Entries | 4 | EXTKEY | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
7 | N1FORMULARY | Medication: Drug Formulary | 101 | EXTKEY | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
8 | N2CCF_MSGS | CCF: Message Table | 18 | EXTKEY | CCF: Additional External Key for a Message | nvarchar | 50 | 0 | | |
9 | NAGENT | IS-H*MED: Agents of Drugs | 4 | EXTKEY | Medication: ID in Base Drug Catalog - OBSOLETE | nvarchar | 40 | 0 | | |
10 | NAGENTEXT | i.s.h.med: Medication; External References for Agents | 5 | EXTKEY | Medication: Key in External Catalog | nvarchar | 40 | 0 | | |
11 | TNTHSYS | Medication: Classification Systems | 5 | EXTKEY | Medication: ID in Base Drug Catalog - OBSOLETE | nvarchar | 40 | 0 | | |
TOPEngineering Change Management |
12 | ECM_OBJADM | Object Mgmt Records | 6 | EXTKEY | External Key for Object Management Record | nvarchar | 140 | 0 | | |