| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P05TPRNL_SYCHIR | Pension Return: System Change - IR Number per PERNR | 5 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | |
| 2 | P2RN_PRAP | Pension Return | 15 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | |
| TOPNetherlands |
| 3 | PA3274 | HR Master Record: Infotype 3274 | 25 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | |
| TOPReporting |
| 4 | P05TPRNL_C_NUMIR | Pension Return: current IR number | 7 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | |
| 5 | P05TPRNL_EE_ADM | Pension Return: Admin Income Relationship - Pers Level | 12 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | |
| 6 | P05TPRNL_M_NUMIR | Pension Return: Highest Assigned IR Number so far | 6 | NUMIR | Number Income Relationship | nvarchar | 4 | 0 | | |
