财务分析(营运能力) (cn_stock_financial_operating)
数据描述: 该表记录了中国股票市场上各上市公司的营运能力相关的财务指标。它详细列出了与公司资产管理和使用效率相关的各种周转率和周转天数,如存货周转率、应收账款周转率、应付账款周转天数、营业周期等,覆盖了最新一期、单季度以及滚动十二期的数据。数据非日频,按照财报的发布进行更新。
文档
用例
表结构
字段 | 字段类型 | 字段描述 |
fix_assets_turnover_mrq | DOUBLE | 固定资产周转率(单季度) |
fix_assets_turnover_ttm | DOUBLE | 固定资产周转率(滚动十二期) |
net_assets_turnover_mrq | DOUBLE | 净资产周转率(单季度) |
net_assets_turnover_ttm | DOUBLE | 净资产周转率(滚动十二期) |
net_operating_cycle_mrq | DOUBLE | 净营业周期(单季度) |
net_operating_cycle_ttm | DOUBLE | 净营业周期(滚动十二期) |
net_assets_turnover_days_mrq | DOUBLE | 净资产周转天数(单季度) |
net_assets_turnover_days_ttm | DOUBLE | 净资产周转天数(滚动十二期) |
accounts_receivable_turnover_days_mrq | DOUBLE | 应收账款周转天数(单季度) |
accounts_receivable_turnover_days_ttm | DOUBLE | 应收账款周转天数(滚动十二期) |
working_capital_turnover_mrq | DOUBLE | 营运资本周转率(单季度) |
working_capital_turnover_ttm | DOUBLE | 营运资本周转率(滚动十二期) |
accounts_payable_turnover_mrq | DOUBLE | 应付账款周转率(单季度) |
accounts_payable_turnover_ttm | DOUBLE | 应付账款周转率(滚动十二期) |
instrument | VARCHAR | 证券代码 |
advances_and_contract_liab_turnover_mrq | DOUBLE | 预收款项及合同负债周转率(单季度) |
advances_and_contract_liab_turnover_ttm | DOUBLE | 预收款项及合同负债周转率(滚动十二期) |
notes_and_accounts_payable_turnover_mrq | DOUBLE | 应付票据及应付账款周转率(单季度) |
notes_and_accounts_payable_turnover_ttm | DOUBLE | 应付票据及应付账款周转率(滚动十二期) |
working_capital_turnover_days_mrq | DOUBLE | 营运资本周转天数(单季度) |
working_capital_turnover_days_ttm | DOUBLE | 营运资本周转天数(滚动十二期) |
accounts_payable_turnover_days_mrq | DOUBLE | 应付账款周转天数(单季度) |
accounts_payable_turnover_days_ttm | DOUBLE | 应付账款周转天数(滚动十二期) |
fix_assets_turnover_lf | DOUBLE | 固定资产周转率(最新一期) |
net_assets_turnover_lf | DOUBLE | 净资产周转率(最新一期) |
net_operating_cycle_lf | DOUBLE | 净营业周期(最新一期) |
intangible_assets_turnover_mrq | DOUBLE | 无形资产周转率(单季度) |
intangible_assets_turnover_ttm | DOUBLE | 无形资产周转率(滚动十二期) |
inventory_turnover_days_lf | DOUBLE | 存货周转天数(最新一期) |
total_assets_turnover_days_mrq | DOUBLE | 总资产周转天数(单季度) |
total_assets_turnover_days_ttm | DOUBLE | 总资产周转天数(滚动十二期) |
net_assets_turnover_days_lf | DOUBLE | 净资产周转天数(最新一期) |
working_capital_turnover_lf | DOUBLE | 营运资本周转率(最新一期) |
accounts_payable_turnover_lf | DOUBLE | 应付账款周转率(最新一期) |
intangible_assets_turnover_lf | DOUBLE | 无形资产周转率(最新一期) |
total_assets_turnover_days_lf | DOUBLE | 总资产周转天数(最新一期) |
accounts_receivable_turnover_lf | DOUBLE | 应收账款周转率(最新一期) |
current_assets_turnover_days_lf | DOUBLE | 流动资产周转天数(最新一期) |
noncurr_assets_turnover_days_lf | DOUBLE | 非流动资产周转天数(最新一期) |
working_capital_turnover_days_lf | DOUBLE | 营运资本周转天数(最新一期) |
accounts_payable_turnover_days_lf | DOUBLE | 应付账款周转天数(最新一期) |
intangible_assets_turnover_days_lf | DOUBLE | 无形资产周转天数(最新一期) |
accounts_receivable_turnover_mrq | DOUBLE | 应收账款周转率(单季度) |
accounts_receivable_turnover_ttm | DOUBLE | 应收账款周转率(滚动十二期) |
notes_and_accounts_payable_turnover_lf | DOUBLE | 应付票据及应付账款周转率(最新一期) |
notes_and_accounts_receivable_turnover_lf | DOUBLE | 应收票据及应收账款周转率(最新一期) |
advances_and_contract_liab_turnover_days_lf | DOUBLE | 预收款项及合同负债周转天数(最新一期) |
notes_and_accounts_payable_turnover_days_lf | DOUBLE | 应付票据及应付账款周转天数(最新一期) |
notes_and_accounts_receivable_turnover_days_lf | DOUBLE | 应收票据及应收账款周转天数(最新一期) |
accounts_receivable_contract_assets_turnover_lf | DOUBLE | 应收账款及合同资产周转率(最新一期) |
accounts_receivable_contract_assets_turnover_days_lf | DOUBLE | 应收账款及合同资产周转天数(最新一期) |
notes_and_accounts_receivable_turnover_mrq | DOUBLE | 应收票据及应收账款周转率(单季度) |
notes_and_accounts_receivable_turnover_ttm | DOUBLE | 应收票据及应收账款周转率(滚动十二期) |
date | TIMESTAMP_NS | - |
advances_and_contract_liab_turnover_days_mrq | DOUBLE | 预收款项及合同负债周转天数(单季度) |
advances_and_contract_liab_turnover_days_ttm | DOUBLE | 预收款项及合同负债周转天数(滚动十二期) |
notes_and_accounts_payable_turnover_days_mrq | DOUBLE | 应付票据及应付账款周转天数(单季度) |
notes_and_accounts_payable_turnover_days_ttm | DOUBLE | 应付票据及应付账款周转天数(滚动十二期) |
inventory_turnover_mrq | DOUBLE | 存货周转率(单季度) |
inventory_turnover_ttm | DOUBLE | 存货周转率(滚动十二期) |
notes_and_accounts_receivable_turnover_days_ttm | DOUBLE | 应收票据及应收账款周转天数(滚动十二期) |
current_assets_turnover_mrq | DOUBLE | 流动资产周转率(单季度) |
current_assets_turnover_ttm | DOUBLE | 流动资产周转率(滚动十二期) |
accounts_receivable_contract_assets_turnover_ttm | DOUBLE | 应收账款及合同资产周转率(滚动十二期) |
accounts_receivable_contract_assets_turnover_days_mrq | DOUBLE | 应收账款及合同资产周转天数(单季度) |
accounts_receivable_contract_assets_turnover_days_ttm | DOUBLE | 应收账款及合同资产周转天数(滚动十二期) |
accounts_receivable_contract_assets_turnover_mrq | DOUBLE | 应收账款及合同资产周转率(单季度) |
notes_and_accounts_receivable_turnover_days_mrq | DOUBLE | 应收票据及应收账款周转天数(单季度) |
current_assets_turnover_days_mrq | DOUBLE | 流动资产周转天数(单季度) |
current_assets_turnover_days_ttm | DOUBLE | 流动资产周转天数(滚动十二期) |
total_assets_turnover_mrq | DOUBLE | 总资产周转率(单季度) |
total_assets_turnover_ttm | DOUBLE | 总资产周转率(滚动十二期) |
noncurr_assets_turnover_mrq | DOUBLE | 非流动资产周转率(单季度) |
noncurr_assets_turnover_ttm | DOUBLE | 非流动资产周转率(滚动十二期) |
noncurr_assets_turnover_days_mrq | DOUBLE | 非流动资产周转天数(单季度) |
noncurr_assets_turnover_days_ttm | DOUBLE | 非流动资产周转天数(滚动十二期) |
advances_and_contract_liab_turnover_lf | DOUBLE | 预收款项及合同负债周转率(最新一期) |
accounts_receivable_turnover_days_lf | DOUBLE | 应收账款周转天数(最新一期) |
intangible_assets_turnover_days_ttm | DOUBLE | 无形资产周转天数(滚动十二期) |
intangible_assets_turnover_days_mrq | DOUBLE | 无形资产周转天数(单季度) |
fix_assets_turnover_days_lf | DOUBLE | 固定资产周转天数(最新一期) |
noncurr_assets_turnover_lf | DOUBLE | 非流动资产周转率(最新一期) |
current_assets_turnover_lf | DOUBLE | 流动资产周转率(最新一期) |
total_assets_turnover_lf | DOUBLE | 总资产周转率(最新一期) |
inventory_turnover_lf | DOUBLE | 存货周转率(最新一期) |
shift | TINYINT | 偏移报告期 |
inventory_turnover_days_ttm | DOUBLE | 存货周转天数(滚动十二期) |
inventory_turnover_days_mrq | DOUBLE | 存货周转天数(单季度) |
fix_assets_turnover_days_mrq | DOUBLE | 固定资产周转天数(单季度) |
operating_cycle_ttm | DOUBLE | 营业周期(滚动十二期) |
operating_cycle_mrq | DOUBLE | 营业周期(单季度) |
operating_cycle_lf | DOUBLE | 营业周期(最新一期) |
report_date | TIMESTAMP_NS | 报告期 |
fix_assets_turnover_days_ttm | DOUBLE | 固定资产周转天数(滚动十二期) |
表名cn_stock_financial_operating
起始时间:
最近更新时间: