| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPReporting |
1 | P05T_AE_AANGIFTE | Wage Return: Administrative Unit - Collective Return | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
2 | P05T_AE_AANG_CUM | Wage Return: Cumulated Values Collective | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
3 | P05T_AE_ADM | Wage Return: Administrative Unit - Admin. Table | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
4 | P05T_AE_ADM_STAT | Wage Return: Administrative Unit - Status Table | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
5 | P05T_AE_CORSALDO | Wage Return: Administrative Unit - Balance Adjustments | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
6 | P05T_AE_WGF | Wage Return: Administrative Unit - Redundancy Pay Scheme | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
7 | P05T_AE_WGF_CUM | Wage Return: Administrative Unit: Sect/Risk Group Cumulated | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
8 | P05T_IV_AANGIFTE | Wage Return: Income Relationship - Nominative Return | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
9 | P05T_IV_AANG_CUM | Wage Return: Cumulated Values per Income Relationship | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
10 | P05T_IV_AA_BSN | Wage Return: Cumulated Values for BSN Changers | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
11 | P05T_IV_ADM | Wage Return: Income Relationship - Admin. Table | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
12 | P05T_IV_ADM_STAT | Wage Return: Income Relationship - Status Table | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
13 | P05T_IV_DA | Wage Return: Income Relationship - Return Data | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
14 | P05T_IV_DA_BSN | Wage Return: Other Cumulated Return Data | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
15 | P05T_IV_DA_CUM | Wage Return: Other Cumulated Return Data | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
16 | P05T_IV_INKPER | Wage Return: Income Relationship - Income Period | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
17 | P05T_IV_INKPERSA | Wage Return: Income Relationship - Income Period SI | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
18 | P05T_IV_PERSOON | Wage Return: Income Relationship - Personal Data | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
19 | P05T_IV_RG | Wage Return: Income Relationship - Risk Group Sector | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
20 | P05T_IV_RG_CUM | Wage Return: Income Relationship: Sect./Riskgrp. cumulated | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |
21 | P05T_RESP2LA | Wage Return: Rel. between Response Message and Wage Return | 6 | SRTAANG | Wage Return: Type of Return | nvarchar | 1 | 0 | | |