invantive documentation
Forum di supporto InvantiveAccedi / Registrati

dnbQuickCheck: Company.info DNB Quick Check

read only XML

  • Catalogo: CompanyInfo
  • Schema: CompanyInfo
  • Label: DNB Quick Check

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Argomento XML: dnbQuickCheck

Parametri

Name Tipo di dati Required Default Documentation
company_id ``
company_id_type ``

Colonne della tabella

Di seguito sono riportate le colonne della tabella dnbQuickCheck. 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
ADDRESS varchar2 Address
ANNUAL_SALES_CONSOLIDATED boolean Annual Sales Consolidated
ANNUAL_SALES_CURRENCY varchar2 Annual Sales Currency
ANNUAL_SALES_ESTIMATED number Annual Sales Estimated
ANNUAL_SALES_VALUE number Annual Sales Value
ANNUAL_SALES_VALUE_TEXT varchar2 Annual Sales itgen_cio_value_text
BUSINESS_NUMBER varchar2 Numero aziendale
BUSINESS_NUMBER_DESCRIPTION varchar2 Numero aziendale Descrizione
BUSINESS_NUMBER_TYPE varchar2 Tipo di numero aziendale
CEO_NAME varchar2 Nome dell'amministratore delegato
CEO_TITLE varchar2 Titolo del CEO
CITY varchar2 City
COUNTRY varchar2 Country
COUNTRY_CALLING_CODE varchar2 Prefisso internazionale
CRIMINAL_PROCEEDINGS boolean itgen_cio_criminal_proceedings
CURRENCY varchar2 Currency
CURRENT_CONTROL_YEAR number Anno di controllo attuale
DEBTOR_INPOSSESSION boolean Debitore in possesso dei beni
DISASTER boolean Disaster
DNB_KEY varchar2 Codice D&B
DNB_RATING varchar2 Rating D&B
DUNS varchar2 DUNS
EMPLOYEES_PRIMARY_EMPLOYEES number Primary Employees
EMPLOYEES_PRIMARY_EMPLOYEES_TEXT varchar2 Primary itgen_cio_employees_text
EMPLOYEES_PRIMARY_ESTIMATED boolean Primary Estimated
EMPLOYEES_PRIMARY_QUALIFICATION_INDICATOR varchar2 Primary itgen_cio_qualification_indicator
EMPLOYEES_PRIMARY_SUBSIDIARIES_INCLUDED boolean Primary itgen_cio_subsidiaries_included
EMPLOYEES_TOTAL_EMPLOYEES number itgen_cio_employees_total Employees
EMPLOYEES_TOTAL_EMPLOYEES_TEXT varchar2 itgen_cio_employees_total itgen_cio_employees_text
EMPLOYEES_TOTAL_ESTIMATED boolean itgen_cio_employees_total Estimated
EMPLOYEES_TOTAL_QUALIFICATION_INDICATOR varchar2 itgen_cio_employees_total itgen_cio_qualification_indicator
EMPLOYEES_TOTAL_SUBSIDIARIES_INCLUDED boolean itgen_cio_employees_total itgen_cio_subsidiaries_included
ENQUIRY_DUNS varchar2 itgen_cio_enquiry_duns
FAX_NUMBER varchar2 Numero di fax
FINANCIAL_EMBARRASSMENT boolean Imbarazzo finanziario
FINANCIAL_LEGAL_EVENTS boolean itgen_cio_financial_legal_events
FINANCIAL_STATEMENT_DATE varchar2 Data di chiusura del bilancio
HISTORY_DESCRIPTION varchar2 itgen_cio_history_description
HISTORY_INDICATOR varchar2 Dati storici degli indicatori
INCOME_STATEMENT_DATE varchar2 Data del conto economico
INCOME_STATEMENT_DATE_END varchar2 itgen_cio_income_statement_date_end
INCOME_STATEMENT_DATE_START varchar2 itgen_cio_income_statement_date_start
INCORPORATION_YEAR number itgen_cio_incorporation_year
INTANGIBLE_ASSETS number itgen_cio_intangible_assets
LEGAL_FORM varchar2 itgen_cio_legal_form
LEGAL_FORM_DESCRIPTION varchar2 itgen_cio_legal_form_description
LOCAL_ACTIVITY_CODE varchar2 itgen_cio_local_activity_code
LOCAL_ACTIVITY_CODE_TYPE varchar2 itgen_cio_local_activity_code_type
LOCAL_ACTIVITY_DESCRIPTION varchar2 itgen_cio_local_activity_description
MAXIMUM_CREDIT number itgen_cio_maximum_credit
MAXIMUM_CREDIT_CURRENCY varchar2 itgen_cio_maximum_credit_currency
NET_WORTH number Patrimonio netto
OPERATIONAL_EVENTS boolean itgen_cio_operational_events
OTHER_EVENTS boolean itgen_cio_other_events
OUT_OF_BUSINESS boolean itgen_cio_out_of_business
PAYDEX_NORM number itgen_cio_paydex_norm
PAYDEX_SCORE number itgen_cio_paydex_score
PHONE_NUMBER varchar2 Numero di telefono
POSTCODE varchar2 Codice postale
PRINCIPAL_NAME varchar2 itgen_cio_principal_name
PRINCIPAL_TITLE varchar2 itgen_cio_principal_title
REGION varchar2 itgen_cio_region
SALES number itgen_cio_sales
SECURED_FILINGS boolean itgen_cio_secured_filings
SIC_ACTIVITY_CODE varchar2 itgen_cio_sic_activity_code
SIC_ACTIVITY_DESCRIPTION varchar2 itgen_cio_sic_activity_description
SIC_VERSION varchar2 itgen_cio_sic_version
START_YEAR number itgen_cio_start_year
STATEMENT_CURRENCY varchar2 itgen_cio_statement_currency
SUBREGION varchar2 itgen_cio_subregion
SUIT_JUDGEMENT boolean itgen_cio_suit_judgement
TANGIBLE_NET_WORTH_CONSOLIDATED boolean itgen_cio_tangible_net_worth Consolidated
TANGIBLE_NET_WORTH_CURRENCY varchar2 itgen_cio_tangible_net_worth Currency
TANGIBLE_NET_WORTH_ESTIMATED number itgen_cio_tangible_net_worth Estimated
TANGIBLE_NET_WORTH_VALUE number itgen_cio_tangible_net_worth Value
TANGIBLE_NET_WORTH_VALUE_TEXT varchar2 itgen_cio_tangible_net_worth itgen_cio_value_text
TRADE_NAME varchar2 Denominazione commerciale
TRADE_NAMES varchar2 Nomi delle tracce

Note di rilascio

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