| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TNNLREFER_TYPE | Steuerung Sorgetyp nach Verweisungstyp | 10 | SPTYP | Facharzt Typ | nvarchar | 2 | 0 | | |
TOPBasic Data |
2 | NPER | IS-H: Persons | 26 | SPTYP | IS-H: Specialist Type | nvarchar | 2 | 0 | | |
3 | NTSI | IS-H: Service catalog column information | 8 | SPTYP | IS-H: Data Type for Service Catalog Column | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
4 | MATERIALID | Material Identification | 8 | SPTYP | Specialization Category | nvarchar | 10 | 0 | | |
5 | MATERIALID_ARC | Archived Material Identification | 7 | SPTYP | Specialization Category | nvarchar | 10 | 0 | | |
TOPERS |
6 | CEKRS | Movement type parameters for automatic ERS | 4 | SPTYP | Document split for evaluated receipt settlement (ERS) | nvarchar | 1 | 0 | | |
TOPLoans Management |
7 | TDP2 | File functions | 5 | SPTYP | Function type (report, transaction etc.) | nvarchar | 1 | 0 | | |
TOPMaterial Master |
8 | MATERIALIDDI_TMP | File for Incorrect Data in Direct Input | 11 | SPTYP | Specialization Category | nvarchar | 10 | 0 | | |
9 | MGVSPECTYPE | Specialization types material master | 2 | SPTYP | Specialization Category | nvarchar | 10 | 0 | | |
10 | MGVSPECTYPET | Specialization types material master | 2 | SPTYP | Specialization Category | nvarchar | 10 | 0 | | |
11 | MGVSPECTYPETEXTS | Text for specialization types | 2 | SPTYP | Specialization Category | nvarchar | 10 | 0 | | |
TOPRemote Logistics Management |
12 | OIO_CM_SPROC_DVP | Supply process derivation from plant | 6 | SPTYP | Supply type | nvarchar | 2 | 0 | | |
13 | OIO_CM_SPROC_DVS | Supply process derivation from store location | 5 | SPTYP | Supply type | nvarchar | 2 | 0 | | |
14 | OIO_CM_SPTYP | RLM Supply Types | 2 | SPTYP | Supply type | nvarchar | 2 | 0 | | |
15 | OIO_CM_SPTYP_TX | RLM Supply type descriptions | 3 | SPTYP | Supply type | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
16 | NLVERZF_002 | Konversion SAP Facharzt nach VEKTIS Sorge arzt | 3 | SPTYP | IS-H: Type specialist | nvarchar | 2 | 0 | | |
17 | NLVERZF_011 | Konversion leistungcode SAP nach leistungcode VEKTIS | 5 | SPTYP | IS-H: Type specialist | nvarchar | 2 | 0 | | |
18 | TNLDBC_TRDBC2 | IS-H NL: Dummy DBC per anfragender Arzt | 4 | SPTYP | IS-H: Type specialist | nvarchar | 2 | 0 | | |