| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2AR_ARCIMP | Tax results | 14 | ICNUM | Document number | nvarchar | 20 | 0 | | |
2 | P2AR_ARDIMP | Tax deduction results | 14 | ICNUM | Document number | nvarchar | 20 | 0 | | |
3 | P2AR_AROIMP | Other employers | 6 | ICNUM | Document number | nvarchar | 20 | 0 | | |
4 | P2BR_BRDEP | Dependents: master data | 12 | ICNUM | IC number | nvarchar | 20 | 0 | | |
5 | P2CO_COSSA | PC2CO_SSA | 20 | ICNUM | Identification number | nvarchar | 12 | 0 | | |
6 | P2IN_GRY | Payroll structure for Gratuity | 10 | ICNUM | IC number | nvarchar | 20 | 0 | | |
7 | P2IN_SAN | Payroll structure for Superannuation | 10 | ICNUM | IC number | nvarchar | 20 | 0 | | |
8 | P2RR_NRIC | Payroll Singapore: NRIC | 19 | ICNUM | IC number | nvarchar | 20 | 0 | | |
9 | T7HK11 | General information of the IR56 forms | 8 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |
TOPArgentina |
10 | PA0390 | Income Tax: Deductions | 32 | ICNUM | Document number | nvarchar | 20 | 0 | | |
11 | PA0391 | Income Tax: Information on other employers | 25 | ICNUM | Document number | nvarchar | 20 | 0 | | |
12 | PA0392 | Social Security: General data | 40 | ICNUM | Document number | nvarchar | 20 | 0 | | |
13 | PA0394 | Family data: Additional information | 35 | ICNUM | Document number | nvarchar | 20 | 0 | | |
TOPBrazil |
14 | PA0397 | Infotype 0021 Family | 43 | ICNUM | CPF no. | nvarchar | 30 | 0 | | |
TOPMalaysia |
15 | PA0213 | Additional family information - Malaysia | 24 | ICNUM | IC number | nvarchar | 20 | 0 | | |
TOPPersonnel Administration |
16 | PA0517 | HR Master Record: Infotype 0517 | 41 | ICNUM | IC number | nvarchar | 20 | 0 | | |
17 | T7COT2 | Payroll external results transfer: COSSA | 20 | ICNUM | Identification number | nvarchar | 12 | 0 | | |
TOPPersonnel Management |
18 | PA0562 | HR Master Record: Infotype 0562 | 26 | ICNUM | Identity card number | nvarchar | 10 | 0 | | |
TOPPublic Sector |
19 | PA0502 | Letter of appointment | 52 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |
20 | PB0502 | Letter of appointment | 52 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |
TOPSingapore |
21 | PA0185 | HR Master Record: Infotype 0185 [Identification] (SG) | 25 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |
22 | PB0185 | HR Master Record: Infotype 0185 (Personal ID) | 25 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |
TOPSouth Africa |
23 | T5WITA88 | ITA88 Transaction Table | 13 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |
TOPTaiwan |
24 | T7TW2I | Reported data of Tax withdrawal report | 32 | ICNUM | Identity Number | nvarchar | 30 | 0 | | |