| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPArchive Information System |
| 1 | AIND_STR1 | Archive Info Structures | 5 | SKEY | Archive Information System Field Catalog | nvarchar | 15 | 0 | | |
| 2 | AIND_STR6 | AS, Field Catalog: Additional Info on Fields | 1 | SKEY | Archive Information System Field Catalog | nvarchar | 15 | 0 | | |
| TOPASAP Tools and Contents |
| 3 | SMAPCOMP0 | Solution Map: Component | 3 | SKEY | Solution Map: Component code | nvarchar | 24 | 0 | | |
| 4 | SMAPPA0 | Solution Map: Partner product | 2 | SKEY | Solution Map: Product code | nvarchar | 20 | 0 | | |
| 5 | SMAPPD0 | Solution Map: Product information | 2 | SKEY | Solution Map: Product code | nvarchar | 20 | 0 | | |
| TOPBank Components |
| 6 | JBDMKFGDT | Risk Object: Required/Optional Control | 4 | SKEY | Indicator for required/optional control: Key field | nvarchar | 1 | 0 | | |
| 7 | JBDMKSECU | Addition to Req./Opt.Control for Security Class Data | 8 | SKEY | Indicator for required/optional control: Key field | nvarchar | 1 | 0 | | |
| TOPCase Management |
| 8 | SCMGPDIR | Template for Area-Specific POID Directory | 3 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| TOPClinical System |
| 9 | N1IPST | IS-H*MED: Asgmt of Stnd. Nursing Plans to Ind. Nursing Plans | 4 | SKEY | Coding of the Standardized Nursing Plan | nvarchar | 20 | 0 | | |
| 10 | N1ZPLST | IS-H*MED: Assignment of standards to STD - nursing plans | 6 | SKEY | Coding of the Standardized Nursing Plan | nvarchar | 20 | 0 | | |
| 11 | N2PS | IS-H*MED: Nursing standard catalog | 4 | SKEY | Coding of the Standardized Nursing Plan | nvarchar | 20 | 0 | | |
| 12 | N2PSBZ | IS-H*MED: Nursing standard - basic catalog assignment | 5 | SKEY | Coding of the Standardized Nursing Plan | nvarchar | 20 | 0 | | |
| 13 | N2PSGZ | IS-H*MED: Nursing standard - classification areas asgmt | 5 | SKEY | Coding of the Standardized Nursing Plan | nvarchar | 20 | 0 | | |
| 14 | N2PSLZ | IS-H*MED: Nursing standard - service catalog assignment | 4 | SKEY | Coding of the Standardized Nursing Plan | nvarchar | 20 | 0 | | |
| TOPCommunication Services Mail, Fax, SMS, Telephony |
| 15 | SRIRSEARCH | BCOM Internal Router: Search Tables (with Addresses) | 6 | SKEY | Routing: Value of Search Key | nvarchar | 241 | 0 | | |
| TOPData Conversion |
| 16 | DMC_IFCO | Application-Specific Configuration | 7 | SKEY | Key for Configuring Interfaces | nvarchar | 4 | 0 | | |
| 17 | DMC_IFREG | Registration of Interfaces | 8 | SKEY | Key for Configuring Interfaces | nvarchar | 4 | 0 | | |
| TOPData Transfer |
| 18 | JBDMKTB | Required/Optional Control for EDT (SAP Banking) | 7 | SKEY | Indicator for required/optional control: Key field | nvarchar | 1 | 0 | | |
| TOPRecords and Case Management |
| 19 | RMPSAPDIR_T | Template for Area-Specific POID Directory | 3 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| 20 | RMPSAPDIR_T_CLNT | Template for Area-Specific POID Directory (Client) | 4 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| TOPSAP Records Management |
| 21 | SCMGPDIR_CLNT | Template for Area-Specific POID Directory (Client) | 4 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| 22 | SRMAPDIR_T | Template for Area-Specific POID Directory | 3 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| 23 | SRMAPDIR_T_CLNT | Template for Area-Specific POID Directory (Client) | 4 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| 24 | SRMRMSPDIR | Template for Area-Specific POID Directory | 3 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| 25 | SRMRMSPDIR_CLNT | Template for Area-Specific POID Directory (Client) | 4 | SKEY | POID Directory - Search Key (not unique) | nvarchar | 32 | 0 | | |
| TOPTransaction Data Pool |
| 26 | JBDMKCDFP | Required/Optional Control for Class Data for Fin. Product | 5 | SKEY | Indicator for required/optional control: Key field | nvarchar | 1 | 0 | | |
| 27 | JBDMKVTFD | Variable Transaction: Opt./Req. Control - Flow Data | 4 | SKEY | Indicator for required/optional control: Key field | nvarchar | 1 | 0 | | |
| 28 | JBDMKVTMD | Variable Transaction: Opt./Req. Control - Master Data | 4 | SKEY | Indicator for required/optional control: Key field | nvarchar | 1 | 0 | | |
