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_ |
`` | |||
company_ |
`` |
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_ |
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 |
Business Number | |||
BUSINESS_ |
varchar2 |
Business Number Description | |||
BUSINESS_ |
varchar2 |
Business Number Type | |||
CEO_ |
varchar2 |
CEO Name | |||
CEO_ |
varchar2 |
CEO Title | |||
CITY |
varchar2 |
City | |||
COUNTRY |
varchar2 |
Country | |||
COUNTRY_ |
varchar2 |
Country Calling Code | |||
CRIMINAL_ |
boolean |
itgen_cio_criminal_proceedings | |||
CURRENCY |
varchar2 |
Currency | |||
CURRENT_ |
number |
Current Control Year | |||
DEBTOR_ |
boolean |
Debtor in Possession | |||
DISASTER |
boolean |
Disaster | |||
DNB_ |
varchar2 |
D&B Key | |||
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 |
Fax Number | |||
FINANCIAL_ |
boolean |
Financial Embarassment | |||
FINANCIAL_ |
boolean |
itgen_cio_financial_legal_events | |||
FINANCIAL_ |
varchar2 |
Financial Statement Date | |||
HISTORY_ |
varchar2 |
itgen_cio_history_description | |||
HISTORY_ |
varchar2 |
Indicator Historical | |||
INCOME_ |
varchar2 |
Income Statement Date | |||
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 |
Net Worth | |||
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 |
Phone Number | |||
POSTCODE |
varchar2 |
Postal Code | |||
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 |
Trade Name | |||
TRADE_ |
varchar2 |
Trace Names |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: