invantive documentation
Invantive Support ForumsLog In / Sign Up

dnbQuickCheck: Company.info DNB Quick Check

read only XML

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

Can only retrieve data.

API Source

  • XML topic: dnbQuickCheck

Parameters

Name Data Type Required Default Documentation
company_id ``
company_id_type ``

Table Columns

The columns of the table dnbQuickCheck are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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 Business Number
BUSINESS_NUMBER_DESCRIPTION varchar2 Business Number Description
BUSINESS_NUMBER_TYPE varchar2 Business Number Type
CEO_NAME varchar2 CEO Name
CEO_TITLE varchar2 CEO Title
CITY varchar2 City
COUNTRY varchar2 Country
COUNTRY_CALLING_CODE varchar2 Country Calling Code
CRIMINAL_PROCEEDINGS boolean itgen_cio_criminal_proceedings
CURRENCY varchar2 Currency
CURRENT_CONTROL_YEAR number Current Control Year
DEBTOR_INPOSSESSION boolean Debtor in Possession
DISASTER boolean Disaster
DNB_KEY varchar2 D&B Key
DNB_RATING varchar2 D&B Rating
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 Fax Number
FINANCIAL_EMBARRASSMENT boolean Financial Embarassment
FINANCIAL_LEGAL_EVENTS boolean itgen_cio_financial_legal_events
FINANCIAL_STATEMENT_DATE varchar2 Financial Statement Date
HISTORY_DESCRIPTION varchar2 itgen_cio_history_description
HISTORY_INDICATOR varchar2 Indicator Historical
INCOME_STATEMENT_DATE varchar2 Income Statement Date
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 Net Worth
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 Phone Number
POSTCODE varchar2 Postal Code
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 Trade Name
TRADE_NAMES varchar2 Trace Names

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: