| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTEI/OCR_TSTG | Staging table for HDCC download data | 18 | HSNMR | House Number | nvarchar | 10 | 0 | | |
2 | P2AR_ARDIMP | Tax deduction results | 17 | HSNMR | House Number | nvarchar | 6 | 0 | | |
3 | P2AR_AROIMP | Other employers | 9 | HSNMR | House Number | nvarchar | 6 | 0 | | |
4 | P2RB_ADR | Address payroll Belgium | 9 | HSNMR | House Number | nvarchar | 10 | 0 | | |
5 | P2RB_I0125 | Garnishment payroll Belgium | 39 | HSNMR | House Number | nvarchar | 6 | 0 | | |
6 | P2RF_SAR | Payroll Results: Garnishment | 21 | HSNMR | House Number | nvarchar | 6 | 0 | | |
7 | P2RN_NADR | Address Data | 12 | HSNMR | House Number | nvarchar | 10 | 0 | | |
8 | T7RU9A | Addresses of organizations | 12 | HSNMR | House Number | nvarchar | 10 | 0 | | |
9 | T7RUPA0006 | PA0006 copy | 39 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPArgentina |
10 | PA0390 | Income Tax: Deductions | 35 | HSNMR | House Number | nvarchar | 10 | 0 | | |
11 | PA0391 | Income Tax: Information on other employers | 28 | HSNMR | House Number | nvarchar | 10 | 0 | | |
12 | PA0392 | Social Security: General data | 43 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPBelgium |
13 | PA0125 | HR Master Record: Infotype 0125 (Garnishment B) | 46 | HSNMR | House Number | nvarchar | 6 | 0 | | |
14 | T5B9A | Institutions (B) | 18 | HSNMR | House Number | nvarchar | 6 | 0 | | |
15 | T5BS3 | Employee information except reductions ( level 3 ) | 20 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPBrazil |
16 | PA0736 | Alimony order for Brazil | 36 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPCompany Pension Scheme Germany |
17 | PA0746 | HR Master Record for Infotype 0746 | 35 | HSNMR | House Number | nvarchar | 9 | 0 | | |
TOPCross-Application Objects in HR |
18 | HRP5583 | DB Table for Infotype 5583 | 30 | HSNMR | House Number | nvarchar | 6 | 0 | | |
TOPFrance |
19 | PA0272 | Infotype 0272 (Garnishment) | 40 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPMexico |
20 | T7MX01 | Additional Company Informaton | 7 | HSNMR | House Number | nvarchar | 6 | 0 | | |
21 | T7MX24 | IMSS Employer Regis. nos. | 6 | HSNMR | House Number | nvarchar | 6 | 0 | | |
TOPNetherlands |
22 | T5N1C | Health Insurance Companies (NL) | 10 | HSNMR | House Number | nvarchar | 6 | 0 | | |
23 | T5N9A | Authority Addresses (NL) | 10 | HSNMR | House Number | nvarchar | 6 | 0 | | |
TOPPayroll |
24 | T5T1X | Last foreign Health insurance - name | 9 | HSNMR | House Number | nvarchar | 10 | 0 | | |
25 | T5TELDP2004TRANS | Records ELDP for transfer from external system to SAP | 28 | HSNMR | House Number | nvarchar | 10 | 0 | | |
26 | T5TREGTRANS | HRCZ - table for transfer items of Insured Register to SAP | 31 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPPersonnel Administration |
27 | PA0006 | HR Master Record: Infotype 0006 (Addresses) | 39 | HSNMR | House Number | nvarchar | 10 | 0 | | |
28 | PA0517 | HR Master Record: Infotype 0517 | 25 | HSNMR | House Number | nvarchar | 10 | 0 | | |
29 | T7PL01 | Tax offices | 7 | HSNMR | House Number | nvarchar | 6 | 0 | | |
TOPRecruitment |
30 | PB0006 | HR Master Record: Infotype 0006 (Addresses) | 39 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPReporting |
31 | P05TPRNL_EE_PD | Pension Return: Personal Data - Pers Level | 27 | HSNMR | House Number | nvarchar | 10 | 0 | | |
TOPSpain |
32 | T5EDH | Local tax offices/authorities | 8 | HSNMR | House Number | nvarchar | 6 | 0 | | |