| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RR_NRIC | Payroll Singapore: NRIC | 15 | DOCN2 | Document number for work permit | nvarchar | 20 | 0 | | |
| 2 | PA3273 | HR Master Record: Infotype 3273 | 59 | DOCN2 | Document Number for Personal Identification | nvarchar | 15 | 0 | | |
| TOPBenefits |
| 3 | PA0171 | HR Master Record: Infotype 0171 (Gen. Benefits Information) | 29 | DOCN2 | Benefit Physician Name | nvarchar | 30 | 0 | | |
| 4 | PA0376 | HR Master Data Record: Infotype 0376 (Medical Benefits Info) | 26 | DOCN2 | Benefit Physician Name | nvarchar | 30 | 0 | | |
| TOPPersonnel Administration |
| 5 | PA0830 | HR master record for infotypes 0830 | 51 | DOCN2 | Payment statement number | nvarchar | 8 | 0 | | |
| TOPUSA |
| 6 | PA0094 | HR Master Record: Infotype 0094 (Residence Status - NA) | 32 | DOCN2 | Document number for work permit | nvarchar | 20 | 0 | | |
| 7 | PA0106 | HR Master Record: Infotype 0106 (Related Persons NA) | 41 | DOCN2 | Benefit Physician Name | nvarchar | 30 | 0 | | |
