BalanceSheet

class zvt.domain.fundamental.finance.BalanceSheet(**kwargs)

Bases: sqlalchemy.orm.decl_api.Base, zvt.contract.schema.Mixin

__init__(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

cash_and_cash_equivalents

货币资金

note_receivable

应收票据

accounts_receivable

应收账款

advances_to_suppliers

预付款项

other_receivables

其他应收款

inventories

存货

current_portion_of_non_current_assets

一年内到期的非流动资产

other_current_assets

其他流动资产

total_current_assets

流动资产合计

fi_assets_saleable

可供出售金融资产

long_term_receivables

长期应收款

long_term_equity_investment

长期股权投资

real_estate_investment

投资性房地产

fixed_assets

固定资产

construction_in_process

在建工程

intangible_assets

无形资产

goodwill

商誉

long_term_prepaid_expenses

长期待摊费用

deferred_tax_assets

递延所得税资产

other_non_current_assets

其他非流动资产

total_non_current_assets

非流动资产合计

total_assets

资产总计

short_term_borrowing

短期借款

accept_money_deposits

吸收存款及同业存放

accounts_payable

应付账款

advances_from_customers

预收款项

employee_benefits_payable

应付职工薪酬

taxes_payable

应交税费

interest_payable

应付利息

other_payable

其他应付款

current_portion_of_non_current_liabilities

一年内到期的非流动负债

other_current_liabilities

其他流动负债

total_current_liabilities

流动负债合计

long_term_borrowing

长期借款

long_term_payable

长期应付款

deferred_revenue

递延收益

deferred_tax_liabilities

递延所得税负债

other_non_current_liabilities

其他非流动负债

total_non_current_liabilities

非流动负债合计

total_liabilities

负债合计

capital

实收资本（或股本）

capital_reserve

资本公积

special_reserve

专项储备

surplus_reserve

盈余公积

undistributed_profits

未分配利润

equity

归属于母公司股东权益合计

equity_as_minority_interest

少数股东权益

total_equity

股东权益合计

total_liabilities_and_equity

负债和股东权益合计

fi_cash_and_deposit_in_central_bank

银行相关 资产 现金及存放中央银行款项

fi_deposit_in_other_fi

存放同业款项

fi_expensive_metals

贵金属

fi_lending_to_other_fi

拆出资金

fi_financial_assets_effect_current_income

以公允价值计量且其变动计入当期损益的金融资产

fi_financial_derivative_asset

衍生金融资产

fi_buying_sell_back_fi__asset

买入返售金融资产

fi_interest_receivable

应收利息

fi_disbursing_loans_and_advances

发放贷款及垫款

fi_held_to_maturity_investment

持有至到期投资

fi_account_receivable_investment

应收款项类投资

fi_other_asset

其他资产

fi_borrowings_from_central_bank

向中央银行借款

fi_deposit_from_other_fi

同业和其他金融机构存放款项

fi_borrowings_from_fi

拆入资金

fi_financial_liability_effect_current_income

以公允价值计量且其变动计入当期损益的金融负债

fi_financial_derivative_liability

衍生金融负债

fi_sell_buy_back_fi_asset

卖出回购金融资产款

fi_savings_absorption

吸收存款

fi_notes_payable

存款证及应付票据

fi_estimated_liabilities

预计负债

fi_bond_payable

应付债券

fi_other_liability

其他负债

fi_capital

所有者权益(或股东权益) 股本

fi_other_equity_instruments

其他权益工具

fi_preferred_stock

其中:优先股

fi_generic_risk_reserve

一般风险准备

fi_client_fund

其中: 客户资金存款

fi_deposit_reservation_for_balance

结算备付金

fi_client_deposit_reservation_for_balance

其中: 客户备付金

fi_margin_out_fund

融出资金

fi_receivables

应收款项

fi_deposit_for_recognizance

存出保证金

fi_receiving_as_agent

代理买卖证券款

fi_short_financing_payable

应付短期融资款

fi_trade_risk_reserve

交易风险准备

fi_premiums_receivable

资产 应收保费

fi_reinsurance_premium_receivable

应收分保账款

fi_reinsurance_contract_reserve

应收分保合同准备金

fi_policy_pledge_loans

保户质押贷款

fi_time_deposit

发放贷款及垫款 定期存款

fi_deposit_for_capital_recognizance

存出资本保证金

fi_capital_in_independent_accounts

独立账户资产

fi_advance_from_customers

预收账款

fi_advance_premium

预收保费

fi_fees_and_commissions_payable

应付手续费及佣金

fi_dividend_payable_for_reinsurance

应付分保账款

fi_claims_payable

应付赔付款

fi_policy_holder_dividend_payable

应付保单红利

fi_policy_holder_deposits_and_investment_funds

保户储金及投资款

fi_contract_reserve

保险合同准备金

fi_independent_liability

独立账户负债

entity_id

entity id

classmethod get_providers() → List[str]

providers of the schema defined by cls

Returns

providers

classmethod get_storages(provider: Optional[str] = None)

get the storages info

Parameters

provider – provider

Returns

storages

id

id

classmethod query_data(provider_index: int = 0, ids: Optional[List[str]] = None, entity_ids: Optional[List[str]] = None, entity_id: Optional[str] = None, codes: Optional[List[str]] = None, code: Optional[str] = None, level: Optional[Union[zvt.contract.IntervalLevel, str]] = None, provider: Optional[str] = None, columns: Optional[List] = None, col_label: Optional[dict] = None, return_type: str = 'df', start_timestamp: Optional[Union[str, pandas._libs.tslibs.timestamps.Timestamp]] = None, end_timestamp: Optional[Union[str, pandas._libs.tslibs.timestamps.Timestamp]] = None, filters: Optional[List] = None, session: Optional[sqlalchemy.orm.session.Session] = None, order=None, limit: Optional[int] = None, index: Optional[Union[str, list]] = None, drop_index_col=False, time_field: str = 'timestamp')

query data by the arguments

Parameters

• provider_index –

• data_schema –

• ids –

• entity_ids –

• entity_id –

• codes –

• code –

• level –

• provider –

• columns –

• col_label – dict with key(column), value(label)

• return_type – df, domain or dict. default is df

• start_timestamp –

• end_timestamp –

• filters –

• session –

• order –

• limit –

• index – index field name, str for single index, str list for multiple index

• drop_index_col – whether drop the col if it’s in index, default False

• time_field –

Returns

results basing on return_type.

classmethod record_data(provider_index: int = 0, provider: Optional[str] = None, force_update=None, sleeping_time=None, exchanges=None, entity_id=None, entity_ids=None, code=None, codes=None, real_time=None, fix_duplicate_way=None, start_timestamp=None, end_timestamp=None, one_day_trading_minutes=None, **kwargs)

record data by the arguments

Parameters

• provider_index –

• provider –

• force_update –

• sleeping_time –

• exchanges –

• entity_ids –

• code –

• codes –

• real_time –

• fix_duplicate_way –

• start_timestamp –

• end_timestamp –

• one_day_trading_minutes –

• kwargs –

Returns

classmethod register_provider(provider)

register the provider to the schema defined by cls

Parameters

provider –

classmethod register_recorder_cls(provider, recorder_cls)

register the recorder for the schema

Parameters

• provider –

• recorder_cls –

timestamp

the meaning could be different for different case,most time it means ‘happen time’