invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

dnbQuickCheck: Company.info DNB Quick Check

read only XML

  • Catalogue : CompanyInfo
  • Schéma : CompanyInfo
  • Label: DNB Quick Check

Permet uniquement de récupérer des données.

Source de l'API

  • Rubrique XML : dnbQuickCheck

Paramètres

Name Type de données Required Default Documentation
company_id ``
company_id_type ``

Colonnes de table

Les colonnes de la table dnbQuickCheck sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données 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 Numéro d'entreprise
BUSINESS_NUMBER_DESCRIPTION varchar2 Numéro d'entreprise - Description
BUSINESS_NUMBER_TYPE varchar2 Type de numéro d'entreprise
CEO_NAME varchar2 Nom du PDG
CEO_TITLE varchar2 Fonction de PDG
CITY varchar2 City
COUNTRY varchar2 Country
COUNTRY_CALLING_CODE varchar2 Indicatif téléphonique du pays
CRIMINAL_PROCEEDINGS boolean itgen_cio_criminal_proceedings
CURRENCY varchar2 Currency
CURRENT_CONTROL_YEAR number Année de contrôle en cours
DEBTOR_INPOSSESSION boolean Débiteur en possession de ses biens
DISASTER boolean Disaster
DNB_KEY varchar2 Clé D&B
DNB_RATING varchar2 Notation 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 Numéro de Fax
FINANCIAL_EMBARRASSMENT boolean Difficultés financières
FINANCIAL_LEGAL_EVENTS boolean itgen_cio_financial_legal_events
FINANCIAL_STATEMENT_DATE varchar2 Date de clôture des comptes annuels
HISTORY_DESCRIPTION varchar2 itgen_cio_history_description
HISTORY_INDICATOR varchar2 Historique des indicateurs
INCOME_STATEMENT_DATE varchar2 Date du compte de résultat
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 Valeur nette
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 Numéro de téléphone
POSTCODE varchar2 Code 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 Dénomination commerciale
TRADE_NAMES varchar2 Noms des traces

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :