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 |
Default Value |
Documentation |
---|---|---|---|---|
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 |
Required |
Documentation |
---|---|---|---|---|
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