| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P05EIR_ADM_UNIT | Electronic Illness Reporting: Administrative Unit Data | 4 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
2 | P05EIR_CH_PARTY | Electronic Illness Reporting: Chain Party Data | 5 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
TOPReporting |
3 | P05T_AE_ADM | Wage Return: Administrative Unit - Admin. Table | 7 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
4 | P05T_CURR_NUMIV | Wage Return: current IR number | 2 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
5 | P05T_CURR_VNR_JR | Wage Return: Current sequence number per year | 3 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
6 | P05T_CURR_VOLGNR | Wage Return: Current Sequence Number | 2 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
7 | P05T_EDM_PERSOON | Personal data for Day-one-announcement (EDM) | 10 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
8 | P05T_JLO_DATA | Data for Annual Wage Return | 2 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
9 | P05T_JLO_STAT | Annual Wage Return status | 2 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |
10 | P05T_MAX_NUMIV | Wage Return: highest assigned IR number so far | 2 | LHNR | Wage Return: Wage Tax Number | nvarchar | 12 | 0 | | |