invantive documentation
Forum di supporto InvantiveAccedi / Registrati

dutchBusinessGetExtractHistoryDocumentDataV3: Company.info itgen_cio_dutchbusinessgetextracthistorydocumentdatav3

read only XML

  • Catalogo: CompanyInfo
  • Schema: CompanyInfo
  • Etichetta: itgen_cio_dutchbusinessgetextracthistorydocumentdatav3

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Argomento XML: dutchBusinessGetExtractHistoryDocumentDataV3

Parametri

Name Tipo di dati Required Default Documentation
extract_id ``
include_source ``

Colonne della tabella

Di seguito sono riportate le colonne della tabella dutchBusinessGetExtractHistoryDocumentDataV3. 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 Numero di fascicolo
DATA_ENTERPRISE_ACTIVITY varchar2 Attività itgen_cio_data_enterprise
DATA_ENTERPRISE_DATE_SINCE_DAY number itgen_cio_data_enterprise_date_since Giorno
DATA_ENTERPRISE_DATE_SINCE_MONTH number itgen_cio_data_enterprise_date_since Mese
DATA_ENTERPRISE_DATE_SINCE_YEAR number itgen_cio_data_enterprise_date_since Anno
DATA_ENTERPRISE_DESCRIPTION varchar2 itgen_cio_data_enterprise Descrizione
DATA_ENTERPRISE_DISCONTINUATION_DATE_DAY number itgen_cio_data_enterprise_discontinuation_date Giorno
DATA_ENTERPRISE_DISCONTINUATION_DATE_MONTH number itgen_cio_data_enterprise_discontinuation_date Mese
DATA_ENTERPRISE_DISCONTINUATION_DATE_YEAR number itgen_cio_data_enterprise_discontinuation_date Anno
DATA_ENTERPRISE_FOUNDING_DATE_DAY number itgen_cio_data_enterprise_founding_date Giorno
DATA_ENTERPRISE_FOUNDING_DATE_MONTH number itgen_cio_data_enterprise_founding_date Mese
DATA_ENTERPRISE_FOUNDING_DATE_YEAR number itgen_cio_data_enterprise_founding_date Anno
DATA_ENTERPRISE_INCORPORATION_DATE_DAY number itgen_cio_data_enterprise_incorporation_date Giorno
DATA_ENTERPRISE_INCORPORATION_DATE_MONTH number itgen_cio_data_enterprise_incorporation_date Mese
DATA_ENTERPRISE_INCORPORATION_DATE_YEAR number itgen_cio_data_enterprise_incorporation_date Anno
DATA_ENTERPRISE_LEGAL_FORM_TEXT varchar2 Forma giuridica itgen_cio_data_enterprise Testo
DATA_ENTERPRISE_NAME varchar2 Nome itgen_cio_data_enterprise
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 Registrazione itgen_cio_data_enterprise
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 Nomi di traccia
DATA_ESTABLISHMENTS varchar2 itgen_cio_data itgen_cio_establishments
DATA_LEGAL_ENTITY_ACTIVITY varchar2 Attività itgen_cio_data_legal_entity
DATA_LEGAL_ENTITY_ALTERNATIVE_NAME varchar2 Nome alternativo itgen_cio_data_legal_entity
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 importo
DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL_CURRENCY varchar2 itgen_cio_data_legal_entity_authorized_share_capital Valuta
DATA_LEGAL_ENTITY_AUTHORIZED_SHARE_CAPITAL_FORMATTED varchar2 itgen_cio_data_legal_entity_authorized_share_capital formattato
DATA_LEGAL_ENTITY_COMPANY_ARRANGEMENT varchar2 itgen_cio_data_legal_entity itgen_cio_company_arrangement
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_ADDRESS varchar2 itgen_cio_data_legal_entity_correspondence_address Indirizzo
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_CITY varchar2 itgen_cio_data_legal_entity_correspondence_address Città
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_COUNTRY varchar2 itgen_cio_data_legal_entity_correspondence_address Paese
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_HOUSE_NUMBER number itgen_cio_data_legal_entity_correspondence_address Numero civico
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 CAP
DATA_LEGAL_ENTITY_CORRESPONDENCE_ADDRESS_STREET varchar2 itgen_cio_data_legal_entity_correspondence_address Via
DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_DAY number itgen_cio_data_legal_entity_deed_incorporation_date Giorno
DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_MONTH number itgen_cio_data_legal_entity_deed_incorporation_date Mese
DATA_LEGAL_ENTITY_DEED_INCORPORATION_DATE_YEAR number itgen_cio_data_legal_entity_deed_incorporation_date Anno
DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_DAY number itgen_cio_data_legal_entity_deed_last_statutes_amendment_date Giorno
DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_MONTH number itgen_cio_data_legal_entity_deed_last_statutes_amendment_date Mese
DATA_LEGAL_ENTITY_DEED_LAST_STATUTES_AMENDMENT_DATE_YEAR number itgen_cio_data_legal_entity_deed_last_statutes_amendment_date Anno
DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_DAY number itgen_cio_data_legal_entity_discontinuation_date Giorno
DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_MONTH number itgen_cio_data_legal_entity_discontinuation_date Mese
DATA_LEGAL_ENTITY_DISCONTINUATION_DATE_YEAR number itgen_cio_data_legal_entity_discontinuation_date Anno
DATA_LEGAL_ENTITY_DISSOLUTION_DATE_DAY number itgen_cio_data_legal_entity_dissolution_date Giorno
DATA_LEGAL_ENTITY_DISSOLUTION_DATE_MONTH number itgen_cio_data_legal_entity_dissolution_date Mese
DATA_LEGAL_ENTITY_DISSOLUTION_DATE_YEAR number itgen_cio_data_legal_entity_dissolution_date Anno
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 Giorno
DATA_LEGAL_ENTITY_DURATION_END_DATE_MONTH number itgen_cio_data_legal_entity_duration_end_date Mese
DATA_LEGAL_ENTITY_DURATION_END_DATE_YEAR number itgen_cio_data_legal_entity_duration_end_date Anno
DATA_LEGAL_ENTITY_EMAIL_ADDRESSES varchar2 itgen_cio_data_legal_entity itgen_cio_email_addresses
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_ADDRESS varchar2 itgen_cio_data_legal_entity_establishment_address Indirizzo
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_CITY varchar2 itgen_cio_data_legal_entity_establishment_address Città
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_COUNTRY varchar2 itgen_cio_data_legal_entity_establishment_address Paese
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_HOUSE_NUMBER number itgen_cio_data_legal_entity_establishment_address Numero civico
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 CAP
DATA_LEGAL_ENTITY_ESTABLISHMENT_ADDRESS_STREET varchar2 itgen_cio_data_legal_entity_establishment_address Via
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 Giorno
DATA_LEGAL_ENTITY_FOUNDING_DATE_MONTH number itgen_cio_data_legal_entity_founding_date Mese
DATA_LEGAL_ENTITY_FOUNDING_DATE_YEAR number itgen_cio_data_legal_entity_founding_date Anno
DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_AMOUNT number itgen_cio_data_legal_entity_issued_share_capital importo
DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_CURRENCY varchar2 itgen_cio_data_legal_entity_issued_share_capital Valuta
DATA_LEGAL_ENTITY_ISSUED_SHARE_CAPITAL_FORMATTED varchar2 itgen_cio_data_legal_entity_issued_share_capital formattato
DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_DAY number itgen_cio_data_legal_entity_last_statutes_amendment_date Giorno
DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_MONTH number itgen_cio_data_legal_entity_last_statutes_amendment_date Mese
DATA_LEGAL_ENTITY_LAST_STATUTES_AMENDMENT_DATE_YEAR number itgen_cio_data_legal_entity_last_statutes_amendment_date Anno
DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_DAY number itgen_cio_data_legal_entity_legal_entity_end_date Giorno
DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_MONTH number itgen_cio_data_legal_entity_legal_entity_end_date Mese
DATA_LEGAL_ENTITY_LEGAL_ENTITY_END_DATE_YEAR number itgen_cio_data_legal_entity_legal_entity_end_date Anno
DATA_LEGAL_ENTITY_LEGAL_FORM_CHANGE varchar2 itgen_cio_data_legal_entity itgen_cio_legal_form_change
DATA_LEGAL_ENTITY_LEGAL_FORM_TEXT varchar2 Forma giuridica itgen_cio_data_legal_entity Testo
DATA_LEGAL_ENTITY_LEGAL_NAME varchar2 itgen_cio_data_legal_entity Ragione sociale
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 Giorno
DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_MONTH number itgen_cio_data_legal_entity_liquidation_closure_date Mese
DATA_LEGAL_ENTITY_LIQUIDATION_CLOSURE_DATE_YEAR number itgen_cio_data_legal_entity_liquidation_closure_date Anno
DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_DAY number itgen_cio_data_legal_entity_liquidation_reopening_date Giorno
DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_MONTH number itgen_cio_data_legal_entity_liquidation_reopening_date Mese
DATA_LEGAL_ENTITY_LIQUIDATION_REOPENING_DATE_YEAR number itgen_cio_data_legal_entity_liquidation_reopening_date Anno
DATA_LEGAL_ENTITY_MERGER_DESCRIPTION varchar2 itgen_cio_data_legal_entity itgen_cio_merger_description
DATA_LEGAL_ENTITY_NAME varchar2 Nome itgen_cio_data_legal_entity
DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_AMOUNT number itgen_cio_data_legal_entity_paid_up_share_capital importo
DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_CURRENCY varchar2 itgen_cio_data_legal_entity_paid_up_share_capital Valuta
DATA_LEGAL_ENTITY_PAID_UP_SHARE_CAPITAL_FORMATTED varchar2 itgen_cio_data_legal_entity_paid_up_share_capital formattato
DATA_LEGAL_ENTITY_REGISTRATION varchar2 Registrazione itgen_cio_data_legal_entity
DATA_LEGAL_ENTITY_REGISTRATION_DATE_DAY number itgen_cio_data_legal_entity_registration_date Giorno
DATA_LEGAL_ENTITY_REGISTRATION_DATE_MONTH number itgen_cio_data_legal_entity_registration_date Mese
DATA_LEGAL_ENTITY_REGISTRATION_DATE_YEAR number itgen_cio_data_legal_entity_registration_date Anno
DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_DAY number itgen_cio_data_legal_entity_registration_end_date Giorno
DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_MONTH number itgen_cio_data_legal_entity_registration_end_date Mese
DATA_LEGAL_ENTITY_REGISTRATION_END_DATE_YEAR number itgen_cio_data_legal_entity_registration_end_date Anno
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 Giorno
DATA_LEGAL_ENTITY_REMOVAL_DATE_MONTH number itgen_cio_data_legal_entity_removal_date Mese
DATA_LEGAL_ENTITY_REMOVAL_DATE_YEAR number itgen_cio_data_legal_entity_removal_date Anno
DATA_LEGAL_ENTITY_RSIN_NUMBER varchar2 Numero RSIN di itgen_cio_data_legal_entity
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_ADDRESS varchar2 itgen_cio_data_partnership_correspondence_address Indirizzo
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_CITY varchar2 itgen_cio_data_partnership_correspondence_address Città
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_COUNTRY varchar2 itgen_cio_data_partnership_correspondence_address Paese
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_HOUSE_NUMBER number itgen_cio_data_partnership_correspondence_address Numero civico
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 CAP
DATA_PARTNERSHIP_CORRESPONDENCE_ADDRESS_STREET varchar2 itgen_cio_data_partnership_correspondence_address Via
DATA_PARTNERSHIP_DISSOLUTION_DATE_DAY number itgen_cio_data_partnership_dissolution_date Giorno
DATA_PARTNERSHIP_DISSOLUTION_DATE_MONTH number itgen_cio_data_partnership_dissolution_date Mese
DATA_PARTNERSHIP_DISSOLUTION_DATE_YEAR number itgen_cio_data_partnership_dissolution_date Anno
DATA_PARTNERSHIP_DOSSIER_NUMBER varchar2 itgen_cio_data_partnership Numero di fascicolo
DATA_PARTNERSHIP_DURATION varchar2 itgen_cio_data_partnership itgen_cio_duration
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_ADDRESS varchar2 itgen_cio_data_partnership_establishment_address Indirizzo
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_CITY varchar2 itgen_cio_data_partnership_establishment_address Città
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_COUNTRY varchar2 itgen_cio_data_partnership_establishment_address Paese
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_HOUSE_NUMBER number itgen_cio_data_partnership_establishment_address Numero civico
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 CAP
DATA_PARTNERSHIP_ESTABLISHMENT_ADDRESS_STREET varchar2 itgen_cio_data_partnership_establishment_address Via
DATA_PARTNERSHIP_FOUNDING_DATE_DAY number itgen_cio_data_partnership_founding_date Giorno
DATA_PARTNERSHIP_FOUNDING_DATE_MONTH number itgen_cio_data_partnership_founding_date Mese
DATA_PARTNERSHIP_FOUNDING_DATE_YEAR number itgen_cio_data_partnership_founding_date Anno
DATA_PARTNERSHIP_FUNCTION_START_DATE_DAY number itgen_cio_data_partnership_function_start_date Giorno
DATA_PARTNERSHIP_FUNCTION_START_DATE_MONTH number itgen_cio_data_partnership_function_start_date Mese
DATA_PARTNERSHIP_FUNCTION_START_DATE_YEAR number itgen_cio_data_partnership_function_start_date Anno
DATA_PARTNERSHIP_LEGAL_FORM_TEXT varchar2 Forma giuridica itgen_cio_data_partnership Testo
DATA_PARTNERSHIP_LIMITED_PARTNERSHIP_CAPITAL_AMOUNT number itgen_cio_data_partnership_limited_partnership_capital importo
DATA_PARTNERSHIP_LIMITED_PARTNERSHIP_CAPITAL_CURRENCY varchar2 itgen_cio_data_partnership_limited_partnership_capital Valuta
DATA_PARTNERSHIP_LIMITED_PARTNERSHIP_CAPITAL_FORMATTED varchar2 itgen_cio_data_partnership_limited_partnership_capital formattato
DATA_PARTNERSHIP_NAME varchar2 Nome itgen_cio_data_partnership
DATA_PARTNERSHIP_REGISTRATION varchar2 Registrazione itgen_cio_data_partnership
DATA_PARTNERSHIP_REMARKS varchar2 itgen_cio_data_partnership itgen_cio_remarks
DATA_PARTNERSHIP_RSIN_NUMBER varchar2 Numero RSIN di itgen_cio_data_partnership
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
SOURCE blob itgen_cio_source

Note di rilascio

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