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