| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P05EIR_IKV | Electronic Illness Reporting. Work Relationship Data | 7 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
2 | P2RN_LA | Payroll Results: Wage Return | 25 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
TOPNetherlands |
3 | PA0808 | HR Master Record Infotype 0808 | 36 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
TOPReporting |
4 | P05T_CURR_NUMIV | Wage Return: current IR number | 6 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
5 | P05T_IV_AA_BSN | Wage Return: Cumulated Values for BSN Changers | 10 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
6 | P05T_IV_ADM | Wage Return: Income Relationship - Admin. Table | 11 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
7 | P05T_IV_DA_BSN | Wage Return: Other Cumulated Return Data | 10 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
8 | P05T_JLO_DATA | Data for Annual Wage Return | 51 | NUMIV | IR Number | nvarchar | 4 | 0 | | |
9 | P05T_MAX_NUMIV | Wage Return: highest assigned IR number so far | 5 | NUMIV | IR Number | nvarchar | 4 | 0 | | |