| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RB_NAME | Payroll Results: Name of Employee | 7 | NAMZU | Other Title | nvarchar | 15 | 0 | | |
2 | P2RD_NAME | Payroll Results: Name of Employee | 7 | NAMZU | Other Title | nvarchar | 15 | 0 | | |
3 | PDPBSZVNAM_R | SPI Confirmation: Name (Record Type 80) | 9 | NAMZU | Name Affix, ZVE-PBS | nvarchar | 20 | 0 | | |
4 | HRP1702 | DB Table for Infotype 1702 | 25 | NAMZU | Other Title | nvarchar | 15 | 0 | | |
TOPAdvertising Management |
5 | JJTAM | IS-M/AM: Media Contact Person | 19 | NAMZU | IS-M: Name Affix | nvarchar | 15 | 0 | | |
TOPBasic Data |
6 | NGPA | IS-H: Business Partners | 14 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | | |
TOPClinical System |
7 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 11 | NAMZU | IS-H: Ad eki | nvarchar | 15 | 0 | | |
8 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 12 | NAMZU | IS-H: Ad eki | nvarchar | 15 | 0 | | |
9 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 12 | NAMZU | IS-H: Ad eki | nvarchar | 15 | 0 | | |
10 | N2MV_DISREQ | Dispatch Request Data Table | 16 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | | |
11 | N2MV_VSDAT | Recipient Data Table | 15 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | | |
TOPCompany Pension Scheme Germany |
12 | P01RBM_IM01 | Notification Data IM01 Pension Receipt Notif. Answer Tax ID | 9 | NAMZU | Name Affixes | nvarchar | 20 | 0 | | |
13 | P01RBM_MI01 | Notification Data MI01 Pension Receipt Notif. Query Tax ID | 21 | NAMZU | Name Affixes | nvarchar | 20 | 0 | | |
14 | P01RBM_MI01R | Confirmation MI01 Pension Receipt Notification Query Tax ID | 21 | NAMZU | Name Affixes | nvarchar | 20 | 0 | | |
15 | P01RBM_MZ01 | Reporting Data MZ01 Pension Receipt Notification | 26 | NAMZU | Name Affixes | nvarchar | 20 | 0 | | |
16 | P01RBM_MZ01R | Confirmation MZ01 Pension Receipt Notification | 26 | NAMZU | Name Affixes | nvarchar | 20 | 0 | | |
17 | PA0746 | HR Master Record for Infotype 0746 | 55 | NAMZU | Name Affixes | nvarchar | 15 | 0 | | |
TOPCross-Application Objects in HR |
18 | HRP5582 | DB Table for Infotype 5582 | 28 | NAMZU | Other Title | nvarchar | 15 | 0 | | |
TOPMaster Data |
19 | JGTSADR | IS-M: Extended Address Management | 20 | NAMZU | IS-M: Name Affix | nvarchar | 15 | 0 | | |
TOPPatient Management |
20 | NPAP | IS-H: Provisional Patient Master Data | 12 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | | |
21 | NPAT | IS-H: Patient Master Data (General) | 10 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | | |
22 | NTMN | IS-H: Patient-Specific Appointments (Header Table for NAPP) | 20 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | | |
TOPPeriodical Sales and Distribution |
23 | JKWWWTEMP_BP | IS-M/SD: WWW, Temporary Table for BP Data from Internet | 44 | NAMZU | IS-M: Name Affix | nvarchar | 15 | 0 | | |
24 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 62 | NAMZU | IS-M: Name Affix | nvarchar | 15 | 0 | | |
25 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 62 | NAMZU | IS-M: Name Affix | nvarchar | 15 | 0 | | |
26 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 43 | NAMZU | IS-M: Name Affix | nvarchar | 15 | 0 | | |
TOPPersonnel Administration |
27 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 32 | NAMZU | Other Title | nvarchar | 15 | 0 | | |
TOPPublic Sector |
28 | PDPBSZVNAM | Name (Record Type 80), ZVE-PBS | 17 | NAMZU | Name Affix, ZVE-PBS | nvarchar | 20 | 0 | | |
TOPRecruitment |
29 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 32 | NAMZU | Other Title | nvarchar | 15 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
30 | NLVERZF_010 | Aufmachung patient name in Vektis format | 6 | NAMZU | IS-H: Titel/voorvoegsel | nvarchar | 1 | 0 | | |
31 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 10 | NAMZU | Pseudonymized Name Affix | nvarchar | 15 | 0 | | |
TOPTax |
32 | P01T_LST | ETStmt: General Employment Tax Data | 19 | NAMZU | ETStmt: Addition to Last Name | nvarchar | 20 | 0 | | |
TOPTraining and Event Management |
33 | HRP1034 | Infotype 1034 DB table | 21 | NAMZU | Title | nvarchar | 15 | 0 | | |