Please enable JavaScript to view this site.

CompanyInfo Data Model Forums

Navigation: Schema: CompanyInfo > Tables

dutchBusinessUBOPickupInvestigation

Catalog: CompanyInfo

Schema: CompanyInfo

This is a read-only table function. The Company.info API may not support changing the data or the Invantive SQL driver for Company.info does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Company.info API.

Topic: dutchBusinessUBOPickupInvestigation

Base XPath: /s:Envelope/s:Body/tns:dutchBusinessUBOPickupInvestigationResponse/tns:out

Filters on API Server: token- include_source

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function dutchBusinessUBOPickupInvestigation. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

include_source

boolean

☐

 

 

token

string

☐

 

 

 

Table Function Columns

The columns of the table function dutchBusinessUBOPickupInvestigation are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

DOSSIER_NUMBER

string

File Number

 

 

NAME

string

Name

 

 

ORGANISATIONS_ITEM_CITY

string

 

 

 

ORGANISATIONS_ITEM_DOSSIER_NUMBER

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_DOCUMENT_DATE

datetime

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_DOCUMENT

byte[]

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_DOSSIER_NUMBER

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ACTIVITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_CORRESPONDENCE_CITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_CORRESPONDENCE_COUNTRY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_CORRESPONDENCE_HOUSE_NUMBER_ADDITION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_CORRESPONDENCE_HOUSE_NUMBER

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_CORRESPONDENCE_POSTCODE

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_CORRESPONDENCE_STREET

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DATE_SINCE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DATE_SINCE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DATE_SINCE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DESCRIPTION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DISCONTINUATION_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DISCONTINUATION_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DISCONTINUATION_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_DOMAIN_NAMES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_EMAIL_ADDRESSES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_CITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_COUNTRY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_HOUSE_NUMBER_ADDITION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_HOUSE_NUMBER

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_POSTCODE

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_ESTABLISHMENT_STREET

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_FAX_NUMBERS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_FOUNDING_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_FOUNDING_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_FOUNDING_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_INCORPORATION_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_INCORPORATION_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_INCORPORATION_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_LEGAL_FORM_TEXT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_NAME

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_PERSONNEL

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_REGISTRATION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_RSIN_NUMBER

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_SBI_CODES_TEXT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_SBI_CODES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_STATUS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_TELEPHONE_NUMBERS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ENTERPRISE_TRADE_NAMES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ESTABLISHMENT_NUMBER

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_ESTABLISHMENTS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ACTIVITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ALTERNATIVE_NAME

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ANNUAL_REPORT_SUBMISSION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL_CURRENCY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL

int64

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_COMPANY_ARRANGEMENT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_CORRESPONDENCE_CITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_CORRESPONDENCE_COUNTRY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_CORRESPONDENCE_HOUSE_NUMBER_ADDITION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_CORRESPONDENCE_HOUSE_NUMBER

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_CORRESPONDENCE_POSTCODE

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_CORRESPONDENCE_STREET

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISSOLUTION_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISSOLUTION_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISSOLUTION_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DISSOLUTION_REASON

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DOMAIN_NAMES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DURATION_END_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DURATION_END_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DURATION_END_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_DURATION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_EMAIL_ADDRESSES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ESTABLISHMENT_CITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ESTABLISHMENT_COUNTRY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ESTABLISHMENT_HOUSE_NUMBER_ADDITION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ESTABLISHMENT_HOUSE_NUMBER

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ESTABLISHMENT_POSTCODE

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ESTABLISHMENT_STREET

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_FAX_NUMBERS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_FOREIGN_LEGAL_FORM_DESCRIPTION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_FOUNDING_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_FOUNDING_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_FOUNDING_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_CURRENCY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL

int64

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LEGAL_FORM_CHANGE

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LEGAL_FORM_TEXT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LEGAL_NAME

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIABILITY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_MERGER_DESCRIPTION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_NAME

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_CURRENCY

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL

int64

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REGISTRATION

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REMOVAL_DATE_DAY

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REMOVAL_DATE_MONTH

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_REMOVAL_DATE_YEAR

int32

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_RSIN_NUMBER

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_SBI_CODES_TEXT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_SBI_CODES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_SHARE_HOLDERS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_SHARES

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_SHORTENED_NAME

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_STATUS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_STATUTORY_SEAT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_LEGAL_ENTITY_TELEPHONE_NUMBERS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_PARTNERSHIP

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_POSITIONS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DATA_STATUS

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_DOCUMENT

string

 

 

 

ORGANISATIONS_ITEM_EXTRACT_EXTRACT_DATE

datetime

 

 

 

ORGANISATIONS_ITEM_EXTRACT_SOURCE

string

 

 

 

ORGANISATIONS_ITEM_LEGAL_FORM_CODE

string

 

 

 

ORGANISATIONS_ITEM_LEGAL_FORM_TEXT

string

 

 

 

ORGANISATIONS_ITEM_NAME

string

 

 

 

PERSONS_ITEM_COUNTRY_OF_BIRTH

string

 

 

 

PERSONS_ITEM_DATE_OF_BIRTH

datetime

 

 

 

PERSONS_ITEM_DATE_OF_DEATH

datetime

 

 

 

PERSONS_ITEM_FIRST_NAME

string

 

 

 

PERSONS_ITEM_GENDER

string

 

 

 

PERSONS_ITEM_KEY

string

 

 

 

PERSONS_ITEM_LAST_NAME

string

 

 

 

PERSONS_ITEM_MIDDLE_NAMES

string

 

 

 

PERSONS_ITEM_PLACE_OF_BIRTH

string

 

 

 

PERSONS_ITEM_ROLES

string

 

 

 

TREE_ID

string

 

 

 

TREE_LEVEL

int64

 

 

 

TREE_NAME

string

 

 

 

TREE_PARENTS_ITEM_ID

string

 

 

 

TREE_PARENTS_ITEM_LEVEL

int64

 

 

 

TREE_PARENTS_ITEM_NAME

string

 

 

 

TREE_PARENTS_ITEM_REGISTERED_IN

string

 

 

 

TREE_PARENTS_ITEM_ROLE_TYPE

string

 

 

 

TREE_PARENTS_ITEM_TYPE

string

 

 

 

TREE_REGISTERED_IN

string

 

 

 

TREE_ROLE_TYPE

string

 

 

 

TREE_TYPE

string

 

 

 

 

15-06-2022 23:19 Version 22.1.46-BETA+3385