| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRP1655 | DB Table for Infotype 1655 | 29 | ANSNR | Organization Tax Number (INN) | nvarchar | 20 | 0 | | |
2 | T7RU9A | Addresses of organizations | 24 | ANSNR | Organization Tax Number (INN) | nvarchar | 20 | 0 | | |
TOPNetherlands |
3 | T5N9A | Authority Addresses (NL) | 19 | ANSNR | Registration Number | nvarchar | 20 | 0 | | |
4 | T5N9R | Relationship Repr. Legal Person and External Agencies | 8 | ANSNR | Registration Number | nvarchar | 20 | 0 | | |
TOPPension fund Netherlands |
5 | T5NH3 | Relatie werkgever en externe instanties | 10 | ANSNR | Aansluitnummer externe instanties | nvarchar | 20 | 0 | | |
TOPReporting |
6 | P05TPRNL_C_NUMIR | Pension Return: current IR number | 3 | ANSNR | Registration Number | nvarchar | 20 | 0 | | |
7 | P05TPRNL_C_SEQNO | Pension Return: Current sequence number per period | 5 | ANSNR | Registration Number | nvarchar | 20 | 0 | | |
8 | P05TPRNL_LP_ADM | Pension Return: Administration - Legal Pers Level | 9 | ANSNR | Registration Number | nvarchar | 20 | 0 | | |
9 | P05TPRNL_M_NUMIR | Pension Return: Highest Assigned IR Number so far | 3 | ANSNR | Registration Number | nvarchar | 20 | 0 | | |