Navigatie: Schema: CompanyInfo > Tables

creditsafeGetReportFull

Catalog: CompanyInfo

Schema: CompanyInfo

This is a read-only table function. The Company.info API may not support changing the data or the Invantive SQL driver for Company.info does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Company.info API.

Topic: creditsafeGetReportFull

Base XPath: /s:Envelope/s:Body/tns:creditsafeGetReportFullResponse/tns:out

Filters on API Server: company_id- language- document

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function creditsafeGetReportFull. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required
company_id	string	☐
document	string	☐
language	string	☐

Table Function Columns

The columns of the table function creditsafeGetReportFull are shown below. Each column has an SQL data type.

Name	Data Type	Label
ADDITIONAL_INFORMATION_BE_EVENTS_ITEM_DESCRIPTION	string
ADDITIONAL_INFORMATION_BE_EVENTS_ITEM_SERIAL_NUMBER	int64
ADDITIONAL_INFORMATION_BE_INDUSTRY_COMPARISON_ACTIVITY_CODE	int64
ADDITIONAL_INFORMATION_BE_INDUSTRY_COMPARISON_ACTIVITY_DESCRIPTION	string
ADDITIONAL_INFORMATION_BE_INDUSTRY_COMPARISON_INDUSTRY_AVERAGE_CREDIT_RATING	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_COMPARISON_INDUSTRY_AVERAGE_DAY_SALES_OUTSTANDING	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_COMPARISON_INDUSTRY_AVERAGE_PAYMENT_EXPECTATION_DAYS	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_QUARTILE_ANALYSIS_DAY_SALES_OUTSTANDING_LOWER	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_QUARTILE_ANALYSIS_DAY_SALES_OUTSTANDING_MEDIAN	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_QUARTILE_ANALYSIS_DAY_SALES_OUTSTANDING_UPPER	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_QUARTILE_ANALYSIS_PAYMENT_EXPECTATION_DAYS_LOWER	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_QUARTILE_ANALYSIS_PAYMENT_EXPECTATION_DAYS_MEDIAN	decimal
ADDITIONAL_INFORMATION_BE_INDUSTRY_QUARTILE_ANALYSIS_PAYMENT_EXPECTATION_DAYS_UPPER	decimal
ADDITIONAL_INFORMATION_BE_MISC_FAX_NUMBER	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_BANKRUPTCY_TYPE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_CITY_OF_REGISTERED_OFFICE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_CITY_OF_TRUSTEE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_CLOSING_DATE_OF_SUMMONS	datetime
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_COMMERCIAL_COURT	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_COMPANY_NAME	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_DATE_OF_DECREEE_OF_BANKRUPTCY	datetime
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_NACE_BEL_CODE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_NACE_BEL_DESCRIPTION	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_NAME_OF_TRUSTEE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_POSTCODE_OF_REGISTERED_OFFICE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_POSTCODE_OF_TRUSTEE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_SOURCE_DATE	datetime
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_SOURCE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_STREET_OF_REGISTERED_OFFICE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_BANKRUPTCY_EVENTS_ITEM_STREET_OF_TRUSTEE	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_NSSO_DETAILS_ITEM_BUSINESS_NUMBER	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_NSSO_DETAILS_ITEM_DATE_OF_SUMMONS	datetime
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_NSSO_DETAILS_ITEM_LABOUR_COURT	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_NSSO_DETAILS_ITEM_LEGAL_FORM_OF_DEFENDANT	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_NSSO_DETAILS_ITEM_NAME_OF_DEFENDANT	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_BILL_AMOUNT	decimal
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_BILL_CURRENCY	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_CITY_OF_DRAWER	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_DRAWEE_ADDRESS	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_DRAWEE_NAME	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_MATURITY_OF_BILL_IN_MONTHS	decimal
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_NAME_OF_DRAWER	string
ADDITIONAL_INFORMATION_BE_NEGATIVE_INFORMATION_PROTESTED_BILLS_ITEM_PAYMENT_DATE	datetime
ADDITIONAL_INFORMATION_BE_PAYMENT_EXPECTATIONS_SUMMARY_DAY_SALES_OUTSTANDING	decimal
ADDITIONAL_INFORMATION_BE_PAYMENT_EXPECTATIONS_SUMMARY_PAYMENT_EXPECTATION_DAYS	decimal
ADDITIONAL_INFORMATION_BE_REGISTERED_CONTRACTORS_ITEM_CONTRACTOR_DESCRIPTION	string
ADDITIONAL_INFORMATION_BE_REGISTERED_CONTRACTORS_ITEM_REGISTRATION_NUMBER	int64
ADDITIONAL_INFORMATION_BE_REGISTERED_CONTRACTORS_ITEM_STRIKING_OFF_DATE	datetime
ADDITIONAL_INFORMATION_NL_INDUSTRY_QUARTILE_ANALYSIS_DAY_SALES_OUTSTANDING_LOWER	decimal
ADDITIONAL_INFORMATION_NL_INDUSTRY_QUARTILE_ANALYSIS_DAY_SALES_OUTSTANDING_MEDIAN	decimal
ADDITIONAL_INFORMATION_NL_INDUSTRY_QUARTILE_ANALYSIS_DAY_SALES_OUTSTANDING_UPPER	decimal
ADDITIONAL_INFORMATION_NL_INDUSTRY_QUARTILE_ANALYSIS_PAYMENT_EXPECTATION_DAYS_LOWER	decimal
ADDITIONAL_INFORMATION_NL_INDUSTRY_QUARTILE_ANALYSIS_PAYMENT_EXPECTATION_DAYS_MEDIAN	decimal
ADDITIONAL_INFORMATION_NL_INDUSTRY_QUARTILE_ANALYSIS_PAYMENT_EXPECTATION_DAYS_UPPER	decimal
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_COMPANY_NAME	string
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_COMPANY_NUMBER	int64
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_DATE_SUBMITTED	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_FINANCIAL_YEAR	int64
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_2ND_PARENT_ITEM_REMOVAL_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_2ND_PARENT_ITEM_REMOVAL_SUBMITTED_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_2ND_PARENT_ITEM_START_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_2ND_PARENT_ITEM_SUBMITTED_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_ITEM_REMOVAL_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_ITEM_REMOVAL_SUBMITTED_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_ITEM_START_DATE	datetime
ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABILITY_INFORMATION_403_LETTERS_OF_LIABILITY_ITEM_SUBMITTED_DATE	datetime
ADDITIONAL_INFORMATION_NL_MISC_CEASED_TRADING_DATE	datetime
ADDITIONAL_INFORMATION_NL_MISC_EXPORTER	boolean
ADDITIONAL_INFORMATION_NL_MISC_IMPORTER	boolean
ADDITIONAL_INFORMATION_NL_NEGATIVE_INFORMATION_COURT_DATA_FACTS_COURT_ACTION	boolean
ADDITIONAL_INFORMATION_NL_NEGATIVE_INFORMATION_COURT_DATA_FACTS_DATE_OF_BANKRUPTCY	datetime
ADDITIONAL_INFORMATION_NL_NEGATIVE_INFORMATION_COURT_DATA_FACTS_DETAILS	string
ADDITIONAL_INFORMATION_NL_NEGATIVE_INFORMATION_COURT_DATA_RECEIVER_DETAILS_ADDRESS	string
ADDITIONAL_INFORMATION_NL_NEGATIVE_INFORMATION_COURT_DATA_RECEIVER_DETAILS_NAME	string
ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_DAY_SALES_OUTSTANDING	decimal
ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_INDUSTRY_AVERAGE_DAY_SALES_OUTSTANDING	decimal
ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_INDUSTRY_AVERAGE_PAYMENT_EXPECTATION_DAYS	decimal
ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_PAYMENT_EXPECTATION_DAYS	decimal
ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_SUSPENSION_OF_PAYMENTS_MORA	boolean
COMPANY_ID	string	Company ID
COMPANY_IDENTIFICATION_ACTIVITIES_ITEM_ACTIVITY_CODE	string
COMPANY_IDENTIFICATION_ACTIVITIES_ITEM_ACTIVITY_DESCRIPTION	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_BUSINESS_NAME	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_COMMERCIAL_COURT	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_COMPANY_REGISTRATION_NUMBER	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_COMPANY_STATUS	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_TELEPHONE_NUMBER	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_COUNTRY	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_DATEOF_COMPANY_REGISTRATION	datetime
COMPANY_IDENTIFICATION_BASIC_INFORMATION_DATEOF_STARTING_OPERATIONS	datetime
COMPANY_IDENTIFICATION_BASIC_INFORMATION_LEGAL_FORM	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_PRINCIPAL_ACTIVITY_ACTIVITY_CODE	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_PRINCIPAL_ACTIVITY_ACTIVITY_DESCRIPTION	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_REGISTERED_COMPANY_NAME	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_REPORT_CURRENCY	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_TYPEOF_OWNERSHIP	string
COMPANY_IDENTIFICATION_BASIC_INFORMATION_VAT_REGISTRATION_DATE	datetime
COMPANY_IDENTIFICATION_BASIC_INFORMATION_VAT_REGISTRATION_NUMBER	string
COMPANY_IDENTIFICATION_PREVIOUS_LEGAL_FORMS_ITEM_DATE_CHANGED	datetime
COMPANY_IDENTIFICATION_PREVIOUS_LEGAL_FORMS_ITEM_VALUE	string
COMPANY_IDENTIFICATION_PREVIOUS_NAMES_ITEM_DATE_CHANGED	datetime
COMPANY_IDENTIFICATION_PREVIOUS_NAMES_ITEM_VALUE	string
COMPANY_SUMMARY_BUSINESS_NAME	string	Summary Business Name
COMPANY_SUMMARY_COMPANY_REGISTRATION_NUMBER	string
COMPANY_SUMMARY_COMPANY_STATUS	string
COMPANY_SUMMARY_COUNTRY	string	Summary Country
COMPANY_SUMMARY_CREDIT_LIMIT	string	Summary Credit Limit
COMPANY_SUMMARY_CREDIT_RATING	string
COMPANY_SUMMARY_LATEST_SHAREHOLDERS_EQUITY_FIGURE	decimal
COMPANY_SUMMARY_LATEST_TURNOVER_FIGURE	decimal
COMPANY_SUMMARY_MAIN_ACTIVITY_ACTIVITY_CODE	string
COMPANY_SUMMARY_MAIN_ACTIVITY_ACTIVITY_DESCRIPTION	string
COMPANY_SUMMARY_NUMBER	string	Summary Number
COMPANY_SUMMARY_RATING_DESCRIPTION	string
CONTACT_INFORMATION_EMAIL_ADDRESSES_ITEM	string
CONTACT_INFORMATION_MAIN_ADDRESS_ADDRESS	string	Contact Main Address Address
CONTACT_INFORMATION_MAIN_ADDRESS_COUNTRY	string	Contact Main Address Country
CONTACT_INFORMATION_MAIN_ADDRESS_TELEPHONE	string	Contact Main Address Telephone
CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_ADDRESS	string
CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_COUNTRY	string
CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_TELEPHONE	string
CONTACT_INFORMATION_PREVIOUS_ADDRESSES_ITEM_ADDRESS	string
CONTACT_INFORMATION_PREVIOUS_ADDRESSES_ITEM_COUNTRY	string
CONTACT_INFORMATION_WEBSITES_ITEM	string
CREDIT_SCORE_CURRENT_CONTRACT_LIMIT	decimal
CREDIT_SCORE_CURRENT_CREDIT_LIMIT	string
CREDIT_SCORE_CURRENT_CREDIT_RATING	string
CREDIT_SCORE_CURRENT_RATING_DESCRIPTION	string
CREDIT_SCORE_DATE_OF_LATEST_RATING_CHANGE	datetime
CREDIT_SCORE_PREVIOUS_CREDIT_LIMIT	string
CREDIT_SCORE_PREVIOUS_CREDIT_RATING	string
CREDIT_SCORE_PREVIOUS_RATING_DESCRIPTION	string
DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS	string
DIRECTORS_CURRENT_DIRECTORS_ITEM_APPOINTMENT_DATE	datetime
DIRECTORS_CURRENT_DIRECTORS_ITEM_DATE_OF_BIRTH	datetime
DIRECTORS_CURRENT_DIRECTORS_ITEM_GENDER	string
DIRECTORS_CURRENT_DIRECTORS_ITEM_NAME	string
DIRECTORS_CURRENT_DIRECTORS_ITEM_POSITION	string
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_ADDRESS	string
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_APPOINTMENT_DATE	datetime
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_DATE_OF_BIRTH	datetime
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_GENDER	string
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_NAME	string
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_POSITION	string
DIRECTORS_PREVIOUS_DIRECTORS_ITEM_RESIGNATION_DATE	datetime
DOCUMENT	byte[]	Document
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_BANK_LIABILITIES_DUE_AFTER1YEAR	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_BANK_LIABILITIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CALLED_UP_SHARE_CAPITAL	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CASH	decimal	Balance Sheet Cash
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CONSOLIDATED_ACCOUNTS	boolean	Balance Sheet Consolidated Accounts
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CURRENCY	string	Balance Sheet Currency
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_FINISHED_GOODS	decimal	Balance Sheet Finished Goods
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GOODWILL	decimal	Balance Sheet Goodwill
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_PAYABLES_DUE_AFTER1YEAR	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_PAYABLES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_RECEIVABLES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_INVESTMENTS	decimal	Balance Sheet Investments
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_LAND_AND_BUILDINGS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_LOANS_TO_GROUP	decimal	Balance Sheet Loans to Group
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_FIXED_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_LIABILITIES_DUE_AFTER1YEAR	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_LIABILITIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_RECEIVABLES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_NUMBER_OF_WEEKS	int64	Balance Sheet Total Assets
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_CURRENT_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_INTANGIBLE_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_INVENTORIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS_OR_FINANCE_DUE_AFTER1YEAR	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS_OR_FINANCE	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_RESERVES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_TANGIBLE_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_PLANT_AND_MACHINERY	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_RAW_MATERIALS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_RECEIVABLES_DUE_AFTER1YEAR	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_REVENUE_RESERVES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_SHARE_PREMIUM	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_ASSETS	decimal	Balance Sheet Total Assets
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_CURRENT_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_CURRENT_LIABILITIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_FIXED_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_INTANGIBLE_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_INVENTORIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_LIABILITIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_LONG_TERM_LIABILITIES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_OTHER_FIXED_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_RECEIVABLES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_SHAREHOLDERS_EQUITY	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_TANGIBLE_ASSETS	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_PAYABLES_DUE_AFTER1YEAR	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_PAYABLES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_RECEIVABLES	decimal
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_WORK_IN_PROGRESS	decimal	Balance Sheet Work in Progress
FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_YEAR_END_DATE	datetime
FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_CONTINGENT_LIABILITIES	string
FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_NET_WORTH	decimal
FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_WORKING_CAPITAL	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_AMORTISATION	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_CONSOLIDATED_ACCOUNTS	boolean	Profit & Loss Consolidated Accounts
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_CURRENCY	string	Profit & Loss Currency
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_DEPRECIATION	decimal	Profit & Loss Depreciation
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_DIVIDENDS	decimal	Profit & Loss Dividens
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_EXTRAORDINARY_COSTS	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_EXTRAORDINARY_INCOME	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_FINANCIAL_EXPENSES	decimal	Profit & Loss Financial Expenses
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_FINANCIAL_INCOME	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_MINORITY_INTERESTS	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_NUMBER_OF_WEEKS	int64	Profit & Loss Total Assets
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OPERATING_COSTS	decimal	Profit & Loss Operating Costs
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OPERATING_PROFIT	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OTHER_APPROPRIATIONS	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PENSION_COSTS	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PROFIT_AFTER_TAX	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PROFIT_BEFORE_TAX	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_RETAINED_PROFIT	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_REVENUE	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_TAX	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_WAGES_AND_SALARIES	decimal
FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_YEAR_END_DATE	datetime
FINANCIAL_STATEMENTS_ITEM_RATIOS_CREDITOR_DAYS	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_CURRENT_DEBT_RATIO	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_CURRENT_RATIO	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_DEBTOR_DAYS	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_EQUITY_IN_PERCENTAGE	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_GEARING	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_LIQUIDITY_RATIO_OR_ACID_TEST	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_PRE_TAX_PROFIT_MARGIN	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_CAPITAL_EMPLOYED	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_NET_ASSETS_EMPLOYED	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_TOTAL_ASSETS_EMPLOYED	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_SALES_OR_NET_WORKING_CAPITAL	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_STOCK_TURNOVER_RATIO	decimal
FINANCIAL_STATEMENTS_ITEM_RATIOS_TOTAL_DEBT_RATIO	decimal
GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_COMPANY_ID	string
GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_COMPANY_NAME	string
GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_COUNTRY	string
GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_NUMBER	string
GROUP_STRUCTURE_IMMEDIATE_PARENT_COMPANY_ID	string
GROUP_STRUCTURE_IMMEDIATE_PARENT_COMPANY_NAME	string
GROUP_STRUCTURE_IMMEDIATE_PARENT_COUNTRY	string
GROUP_STRUCTURE_IMMEDIATE_PARENT_NUMBER	string
GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_COMPANY_ID	string
GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_COMPANY_NAME	string
GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_COUNTRY	string
GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_NUMBER	string
GROUP_STRUCTURE_ULTIMATE_PARENT_COMPANY_ID	string
GROUP_STRUCTURE_ULTIMATE_PARENT_COMPANY_NAME	string
GROUP_STRUCTURE_ULTIMATE_PARENT_COUNTRY	string
GROUP_STRUCTURE_ULTIMATE_PARENT_NUMBER	string
LANGUAGE	string	Language
ORDER_NUMBER	int64
OTHER_INFORMATION_ADVISORS_ITEM_AUDITOR_NAME	string
OTHER_INFORMATION_ADVISORS_ITEM_SOLICITOR_NAME	string
OTHER_INFORMATION_BANKERS_ITEM_ADDRESS	string
OTHER_INFORMATION_BANKERS_ITEM_BANK_CODE	string
OTHER_INFORMATION_BANKERS_ITEM_NAME	string
OTHER_INFORMATION_EMPLOYEES_INFORMATION_ITEM_NUMBER_OF_EMPLOYEES	string
OTHER_INFORMATION_EMPLOYEES_INFORMATION_ITEM_YEAR	int16
SHARE_CAPITAL_STRUCTURE_ISSUED_SHARE_CAPITAL	decimal
SHARE_CAPITAL_STRUCTURE_NOMINAL_SHARE_CAPITAL	decimal
SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS	string
SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_NAME	string
SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_SHARE_PERCENT	decimal

15-06-2022 23:19 Version 22.1.46-BETA+3385

Schakel JavaScript in om deze site te bekijken.

CompanyInfo Data Model CompanyInfo Forums

creditsafeGetReportFull

Parameters of Table Function

Table Function Columns

Belangrijke Informatie over Veiligheid en Gebruik