| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPABAP List-Based PI Sheet |
1 | COCHP | PI sheet: Control Recipe Header | 6 | ADRES | Operator or group of operators processing a PI sheet | nvarchar | 32 | 0 | | |
TOPB2A Business to Administration |
2 | PB2AMGR | HR-B2A: Application Data | 11 | ADRES | HR-B2A: Recipient | nvarchar | 10 | 0 | | |
3 | T50BC | HR-B2A: Transfer Format for Customer | 5 | ADRES | Address number | nvarchar | 10 | 0 | | |
TOPBelgium |
4 | T5B9A | Institutions (B) | 8 | ADRES | House number and street | nvarchar | 30 | 0 | | |
TOPBrowser-Based PI Sheet Cockpit |
5 | POC_DB_ARC_CONN | Optical Archiving: Link Data (ArchiveLink) | 16 | ADRES | Operator or group of operators processing a PI sheet | nvarchar | 32 | 0 | | |
TOPNetherlands |
6 | T5N1C | Health Insurance Companies (NL) | 9 | ADRES | House number and street | nvarchar | 30 | 0 | | |
7 | T5N9I | External Agencies | 6 | ADRES | External Agency Address Key | nvarchar | 8 | 0 | | |
8 | T5N9P | Representing Legal Persons (for External Agencies) | 5 | ADRES | Representing Legal Person Address Key | nvarchar | 8 | 0 | | |
TOPPayroll |
9 | PA0778 | Personel ana verileri: Bilgi tipi 0778 | 41 | ADRES | Metin (120 karakter uzunlugunda) | nvarchar | 120 | 0 | | |
TOPPension fund Netherlands |
10 | T5NH2 | Externe instanties werkgever | 7 | ADRES | Adrescode externe instantie | nvarchar | 8 | 0 | | |
11 | T5NH5 | Werkgeversdata van de aan het pensioenfonds verbonden deeln. | 14 | ADRES | Correspondentieadres | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
12 | T51CG | Leasing Companies for Company Cars | 6 | ADRES | Address Key for Leasing Company | nvarchar | 8 | 0 | | |
13 | T7CO01 | Additional data of the company | 13 | ADRES | Address | nvarchar | 50 | 0 | | |
TOPProcess Data Documentation |
14 | MCHPVS | Batch Record: Shadow Table for Link to Archive | 14 | ADRES | Operator or group of operators processing a PI sheet | nvarchar | 32 | 0 | | |
TOPProcess Management |
15 | COCH | Process Management: Control Recipe Header | 6 | ADRES | Address of the Control Recipe Destination | nvarchar | 32 | 0 | | |
16 | TC52 | Control Recipe Destinations | 4 | ADRES | Address of the Control Recipe Destination | nvarchar | 32 | 0 | | |
TOPPublic Sector |
17 | T5DPBSZVST | Notification Record Structures for Data Medium | 10 | ADRES | Name of Structure | nvarchar | 30 | 0 | | |
TOPRecruitment |
18 | T750C | Recruitment instrument | 5 | ADRES | Layout rule for address type | nvarchar | 8 | 0 | | |
TOPReporting |
19 | P05T_CVZ_REG_DAT | (De)registration data for HCIB | 14 | ADRES | Address for Health Care Insurance Board (De)Registration | nvarchar | 40 | 0 | | |
TOPSpain |
20 | T5E05 | Social Insurance branch offices | 4 | ADRES | House number and street | nvarchar | 30 | 0 | | |
21 | T5E70 | INEM offices | 4 | ADRES | House number and street | nvarchar | 30 | 0 | | |
TOPUSA |
22 | T5UTV | Unemployment Insurance Work Sites/NC-9901 Locations | 8 | ADRES | Address Text (Name, Street, City, Tel. No.) | nvarchar | 40 | 0 | | |