Schakel JavaScript in om deze site te bekijken.

CompanyInfo Forums

CompanyInfo Data Model

Navigatie: Schema: CompanyInfo > Tables

creditsafeGetReportFullV2

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: creditsafeGetReportFullV2

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

Filters on API Server: company_id- language- reason

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function creditsafeGetReportFullV2. 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

Default Value

Documentation

company_id

string

☐

 

 

language

string

☐

 

 

reason

string

☐

 

 

 

Table Function Columns

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

Name

Data Type

Label

Required

Documentation

ADDITIONAL_INFORMATION_DE_BENEFICIARY_OWNERS_CITY

string

 

 

 

ADDITIONAL_INFORMATION_DE_BENEFICIARY_OWNERS_COUNTRY

string

 

 

 

ADDITIONAL_INFORMATION_DE_BENEFICIARY_OWNERS_NAME

string

 

 

 

ADDITIONAL_INFORMATION_DE_BENEFICIARY_OWNERS_POSTAL_CODE

string

 

 

 

ADDITIONAL_INFORMATION_DE_BENEFICIARY_OWNERS_SHARE_PERCENT

string

 

 

 

ADDITIONAL_INFORMATION_DE_COMMENTS_ITEM_SENTIMENT

string

 

 

 

ADDITIONAL_INFORMATION_DE_COMMENTS_ITEM_TEXT

string

 

 

 

ADDITIONAL_INFORMATION_DE_HISTORICAL_EVENTS_ITEM_CURRENT_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_HISTORICAL_EVENTS_ITEM_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_DE_HISTORICAL_EVENTS_ITEM_DESCRIPTION

string

 

 

 

ADDITIONAL_INFORMATION_DE_HISTORICAL_EVENTS_ITEM_PREVIOUS_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_IMAGE_ACCOUNTS_DOCUMENT_TYPE

string

 

 

 

ADDITIONAL_INFORMATION_DE_IMAGE_ACCOUNTS_END_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_DE_IMAGE_ACCOUNTS_FINANCIALS_TYPE

string

 

 

 

ADDITIONAL_INFORMATION_DE_IMAGE_ACCOUNTS_PUBLISHED_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_DE_IMAGE_ACCOUNTS_SERIAL_NUMBER

string

 

 

 

ADDITIONAL_INFORMATION_DE_IMAGE_ACCOUNTS_START_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_BUSINESS_PURPOSE

string

DE Miscellaneous Business Purpose

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_COMMERCIAL_REGISTER_CITY

string

DE Miscellaneous Commercial Register City

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_COMMERCIAL_REGISTER_ZIP

string

DE Miscellaneous Commercial Register ZIP Code

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_COMPANY_TYPE

string

DE Miscellaneous Company Type

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_COMPLEMENTARY_COMPANY

string

DE Miscellaneous Complementary Company

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_CURRENT_RATING_MAX_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_CURRENT_RATING_MIN_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_CURRENT_RATING_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_FAX_NUMBER

string

DE Miscellaneous Fax Number

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_FINANCIALS_QUALITY

string

DE Miscellaneous Financials Quality

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_NEGATIVE_RATING

string

DE Miscellaneous Negative Rating

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_PREMISE_TYPE

string

DE Miscellaneous Premise Type

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_PREVIOUS_RATING_MAX_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_PREVIOUS_RATING_MIN_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_PREVIOUS_RATING_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_SMALL_OFFICE

string

DE Miscellaneous Small Office

 

 

ADDITIONAL_INFORMATION_DE_MISCELLANEOUS_TURNOVER_RANGE

string

DE Miscellaneous Turnover Range

 

 

ADDITIONAL_INFORMATION_DE_TURNOVER_RANGES_RANGE

string

 

 

 

ADDITIONAL_INFORMATION_DE_TURNOVER_RANGES_YEAR

int64

 

 

 

ADDITIONAL_INFORMATION_GENERIC_ITEM_KEY

string

 

 

 

ADDITIONAL_INFORMATION_GENERIC_ITEM_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_NL_COMMENTS_ITEM_SENTIMENT

string

 

 

 

ADDITIONAL_INFORMATION_NL_COMMENTS_ITEM_TEXT

string

 

 

 

ADDITIONAL_INFORMATION_NL_FINANCIAL_ITEMS_ITEM_CONSOLIDATED_SUBSIDIARIES

string

 

 

 

ADDITIONAL_INFORMATION_NL_FINANCIAL_ITEMS_ITEM_DATE_YEAR_END

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_FINANCIAL_ITEMS_ITEM_JUDGEMENT

string

 

 

 

ADDITIONAL_INFORMATION_NL_HISTORICAL_EVENTS_ITEM_CURRENT_VALUE

string

 

 

 

ADDITIONAL_INFORMATION_NL_HISTORICAL_EVENTS_ITEM_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_HISTORICAL_EVENTS_ITEM_DESCRIPTION

string

 

 

 

ADDITIONAL_INFORMATION_NL_HISTORICAL_EVENTS_ITEM_PREVIOUS_VALUE

string

 

 

 

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_INDUSTY_COMPARISON_INDUSTRY_AVERAGE_CREDIT_LIMIT

decimal

 

 

 

ADDITIONAL_INFORMATION_NL_INDUSTY_COMPARISON_INDUSTRY_AVERAGE_CREDIT_RATING

decimal

 

 

 

ADDITIONAL_INFORMATION_NL_KVK_FILINGS_ITEM_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_KVK_FILINGS_ITEM_EVENT

string

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_COMPANY_NAME

string

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_COMPANY_NUMBER

string

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_DATE_SUBMITTED

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_FINANCIAL_YEAR

int64

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_REMOVAL_DATE_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_REMOVAL_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_REMOVAL_SUBMITTED_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_REMOVAL_SUBMITTED

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_START_DATE_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_START_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_SUBMITTED_DATE_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY1_SUBMITTED_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_REMOVAL_DATE_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_REMOVAL_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_REMOVAL_SUBMITTED_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_REMOVAL_SUBMITTED

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_START_DATE_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_START_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_SUBMITTED_DATE_PARENT2

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_LETTERS_OF_LIABLILITY_INFORMATION403_ITEM_LETTER_OF_LIABILITY2_SUBMITTED_DATE

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_BRANCH_NUMBER

string

NL Miscellaneous Branch Number

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_DATE_OF_CESSATION_TRADING

datetime

 

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_DATE_OF_LEGAL_FORM

datetime

NL Miscellaneous Date of Legal Form

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_EXPORTER

string

NL Miscellaneous Exporter

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_IMPORTER

string

NL Miscellaneous Importer

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_NEGATIVE_RATING

int64

NL Miscellaneous Negative Rating

 

 

ADDITIONAL_INFORMATION_NL_MISCELLANEOUS_RSIN_NUMBER

string

NL Miscellaneous RSIN Number

 

 

ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_DAY_SALES_OUTSTANDING

int64

 

 

 

ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_INDUSTRY_AVERAGE_DAY_SALES_OUTSTANDING

int64

 

 

 

ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_INDUSTRY_AVERAGE_PAYMENT_EXPECTATION_DAYS

int64

 

 

 

ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_PAYMENT_EXPECTATION_DAYS

int64

 

 

 

ADDITIONAL_INFORMATION_NL_PAYMENT_EXPECTATIONS_SUMMARY_SUSPENSION_OF_PAYMENTS_MORA

string

 

 

 

COMPANY_ID

string

Company ID

 

 

COMPANY_IDENTIFICATION_ACTIVITY_CLASSIFICATIONS_ITEM_ACTIVITIES

string

 

 

 

COMPANY_IDENTIFICATION_ACTIVITY_CLASSIFICATIONS_ITEM_CLASSIFICATION

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_BUSINESS_NAME

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_COMPANY_REGISTRATION_NUMBER

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_COMPANY_STATUS_DESCRIPTION

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_COMPANY_STATUS_STATUS

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_CITY

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_COUNTRY

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_FULL_ADDRESS

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_HOUSE_NUMBER

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_POSTAL_CODE

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_STREET

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_CONTACT_ADDRESS_TELEPHONE

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_CODE

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_LEGAL_FORM_DESCRIPTION

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_LEGAL_FORM_VALUE

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_PRINCIPAL_ACTIVITY_CODE

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_PRINCIPAL_ACTIVITY_DESCRIPTION

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_PRINCIPAL_ACTIVITY_VALUE

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_REGISTERED_COMPANY_NAME

string

 

 

 

COMPANY_IDENTIFICATION_BASIC_INFORMATION_VAT_REGISTRATION_NUMBER

string

 

 

 

COMPANY_SUMMARY_BUSINESS_NAME

string

Summary Business Name

 

 

COMPANY_SUMMARY_COMPANY_REGISTRATION_NUMBER

string

 

 

 

COMPANY_SUMMARY_COMPANY_STATUS_DESCRIPTION

string

Summary Company Status Description

 

 

COMPANY_SUMMARY_COMPANY_STATUS_STATUS

string

Summary Company Status Status

 

 

COMPANY_SUMMARY_COUNTRY

string

Summary Country

 

 

COMPANY_SUMMARY_CREDIT_RATING_COMMON_DESCRIPTION

string

Summary Credit Rating Common Description

 

 

COMPANY_SUMMARY_CREDIT_RATING_COMMON_VALUE

string

Summary Credit Rating Common Value

 

 

COMPANY_SUMMARY_CREDIT_RATING_CREDIT_LIMIT

string

Summary Credit Rating Credit Limit

 

 

COMPANY_SUMMARY_CREDIT_RATING_PROVIDER_DESCRIPTION

string

 

 

 

COMPANY_SUMMARY_CREDIT_RATING_PROVIDER_VALUE_MAX_VALUE

string

Summary Credit Rating Provider Value Maximum Value

 

 

COMPANY_SUMMARY_CREDIT_RATING_PROVIDER_VALUE_MIN_VALUE

string

Summary Credit Rating Provider Value Minimum Value

 

 

COMPANY_SUMMARY_CREDIT_RATING_PROVIDER_VALUE_VALUE

string

Summary Credit Rating Provider Value Value

 

 

COMPANY_SUMMARY_LATEST_SHAREHOLDERS_EQUITY_FIGURE

int32

 

 

 

COMPANY_SUMMARY_LATEST_TURNOVER_FIGURE

int32

 

 

 

COMPANY_SUMMARY_MAIN_ACTIVITY_ACTIVITY_CODE

string

 

 

 

COMPANY_SUMMARY_MAIN_ACTIVITY_ACTIVITY_DESCRIPTION

string

 

 

 

COMPANY_SUMMARY_MAIN_ACTIVITY_CLASSIFICATION

string

 

 

 

COMPANY_SUMMARY_NUMBER

string

Summary Number

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_CITY

string

Contact Main Address City

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_COUNTRY

string

Contact Main Address Country

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_FULL_ADDRESS

string

Contact Main Address Full Address

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_HOUSE_NUMBER

string

Contact Main Address House Number

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_POSTAL_CODE

string

Contact Main Address Postal Code

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_STREET

string

Contact Main Address Street

 

 

CONTACT_INFORMATION_MAIN_ADDRESS_TELEPHONE

string

Contact Main Address Telephone

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_CITY

string

 

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_COUNTRY

string

 

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_FULL_ADDRESS

string

 

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_HOUSE_NUMBER

string

 

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_POSTAL_CODE

string

 

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_STREET

string

 

 

 

CONTACT_INFORMATION_OTHER_ADDRESSES_ITEM_TELEPHONE

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_COMMON_DESCRIPTION

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_COMMON_VALUE

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_CREDIT_LIMIT

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_PROVIDER_DESCRIPTION

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_PROVIDER_VALUE_MAX_VALUE

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_PROVIDER_VALUE_MIN_VALUE

string

 

 

 

CREDIT_SCORE_CURRENT_CREDIT_RATING_PROVIDER_VALUE_VALUE

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_COMMON_DESCRIPTION

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_COMMON_VALUE

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_CREDIT_LIMIT

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_PROVIDER_DESCRIPTION

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_PROVIDER_VALUE_MAX_VALUE

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_PROVIDER_VALUE_MIN_VALUE

string

 

 

 

CREDIT_SCORE_PREVIOUS_CREDIT_RATING_PROVIDER_VALUE_VALUE

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_CITY

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_COUNTRY

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_FULL_ADDRESS

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_HOUSE_NUMBER

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_POSTAL_CODE

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_STREET

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ADDRESS_TELEPHONE

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_DATE_OF_BIRTH

datetime

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_DIRECTOR_TYPE

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_GENDER

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_ID

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_NAME

string

 

 

 

DIRECTORS_CURRENT_DIRECTORS_ITEM_POSITIONS

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_CITY

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_COUNTRY

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_FULL_ADDRESS

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_HOUSE_NUMBER

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_POSTAL_CODE

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_STREET

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ADDRESS_TELEPHONE

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DATE_OF_BIRTH

datetime

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_DIRECTOR_TYPE

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_GENDER

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_ID

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_NAME

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_POSITIONS

string

 

 

 

DIRECTORS_PREVIOUS_DIRECTORS_ITEM_RESIGNATION_DATE

datetime

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_BANK_LIABILITIES_DUE_AFTER1YEAR

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_BANK_LIABILITIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CALLED_UP_SHARE_CAPITAL

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CASH

int32

Balance Sheet Cash

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CONSOLIDATED_ACCOUNTS

int32

Balance Sheet Consolidated Accounts

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_FINISHED_GOODS

int32

Balance Sheet Finished Goods

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GOODWILL

int32

Balance Sheet Goodwill

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_PAYABLES_DUE_AFTER1YEAR

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_PAYABLES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_RECEIVABLES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_INVESTMENTS

int32

Balance Sheet Investments

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_LAND_AND_BUILDINGS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_LOANS_TO_GROUP

int32

Balance Sheet Loans to Group

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_FIXED_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_LIABILITIES_DUE_AFTER1_YEAR

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_LIABILITIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_RECEIVABLES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_CURRENT_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_INTANGIBLE_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_INVENTORIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS_OR_FINANCE_DUE_AFTER1_YEAR

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS_OR_FINANCE

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_RESERVES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_TANGIBLE_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_PLANT_AND_MACHINERY

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_RAW_MATERIALS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_RECEIVABLES_DUE_AFTER1YEAR

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_REVENUE_RESERVES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_SHARE_PREMIUM

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_ASSETS

int32

Balance Sheet Total Assets

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_CURRENT_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_CURRENT_LIABILITIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_FIXED_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_INTANGIBLE_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_INVENTORIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_LIABILITIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_LONG_TERM_LIABILITIES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_OTHER_FIXED_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_RECEIVABLES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_SHAREHOLDERS_EQUITY

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_TANGIBLE_ASSETS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_PAYABLES_DUE_AFTER1YEAR

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_PAYABLES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_RECEIVABLES

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_WORK_IN_PROGRESS

int32

Balance Sheet Work in Progress

 

 

FINANCIAL_STATEMENTS_ITEM_CONSOLIDATED_ACCOUNTS

boolean

Financial Statement Consolidated Accounts

 

 

FINANCIAL_STATEMENTS_ITEM_CURRENCY

string

Financial Statement Currency

 

 

FINANCIAL_STATEMENTS_ITEM_NUMBER_OF_WEEKS

int64

Financial Statement Total Assets

 

 

FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_NET_WORTH

int64

 

 

 

FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_WORKING_CAPITAL

int64

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_DEPRECIATION

int32

Profit & Loss Depreciation

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_DIVIDENDS

int32

Profit & Loss Dividens

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_FINANCIAL_EXPENSES

int32

Profit & Loss Financial Expenses

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_FINANCIAL_INCOME

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OPERATING_COSTS

int32

Profit & Loss Operating Costs

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OPERATING_PROFIT

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OTHER_APPROPRIATIONS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PENSION_COSTS

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PROFIT_AFTER_TAX

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PROFIT_BEFORE_TAX

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_RETAINED_PROFIT

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_REVENUE

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_TAX

int32

 

 

 

FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_WAGES_AND_SALARIES

int32

 

 

 

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

 

 

 

FINANCIAL_STATEMENTS_ITEM_TYPE

string

Financial Statement Type

 

 

FINANCIAL_STATEMENTS_ITEM_YEAR_END_DATE

datetime

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_CITY

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_COUNTRY

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_FULL_ADDRESS

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_HOUSE_NUMBER

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_POSTAL_CODE

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_STREET

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ADDRESS_TELEPHONE

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_COUNTRY

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_CREDITSAFE_NUMBER

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_DATE_LAST_ACCOUNT

datetime

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_DATE_LAST_CHANGE

datetime

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_ID

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_NAME

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_OFFICE_TYPE

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_REGISTRATION_NUMBER

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_STATUS

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_TRADE_NAMES

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_TYPE

string

 

 

 

GROUP_STRUCTURE_AFFILIATED_COMPANIES_ITEM_VAT_NUMBERS

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_CITY

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_COUNTRY

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_FULL_ADDRESS

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_HOUSE_NUMBER

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_POSTAL_CODE

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_STREET

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ADDRESS_TELEPHONE

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_COUNTRY

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_CREDITSAFE_NUMBER

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_DATE_LAST_ACCOUNT

datetime

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_DATE_LAST_CHANGE

datetime

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_ID

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_NAME

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_OFFICE_TYPE

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_REGISTRATION_NUMBER

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_STATUS

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_TRADE_NAMES_ITEM

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_TYPE

string

 

 

 

GROUP_STRUCTURE_IMMEDIATE_PARENT_VAT_NUMBERS_ITEM

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_CITY

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_COUNTRY

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_FULL_ADDRESS

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_HOUSE_NUMBER

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_POSTAL_CODE

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_STREET

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ADDRESS_TELEPHONE

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_COUNTRY

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_CREDITSAFE_NUMBER

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_DATE_LAST_ACCOUNT

datetime

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_DATE_LAST_CHANGE

datetime

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_ID

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_NAME

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_OFFICE_TYPE

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_REGISTRATION_NUMBER

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_STATUS

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_TRADE_NAMES

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_TYPE

string

 

 

 

GROUP_STRUCTURE_SUBSIDIARY_COMPANIES_ITEM_VAT_NUMBERS

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_CITY

string

Group Structure Ultimate Parent Address City

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_COUNTRY

string

Group Structure Ultimate Parent Address Country

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_FULL_ADDRESS

string

Group Structure Ultimate Parent Address Full Address

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_HOUSE_NUMBER

string

Group Structure Ultimate Parent Address House Number

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_POSTAL_CODE

string

Group Structure Ultimate Parent Address Postal Code

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_STREET

string

Group Structure Ultimate Parent Address Street

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ADDRESS_TELEPHONE

string

Group Structure Ultimate Parent Address Telephone

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_COUNTRY

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_CREDITSAFE_NUMBER

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_DATE_LAST_ACCOUNT

datetime

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_DATE_LAST_CHANGE

datetime

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_ID

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_NAME

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_OFFICE_TYPE

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_REGISTRATION_NUMBER

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_STATUS

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_TRADE_NAMES_ITEM

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_TYPE

string

 

 

 

GROUP_STRUCTURE_ULTIMATE_PARENT_VAT_NUMBERS_ITEM

string

 

 

 

LANGUAGE

string

Language

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_BANK_LIABILITIES_DUE_AFTER1YEAR

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_BANK_LIABILITIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CALLED_UP_SHARE_CAPITAL

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CASH

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_CONSOLIDATED_ACCOUNTS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_FINISHED_GOODS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GOODWILL

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_PAYABLES_DUE_AFTER1YEAR

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_PAYABLES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_GROUP_RECEIVABLES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_INVESTMENTS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_LAND_AND_BUILDINGS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_LOANS_TO_GROUP

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_FIXED_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_LIABILITIES_DUE_AFTER1_YEAR

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_LIABILITIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_MISCELLANEOUS_RECEIVABLES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_CURRENT_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_INTANGIBLE_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_INVENTORIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS_OR_FINANCE_DUE_AFTER1_YEAR

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS_OR_FINANCE

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_LOANS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_RESERVES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_OTHER_TANGIBLE_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_PLANT_AND_MACHINERY

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_RAW_MATERIALS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_RECEIVABLES_DUE_AFTER1YEAR

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_REVENUE_RESERVES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_SHARE_PREMIUM

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_CURRENT_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_CURRENT_LIABILITIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_FIXED_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_INTANGIBLE_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_INVENTORIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_LIABILITIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_LONG_TERM_LIABILITIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_OTHER_FIXED_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_RECEIVABLES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_SHAREHOLDERS_EQUITY

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TOTAL_TANGIBLE_ASSETS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_PAYABLES_DUE_AFTER1YEAR

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_PAYABLES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_TRADE_RECEIVABLES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_SHEET_WORK_IN_PROGRESS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_CONSOLIDATED_ACCOUNTS

boolean

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_CURRENCY

string

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_NUMBER_OF_WEEKS

int64

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_NET_WORTH

int64

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_OTHER_FINANCIALS_WORKING_CAPITAL

int64

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_DEPRECIATION

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_DIVIDENDS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_FINANCIAL_EXPENSES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_FINANCIAL_INCOME

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OPERATING_COSTS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OPERATING_PROFIT

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_OTHER_APPROPRIATIONS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PENSION_COSTS

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PROFIT_AFTER_TAX

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_PROFIT_BEFORE_TAX

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_RETAINED_PROFIT

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_REVENUE

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_TAX

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_PROFIT_AND_LOSS_WAGES_AND_SALARIES

int32

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CREDITOR_DAYS

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CURRENT_DEBT_RATIO

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CURRENT_RATIO

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_DEBTOR_DAYS

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_EQUITY_IN_PERCENTAGE

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_GEARING

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_LIQUIDITY_RATIO_OR_ACID_TEST

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_PRE_TAX_PROFIT_MARGIN

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_CAPITAL_EMPLOYED

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_NET_ASSETS_EMPLOYED

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_TOTAL_ASSETS_EMPLOYED

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_SALES_OR_NET_WORKING_CAPITAL

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_STOCK_TURNOVER_RATIO

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_TOTAL_DEBT_RATIO

decimal

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_TYPE

string

 

 

 

LOCAL_FINANCIAL_STATEMENTS_ITEM_YEAR_END_DATE

datetime

 

 

 

NEGATIVE_INFORMATION_DE_BANKRUPTCY_HAS_BANKRUPTCY

string

 

 

 

NEGATIVE_INFORMATION_DE_DIRECTOR_EVENTS_ITEM_CODE

string

 

 

 

NEGATIVE_INFORMATION_DE_DIRECTOR_EVENTS_ITEM_DATE

datetime

 

 

 

NEGATIVE_INFORMATION_DE_DIRECTOR_EVENTS_ITEM_DESCRIPTION

string

 

 

 

NEGATIVE_INFORMATION_DE_DIRECTOR_EVENTS_ITEM_NAME

string

 

 

 

NEGATIVE_INFORMATION_DE_DIRECTOR_EVENTS_ITEM_TYPE

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_DATEOF_INSOLVENCY

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_INSOLVENCY_EVENTS_ITEM_CREATED_AT

datetime

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_INSOLVENCY_EVENTS_ITEM_REFERENCE_NUMBER_COURT

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_CITY

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_CODE

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_EMAIL_ADDRESS

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_FAX_NUMBER

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_FIRST_NAME

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_LAST_NAME

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_NAME

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_TELEPHONE_NUMBER

string

 

 

 

NEGATIVE_INFORMATION_DE_INSOLVENCY_INFORMATION_TRUSTEE_TITLE

string

 

 

 

NEGATIVE_INFORMATION_GENERIC_ITEM_KEY

string

 

 

 

NEGATIVE_INFORMATION_GENERIC_ITEM_VALUE

string

 

 

 

NEGATIVE_INFORMATION_NL_COURT_ITEMS_ITEM_ADDRESS

string

 

 

 

NEGATIVE_INFORMATION_NL_COURT_ITEMS_ITEM_COURT_ACTION

string

 

 

 

NEGATIVE_INFORMATION_NL_COURT_ITEMS_ITEM_DATE_OF_BANKRUPTCY

datetime

 

 

 

ORDER_NUMBER

string

 

 

 

OTHER_INFORMATION_ADVISORS_ITEM_AUDITOR_NAME

string

 

 

 

OTHER_INFORMATION_ADVISORS_ITEM_SOLICITOR_NAME

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_CITY

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_COUNTRY

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_FULL_ADDRESS

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_HOUSE_NUMBER

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_POSTAL_CODE

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_STREET

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_ADDRESS_TELEPHONE

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_BANK_CODE

string

 

 

 

OTHER_INFORMATION_BANKERS_ITEM_NAME

string

 

 

 

OTHER_INFORMATION_EMPLOYEES_INFORMATION_ITEM_NUMBER_OF_EMPLOYEES

int64

 

 

 

OTHER_INFORMATION_EMPLOYEES_INFORMATION_ITEM_YEAR

int64

 

 

 

PAYMENT_DATA_GENERIC_ITEM_KEY

string

 

 

 

PAYMENT_DATA_GENERIC_ITEM_VALUE

string

 

 

 

SHARE_CAPITAL_STRUCTURE_ISSUED_SHARE_CAPITAL

string

 

 

 

SHARE_CAPITAL_STRUCTURE_NOMINAL_SHARE_CAPITAL

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_CITY

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_COUNTRY

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_FULL_ADDRESS

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_HOUSE_NUMBER

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_POSTAL_CODE

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_STREET

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_ADDRESS_TELEPHONE

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_NAME

string

 

 

 

SHARE_CAPITAL_STRUCTURE_SHARE_HOLDERS_ITEM_SHARE_PERCENT

int64

 

 

 

 

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

X

Belangrijke Informatie over Veiligheid en Gebruik

Beoogd gebruik en beperkingen: Deze software, ontwikkeld door Invantive, is ontworpen om een verscheidenheid aan zakelijke en informatietechnologische gegevensverwerkingsfuncties te ondersteunen, zoals boekhouding, financiële rapportage en verkooprapportage. Het is belangrijk om op te merken dat deze software niet is ontworpen, getest of goedgekeurd voor gebruik in omgevingen waar een storing of defect kan leiden tot levensbedreigende situaties, ernstige fysieke schade of milieuschade. Dit omvat, maar is niet beperkt tot:

  • Nucleaire faciliteiten: de software mag niet worden gebruikt voor operaties of functies die verband houden met de controle, het onderhoud of de werking van nucleaire faciliteiten.
  • Defensie en militaire toepassingen: deze software is niet geschikt voor gebruik in defensiegerelateerde toepassingen, inclusief maar niet beperkt tot wapenbeheer, militaire strategieplanning of andere aspecten van nationale defensie.
  • Luchtvaart: de software is niet bedoeld voor gebruik in de bediening, navigatie of communicatiesystemen van vliegtuigen of luchtverkeersleidingomgevingen.
  • Gezondheidszorg en medicijnproductie: deze software mag niet worden gebruikt voor de werking van medische apparaten, de analyse van patiëntgegevens voor kritieke gezondheidsbeslissingen, farmaceutische productie of medisch onderzoek waarbij een storing of defect de gezondheid van de patiënt kan beïnvloeden.
  • Verwerking van chemische en/of gevaarlijke stoffen: deze software is niet bedoeld voor het beheer, de controle of de operationele aspecten van chemische fabrieken of faciliteiten voor de verwerking van chemische en/of gevaarlijke stoffen. Elke storing in de software die in deze omgevingen wordt gebruikt kan leiden tot gevaarlijke chemische lozingen, explosies of milieurampen.
  • Transport- en verkeerscontrolesystemen: de software mag niet worden gebruikt voor de besturing, bediening of het beheer van transportsystemen, waaronder de besturing van spoorwegsignalen, metrosystemen of verkeerslichten. Storingen in dergelijke kritieke systemen kunnen tot ernstige ongelukken leiden en de openbare veiligheid in gevaar brengen.
  • Energienetwerk- en nutsbesturingssystemen: deze software is niet ontworpen voor de besturing of bediening van energienetwerksystemen, waaronder elektrische onderstations, besturingssystemen voor hernieuwbare energie of besturingssystemen van waternutsbedrijven. Het falen van software op deze gebieden kan leiden tot aanzienlijke stroomonderbrekingen, onderbrekingen in de watervoorziening of andere storingen in openbare voorzieningen, waardoor gemeenschappen in gevaar kunnen komen en grote schade kan worden aangericht.
  • Andere omgevingen met een hoog risico: alle andere kritieke infrastructuren en omgevingen waar een storing in de software kan leiden tot aanzienlijke schade aan personen of het milieu.

Gebruikersverantwoordelijkheid: gebruikers moeten ervoor zorgen dat ze het beoogde gebruik van de software begrijpen en de software niet gebruiken in een omgeving die buiten het beoogde doel valt. Het is de verantwoordelijkheid van de gebruiker om de geschiktheid van de software voor de beoogde toepassing te beoordelen, vooral in scenario's die een risico kunnen vormen voor leven, gezondheid en/of milieu.

Afwijzing van aansprakelijkheid: Invantive wijst elke verantwoordelijkheid af voor schade, letsel of wettelijke gevolgen die voortvloeien uit het gebruik of misbruik van deze software in verboden en/of onbedoelde toepassingen.
  
Disclaimer