invantive documentation
Forum di supporto InvantiveAccedi / Registrati

dutchBusinessGetExtractDocumentDataV2: Company.info itgen_cio_dutchbusinessgetextractdocumentdatav2

read only XML

  • Catalogo: CompanyInfo
  • Schema: CompanyInfo
  • Etichetta: itgen_cio_dutchbusinessgetextractdocumentdatav2

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Argomento XML: dutchBusinessGetExtractDocumentDataV2

Parametri

Name Tipo di dati Required Default Documentation
dossier_number ``

Colonne della tabella

Di seguito sono riportate le colonne della tabella dutchBusinessGetExtractDocumentDataV2. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
DATA_DOSSIER_NUMBER varchar2 itgen_cio_data File Number
DATA_ENTERPRISE_ACTIVITY varchar2 itgen_cio_data_enterprise Activity
DATA_ENTERPRISE_DATE_SINCE_DAY number itgen_cio_data_enterprise_date_since Day
DATA_ENTERPRISE_DATE_SINCE_MONTH number itgen_cio_data_enterprise_date_since Month
DATA_ENTERPRISE_DATE_SINCE_YEAR number itgen_cio_data_enterprise_date_since Year
DATA_ENTERPRISE_DESCRIPTION varchar2 itgen_cio_data_enterprise Description
DATA_ENTERPRISE_DISCONTINUATION_DATE_DAY number itgen_cio_data_enterprise_discontinuation_date Day
DATA_ENTERPRISE_DISCONTINUATION_DATE_MONTH number itgen_cio_data_enterprise_discontinuation_date Month
DATA_ENTERPRISE_DISCONTINUATION_DATE_YEAR number itgen_cio_data_enterprise_discontinuation_date Year
DATA_ENTERPRISE_FOUNDING_DATE_DAY number itgen_cio_data_enterprise_founding_date Day
DATA_ENTERPRISE_FOUNDING_DATE_MONTH number itgen_cio_data_enterprise_founding_date Month
DATA_ENTERPRISE_FOUNDING_DATE_YEAR number itgen_cio_data_enterprise_founding_date Year
DATA_ENTERPRISE_INCORPORATION_DATE_DAY number itgen_cio_data_enterprise_incorporation_date Day
DATA_ENTERPRISE_INCORPORATION_DATE_MONTH number itgen_cio_data_enterprise_incorporation_date Month
DATA_ENTERPRISE_INCORPORATION_DATE_YEAR number itgen_cio_data_enterprise_incorporation_date Year
DATA_ENTERPRISE_LEGAL_FORM_TEXT varchar2 itgen_cio_data_enterprise Legal Form Text
DATA_ENTERPRISE_NAME varchar2 itgen_cio_data_enterprise Name
DATA_ENTERPRISE_PERSONNEL_FULLTIME number itgen_cio_data_enterprise_personnel itgen_cio_fulltime
DATA_ENTERPRISE_PERSONNEL_PARTTIME number itgen_cio_data_enterprise_personnel itgen_cio_parttime
DATA_ENTERPRISE_PERSONNEL_TOTAL number itgen_cio_data_enterprise_personnel itgen_cio_total
DATA_ENTERPRISE_REGISTRATION varchar2 itgen_cio_data_enterprise Registration
DATA_ENTERPRISE_REMARKS varchar2 itgen_cio_data_enterprise itgen_cio_remarks
DATA_ENTERPRISE_SBI_CODES varchar2 itgen_cio_data_enterprise itgen_cio_sbi_codes
DATA_ENTERPRISE_TRADE_NAMES varchar2 itgen_cio_data_enterprise Trace Names
DATA_ESTABLISHMENTS varchar2 itgen_cio_data itgen_cio_establishments
DATA_LEGAL_ENTITY_ACTIVITY varchar2 itgen_cio_data_legal_entity Activity
DATA_LEGAL_ENTITY_ALTERNATIVE_NAME varchar2 itgen_cio_data_legal_entity Alternative Name
DATA_LEGAL_ENTITY_ANNUAL_REPORT_SUBMISSION varchar2 itgen_cio_data_legal_entity itgen_cio_annual_report_submission
DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL_AMOUNT number itgen_cio_data_legal_entity_authorized_share_capital Amount
DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL_CURRENCY varchar2 itgen_cio_data_legal_entity_authorized_share_capital Currency
DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL_FORMATTED varchar2 itgen_cio_data_legal_entity_authorized_share_capital Formatted
DATA_LEGAL_ENTITY_COMPANY_ARRANGEMENT varchar2 itgen_cio_data_legal_entity itgen_cio_company_arrangement
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_CITY varchar2 itgen_cio_data_legal_entity_correspondence_address City
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_COUNTRY varchar2 itgen_cio_data_legal_entity_correspondence_address Country
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_HOUSE_NUMBER number itgen_cio_data_legal_entity_correspondence_address House Number
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_HOUSE_NUMBER_ADDITION varchar2 itgen_cio_data_legal_entity_correspondence_address itgen_cio_house_number_addition
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_POSTCODE varchar2 itgen_cio_data_legal_entity_correspondence_address Postal Code
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_STREET varchar2 itgen_cio_data_legal_entity_correspondence_address Street
DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_DAY number itgen_cio_data_legal_entity_deed_incorporation_date Day
DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_MONTH number itgen_cio_data_legal_entity_deed_incorporation_date Month
DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_YEAR number itgen_cio_data_legal_entity_deed_incorporation_date Year
DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_DAY number itgen_cio_data_legal_entity_deed_last_statutes_amendment_date Day
DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_MONTH number itgen_cio_data_legal_entity_deed_last_statutes_amendment_date Month
DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_YEAR number itgen_cio_data_legal_entity_deed_last_statutes_amendment_date Year
DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_DAY number itgen_cio_data_legal_entity_discontinuation_date Day
DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_MONTH number itgen_cio_data_legal_entity_discontinuation_date Month
DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_YEAR number itgen_cio_data_legal_entity_discontinuation_date Year
DATA_LEGAL_ENTITY_DISSOLUTION_DATE_DAY number itgen_cio_data_legal_entity_dissolution_date Day
DATA_LEGAL_ENTITY_DISSOLUTION_DATE_MONTH number itgen_cio_data_legal_entity_dissolution_date Month
DATA_LEGAL_ENTITY_DISSOLUTION_DATE_YEAR number itgen_cio_data_legal_entity_dissolution_date Year
DATA_LEGAL_ENTITY_DISSOLUTION_REASON varchar2 itgen_cio_data_legal_entity itgen_cio_dissolution_reason
DATA_LEGAL_ENTITY_DOMAIN_NAMES varchar2 itgen_cio_data_legal_entity itgen_cio_domain_names
DATA_LEGAL_ENTITY_DURATION varchar2 itgen_cio_data_legal_entity itgen_cio_duration
DATA_LEGAL_ENTITY_DURATION_END_DATE_DAY number itgen_cio_data_legal_entity_duration_end_date Day
DATA_LEGAL_ENTITY_DURATION_END_DATE_MONTH number itgen_cio_data_legal_entity_duration_end_date Month
DATA_LEGAL_ENTITY_DURATION_END_DATE_YEAR number itgen_cio_data_legal_entity_duration_end_date Year
DATA_LEGAL_ENTITY_EMAIL_ADDRESSES varchar2 itgen_cio_data_legal_entity itgen_cio_email_addresses
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_CITY varchar2 itgen_cio_data_legal_entity_establishment_address City
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_COUNTRY varchar2 itgen_cio_data_legal_entity_establishment_address Country
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_HOUSE_NUMBER number itgen_cio_data_legal_entity_establishment_address House Number
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_HOUSE_NUMBER_ADDITION varchar2 itgen_cio_data_legal_entity_establishment_address itgen_cio_house_number_addition
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_POSTCODE varchar2 itgen_cio_data_legal_entity_establishment_address Postal Code
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_STREET varchar2 itgen_cio_data_legal_entity_establishment_address Street
DATA_LEGAL_ENTITY_FAX_NUMBERS varchar2 itgen_cio_data_legal_entity itgen_cio_fax_numbers
DATA_LEGAL_ENTITY_FOREIGN_LEGAL_FORM_DESCRIPTION varchar2 itgen_cio_data_legal_entity itgen_cio_foreign_legal_form_description
DATA_LEGAL_ENTITY_FOUNDING_DATE_DAY number itgen_cio_data_legal_entity_founding_date Day
DATA_LEGAL_ENTITY_FOUNDING_DATE_MONTH number itgen_cio_data_legal_entity_founding_date Month
DATA_LEGAL_ENTITY_FOUNDING_DATE_YEAR number itgen_cio_data_legal_entity_founding_date Year
DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_AMOUNT number itgen_cio_data_legal_entity_issued_share_capital Amount
DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_CURRENCY varchar2 itgen_cio_data_legal_entity_issued_share_capital Currency
DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_FORMATTED varchar2 itgen_cio_data_legal_entity_issued_share_capital Formatted
DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_DAY number itgen_cio_data_legal_entity_last_statutes_amendment_date Day
DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_MONTH number itgen_cio_data_legal_entity_last_statutes_amendment_date Month
DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_YEAR number itgen_cio_data_legal_entity_last_statutes_amendment_date Year
DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_DAY number itgen_cio_data_legal_entity_legal_entity_end_date Day
DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_MONTH number itgen_cio_data_legal_entity_legal_entity_end_date Month
DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_YEAR number itgen_cio_data_legal_entity_legal_entity_end_date Year
DATA_LEGAL_ENTITY_LEGAL_FORM_CHANGE varchar2 itgen_cio_data_legal_entity itgen_cio_legal_form_change
DATA_LEGAL_ENTITY_LEGAL_FORM_TEXT varchar2 itgen_cio_data_legal_entity Legal Form Text
DATA_LEGAL_ENTITY_LEGAL_NAME varchar2 itgen_cio_data_legal_entity Legal Name
DATA_LEGAL_ENTITY_LIABILITY varchar2 itgen_cio_data_legal_entity itgen_cio_liability
DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_DAY number itgen_cio_data_legal_entity_liquidation_closure_date Day
DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_MONTH number itgen_cio_data_legal_entity_liquidation_closure_date Month
DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_YEAR number itgen_cio_data_legal_entity_liquidation_closure_date Year
DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_DAY number itgen_cio_data_legal_entity_liquidation_reopening_date Day
DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_MONTH number itgen_cio_data_legal_entity_liquidation_reopening_date Month
DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_YEAR number itgen_cio_data_legal_entity_liquidation_reopening_date Year
DATA_LEGAL_ENTITY_MERGER_DESCRIPTION varchar2 itgen_cio_data_legal_entity itgen_cio_merger_description
DATA_LEGAL_ENTITY_NAME varchar2 itgen_cio_data_legal_entity Name
DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_AMOUNT number itgen_cio_data_legal_entity_paid_up_share_capital Amount
DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_CURRENCY varchar2 itgen_cio_data_legal_entity_paid_up_share_capital Currency
DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_FORMATTED varchar2 itgen_cio_data_legal_entity_paid_up_share_capital Formatted
DATA_LEGAL_ENTITY_REGISTRATION varchar2 itgen_cio_data_legal_entity Registration
DATA_LEGAL_ENTITY_REGISTRATION_DATE_DAY number itgen_cio_data_legal_entity_registration_date Day
DATA_LEGAL_ENTITY_REGISTRATION_DATE_MONTH number itgen_cio_data_legal_entity_registration_date Month
DATA_LEGAL_ENTITY_REGISTRATION_DATE_YEAR number itgen_cio_data_legal_entity_registration_date Year
DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_DAY number itgen_cio_data_legal_entity_registration_end_date Day
DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_MONTH number itgen_cio_data_legal_entity_registration_end_date Month
DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_YEAR number itgen_cio_data_legal_entity_registration_end_date Year
DATA_LEGAL_ENTITY_REMARKS varchar2 itgen_cio_data_legal_entity itgen_cio_remarks
DATA_LEGAL_ENTITY_REMOVAL_DATE_DAY number itgen_cio_data_legal_entity_removal_date Day
DATA_LEGAL_ENTITY_REMOVAL_DATE_MONTH number itgen_cio_data_legal_entity_removal_date Month
DATA_LEGAL_ENTITY_REMOVAL_DATE_YEAR number itgen_cio_data_legal_entity_removal_date Year
DATA_LEGAL_ENTITY_RSIN_NUMBER varchar2 itgen_cio_data_legal_entity RSIN Number
DATA_LEGAL_ENTITY_SBI_CODES varchar2 itgen_cio_data_legal_entity itgen_cio_sbi_codes
DATA_LEGAL_ENTITY_SHARE_HOLDERS varchar2 itgen_cio_data_legal_entity itgen_cio_share_holders
DATA_LEGAL_ENTITY_SHARES varchar2 itgen_cio_data_legal_entity itgen_cio_shares
DATA_LEGAL_ENTITY_SHORTENED_NAME varchar2 itgen_cio_data_legal_entity itgen_cio_shortened_name
DATA_LEGAL_ENTITY_STATUTORY_SEAT varchar2 itgen_cio_data_legal_entity itgen_cio_statutory_seat
DATA_LEGAL_ENTITY_TELEPHONE_NUMBERS varchar2 itgen_cio_data_legal_entity itgen_cio_telephone_numbers
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_CITY varchar2 itgen_cio_data_partnership_correspondence_address City
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_COUNTRY varchar2 itgen_cio_data_partnership_correspondence_address Country
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_HOUSE_NUMBER number itgen_cio_data_partnership_correspondence_address House Number
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_HOUSE_NUMBER_ADDITION varchar2 itgen_cio_data_partnership_correspondence_address itgen_cio_house_number_addition
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_POSTCODE varchar2 itgen_cio_data_partnership_correspondence_address Postal Code
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_STREET varchar2 itgen_cio_data_partnership_correspondence_address Street
DATA_PARTNERSHIP_DISSOLUTION_DATE_DAY number itgen_cio_data_partnership_dissolution_date Day
DATA_PARTNERSHIP_DISSOLUTION_DATE_MONTH number itgen_cio_data_partnership_dissolution_date Month
DATA_PARTNERSHIP_DISSOLUTION_DATE_YEAR number itgen_cio_data_partnership_dissolution_date Year
DATA_PARTNERSHIP_DOSSIER_NUMBER varchar2 itgen_cio_data_partnership File Number
DATA_PARTNERSHIP_DURATION varchar2 itgen_cio_data_partnership itgen_cio_duration
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_CITY varchar2 itgen_cio_data_partnership_establishment_address City
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_COUNTRY varchar2 itgen_cio_data_partnership_establishment_address Country
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_HOUSE_NUMBER number itgen_cio_data_partnership_establishment_address House Number
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_HOUSE_NUMBER_ADDITION varchar2 itgen_cio_data_partnership_establishment_address itgen_cio_house_number_addition
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_POSTCODE varchar2 itgen_cio_data_partnership_establishment_address Postal Code
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_STREET varchar2 itgen_cio_data_partnership_establishment_address Street
DATA_PARTNERSHIP_FOUNDING_DATE_DAY number itgen_cio_data_partnership_founding_date Day
DATA_PARTNERSHIP_FOUNDING_DATE_MONTH number itgen_cio_data_partnership_founding_date Month
DATA_PARTNERSHIP_FOUNDING_DATE_YEAR number itgen_cio_data_partnership_founding_date Year
DATA_PARTNERSHIP_FUNCTION_START_DATE_DAY number itgen_cio_data_partnership_function_start_date Day
DATA_PARTNERSHIP_FUNCTION_START_DATE_MONTH number itgen_cio_data_partnership_function_start_date Month
DATA_PARTNERSHIP_FUNCTION_START_DATE_YEAR number itgen_cio_data_partnership_function_start_date Year
DATA_PARTNERSHIP_LEGAL_FORM_TEXT varchar2 itgen_cio_data_partnership Legal Form Text
DATA_PARTNERSHIP_LIMITED_PARTNERSHIP_CAPITAL_AMOUNT number itgen_cio_data_partnership_limited_partnership_capital Amount
DATA_PARTNERSHIP_LIMITED_PARTNERSHIP_CAPITAL_CURRENCY varchar2 itgen_cio_data_partnership_limited_partnership_capital Currency
DATA_PARTNERSHIP_LIMITED_PARTNERSHIP_CAPITAL_FORMATTED varchar2 itgen_cio_data_partnership_limited_partnership_capital Formatted
DATA_PARTNERSHIP_NAME varchar2 itgen_cio_data_partnership Name
DATA_PARTNERSHIP_REGISTRATION varchar2 itgen_cio_data_partnership Registration
DATA_PARTNERSHIP_REMARKS varchar2 itgen_cio_data_partnership itgen_cio_remarks
DATA_PARTNERSHIP_RSIN_NUMBER varchar2 itgen_cio_data_partnership RSIN Number
DATA_PARTNERSHIP_SILENT_PARTNERS number itgen_cio_data_partnership itgen_cio_silent_partners
DATA_POSITIONS varchar2 itgen_cio_data itgen_cio_positions
DATA_REFERENCE_DATE datetime itgen_cio_data itgen_cio_reference_date
DATA_REMARKS varchar2 itgen_cio_data itgen_cio_remarks
DOCUMENT blob Document

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: