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