invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

dnbQuickCheck: Company.info DNB Quick Check

read only XML

  • Catálogo: CompanyInfo
  • Esquema: CompanyInfo
  • Label: DNB Quick Check

Solo puede recuperar datos.

Fuente de la API

  • Tema XML: dnbQuickCheck

Parámetros

Name Tipo de Datos Required Default Documentation
company_id ``
company_id_type ``

Columnas de la Tabla

A continuación se muestran las columnas de la tabla dnbQuickCheck. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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 Número de identificación fiscal
BUSINESS_NUMBER_DESCRIPTION varchar2 Número de empresa Descripción
BUSINESS_NUMBER_TYPE varchar2 Tipo de número de empresa
CEO_NAME varchar2 Nombre del director general
CEO_TITLE varchar2 Cargo de director general
CITY varchar2 City
COUNTRY varchar2 Country
COUNTRY_CALLING_CODE varchar2 Prefijo telefónico del país
CRIMINAL_PROCEEDINGS boolean itgen_cio_criminal_proceedings
CURRENCY varchar2 Currency
CURRENT_CONTROL_YEAR number Año de control actual
DEBTOR_INPOSSESSION boolean Deudor en posesión
DISASTER boolean Disaster
DNB_KEY varchar2 Clave D&B
DNB_RATING varchar2 Calificación de 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 Número de Fax
FINANCIAL_EMBARRASSMENT boolean Dificultades económicas
FINANCIAL_LEGAL_EVENTS boolean itgen_cio_financial_legal_events
FINANCIAL_STATEMENT_DATE varchar2 Fecha de los estados financieros
HISTORY_DESCRIPTION varchar2 itgen_cio_history_description
HISTORY_INDICATOR varchar2 Historial de indicadores
INCOME_STATEMENT_DATE varchar2 Fecha de la cuenta de resultados
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 Patrimonio neto
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 Número de Teléfono
POSTCODE varchar2 Código Postal
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 Nombre de Intercambio
TRADE_NAMES varchar2 Nombres de trazas

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: