| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P05EIR_AANGIFTE | Electronic Illness Reporting: Data for Wage Information | 5 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
2 | T5C1G | Percentages | 9 | ANPRM | Employee percent - male | decimal | 5 | 2 | | |
3 | T5C1K | HR-CH: insurance contributions | 8 | ANPRM | Insurance premium per thousand | decimal | 6 | 3 | | |
TOPReporting |
4 | P05T_AE_AANGIFTE | Wage Return: Administrative Unit - Collective Return | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
5 | P05T_AE_AANG_CUM | Wage Return: Cumulated Values Collective | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
6 | P05T_AE_ADM | Wage Return: Administrative Unit - Admin. Table | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
7 | P05T_AE_ADM_STAT | Wage Return: Administrative Unit - Status Table | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
8 | P05T_AE_CORSALDO | Wage Return: Administrative Unit - Balance Adjustments | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
9 | P05T_AE_WGF | Wage Return: Administrative Unit - Redundancy Pay Scheme | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
10 | P05T_AE_WGF_CUM | Wage Return: Administrative Unit: Sect/Risk Group Cumulated | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
11 | P05T_IV_AANGIFTE | Wage Return: Income Relationship - Nominative Return | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
12 | P05T_IV_AANG_CUM | Wage Return: Cumulated Values per Income Relationship | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
13 | P05T_IV_AA_BSN | Wage Return: Cumulated Values for BSN Changers | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
14 | P05T_IV_ADM | Wage Return: Income Relationship - Admin. Table | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
15 | P05T_IV_ADM_STAT | Wage Return: Income Relationship - Status Table | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
16 | P05T_IV_DA | Wage Return: Income Relationship - Return Data | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
17 | P05T_IV_DA_BSN | Wage Return: Other Cumulated Return Data | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
18 | P05T_IV_DA_CUM | Wage Return: Other Cumulated Return Data | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
19 | P05T_IV_INKPER | Wage Return: Income Relationship - Income Period | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
20 | P05T_IV_INKPERSA | Wage Return: Income Relationship - Income Period SI | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
21 | P05T_IV_PERSOON | Wage Return: Income Relationship - Personal Data | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
22 | P05T_IV_RG | Wage Return: Income Relationship - Risk Group Sector | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
23 | P05T_IV_RG_CUM | Wage Return: Income Relationship: Sect./Riskgrp. cumulated | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
24 | P05T_WCR_EE_DATA | WCR Data on Employee Level | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
25 | P05T_WCR_ER_DATA | WCR Data on Employer Level | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
26 | P05T_WCR_ER_INFO | WCR Info on Employer Level | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
27 | P05T_WCR_FL | WCR: Final Levy and Final Settlement | 6 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
28 | P05T_WCR_PROT | WCR Protocol Table | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
29 | P05T_WCR_STAT | WCR Status Table | 4 | ANPRM | Wage Return For-Period | nvarchar | 2 | 0 | | |
TOPTax |
30 | P01T_A_ADM | ETNotif.: Administration - Employment Tax Notification | 5 | ANPRM | ETNotif.: Notification Period | nvarchar | 2 | 0 | | |
31 | P01T_A_ADS | ETNotif.: Status Administration/Employment Tax Notification | 5 | ANPRM | ETNotif.: Notification Period | nvarchar | 2 | 0 | | |
32 | P01T_A_BTG | ETNotif.: Tax Amounts in Employment Tax Notification | 5 | ANPRM | ETNotif.: Notification Period | nvarchar | 2 | 0 | | |
33 | P01T_A_DAT | ETNotif.: General Data for Employment Tax Notification | 5 | ANPRM | ETNotif.: Notification Period | nvarchar | 2 | 0 | | |
34 | P01T_A_EXT | ETNotif.: External Data | 5 | ANPRM | ETNotif.: Notification Period | nvarchar | 2 | 0 | | |