| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RN_ST | Payroll Results: Wage Tax (NL) | 8 | SOFIN | SoFi Number | nvarchar | 9 | 0 | | |
TOPNetherlands |
2 | PA0060 | HR Master Record: Infotype 0060 (Fiscal Data - NL) | 24 | SOFIN | Citizen Service Number [BSN] | nvarchar | 9 | 0 | | |
TOPReporting |
3 | P05TPRNL_M_NUMIR | Pension Return: Highest Assigned IR Number so far | 4 | SOFIN | Wage return: CSN/SoFi Number | nvarchar | 9 | 0 | | |
4 | P05T_EDM_PERSOON | Personal data for Day-one-announcement (EDM) | 4 | SOFIN | Citizen Service Number [BSN] | nvarchar | 9 | 0 | | |
5 | P05T_MAX_NUMIV | Wage Return: highest assigned IR number so far | 3 | SOFIN | Wage return: CSN/SoFi Number | nvarchar | 9 | 0 | | |