| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2RB_SV | Social Insurance payroll Belgium | 69 | APTYP | Apprenticeship Type (00055) | nvarchar | 1 | 0 | | |
| 2 | P2RB_SVEVL | Payroll Results: DMFA Social Insurance table for Evaluation | 22 | APTYP | Apprenticeship Type (00055) | nvarchar | 1 | 0 | | |
| 3 | P2RL_TAX | Payroll result: Tax (Malaysia) | 18 | APTYP | Additional pay types | nvarchar | 1 | 0 | | |
| 4 | T77WWW_GACDEF | Generic Application Definition | 8 | APTYP | Solution Type | nvarchar | 2 | 0 | | |
| TOPBelgium |
| 5 | PA0100 | HR Master Record: Infotype 0100 (SI B) | 41 | APTYP | Apprenticeship Type (00055) | nvarchar | 1 | 0 | | |
| TOPCompany Pension Scheme Germany |
| 6 | T5DV2 | Entitlement Assignment of Value Types | 2 | APTYP | Entitlement Assignment for Value Types | nvarchar | 2 | 0 | | |
| 7 | T5DV2T | Entitlement Assignment of Value Types | 3 | APTYP | Entitlement Assignment for Value Types | nvarchar | 2 | 0 | | |
| TOPMalaysia |
| 8 | T5LTA | Additional tax table - Malaysia | 4 | APTYP | Additional pay types | nvarchar | 1 | 0 | | |
| TOPPublic Sector |
| 9 | PA0502 | Letter of appointment | 25 | APTYP | Appointment type | nvarchar | 2 | 0 | | |
| 10 | PB0502 | Letter of appointment | 25 | APTYP | Appointment type | nvarchar | 2 | 0 | | |
| 11 | T5PBSR4A | Appointment type | 2 | APTYP | Appointment type | nvarchar | 2 | 0 | | |
| 12 | T5PBSR4AT | Appointment type description | 3 | APTYP | Appointment type | nvarchar | 2 | 0 | | |
| TOPRecruitment |
| 13 | T750F | Text for applicant range | 3 | APTYP | Applicant range | nvarchar | 2 | 0 | | |
| 14 | T750X | Vacancy | 9 | APTYP | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | | |
