Please enable JavaScript to view this site.

Navigation: Schema: CompanyInfo > Tables

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