10. DataTables — Listed-company fundamental data

10.1. Listed-company financial statement data

qteasy provides listed-company financial statements (income, balance sheet, cash flow, etc.) sourced from Tushare at quarterly frequency.

Listed-company income statement: income

Table use: report, asset type: E, frequency: q

Income statement fields include total revenue, operating revenue/costs, taxes, selling/admin/financial expenses, impairment, operating/total profit, tax, net profit, etc.

	columns	dtypes	remarks	is_prime_key
0	ts_code	varchar(9)	Security code	Y
1	end_date	date	Reporting period	Y
2	ann_date	date	Announcement date	N
3	f_ann_date	date	Actual announcement date	N
4	report_type	varchar(6)	Report type — see table at bottom	N
5	comp_type	varchar(6)	Company type (1 general industry 2 bank 3 insurance 4 securities)	N
6	end_type	varchar(6)	Reporting period type	N
7	basic_eps	double	Basic EPS	N
8	diluted_eps	double	Diluted EPS	N
9	total_revenue	double	Total operating revenue	N
10	revenue	double	Operating revenue	N
11	int_income	double	Interest income	N
12	prem_earned	double	Earned premiums	N
13	comm_income	double	Fees and commission income	N
14	n_commis_income	double	Net fees and commission income	N
15	n_oth_income	double	Other operating net income	N
16	n_oth_b_income	double	Add: other operating net income	N
17	prem_income	double	Insurance business revenue	N
18	out_prem	double	Less: ceded premiums	N
19	une_prem_reser	double	Unearned premium reserve appropriation	N
20	reins_income	double	Including: ceded premium income	N
21	n_sec_tb_income	double	Net income from agency securities trading	N
22	n_sec_uw_income	double	Net income from securities underwriting	N
23	n_asset_mg_income	double	Net income from entrusted asset management	N
24	oth_b_income	double	Other operating revenue	N
25	fv_value_chg_gain	double	Add: net gain on fair value changes	N
26	invest_income	double	Add: net investment income	N
27	ass_invest_income	double	Including: investment income from associates and joint ventures	N
28	forex_gain	double	Add: net exchange gain	N
29	total_cogs	double	Total operating costs	N
30	oper_cost	double	Less: operating costs	N
31	int_exp	double	Less: interest expense	N
32	comm_exp	double	Less: fees and commission expense	N
33	biz_tax_surchg	double	Less: business taxes and surcharges	N
34	sell_exp	double	Less: selling expenses	N
35	admin_exp	double	Less: administrative expenses	N
36	fin_exp	double	Less: financial expenses	N
37	assets_impair_loss	double	Less: asset impairment losses	N
38	prem_refund	double	Surrender benefits paid	N
39	compens_payout	double	Total claim payments	N
40	reser_insur_liab	double	Insurance reserve appropriation	N
41	div_payt	double	Policyholder dividend payments	N
42	reins_exp	double	Reinsurance expenses	N
43	oper_exp	double	Operating expenses	N
44	compens_payout_refu	double	Less: reinsurance claims recovered	N
45	insur_reser_refu	double	Less: reinsurance reserve recovered	N
46	reins_cost_refund	double	Less: reinsurance expenses recovered	N
47	other_bus_cost	double	Other operating costs	N
48	operate_profit	double	Operating profit	N
49	non_oper_income	double	Add: non-operating income	N
50	non_oper_exp	double	Less: non-operating expenses	N
51	nca_disploss	double	Including: less: net loss on disposal of non-current assets	N
52	total_profit	double	Total profit	N
53	income_tax	double	Income tax expense	N
54	n_income	double	Net profit (incl. minority interests)	N
55	n_income_attr_p	double	Net profit (excl. minority interests)	N
56	minority_gain	double	Minority interests income	N
57	oth_compr_income	double	Other comprehensive income	N
58	t_compr_income	double	Total comprehensive income	N
59	compr_inc_attr_p	double	Total comprehensive income attributable to parent (or shareholders)	N
60	compr_inc_attr_m_s	double	Total comprehensive income attributable to minority shareholders	N
61	ebit	double	EBIT	N
62	ebitda	double	EBITDA	N
63	insurance_exp	double	Insurance business expenses	N
64	undist_profit	double	Retained earnings at year start	N
65	distable_profit	double	Distributable profit	N
66	rd_exp	double	R&D expenses	N
67	fin_exp_int_exp	double	Financial expenses: interest expense	N
68	fin_exp_int_inc	double	Financial expenses: interest income	N
69	transfer_surplus_rese	double	Transfer from surplus reserve	N
70	transfer_housing_imprest	double	Transfer from housing revolving fund	N
71	transfer_oth	double	Other transfers in	N
72	adj_lossgain	double	Prior-year adjustment	N
73	withdra_legal_surplus	double	Statutory surplus reserve appropriation	N
74	withdra_legal_pubfund	double	Statutory public welfare fund appropriation	N
75	withdra_biz_devfund	double	Enterprise expansion fund appropriation	N
76	withdra_rese_fund	double	Reserve fund appropriation	N
77	withdra_oth_ersu	double	Discretionary surplus reserve appropriation	N
78	workers_welfare	double	Employee bonuses and benefits	N
79	distr_profit_shrhder	double	Profit available for distribution to shareholders	N
80	prfshare_payable_dvd	double	Dividends payable on preferred stock	N
81	comshare_payable_dvd	double	Common stock dividends payable	N
82	capit_comstock_div	double	Common stock dividends converted to share capital	N
83	net_after_nr_lp_correct	double	Net profit after non-recurring items (before correction)	N
84	credit_impa_loss	double	Credit impairment loss	N
85	net_expo_hedging_benefits	double	Net hedging gain	N
86	oth_impair_loss_assets	double	Other asset impairment losses	N
87	total_opcost	double	Total operating costs (II)	N
88	amodcost_fin_assets	double	Gain on derecognition of financial assets at amortized cost	N
89	oth_income	double	Other income	N
90	asset_disp_income	double	Gain on asset disposal	N
91	continued_net_profit	double	Net profit from continuing operations	N
92	end_net_profit	double	Net profit from discontinued operations	N
93	update_flag	varchar(4)	Update identifier	N

Listed-company balance sheet: balance

Table use: report, asset type: E, frequency: q

Balance sheet — assets, liabilities, shareholders’ equity.

	columns	dtypes	remarks	is_prime_key
0	ts_code	varchar(9)	Security code	Y
1	end_date	date	Reporting period	Y
2	ann_date	date	Announcement date	N
3	f_ann_date	date	Actual announcement date	N
4	report_type	varchar(10)	Report type	N
5	comp_type	varchar(10)	Company type	N
6	end_type	varchar(10)	Reporting period type	N
7	total_share	double	Closing total shares outstanding	N
8	cap_rese	double	Capital reserve	N
9	undistr_porfit	double	Retained earnings	N
10	surplus_rese	double	Surplus reserve	N
11	special_rese	double	Special reserve	N
12	money_cap	double	Cash and equivalents	N
13	trad_asset	double	Trading financial assets	N
14	notes_receiv	double	Notes receivable	N
15	accounts_receiv	double	Accounts receivable	N
16	oth_receiv	double	Other receivables	N
17	prepayment	double	Prepayments	N
18	div_receiv	double	Dividends receivable	N
19	int_receiv	double	Interest receivable	N
20	inventories	double	Inventories	N
21	amor_exp	double	Long-term prepaid expenses	N
22	nca_within_1y	double	Non-current assets due within one year	N
23	sett_rsrv	double	Settlement reserve	N
24	loanto_oth_bank_fi	double	Lending funds	N
25	premium_receiv	double	Premiums receivable	N
26	reinsur_receiv	double	Reinsurance accounts receivable	N
27	reinsur_res_receiv	double	Reinsurance contract reserves receivable	N
28	pur_resale_fa	double	Financial assets purchased under resale agreements	N
29	oth_cur_assets	double	Other current assets	N
30	total_cur_assets	double	Total current assets	N
31	fa_avail_for_sale	double	Available-for-sale financial assets	N
32	htm_invest	double	Held-to-maturity investments	N
33	lt_eqt_invest	double	Long-term equity investments	N
34	invest_real_estate	double	Investment properties	N
35	time_deposits	double	Time deposits	N
36	oth_assets	double	Other assets	N
37	lt_rec	double	Long-term receivables	N
38	fix_assets	double	Fixed assets	N
39	cip	double	Construction in progress	N
40	const_materials	double	Engineering materials	N
41	fixed_assets_disp	double	Fixed asset disposal	N
42	produc_bio_assets	double	Productive biological assets	N
43	oil_and_gas_assets	double	Oil and gas assets	N
44	intan_assets	double	Intangible assets	N
45	r_and_d	double	R&D expenditure	N
46	goodwill	double	Goodwill	N
47	lt_amor_exp	double	Long-term prepaid expenses	N
48	defer_tax_assets	double	Deferred tax assets	N
49	decr_in_disbur	double	Loans and advances issued	N
50	oth_nca	double	Other non-current assets	N
51	total_nca	double	Total non-current assets	N
52	cash_reser_cb	double	Cash and deposits with central bank	N
53	depos_in_oth_bfi	double	Deposits with peers and other financial institutions	N
54	prec_metals	double	Precious metals	N
55	deriv_assets	double	Derivative financial assets	N
56	rr_reins_une_prem	double	Reinsurance unearned premium reserves receivable	N
57	rr_reins_outstd_cla	double	Reinsurance outstanding claim reserves receivable	N
58	rr_reins_lins_liab	double	Reinsurance life reserves receivable	N
59	rr_reins_lthins_liab	double	Reinsurance long-term health reserves receivable	N
60	refund_depos	double	Margin paid out	N
61	ph_pledge_loans	double	Policyholder pledged loans	N
62	refund_cap_depos	double	Capital margin paid out	N
63	indep_acct_assets	double	Separate account assets	N
64	client_depos	double	Including: client fund deposits	N
65	client_prov	double	Including: client reserve funds	N
66	transac_seat_fee	double	Including: trading seat fees	N
67	invest_as_receiv	double	Receivables-type investments	N
68	total_assets	double	Total assets	N
69	lt_borr	double	Long-term borrowings	N
70	st_borr	double	Short-term borrowings	N
71	cb_borr	double	Borrowings from central bank	N
72	depos_ib_deposits	double	Deposits and interbank placements	N
73	loan_oth_bank	double	Borrowings taken	N
74	trading_fl	double	Trading financial liabilities	N
75	notes_payable	double	Notes payable	N
76	acct_payable	double	Accounts payable	N
77	adv_receipts	double	Advances from customers	N
78	sold_for_repur_fa	double	Financial assets sold under repurchase agreements	N
79	comm_payable	double	Fees and commissions payable	N
80	payroll_payable	double	Employee benefits payable	N
81	taxes_payable	double	Taxes payable	N
82	int_payable	double	Interest payable	N
83	div_payable	double	Dividends payable	N
84	oth_payable	double	Other payables	N
85	acc_exp	double	Accrued expenses	N
86	deferred_inc	double	Deferred revenue	N
87	st_bonds_payable	double	Short-term bonds payable	N
88	payable_to_reinsurer	double	Reinsurance payables	N
89	rsrv_insur_cont	double	Insurance contract reserves	N
90	acting_trading_sec	double	Agency securities trading payables	N
91	acting_uw_sec	double	Agency underwriting securities payables	N
92	non_cur_liab_due_1y	double	Non-current liabilities due within one year	N
93	oth_cur_liab	double	Other current liabilities	N
94	total_cur_liab	double	Total current liabilities	N
95	bond_payable	double	Bonds payable	N
96	lt_payable	double	Long-term payables	N
97	specific_payables	double	Special payables	N
98	estimated_liab	double	Provisions	N
99	defer_tax_liab	double	Deferred tax liabilities	N
100	defer_inc_non_cur_liab	double	Deferred revenue — non-current liabilities	N
101	oth_ncl	double	Other non-current liabilities	N
102	total_ncl	double	Total non-current liabilities	N
103	depos_oth_bfi	double	Deposits from peers and other financial institutions	N
104	deriv_liab	double	Derivative financial liabilities	N
105	depos	double	Deposits absorbed	N
106	agency_bus_liab	double	Agency business liabilities	N
107	oth_liab	double	Other liabilities	N
108	prem_receiv_adva	double	Premiums received in advance	N
109	depos_received	double	Deposited margin	N
110	ph_invest	double	Policyholder deposits and investment payables	N
111	reser_une_prem	double	Unearned premium reserves	N
112	reser_outstd_claims	double	Outstanding claim reserves	N
113	reser_lins_liab	double	Life insurance reserves	N
114	reser_lthins_liab	double	Long-term health insurance reserves	N
115	indept_acc_liab	double	Separate account liabilities	N
116	pledge_borr	double	Including: pledged borrowings	N
117	indem_payable	double	Claim payables	N
118	policy_div_payable	double	Policyholder dividends payable	N
119	total_liab	double	Total liabilities	N
120	treasury_share	double	Less: treasury stock	N
121	ordin_risk_reser	double	General risk reserve	N
122	forex_differ	double	Foreign currency translation difference	N
123	invest_loss_unconf	double	Unrecognized investment losses	N
124	minority_int	double	Minority interests equity	N
125	total_hldr_eqy_exc_min_int	double	Total shareholders’ equity (excl. minority interests)	N
126	total_hldr_eqy_inc_min_int	double	Total shareholders’ equity (incl. minority interests)	N
127	total_liab_hldr_eqy	double	Total liabilities and shareholders’ equity	N
128	lt_payroll_payable	double	Long-term employee benefits payable	N
129	oth_comp_income	double	Other comprehensive income	N
130	oth_eqt_tools	double	Other equity instruments	N
131	oth_eqt_tools_p_shr	double	Other equity instruments (preferred stock)	N
132	lending_funds	double	Securities lending balance (margin)	N
133	acc_receivable	double	Receivables	N
134	st_fin_payable	double	Short-term financing payables	N
135	payables	double	Payables	N
136	hfs_assets	double	Assets held for sale	N
137	hfs_sales	double	Liabilities held for sale	N
138	cost_fin_assets	double	Financial assets at amortized cost	N
139	fair_value_fin_assets	double	Financial assets at FVOCI	N
140	cip_total	double	Construction in progress (total) (yuan)	N
141	oth_pay_total	double	Other payables (total) (yuan)	N
142	long_pay_total	double	Long-term payables (total) (yuan)	N
143	debt_invest	double	Debt investments (yuan)	N
144	oth_debt_invest	double	Other debt investments (yuan)	N
145	oth_eq_invest	double	Other equity instrument investments (yuan)	N
146	oth_illiq_fin_assets	double	Other non-current financial assets (yuan)	N
147	oth_eq_ppbond	double	Other equity instruments: perpetual bonds (yuan)	N
148	receiv_financing	double	Receivables financing	N
149	use_right_assets	double	Right-of-use assets	N
150	lease_liab	double	Lease liabilities	N
151	contract_assets	double	Contract assets	N
152	contract_liab	double	Contract liabilities	N
153	accounts_receiv_bill	double	Notes and accounts receivable	N
154	accounts_pay	double	Notes and accounts payable	N
155	oth_rcv_total	double	Other receivables (total) (yuan)	N
156	fix_assets_total	double	Fixed assets (total) (yuan)	N
157	update_flag	varchar(2)	Update identifier	N

Listed-company cash flow statement: cashflow

Table use: report, asset type: E, frequency: q

Cash flow statement — operating, investing, and financing cash flows.

	columns	dtypes	remarks	is_prime_key
0	ts_code	varchar(9)	Security code	Y
1	end_date	date	Reporting period	Y
2	ann_date	date	Announcement date	N
3	f_ann_date	date	Actual announcement date	N
4	comp_type	varchar(10)	Company type	N
5	report_type	varchar(10)	Report type	N
6	end_type	varchar(10)	Reporting period type	N
7	net_profit	double	Net profit	N
8	finan_exp	double	Financial expenses	N
9	c_fr_sale_sg	double	Cash received from sales of goods and services	N
10	recp_tax_rends	double	Tax refunds received	N
11	n_depos_incr_fi	double	Net increase in client deposits and interbank placements	N
12	n_incr_loans_cb	double	Net increase in borrowings from central bank	N
13	n_inc_borr_oth_fi	double	Net increase in borrowings from other financial institutions	N
14	prem_fr_orig_contr	double	Cash received from original insurance premiums	N
15	n_incr_insured_dep	double	Net increase in policyholder deposits	N
16	n_reinsur_prem	double	Net cash received from reinsurance	N
17	n_incr_disp_tfa	double	Net increase in trading financial assets disposed	N
18	ifc_cash_incr	double	Net increase in interest and fee income	N
19	n_incr_disp_faas	double	Net increase in available-for-sale financial assets disposed	N
20	n_incr_loans_oth_bank	double	Net increase in borrowings taken	N
21	n_cap_incr_repur	double	Net increase in repurchase business funds	N
22	c_fr_oth_operate_a	double	Cash received from other operating activities	N
23	c_inf_fr_operate_a	double	Total cash inflows from operating activities	N
24	c_paid_goods_s	double	Cash paid for goods and services	N
25	c_paid_to_for_empl	double	Cash paid to and on behalf of employees	N
26	c_paid_for_taxes	double	Taxes paid	N
27	n_incr_clt_loan_adv	double	Net increase in client loans and advances	N
28	n_incr_dep_cbob	double	Net increase in deposits with central bank and peers	N
29	c_pay_claims_orig_inco	double	Cash paid for original insurance claims	N
30	pay_handling_chrg	double	Cash paid for fees and commissions	N
31	pay_comm_insur_plcy	double	Cash paid for policyholder dividends	N
32	oth_cash_pay_oper_act	double	Cash paid for other operating activities	N
33	st_cash_out_act	double	Total cash outflows from operating activities	N
34	n_cashflow_act	double	Net cash from operating activities	N
35	oth_recp_ral_inv_act	double	Cash received from other investing activities	N
36	c_disp_withdrwl_invest	double	Cash received from investment recovery	N
37	c_recp_return_invest	double	Cash received from investment income	N
38	n_recp_disp_fiolta	double	Net cash from disposal of fixed/intangible and other long-term assets	N
39	n_recp_disp_sobu	double	Net cash received from disposal of subsidiaries and other units	N
40	stot_inflows_inv_act	double	Total cash inflows from investing activities	N
41	c_pay_acq_const_fiolta	double	Cash paid for fixed/intangible and other long-term assets	N
42	c_paid_invest	double	Cash paid for investments	N
43	n_disp_subs_oth_biz	double	Net cash paid to acquire subsidiaries and other business units	N
44	oth_pay_ral_inv_act	double	Cash paid for other investing activities	N
45	n_incr_pledge_loan	double	Net increase in pledged loans	N
46	stot_out_inv_act	double	Total cash outflows from investing activities	N
47	n_cashflow_inv_act	double	Net cash from investing activities	N
48	c_recp_borrow	double	Cash received from borrowings	N
49	proc_issue_bonds	double	Cash received from bond issuance	N
50	oth_cash_recp_ral_fnc_act	double	Cash received from other financing activities	N
51	stot_cash_in_fnc_act	double	Total cash inflows from financing activities	N
52	free_cashflow	double	Enterprise free cash flow	N
53	c_prepay_amt_borr	double	Cash paid for debt repayment	N
54	c_pay_dist_dpcp_int_exp	double	Cash paid for dividends, profits, or interest	N
55	incl_dvd_profit_paid_sc_ms	double	Including: dividends paid to minority shareholders by subsidiaries	N
56	oth_cashpay_ral_fnc_act	double	Cash paid for other financing activities	N
57	stot_cashout_fnc_act	double	Total cash outflows from financing activities	N
58	n_cash_flows_fnc_act	double	Net cash from financing activities	N
59	eff_fx_flu_cash	double	Effect of exchange rate changes on cash	N
60	n_incr_cash_cash_equ	double	Net increase in cash and cash equivalents	N
61	c_cash_equ_beg_period	double	Opening cash and cash equivalents balance	N
62	c_cash_equ_end_period	double	Closing cash and cash equivalents balance	N
63	c_recp_cap_contrib	double	Cash received from investments	N
64	incl_cash_rec_saims	double	Including: cash received from minority shareholders investing in subsidiaries	N
65	uncon_invest_loss	double	Unrecognized investment loss	N
66	prov_depr_assets	double	Add: asset impairment provision	N
67	depr_fa_coga_dpba	double	Depreciation of fixed assets, oil/gas depletion, productive biological assets	N
68	amort_intang_assets	double	Amortization of intangible assets	N
69	lt_amort_deferred_exp	double	Amortization of long-term prepaid expenses	N
70	decr_deferred_exp	double	Decrease in prepaid expenses	N
71	incr_acc_exp	double	Increase in accrued expenses	N
72	loss_disp_fiolta	double	Loss on disposal of fixed/intangible and other long-term assets	N
73	loss_scr_fa	double	Loss on fixed asset retirement	N
74	loss_fv_chg	double	Loss on fair value changes	N
75	invest_loss	double	Investment loss	N
76	decr_def_inc_tax_assets	double	Decrease in deferred tax assets	N
77	incr_def_inc_tax_liab	double	Increase in deferred tax liabilities	N
78	decr_inventories	double	Decrease in inventories	N
79	decr_oper_payable	double	Decrease in operating receivables	N
80	incr_oper_payable	double	Increase in operating payables	N
81	others	double	Other	N
82	im_net_cashflow_oper_act	double	Net cash from operating activities (indirect method)	N
83	conv_debt_into_cap	double	Debt converted to capital	N
84	conv_copbonds_due_within_1y	double	Convertible corporate bonds due within one year	N
85	fa_fnc_leases	double	Finance lease of fixed assets	N
86	im_n_incr_cash_equ	double	Net increase in cash and cash equivalents (indirect method)	N
87	net_dism_capital_add	double	Net increase in lending funds	N
88	net_cash_rece_sec	double	Net cash received from agency securities trading (yuan)	N
89	credit_impa_loss	double	Credit impairment loss	N
90	use_right_asset_dep	double	Right-of-use asset depreciation	N
91	oth_loss_asset	double	Other asset impairment losses	N
92	end_bal_cash	double	Closing cash balance	N
93	beg_bal_cash	double	Less: opening cash balance	N
94	end_bal_cash_equ	double	Add: closing cash equivalents balance	N
95	beg_bal_cash_equ	double	Less: opening cash equivalents balance	N
96	update_flag	varchar(2)	Update flag (1 = latest)	N

Listed-company financial indicators: financial

Table use: report, asset type: E, frequency: q

Financial indicators — per-share, profitability, growth, solvency, cash flow metrics.

	columns	dtypes	remarks	is_prime_key
0	ts_code	varchar(9)	Security code	Y
1	end_date	date	Reporting period	Y
2	ann_date	date	Announcement date	N
3	eps	double	Basic EPS	N
4	dt_eps	double	Diluted EPS	N
5	total_revenue_ps	double	Total operating revenue per share	N
6	revenue_ps	double	Operating revenue per share	N
7	capital_rese_ps	double	Capital reserve per share	N
8	surplus_rese_ps	double	Surplus reserve per share	N
9	undist_profit_ps	double	Retained earnings per share	N
10	extra_item	double	Non-recurring gains and losses	N
11	profit_dedt	double	Net profit after deducting non-recurring items (non-GAAP net profit)	N
12	gross_margin	double	Gross profit	N
13	current_ratio	double	Current ratio	N
14	quick_ratio	double	Quick ratio	N
15	cash_ratio	double	Conservative quick ratio	N
16	invturn_days	double	Inventory turnover days	N
17	arturn_days	double	Accounts receivable turnover days	N
18	inv_turn	double	Inventory turnover	N
19	ar_turn	double	Accounts receivable turnover	N
20	ca_turn	double	Current asset turnover	N
21	fa_turn	double	Fixed asset turnover	N
22	assets_turn	double	Total asset turnover	N
23	op_income	double	Operating net income	N
24	valuechange_income	double	Net gain on fair value changes	N
25	interst_income	double	Interest expense	N
26	daa	double	Depreciation and amortization	N
27	ebit	double	EBIT	N
28	ebitda	double	EBITDA	N
29	fcff	double	Enterprise free cash flow	N
30	fcfe	double	Equity free cash flow	N
31	current_exint	double	Non-interest-bearing current liabilities	N
32	noncurrent_exint	double	Non-interest-bearing non-current liabilities	N
33	interestdebt	double	Interest-bearing debt	N
34	netdebt	double	Net debt	N
35	tangible_asset	double	Tangible assets	N
36	working_capital	double	Working capital	N
37	networking_capital	double	Working capital	N
38	invest_capital	double	Total invested capital	N
39	retained_earnings	double	Retained earnings	N
40	diluted2_eps	double	Closing diluted EPS	N
41	bps	double	Net assets per share	N
42	ocfps	double	Operating cash flow per share	N
43	retainedps	double	Retained earnings per share	N
44	cfps	double	Net cash flow per share	N
45	ebit_ps	double	EBIT per share	N
46	fcff_ps	double	Free cash flow per share (enterprise)	N
47	fcfe_ps	double	Free cash flow per share (equity)	N
48	netprofit_margin	double	Net profit margin	N
49	grossprofit_margin	double	Gross profit margin	N
50	cogs_of_sales	double	Cost of sales ratio	N
51	expense_of_sales	double	Selling expense ratio	N
52	profit_to_gr	double	Net profit / total operating revenue	N
53	saleexp_to_gr	double	Selling expenses / total operating revenue	N
54	adminexp_of_gr	double	Administrative expenses / total operating revenue	N
55	finaexp_of_gr	double	Financial expenses / total operating revenue	N
56	impai_ttm	double	Asset impairment loss / total operating revenue	N
57	gc_of_gr	double	Total operating costs / total operating revenue	N
58	op_of_gr	double	Operating profit / total operating revenue	N
59	ebit_of_gr	double	EBIT / total operating revenue	N
60	roe	double	Return on equity (ROE)	N
61	roe_waa	double	Weighted average ROE	N
62	roe_dt	double	ROE (excl. non-recurring items)	N
63	roa	double	Return on total assets	N
64	npta	double	Net profit on total assets	N
65	roic	double	Return on invested capital	N
66	roe_yearly	double	Annualized ROE	N
67	roa2_yearly	double	Annualized return on total assets	N
68	roe_avg	double	Average ROE (SEO condition)	N
69	opincome_of_ebt	double	Operating net income / total profit	N
70	investincome_of_ebt	double	Net gain on fair value changes / total profit	N
71	n_op_profit_of_ebt	double	Net non-operating income / total profit	N
72	tax_to_ebt	double	Income tax / total profit	N
73	dtprofit_to_profit	double	Net profit after non-recurring items / net profit	N
74	salescash_to_or	double	Cash from sales / operating revenue	N
75	ocf_to_or	double	Net cash from operating activities / operating revenue	N
76	ocf_to_opincome	double	Net cash from operating activities / operating net income	N
77	capitalized_to_da	double	Capital expenditure / depreciation and amortization	N
78	debt_to_assets	double	Asset-liability ratio	N
79	assets_to_eqt	double	Equity multiplier	N
80	dp_assets_to_eqt	double	Equity multiplier (DuPont)	N
81	ca_to_assets	double	Current assets / total assets	N
82	nca_to_assets	double	Non-current assets / total assets	N
83	tbassets_to_totalassets	double	Tangible assets / total assets	N
84	int_to_talcap	double	Interest-bearing debt / total invested capital	N
85	eqt_to_talcapital	double	Parent shareholders’ equity / total invested capital	N
86	currentdebt_to_debt	double	Current liabilities / total liabilities	N
87	longdeb_to_debt	double	Non-current liabilities / total liabilities	N
88	ocf_to_shortdebt	double	Net cash from operating activities / current liabilities	N
89	debt_to_eqt	double	Equity ratio	N
90	eqt_to_debt	double	Parent shareholders’ equity / total liabilities	N
91	eqt_to_interestdebt	double	Parent shareholders’ equity / interest-bearing debt	N
92	tangibleasset_to_debt	double	Tangible assets / total liabilities	N
93	tangasset_to_intdebt	double	Tangible assets / interest-bearing debt	N
94	tangibleasset_to_netdebt	double	Tangible assets / net debt	N
95	ocf_to_debt	double	Net cash from operating activities / total liabilities	N
96	ocf_to_interestdebt	double	Net cash from operating activities / interest-bearing debt	N
97	ocf_to_netdebt	double	Net cash from operating activities / net debt	N
98	ebit_to_interest	double	Interest coverage ratio (EBIT/interest expense)	N
99	longdebt_to_workingcapital	double	Long-term debt to working capital ratio	N
100	ebitda_to_debt	double	EBITDA / total liabilities	N
101	turn_days	double	Operating cycle	N
102	roa_yearly	double	Annualized net profit margin on total assets	N
103	roa_dp	double	Net profit margin on total assets (DuPont)	N
104	fixed_assets	double	Total fixed assets	N
105	profit_prefin_exp	double	Operating profit before financial expenses	N
106	non_op_profit	double	Non-operating profit	N
107	op_to_ebt	double	Operating profit / total profit	N
108	nop_to_ebt	double	Non-operating profit / total profit	N
109	ocf_to_profit	double	Net cash from operating activities / operating profit	N
110	cash_to_liqdebt	double	Cash and equivalents / current liabilities	N
111	cash_to_liqdebt_withinterest	double	Cash and equivalents / interest-bearing current liabilities	N
112	op_to_liqdebt	double	Operating profit / current liabilities	N
113	op_to_debt	double	Operating profit / total liabilities	N
114	roic_yearly	double	Annualized return on invested capital	N
115	total_fa_trun	double	Total fixed asset turnover	N
116	profit_to_op	double	Total profit / operating revenue	N
117	q_opincome	double	Single-quarter operating net income	N
118	q_investincome	double	Single-quarter net gain on fair value changes	N
119	q_dtprofit	double	Single-quarter net profit after non-recurring items	N
120	q_eps	double	EPS (single quarter)	N
121	q_netprofit_margin	double	Net profit margin (single quarter)	N
122	q_gsprofit_margin	double	Gross profit margin (single quarter)	N
123	q_exp_to_sales	double	Selling expense ratio (single quarter)	N
124	q_profit_to_gr	double	Net profit / total operating revenue (single quarter)	N
125	q_saleexp_to_gr	double	Selling expenses / total operating revenue (single quarter)	N
126	q_adminexp_to_gr	double	Administrative expenses / total operating revenue (single quarter)	N
127	q_finaexp_to_gr	double	Financial expenses / total operating revenue (single quarter)	N
128	q_impair_to_gr_ttm	double	Asset impairment loss / total operating revenue (single quarter)	N
129	q_gc_to_gr	double	Total operating costs / total operating revenue (single quarter)	N
130	q_op_to_gr	double	Operating profit / total operating revenue (single quarter)	N
131	q_roe	double	ROE (single quarter)	N
132	q_dt_roe	double	Single-quarter ROE (excl. non-recurring items)	N
133	q_npta	double	Net profit on total assets (single quarter)	N
134	q_opincome_to_ebt	double	Operating net income / total profit (single quarter)	N
135	q_investincome_to_ebt	double	Net gain on fair value changes / total profit (single quarter)	N
136	q_dtprofit_to_profit	double	Net profit after non-recurring items / net profit (single quarter)	N
137	q_salescash_to_or	double	Cash from sales / operating revenue (single quarter)	N
138	q_ocf_to_sales	double	Net cash from operating activities / operating revenue (single quarter)	N
139	q_ocf_to_or	double	Net cash from operating activities / operating net income (single quarter)	N
140	basic_eps_yoy	double	Basic EPS YoY growth rate (%)	N
141	dt_eps_yoy	double	Diluted EPS YoY growth rate (%)	N
142	cfps_yoy	double	Operating cash flow per share YoY growth rate (%)	N
143	op_yoy	double	Operating profit YoY growth rate (%)	N
144	ebt_yoy	double	Total profit YoY growth rate (%)	N
145	netprofit_yoy	double	YoY growth of net profit attributable to parent (%)	N
146	dt_netprofit_yoy	double	YoY growth of parent net profit excl. non-recurring items (%)	N
147	ocf_yoy	double	Net cash from operating activities YoY growth rate (%)	N
148	roe_yoy	double	Diluted ROE YoY growth rate (%)	N
149	bps_yoy	double	Net assets per share growth vs. year start (%)	N
150	assets_yoy	double	Total assets growth vs. year start (%)	N
151	eqt_yoy	double	Parent shareholders’ equity growth vs. year start (%)	N
152	tr_yoy	double	Total operating revenue YoY growth rate (%)	N
153	or_yoy	double	Operating revenue YoY growth rate (%)	N
154	q_gr_yoy	double	Total operating revenue YoY growth rate (%) (single quarter)	N
155	q_gr_qoq	double	Total operating revenue QoQ growth rate (%) (single quarter)	N
156	q_sales_yoy	double	Operating revenue YoY growth rate (%) (single quarter)	N
157	q_sales_qoq	double	Operating revenue QoQ growth rate (%) (single quarter)	N
158	q_op_yoy	double	Operating profit YoY growth rate (%) (single quarter)	N
159	q_op_qoq	double	Operating profit QoQ growth rate (%) (single quarter)	N
160	q_profit_yoy	double	Net profit YoY growth rate (%) (single quarter)	N
161	q_profit_qoq	double	Net profit QoQ growth rate (%) (single quarter)	N
162	q_netprofit_yoy	double	YoY growth of net profit attributable to parent (%) (single quarter)	N
163	q_netprofit_qoq	double	QoQ growth of net profit attributable to parent (%) (single quarter)	N
164	equity_yoy	double	Net assets YoY growth rate	N
165	rd_exp	double	R&D expenses	N
166	update_flag	varchar(4)	Update identifier	N

Listed-company earnings forecast: forecast

Table use: report, asset type: E, frequency: q

Earnings forecast reports — guidance, express, forecasts.

	columns	dtypes	remarks	is_prime_key
0	ts_code	varchar(9)	Security code	Y
1	end_date	date	Reporting period	Y
2	ann_date	date	Announcement date	Y
3	type	varchar(9)	Earnings guidance type	N
4	p_change_min	float	Forecast net profit change lower bound (%)	N
5	p_change_max	float	Forecast net profit change upper bound (%)	N
6	net_profit_min	double	Forecast net profit lower bound (10,000 yuan)	N
7	net_profit_max	double	Forecast net profit upper bound (10,000 yuan)	N
8	last_parent_net	double	Net profit attributable to parent in the same period last year	N
9	first_ann_date	date	First announcement date	N
10	summary	text	Earnings guidance summary	N
11	change_reason	text	Reason for earnings change	N

Listed-company earnings express: express

Table use: report, asset type: E, frequency: q

Earnings express reports — express, guidance, forecasts.

	columns	dtypes	remarks	is_prime_key
0	ts_code	varchar(9)	Security code	Y
1	end_date	date	Reporting period	Y
2	ann_date	date	Announcement date	N
3	revenue	double	Operating revenue (yuan)	N
4	operate_profit	double	Operating profit (yuan)	N
5	total_profit	double	Total profit (yuan)	N
6	n_income	double	Net profit (yuan)	N
7	total_assets	double	Total assets (yuan)	N
8	total_hldr_eqy_exc_min_int	double	Total shareholders’ equity (excl. minority interests) (yuan)	N
9	diluted_eps	double	Diluted EPS (yuan)	N
10	diluted_roe	double	Diluted ROE (%)	N
11	yoy_net_profit	double	Restated net profit in the same period last year	N
12	bps	double	Net assets per share	N
13	yoy_sales	double	YoY growth rate: operating revenue	N
14	yoy_op	double	YoY growth rate: operating profit	N
15	yoy_tp	double	YoY growth rate: total profit	N
16	yoy_dedu_np	double	YoY growth rate: net profit attributable to parent	N
17	yoy_eps	double	YoY growth rate: basic EPS	N
18	yoy_roe	double	YoY change: weighted average ROE	N
19	growth_assets	double	Growth vs. year start: total assets	N
20	yoy_equity	double	Growth vs. year start: parent shareholders’ equity	N
21	growth_bps	double	Growth vs. year start: net assets per share attributable to parent	N
22	or_last_year	double	Operating revenue in the same period last year	N
23	op_last_year	double	Operating profit in the same period last year	N
24	tp_last_year	double	Total profit in the same period last year	N
25	np_last_year	double	Net profit in the same period last year	N
26	eps_last_year	double	EPS in the same period last year	N
27	open_net_assets	double	Opening net assets	N
28	open_bps	double	Opening net assets per share	N
29	perf_summary	text	Brief earnings description	N
30	is_audit	varchar(9)	Audited: 1 yes 0 no	N
31	remark	text	Remarks	N