invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

dnbQuickCheck: Company.info DNB Quick Check

read only XML

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

Kan alleen gegevens ophalen.

API-bron

  • XML-onderwerp: dnbQuickCheck

Parameters

Name Datatype Required Default Documentation
company_id ``
company_id_type ``

Tabelkolommen

De kolommen van de tabel dnbQuickCheck worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype 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 Bedrijfsnummer
BUSINESS_NUMBER_DESCRIPTION varchar2 Bedrijfsnummeromschrijving
BUSINESS_NUMBER_TYPE varchar2 Bedrijfsnummersoort
CEO_NAME varchar2 Directeur Naam
CEO_TITLE varchar2 Directeur Titel
CITY varchar2 City
COUNTRY varchar2 Country
COUNTRY_CALLING_CODE varchar2 Landcode
CRIMINAL_PROCEEDINGS boolean itgen_cio_criminal_proceedings
CURRENCY varchar2 Currency
CURRENT_CONTROL_YEAR number Huidig Controlejaar
DEBTOR_INPOSSESSION boolean Surseance van Betaling
DISASTER boolean Disaster
DNB_KEY varchar2 D&B Sleutel
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 Faxnummer
FINANCIAL_EMBARRASSMENT boolean Financiële Uitsluiting
FINANCIAL_LEGAL_EVENTS boolean itgen_cio_financial_legal_events
FINANCIAL_STATEMENT_DATE varchar2 Jaarrekeningdatum
HISTORY_DESCRIPTION varchar2 itgen_cio_history_description
HISTORY_INDICATOR varchar2 Indicator Historisch
INCOME_STATEMENT_DATE varchar2 Winst-en Verliesrekening Datum
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 Netto Waarde
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 Telefoonnummer
POSTCODE varchar2 Postcode
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 Handelsnaam
TRADE_NAMES varchar2 Handelsnamen

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: