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_ |
`` | |||
company_ |
`` |
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_ |
boolean |
Annual Sales Consolidated | |||
ANNUAL_ |
varchar2 |
Annual Sales Currency | |||
ANNUAL_ |
number |
Annual Sales Estimated | |||
ANNUAL_ |
number |
Annual Sales Value | |||
ANNUAL_ |
varchar2 |
Annual Sales itgen_cio_value_text | |||
BUSINESS_ |
varchar2 |
Bedrijfsnummer | |||
BUSINESS_ |
varchar2 |
Bedrijfsnummeromschrijving | |||
BUSINESS_ |
varchar2 |
Bedrijfsnummersoort | |||
CEO_ |
varchar2 |
Directeur Naam | |||
CEO_ |
varchar2 |
Directeur Titel | |||
CITY |
varchar2 |
City | |||
COUNTRY |
varchar2 |
Country | |||
COUNTRY_ |
varchar2 |
Landcode | |||
CRIMINAL_ |
boolean |
itgen_cio_criminal_proceedings | |||
CURRENCY |
varchar2 |
Currency | |||
CURRENT_ |
number |
Huidig Controlejaar | |||
DEBTOR_ |
boolean |
Surseance van Betaling | |||
DISASTER |
boolean |
Disaster | |||
DNB_ |
varchar2 |
D&B Sleutel | |||
DNB_ |
varchar2 |
D&B Rating | |||
DUNS |
varchar2 |
DUNS | |||
EMPLOYEES_ |
number |
Primary Employees | |||
EMPLOYEES_ |
varchar2 |
Primary itgen_cio_employees_text | |||
EMPLOYEES_ |
boolean |
Primary Estimated | |||
EMPLOYEES_ |
varchar2 |
Primary itgen_cio_qualification_indicator | |||
EMPLOYEES_ |
boolean |
Primary itgen_cio_subsidiaries_included | |||
EMPLOYEES_ |
number |
itgen_cio_employees_total Employees | |||
EMPLOYEES_ |
varchar2 |
itgen_cio_employees_total itgen_cio_employees_text | |||
EMPLOYEES_ |
boolean |
itgen_cio_employees_total Estimated | |||
EMPLOYEES_ |
varchar2 |
itgen_cio_employees_total itgen_cio_qualification_indicator | |||
EMPLOYEES_ |
boolean |
itgen_cio_employees_total itgen_cio_subsidiaries_included | |||
ENQUIRY_ |
varchar2 |
itgen_cio_enquiry_duns | |||
FAX_ |
varchar2 |
Faxnummer | |||
FINANCIAL_ |
boolean |
Financiële Uitsluiting | |||
FINANCIAL_ |
boolean |
itgen_cio_financial_legal_events | |||
FINANCIAL_ |
varchar2 |
Jaarrekeningdatum | |||
HISTORY_ |
varchar2 |
itgen_cio_history_description | |||
HISTORY_ |
varchar2 |
Indicator Historisch | |||
INCOME_ |
varchar2 |
Winst-en Verliesrekening Datum | |||
INCOME_ |
varchar2 |
itgen_cio_income_statement_date_end | |||
INCOME_ |
varchar2 |
itgen_cio_income_statement_date_start | |||
INCORPORATION_ |
number |
itgen_cio_incorporation_year | |||
INTANGIBLE_ |
number |
itgen_cio_intangible_assets | |||
LEGAL_ |
varchar2 |
itgen_cio_legal_form | |||
LEGAL_ |
varchar2 |
itgen_cio_legal_form_description | |||
LOCAL_ |
varchar2 |
itgen_cio_local_activity_code | |||
LOCAL_ |
varchar2 |
itgen_cio_local_activity_code_type | |||
LOCAL_ |
varchar2 |
itgen_cio_local_activity_description | |||
MAXIMUM_ |
number |
itgen_cio_maximum_credit | |||
MAXIMUM_ |
varchar2 |
itgen_cio_maximum_credit_currency | |||
NET_ |
number |
Netto Waarde | |||
OPERATIONAL_ |
boolean |
itgen_cio_operational_events | |||
OTHER_ |
boolean |
itgen_cio_other_events | |||
OUT_ |
boolean |
itgen_cio_out_of_business | |||
PAYDEX_ |
number |
itgen_cio_paydex_norm | |||
PAYDEX_ |
number |
itgen_cio_paydex_score | |||
PHONE_ |
varchar2 |
Telefoonnummer | |||
POSTCODE |
varchar2 |
Postcode | |||
PRINCIPAL_ |
varchar2 |
itgen_cio_principal_name | |||
PRINCIPAL_ |
varchar2 |
itgen_cio_principal_title | |||
REGION |
varchar2 |
itgen_cio_region | |||
SALES |
number |
itgen_cio_sales | |||
SECURED_ |
boolean |
itgen_cio_secured_filings | |||
SIC_ |
varchar2 |
itgen_cio_sic_activity_code | |||
SIC_ |
varchar2 |
itgen_cio_sic_activity_description | |||
SIC_ |
varchar2 |
itgen_cio_sic_version | |||
START_ |
number |
itgen_cio_start_year | |||
STATEMENT_ |
varchar2 |
itgen_cio_statement_currency | |||
SUBREGION |
varchar2 |
itgen_cio_subregion | |||
SUIT_ |
boolean |
itgen_cio_suit_judgement | |||
TANGIBLE_ |
boolean |
itgen_cio_tangible_net_worth Consolidated | |||
TANGIBLE_ |
varchar2 |
itgen_cio_tangible_net_worth Currency | |||
TANGIBLE_ |
number |
itgen_cio_tangible_net_worth Estimated | |||
TANGIBLE_ |
number |
itgen_cio_tangible_net_worth Value | |||
TANGIBLE_ |
varchar2 |
itgen_cio_tangible_net_worth itgen_cio_value_text | |||
TRADE_ |
varchar2 |
Handelsnaam | |||
TRADE_ |
varchar2 |
Handelsnamen |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: