CashFlowStatement

class zvt.domain.fundamental.finance.CashFlowStatement(**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_from_selling

销售商品、提供劳务收到的现金

tax_refund

收到的税费返还

cash_from_other_op

收到其他与经营活动有关的现金

total_op_cash_inflows

经营活动现金流入小计

cash_to_goods_services

购买商品、接受劳务支付的现金

cash_to_employees

支付给职工以及为职工支付的现金

taxes_and_surcharges

支付的各项税费

支付其他与经营活动有关的现金

total_op_cash_outflows

经营活动现金流出小计

net_op_cash_flows

经营活动产生的现金流量净额

cash_from_disposal_of_investments

收回投资收到的现金

cash_from_returns_on_investments

取得投资收益收到的现金

cash_from_disposal_fixed_intangible_assets

处置固定资产、无形资产和其他长期资产收回的现金净额

cash_from_disposal_subsidiaries

处置子公司及其他营业单位收到的现金净额

cash_from_other_investing

收到其他与投资活动有关的现金

total_investing_cash_inflows

投资活动现金流入小计

cash_to_acquire_fixed_intangible_assets

购建固定资产、无形资产和其他长期资产支付的现金

cash_to_investments

投资支付的现金

cash_to_acquire_subsidiaries

取得子公司及其他营业单位支付的现金净额

cash_to_other_investing

支付其他与投资活动有关的现金

total_investing_cash_outflows

投资活动现金流出小计

net_investing_cash_flows

投资活动产生的现金流量净额

cash_from_accepting_investment

吸收投资收到的现金

cash_from_subsidiaries_accepting_minority_interest

子公司吸收少数股东投资收到的现金

cash_from_borrowings

取得借款收到的现金

cash_from_issuing_bonds

发行债券收到的现金

cash_from_other_financing

收到其他与筹资活动有关的现金

total_financing_cash_inflows

筹资活动现金流入小计

cash_to_repay_borrowings

偿还债务支付的现金

cash_to_pay_interest_dividend

分配股利、利润或偿付利息支付的现金

cash_to_pay_subsidiaries_minority_interest

子公司支付给少数股东的股利、利润

cash_to_other_financing

支付其他与筹资活动有关的现金

total_financing_cash_outflows

筹资活动现金流出小计

net_financing_cash_flows

筹资活动产生的现金流量净额

foreign_exchange_rate_effect

汇率变动对现金及现金等价物的影响

net_cash_increase

现金及现金等价物净增加额

cash_at_beginning

加: 期初现金及现金等价物余额

cash

期末现金及现金等价物余额

fi_deposit_increase

银行相关 客户存款和同业及其他金融机构存放款项净增加额

fi_borrow_from_central_bank_increase

向中央银行借款净增加额

fi_deposit_in_others_decrease

存放中央银行和同业款项及其他金融机构净减少额

fi_borrowing_and_sell_repurchase_increase

拆入资金及卖出回购金融资产款净增加额

fi_sell_repurchase_increase

其中:卖出回购金融资产款净增加额

fi_lending_and_buy_repurchase_decrease

拆出资金及买入返售金融资产净减少额

fi_buy_repurchase_decrease

买入返售金融资产净减少额

fi_cash_from_interest_commission

收取的利息、手续费及佣金的现金

fi_loan_advance_increase

客户贷款及垫款净增加额

fi_deposit_in_others_increase

存放中央银行和同业及其他金融机构款项净增加额

fi_lending_and_buy_repurchase_increase

拆出资金及买入返售金融资产净增加额

fi_lending_increase

其中:拆出资金净增加额

fi_borrowing_and_sell_repurchase_decrease

拆入资金及卖出回购金融资产款净减少额

fi_borrowing_decrease

其中:拆入资金净减少额

fi_sell_repurchase_decrease

卖出回购金融资产净减少额

fi_cash_to_interest_commission

支付利息、手续费及佣金的现金

fi_account_receivable_increase

应收账款净增加额

fi_cash_to_pay_interest

偿付债券利息支付的现金

fi_cash_from_premium_of_original

保险相关 收到原保险合同保费取得的现金

fi_insured_deposit_increase

保户储金及投资款净增加额

fi_bank_broker_sell_repurchase_increase

银行及证券业务卖出回购资金净增加额

fi_bank_broker_buy_repurchase_decrease

银行及证券业务买入返售资金净减少额

fi_cash_to_insurance_claim

支付原保险合同赔付等款项的现金

fi_cash_to_reinsurance

支付再保险业务现金净额

fi_lending_decrease

银行业务及证券业务拆借资金净减少额

fi_bank_broker_sell_repurchase_decrease

银行业务及证券业务卖出回购资金净减少额

fi_cash_to_dividends

支付保单红利的现金

fi_insured_pledge_loans_increase

保户质押贷款净增加额

fi_cash_to_acquire_subsidiaries

收购子公司及其他营业单位支付的现金净额

fi_cash_to_disposal_subsidiaries

处置子公司及其他营业单位流出的现金净额

fi_cash_to_sell_repurchase

支付卖出回购金融资产款现金净额

fi_borrowing_increase

券商相关 拆入资金净增加额

fi_cash_from_trading_agent

代理买卖证券收到的现金净额

fi_cash_from_repurchase_increase

回购业务资金净增加额

fi_disposal_trade_asset_decrease

处置交易性金融资产的净减少额

fi_repurchase_decrease

回购业务资金净减少额

fi_cash_to_agent_trade

代理买卖证券支付的现金净额(净减少额)

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[pandas._libs.tslibs.timestamps.Timestamp, str]] = None, end_timestamp: Optional[Union[pandas._libs.tslibs.timestamps.Timestamp, str]] = 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
  • entity_id

  • 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’