| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RF_SV | Payroll Result: Social Insurance (F) | 11 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
2 | P2RG_CARCO2 | Payroll Results: GB Company Cars (CO2 based calculation) | 5 | REGNO | License plate number | nvarchar | 10 | 0 | | |
3 | P2RW_CST | Payroll Result: Cumulated Tax Data for South Africa. | 21 | REGNO | Old version - Use P16_REGNO_C instead | nvarchar | 16 | 0 | | |
4 | P2RW_ST | Payroll Result: Tax Data for South Africa. | 22 | REGNO | Old version - Use P16_REGNO_C instead | nvarchar | 16 | 0 | | |
5 | PA0617 | HR Master Record: Infotype 0617 | 26 | REGNO | Registration number | nvarchar | 16 | 0 | | |
6 | T5FPBS1I | Effacement de bases pour les cotisations des organismes | 2 | REGNO | Modèle de charges | nvarchar | 4 | 0 | | |
7 | T7RU1655 | Infotype 1655 Fields: Legal properties (Russia) | 27 | REGNO | Registration Number | nvarchar | 14 | 0 | | |
8 | T7RU9A | Addresses of organizations | 33 | REGNO | Registration Number | nvarchar | 14 | 0 | | |
TOPBelgium |
9 | T5B1H | Relationships Betw. Companies and Institutions | 7 | REGNO | Registration Number at Institution | nvarchar | 20 | 0 | | |
10 | T5B1R | Relationships Betw. Pers. Subareas and Institutions | 8 | REGNO | Registration Number at Institution | nvarchar | 20 | 0 | | |
11 | T5B1T | Relationships Betw. Companies and Institutions | 8 | REGNO | Registration Number at Institution | nvarchar | 20 | 0 | | |
12 | T5B1U | Relationships Betw. Personnel Subareas and Institutions | 9 | REGNO | Registration Number at Institution | nvarchar | 20 | 0 | | |
TOPEnvironment, Health and Safety |
13 | DGTPK | DG: Packing Requirement | 31 | REGNO | Approval no. | nvarchar | 30 | 0 | | |
TOPEnvironment, Health and Safety Master Data |
14 | CCDUTPACK | Packaging Code Approvals | 34 | REGNO | Approval no. | nvarchar | 30 | 0 | | |
TOPFrance |
15 | PA0064 | Infotype 0064 : Social Insurance - France | 27 | REGNO | Expense template for other plans | nvarchar | 4 | 0 | | |
16 | T5F1D | Contributions plan | 4 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
17 | T5F1F | Assignment to social insurance fund model (France) | 2 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
18 | T5F1I | Fund model | 2 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
19 | T5F1M | Assignment to social insurance fund model (France) | 2 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
20 | T5F1T | Name of SI contribution plans | 3 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
21 | T5F4S | Employee groups associated with SI contribution models | 2 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
22 | T5F4V | Do not use: replaced by T5F4W | 12 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
23 | T5F4W | Contributions linked to personnel type | 12 | REGNO | SI contrib. model | nvarchar | 4 | 0 | | |
TOPGreat Britain |
24 | PA0222 | HR Master Record for Infotype 0222 (Company Cars GB) | 25 | REGNO | License Plate Number | nvarchar | 10 | 0 | | |
25 | T5G_P46ARV | HR-GB: Archive for P46(Car)-Forms | 4 | REGNO | License plate number | nvarchar | 10 | 0 | | |
TOPKorea |
26 | PA0539 | HR Master Record: Infotype 0539 | 28 | REGNO | Korean Registration Number | nvarchar | 13 | 0 | | |
27 | PA0540 | Family KOR | 26 | REGNO | Korean Registration Number | nvarchar | 13 | 0 | | |
28 | PB0539 | HR Master Record: Infotype 0539 | 28 | REGNO | Korean Registration Number | nvarchar | 13 | 0 | | |
TOPLocalization |
29 | J_1BECD_CUST05 | ECD Register Category | 2 | REGNO | ECD Register Number | nvarchar | 4 | 0 | | |
30 | J_1ISERVC | Service tax details | 11 | REGNO | Service tax registration number | nvarchar | 30 | 0 | | |
TOPPayroll |
31 | PA0770 | Personnel master data: Info type 0770 | 36 | REGNO | Registration No | nvarchar | 10 | 0 | | |
32 | PB0770 | Personnel master data: Info type 0770 | 36 | REGNO | Registration No | nvarchar | 10 | 0 | | |
TOPPersonnel Administration |
33 | PA0442 | HR Master Record: Infotype 0442 | 28 | REGNO | License plate number | nvarchar | 10 | 0 | | |
TOPSouth Africa |
34 | PA0149 | HR Master Record Infotype 0149 (Tax Data South Africa) | 44 | REGNO | Registered Number for Trust, CC and Company for IRP5 | nvarchar | 16 | 0 | | |