CompanyInfo Data Model
belgianBusinessGetDossier |
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: belgianBusinessGetDossier
Base XPath: /s:Envelope/s:Body/tns:belgianBusinessGetDossierResponse/tns:out
Filters on API Server: vat_number
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function belgianBusinessGetDossier. 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 |
|---|---|---|---|---|
vat_number |
string |
☐ |
|
|
Table Function Columns
The columns of the table function belgianBusinessGetDossier are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_ACCOUNT_DATE_DAY |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_ACCOUNT_DATE_MONTH |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_ACCOUNT_DATE_YEAR |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_BALANCE_TYPE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_CURRENT_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_CURRENT_RATIO |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_EQUITY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_ACCRUED_CHARGES_DEFERRED_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_ACCUMULATED_PROFITS_LOSSES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_ADVANCE_PAYMENTS_PURCHASES_STOCKS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_PAYABLE_MORE_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_PAYABLE_WITHIN_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_PAYABLE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_RECEIVABLE_MORE_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_RECEIVABLE_WITHIN_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_WRITTEN_DOWN_CURRENT_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_WRITTEN_DOWN_FINANCIAL_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_AMOUNTS_WRITTEN_DOWN_STOCKS_CONTRACTS_PROGRESS_TRADE_DEBTORS_APPROPRIATIONS_WRITE_BACKS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CAPITAL_SUBSIDIES_GRANTED_PUBLIC_AUTHORITIES_RECORDED_INCOME_PERIOD |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CAPITAL |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CASH_BANK_HAND |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CHARGES_DISCOUNTING_AMOUNTS_RECEIVABLE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CONTRACTS_PROGRESS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CONTRIBUTIONS_GIFTS_LEGACIES_GRANTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CURRENT_INVESTMENTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CURRENT_PORTION_AMOUNTS_PAYABLE_MORE_ONE_YEAR_FALLING_DUE_WITHIN_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_CURRENTS_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_DEBT_CHARGES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_DEFERRED_CHARGES_ACCRUED_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_DEPRECIATION_LOAN_ISSUE_EXPENSES_REIMBURSEMENT_PREMIUMS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_DEPRECIATION_OTHER_AMOUNTS_WRITTEN_DOWN_FORMATION_EXPENSES_INTANGIBLE_TANGIBLE_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EMPLOYEES_RECORDED_PERSONNEL_REGISTER_AVERAGE_NUMBER_EMPLOYEES_CALCULATED_FULL_TIME_EQUIVALENTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EMPLOYEES_RECORDED_PERSONNEL_REGISTER_TOTAL_NUMBER_CLOSING_DATE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EQUITY_LIABILITIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EQUITY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EXTRAORDINARY_CHARGES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EXTRAORDINARY_DEPRECIATION_EXTRAORDINARY_AMOUNTS_WRITTEN_DOWN |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_EXTRAORDINARY_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FINANCIAL_CHARGES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FINANCIAL_DEBTS_PAYABLE_WITHIN_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FINANCIAL_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FINANCIAL_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FORMATION_EXPENSES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FURNITURE_VEHICLES_ACQUISITION_INCLUDING_PRODUCED_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FURNITURE_VEHICLES_DEPRECIATIONS_AMOUNT_WRITTEN_DOWN_ACQUIRED_THIRD_PARTY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_FURNITURE_VEHICLES_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_GAIN_LOSS_PERIOD |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_GROSS_OPERATING_MARGIN |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_HIRED_TEMPORARY_STAFF_COSTS_ENTERPRISE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_INCOME_TAXES_RESULT_PERIOD |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_INCOME_TAXES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_INCREASE_DECREASE_STOCKS_WORK_CONTRACTS_PROGRESS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_INTANGIBLE_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_INTEREST_SUBSIDIES_GRANTED_PUBLIC_AUTHORITIES_RECORDED_INCOME_PERIOD |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_INVESTMENTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LAND_BUILDINGS_ACQUISITION_INCLUDING_PRODUCED_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LAND_BUILDINGS_DEPRECIATIONS_AMOUNT_WRITTEN_DOWN_ACQUIRED_THIRD_PARTY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LAND_BUILDINGS_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LEASING_OTHER_SIMILAR_RIGHTS_ACQUISITION_INCLUDING_PRODUCED_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LEASING_OTHER_SIMILAR_RIGHTS_DEPRECIATIONS_AMOUNT_WRITTEN_DOWN_ACQUIRED_THIRD_PARTY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LEASING_OTHER_SIMILAR_RIGHTS_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_LOSSES_DISPOSAL_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_EMPLOYEES_PERSONNEL_REGISTER_CLOSING_DATE_FINANCIAL_YEAR_MEN_FULL_TIME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_EMPLOYEES_PERSONNEL_REGISTER_CLOSING_DATE_FINANCIAL_YEAR_MEN_PART_TIME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_EMPLOYEES_PERSONNEL_REGISTER_CLOSING_DATE_FINANCIAL_YEAR_WOMEN_FULL_TIME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_EMPLOYEES_PERSONNEL_REGISTER_CLOSING_DATE_FINANCIAL_YEAR_WOMEN_PART_TIME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_OF_EMPLOYEES_MEN |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_OF_EMPLOYEES_WOMEN |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_NUMBER_OF_EMPLOYEES |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OPERATING_CHARGES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OPERATING_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OPERATING_PROFIT_LOSS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OPERATING_SUBSIDIES_COMPENSATORY_AMOUNTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OTHER_OPERATING_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OTHER_TANGIBLE_FIXED_ASSETS_ACQUISITION_INCLUDING_PRODUCED_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OTHER_TANGIBLE_FIXED_ASSETS_DEPRECIATIONS_AMOUNT_WRITTEN_DOWN_ACQUIRED_THIRD_PARTY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OTHER_TANGIBLE_FIXED_ASSETS_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OUTSTANDING_TAXES_PAYABLE_DUE_TAX_AUTHORITIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_OWN_CONSTRUCTION_CAPITALISED |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PERSONAL_GUARANTEES_PROVIDED_OR_IRREVOCABLY_PROMISED_BY_ENTERPRISE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PERSONS_PLACED_ENTERPRISES_DISPOSAL_COSTS_ENTERPRISE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PLANT_MACHINERY_EQUIPMENT_ACQUISITION_INCLUDING_PRODUCED_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PLANT_MACHINERY_EQUIPMENT_DEPRECIATIONS_AMOUNT_WRITTEN_DOWN_ACQUIRED_THIRD_PARTY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PLANT_MACHINERY_EQUIPMENT_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PROVISIONS_DEFERRED_TAXES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PROVISIONS_EXTRAORDINARY_LIABILITIES_CHARGES_APPROPRIATIONS_USES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PROVISIONS_FINANCIAL_NATURE_APPROPRIATIONS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PROVISIONS_FINANCIAL_NATURE_USES_WRITE_BACKS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PROVISIONS_PENSIONS_SIMILAR_OBLIGATIONS_APPROPRIATIONS_WRITE_BACKS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PROVISIONS_RISKS_CHARGES_APPROPRIATIONS_WRITE_BACKS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_PURCHASES_RAW_MATERIALS_CONSUMABLES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_RAW_MATERIALS_CONSUMABLES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_REMUNERATION_SOCIAL_SECURITY_PENSIONS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_REMUNERATION_SOCIAL_SECURITY_RECIPIENT_NATIONAL_SOCIAL_SECURITY_OFFICE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_RESERVES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_SERVICES_OTHER_GOODS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_STOCK_FINISHED_GOODS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_STOCK_GOODS_PURCHASED_RESALE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_STOCK_IMMOVABLE_PROPERTY_INTENDED_SALE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_STOCK_RAW_MATERIALS_CONSUMABLES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_STOCK_WORK_PROGRESS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_STOCKS_CONTRACTS_PROGRESS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS_ACQUISITION_INCLUDING_PRODUCED_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS_DEPRECIATIONS_AMOUNT_WRITTEN_DOWN_ACQUIRED_THIRD_PARTY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS_UNDER_CONSTRUCTION_ADVANCE_PAYMENTS_DEPRECIATIONS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS_UNDER_CONSTRUCTION_ADVANCE_PAYMENTS_REVALUATION_GAINS_THIRD_PARTIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS_UNDER_CONSTRUCTION |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TANGIBLE_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TRADE_DEBTORS_WITHIN_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TRADE_DEBTS_PAYABLE_WITHIN_ONE_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TRANSFER_FROM_DEFERRED_TAXES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TRANSFER_TO_DEFERRED_TAXES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_TURNOVER |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_VALUE_ADDED_TAXES_CHARGED_BY_ENTERPRISE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_VALUE_ADDED_TAXES_CHARGED_TO_ENTERPRISE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_WRITE_BACK_AMOUNTS_WRITTEN_DOWN_FINANCIAL_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_WRITE_BACK_DEPRECIATION_AMOUNTS_WRITTEN_DOWN_INTANGIBLE_TANGIBLE_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_FINANCIAL_VALUES_WRITE_BACK_PROVISIONS_EXTRAORDINARY_LIABILITIES_CHARGES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_GAIN_LOSS_PERIOD |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_GROSS_OPERATING_MARGIN |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_ID |
string |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_NET_CASH |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_NUMBER_OF_EMPLOYEES |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_ADDED_VALUE_PER_EMPLOYEE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_ADDED_VALUE_TO_OPERATING_INCOME |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CASH_FLOW_TO_DEBT |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CASH_FLOW_TO_LONG_TERM_DEBT |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CASH_FLOW |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_CURRENT_RATIO |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_DEBT_REPAYMENT |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_DFL |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_FINANCIAL_CHARGES_TO_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_GROSS_OPERATING_SALES_MARGIN |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_IMMEDIATE_LIQUIDITY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_INVESTMENT_RATIO |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_INVESTMENTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_LONG_TERM_DEBT_TO_SHORT_TERM_DEBT |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NET_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NET_CASH_RATIO |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NET_CASH |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NET_CURRENT_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NET_OPERATING_SALES_MARGIN |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NET_PROFIT_TO_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NUMBER_DAYS_CUSTOMER_CREDIT |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_NUMBER_DAYS_SUPPLIER_CREDIT |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_OUTSTANDING_TAX_TO_LIABILITIES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_OWN_ASSETS_TO_CAPITAL |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_PAYROLL_COSTS_TO_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_QUICK_RATIO |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_RETURN_ON_EQUITY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_ROTATION_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_SELF_FINANCING_DEGREE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_TOTAL_ASSETS_TO_TURNOVER |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RATIOS_WRITE_DOWNS_TO_ADDED_VALUE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_RETURN_ON_EQUITY |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_REVISORS |
string |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SELF_FINANCING_DEGREE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_ADVANTAGES_ADDITION_WAGES |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_AVERAGE_NUMBER_OF_EMPLOYEES_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_DEFINITE_PERIOD_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_INDEFINITE_PERIOD_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_TERMINATION_DISMISSAL |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_TERMINATION_EARLY_RETIREMENT_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_TERMINATION_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_TERMINATION_OTHER_REASON |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_CONTRACT_TERMINATION_RETIREMENT_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_MANAGEMENT_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_MEN_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_NON_UNIVERSITY_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_OTHERS_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_PRIMARY_EDUCATION_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_SECONDARY_EDUCATION_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_UNIVERSITY_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_WOMEN_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR_WORKERS_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_END_OF_YEAR |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_NEW_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_EMPLOYEES_WORKED_HOURS |
int32 |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_HIRED_TEMPORARY_STAFF_COSTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_HIRED_TEMPORARY_STAFF_FTE |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_HIRED_TEMPORARY_STAFF_WORKED_HOURS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_PROFESSIONAL_TRAINING_HOURS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_SOCIAL_BALANCE_PROFESSIONAL_TRAINING_NET_COSTS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_TANGIBLE_FIXED_ASSETS |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_TURNOVER |
decimal |
|
|
|
ANNUAL_FINANCIAL_STATEMENTS_ITEM_YEAR |
int32 |
|
|
|
BANK_ACCOUNTS_ITEM_BIC |
string |
|
|
|
BANK_ACCOUNTS_ITEM_IBAN_VALID |
boolean |
|
|
|
BANK_ACCOUNTS_ITEM_IBAN |
string |
|
|
|
BANK_ACCOUNTS_ITEM_START_DATE_DAY |
int32 |
|
|
|
BANK_ACCOUNTS_ITEM_START_DATE_MONTH |
int32 |
|
|
|
BANK_ACCOUNTS_ITEM_START_DATE_YEAR |
int32 |
|
|
|
COMPANY_ACTIVITIES_ITEM_CODE |
string |
|
|
|
COMPANY_ACTIVITIES_ITEM_END_DATE_DAY |
int32 |
|
|
|
COMPANY_ACTIVITIES_ITEM_END_DATE_MONTH |
int32 |
|
|
|
COMPANY_ACTIVITIES_ITEM_END_DATE_YEAR |
int32 |
|
|
|
COMPANY_ACTIVITIES_ITEM_LABEL |
string |
|
|
|
COMPANY_ACTIVITIES_ITEM_START_DATE_DAY |
int32 |
|
|
|
COMPANY_ACTIVITIES_ITEM_START_DATE_MONTH |
int32 |
|
|
|
COMPANY_ACTIVITIES_ITEM_START_DATE_YEAR |
int32 |
|
|
|
COMPANY_ADDRESSES_ITEM_BOX |
string |
|
|
|
COMPANY_ADDRESSES_ITEM_COUNTRY_CODE |
string |
|
|
|
COMPANY_ADDRESSES_ITEM_HOUSE_NUMBER |
int32 |
|
|
|
COMPANY_ADDRESSES_ITEM_MUNICIPALITY |
string |
|
|
|
COMPANY_ADDRESSES_ITEM_POST_CODE |
string |
|
|
|
COMPANY_ADDRESSES_ITEM_STREET |
string |
|
|
|
COMPANY_ESTABLISHMENT_UNITS |
int32 |
|
|
|
COMPANY_JURIDICAL_FORM_CODE |
string |
|
|
|
COMPANY_JURIDICAL_FORM_END_DATE_DAY |
int32 |
|
|
|
COMPANY_JURIDICAL_FORM_END_DATE_MONTH |
int32 |
|
|
|
COMPANY_JURIDICAL_FORM_END_DATE_YEAR |
int32 |
|
|
|
COMPANY_JURIDICAL_FORM_LABEL |
string |
|
|
|
COMPANY_JURIDICAL_FORM_START_DATE_DAY |
int32 |
|
|
|
COMPANY_JURIDICAL_FORM_START_DATE_MONTH |
int32 |
|
|
|
COMPANY_JURIDICAL_FORM_START_DATE_YEAR |
int32 |
|
|
|
COMPANY_JURIDICAL_SITUATION_CODE |
string |
|
|
|
COMPANY_JURIDICAL_SITUATION_END_DATE_DAY |
int32 |
|
|
|
COMPANY_JURIDICAL_SITUATION_END_DATE_MONTH |
int32 |
|
|
|
COMPANY_JURIDICAL_SITUATION_END_DATE_YEAR |
int32 |
|
|
|
COMPANY_JURIDICAL_SITUATION_LABEL |
string |
|
|
|
COMPANY_JURIDICAL_SITUATION_START_DATE_DAY |
int32 |
|
|
|
COMPANY_JURIDICAL_SITUATION_START_DATE_MONTH |
int32 |
|
|
|
COMPANY_JURIDICAL_SITUATION_START_DATE_YEAR |
int32 |
|
|
|
COMPANY_LEGAL_REPRESENTATIVE_COMPANIES_COUNT |
string |
|
|
|
COMPANY_LEGAL_REPRESENTATIVES_COUNT |
string |
|
|
|
COMPANY_NAME |
string |
|
|
|
COMPANY_PHONE_NUMBER |
string |
|
|
|
COMPANY_START_DATE_DAY |
int32 |
|
|
|
COMPANY_START_DATE_MONTH |
int32 |
|
|
|
COMPANY_START_DATE_YEAR |
int32 |
|
|
|
COMPANY_TYPE_CODE |
string |
Company Type Code |
|
|
COMPANY_TYPE_END_DATE_DAY |
int32 |
|
|
|
COMPANY_TYPE_END_DATE_MONTH |
int32 |
|
|
|
COMPANY_TYPE_END_DATE_YEAR |
int32 |
|
|
|
COMPANY_TYPE_LABEL |
string |
|
|
|
COMPANY_TYPE_START_DATE_DAY |
int32 |
|
|
|
COMPANY_TYPE_START_DATE_MONTH |
int32 |
|
|
|
COMPANY_TYPE_START_DATE_YEAR |
int32 |
|
|
|
COMPANY_VAT_NUMBER |
string |
|
|
|
COMPANY_WEBSITE |
string |
|
|
|
ERRORS_ANNUAL_FINANCIAL_STATEMENTS_ERROR |
string |
|
|
|
ERRORS_BANK_ACCOUNTS_ERROR |
string |
|
|
|
ERRORS_LEGAL_REPRESENTATIVE_COMPANIES_ERROR |
string |
|
|
|
ERRORS_LEGAL_REPRESENTATIVES_ERROR |
string |
|
|
|
ERRORS_STAKEHOLDERS_ERROR |
string |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_NAME |
string |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_CODE |
string |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_END_DATE_DAY |
int32 |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_END_DATE_MONTH |
int32 |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_END_DATE_YEAR |
int32 |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_LABEL |
string |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_START_DATE_DAY |
int32 |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_START_DATE_MONTH |
int32 |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_ROLE_START_DATE_YEAR |
int32 |
|
|
|
LEGAL_REPRESENTATIVE_COMPANIES_ITEM_VAT_NUMBER |
string |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_COMPANY_VAT_NUMBER |
string |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_FIRST_NAME |
string |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_LAST_NAME |
string |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_CODE |
string |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_END_DATE_DAY |
int32 |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_END_DATE_MONTH |
int32 |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_END_DATE_YEAR |
int32 |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_LABEL |
string |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_START_DATE_DAY |
int32 |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_START_DATE_MONTH |
int32 |
|
|
|
LEGAL_REPRESENTATIVES_ITEM_ROLE_START_DATE_YEAR |
int32 |
|
|
|
STAKEHOLDERS_ITEM_ADDRESS_BOX |
string |
|
|
|
STAKEHOLDERS_ITEM_ADDRESS_COUNTRY_CODE |
string |
|
|
|
STAKEHOLDERS_ITEM_ADDRESS_HOUSE_NUMBER |
int32 |
|
|
|
STAKEHOLDERS_ITEM_ADDRESS_MUNICIPALITY |
string |
|
|
|
STAKEHOLDERS_ITEM_ADDRESS_POST_CODE |
string |
|
|
|
STAKEHOLDERS_ITEM_ADDRESS_STREET |
string |
|
|
|
STAKEHOLDERS_ITEM_COMPANY_NAME |
string |
|
|
|
STAKEHOLDERS_ITEM_FIRST_NAME |
string |
|
|
|
STAKEHOLDERS_ITEM_ID |
string |
|
|
|
STAKEHOLDERS_ITEM_LAST_NAME |
string |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_CODE |
string |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_END_DATE_DAY |
int32 |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_END_DATE_MONTH |
int32 |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_END_DATE_YEAR |
int32 |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_LABEL |
string |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_START_DATE_DAY |
int32 |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_START_DATE_MONTH |
int32 |
|
|
|
STAKEHOLDERS_ITEM_MANDATE_START_DATE_YEAR |
int32 |
|
|
|
STAKEHOLDERS_ITEM_PROFESSION |
string |
|
|
|
STAKEHOLDERS_ITEM_SOURCE_DATE_DAY |
int32 |
|
|
|
STAKEHOLDERS_ITEM_SOURCE_DATE_MONTH |
int32 |
|
|
|
STAKEHOLDERS_ITEM_SOURCE_DATE_YEAR |
int32 |
|
|
|
STAKEHOLDERS_ITEM_TYPE |
string |
|
|
|
15-06-2022 23:19 Version 22.1.46-BETA+3385
