📄 fx.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
		[siRowLabel],
		[siColLabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_Head] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_Head__bGetDa__725BF7F6] DEFAULT (0) FOR [bGetDataCol],
	CONSTRAINT [PK_fx_Head] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siColLabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_Item] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_Item__bMerge__753864A1] DEFAULT ((-1)) FOR [bMerge],
	CONSTRAINT [DF__tfx_Item__bAnaly__762C88DA] DEFAULT ((-1)) FOR [bAnalysis],
	CONSTRAINT [PK_fx_Item] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siRowLabel],
		[siColLabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_Report] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_Repor__bTota__66EA454A] DEFAULT ((-1)) FOR [bTotal],
	CONSTRAINT [DF__tfx_Repor__bColl__67DE6983] DEFAULT ((-1)) FOR [bCollect],
	CONSTRAINT [DF__tfx_Repor__bMerg__68D28DBC] DEFAULT ((-1)) FOR [bMerge],
	CONSTRAINT [DF__tfx_Repor__bAnal__69C6B1F5] DEFAULT (0) FOR [bAnalysis],
	CONSTRAINT [DF__tfx_Report__ID__6ABAD62E] DEFAULT (0) FOR [ID],
	CONSTRAINT [DF__tfx_Repor__babso__6BAEFA67] DEFAULT (0) FOR [babsoluteness],
	CONSTRAINT [DF__tfx_Repor__bbase__6CA31EA0] DEFAULT (0) FOR [bbase],
	CONSTRAINT [DF__tfx_Repor__bcirc__6D9742D9] DEFAULT (0) FOR [bcircle],
	CONSTRAINT [DF__tfx_Repor__bcomp__6E8B6712] DEFAULT (0) FOR [bcompare],
	CONSTRAINT [DF__tfx_Repor__bstru__6F7F8B4B] DEFAULT (0) FOR [bstructrue],
	CONSTRAINT [PK_fx_Report] PRIMARY KEY  CLUSTERED 
	(
		[cyear],
		[vcReportCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_constant] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_const__mvalu__6319B466] DEFAULT (0) FOR [mvalue],
	CONSTRAINT [DF__tfx_const__siuse__640DD89F] DEFAULT (0) FOR [siusetimes],
	CONSTRAINT [pk_fx_constant] PRIMARY KEY  NONCLUSTERED 
	(
		[cyear],
		[vcname],
		[cmonthfrom],
		[cmonthto],
		[vccomment]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_factorinit] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_facto__issys__047AA831] DEFAULT (0) FOR [issysdef],
	CONSTRAINT [DF__tfx_facto__banal__056ECC6A] DEFAULT (0) FOR [banalysis],
	CONSTRAINT [pk_fx_factorinit] PRIMARY KEY  CLUSTERED 
	(
		[cyear],
		[factorname]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_reportdata<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [pk_fx_reportdata<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[reportcode],
		[entercode],
		[month],
		[irowlabel],
		[collabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_reportdata<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_repor__celld__7FB5F314] DEFAULT (0) FOR [celldata] 
;

ALTER TABLE [dbo].[tfx_reportmode] WITH NOCHECK ADD 
	CONSTRAINT [DF__tfx_repor__lengt__7CD98669] DEFAULT (0) FOR [length],
	CONSTRAINT [pk_fx_reportmode] PRIMARY KEY  CLUSTERED 
	(
		[cyear],
		[cmonth],
		[vcreportcode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_subject] WITH NOCHECK ADD 
	CONSTRAINT [pk_fx_subject] PRIMARY KEY  CLUSTERED 
	(
		[cyear],
		[subjectcode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tfx_xjkm] WITH NOCHECK ADD 
	CONSTRAINT [pk_fx_xjkm] PRIMARY KEY  CLUSTERED 
	(
		[cyear],
		[kmcode],
		[direction]
	)  ON [PRIMARY] 
;
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '01', '权益净利率', '%', '资产净利率*权益乘数', 1, 'ZB("DB0101")*ZB("DB0102")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '01010101', '净利润', '元', '损益表的净利润', 1, 'BJQS("0000","jb020","本年","同期","24","24","4","4")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '010102', '总资产周转率', '%', '销售净额/资产平均总额', 1, 'ZB("DB01010102")/ZB("DB01010201")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '01010201', '资产平均总额', '元', '（期初资产总额+期末资产总额）/2', 1, '(BJQS("0000","jb010","本年","同期","34","34","3","3")+BJQS("0000","jb010","本年","同期","34","34","4","4"))/2');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '0102', '权益乘数', '%', '1/（1-资产负债率）', 1, '1/(1-ZB("HY05"))');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'HY', '04', '资本保值增值率', '%', '期末所有者权益总额/期初所有者权益总额', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'HY', '09', '社会贡献率', '%', '企业社会贡献总额/平均资产总额', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'HY', '10', '社会积累率', '%', '上交国家财政总额/企业社会贡献总额', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '08', '每股净资产', '元', '股东权益/普通股平均股数', 1, 'BJQS("0000","jb010","本年","同期","34","34","8","8")/BN("3101","LJYE","DF")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '02', '存货周转天数', '天', '天数/(销售成本/((期初存货+期末存货)/2))', 1, '30/ZB("0201")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '03', '应收账款周转率', '次', '赊销收入净额/((期初应收账款余额+期末应收账款余额)/2)', 1, 'ZB("DB01010102")/(BJQS("0000","jb010","本年","同期","7","7","3","3")+BJQS("0000","jb010","本年","同期","7","7","4","4"))/2');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '04', '应收账款天数', '天', '天数/(销售收入净额/((期初应收账款余额+期末应收账款余额)/2))', 1, '360/ZB("0203")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '05', '营业周期', '天', '天数/(销售成本/((期初存货+期末存货)/2))+天数/(销售收入/((期初应收帐款余额+期末应收帐款余额)/2))', 1, '30/(ZB("0201")/ZB("0203"))');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '07', '总资产周转率', '次', '销售收入净额/((期初资产总额+期末资产总额)/2)', 1, 'ZB("DB01010102")/((BJQS("0000","jb010","本年","同期","34","34","3","3")+BJQS("0000","jb010","本年","同期","34","34","4","4"))/2)');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '03', '02', '产权比率', '%', '负债总额/所有者权益', 1, '(BJQS("0000","jb010","本年","同期","15","15","8","8")+BJQS("0000","jb010","本年","同期","22","22","8","8"))/BJQS("0000","jb010","本年","同期","34","34","8","8")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '04', '01', '销售净利率', '%', '净利润/销售收入', 1, '(BN("3131","LJYE","DF")+BN("3131-99","LJYE","JF"))/ZB("DB01010102")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '04', '05', '资本金利润率', '%', '利润总额/资本总额', 1, 'BJQS("0000","jb020","本年","同期","21","21","4","4")/BJQS("0000","jb010","本年","同期","26","26","8","8")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '05', '01', '经费自给率', '%', '(事业收入+经营收入+附属单位上缴收入+其它收入)/(事业支出+经营支出)', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '01', '01', '流动比率', '%', '流动资产/流动负债', 1, 'BJQS("0000","jb010","本年","同期","15","15","4","4")/BJQS("0000","jb010","本年","同期","15","15","8","8")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '01', '每股收益', '元', '净利润/普通股平均股数', 1, 'BJQS("0000","jb020","本年","同期","24","24","4","4")/BN("3101","LJYE","DF")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '02', '市盈率', '%', '每股市价/每股盈余', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '03', '股利与市价比率', '%', '每股股利/股利市价', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '04', '股利分派率', '%', '每股股利/每股收益额', 1, null);
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '05', '每股账面价值', '天', '(股东权益总额-优先股权益)/普通股股数', 1, 'BJQS("0000","jb010","本年","同期","34","34","8","8")/BN("3101","LJYE","DF")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '010101', '销售净利率', '%', '净利润/销售净额', 1, 'ZB("DB01010101")/ZB("DB01010102")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '0101', '资产净利率', '%', '销售净利率*总资产周转率', 1, 'ZB("DB010101")*ZB("DB010102")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '010201', '资产负债率', '%', '（负债总额/资产总额）*100%', 1, '(BJQS("0000","jb010","本年","同期","15","15","8","8")+BJQS("0000","jb010","本年","同期","22","22","8","8"))/BJQS("0000","jb010","本年","同期","34","34","4","4")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '01', '02', '速动比率', '%', '(流动资产-存货-待摊费用-待处理流动资产损失)/流动负债*100', 1, '(BJQS("0000","jb010","本年","同期","15","15","4","4")-BJQS("0000","jb010","本年","同期","10","10","4","4")-BJQS("0000","jb010","本年","同期","11","11","4","4")-BJQS("0000","jb010","本年","同期","12","12","4","4"))/BJQS("0000","jb010","本年","同期","15","15","8","8")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', 'DB', '01010102', '销售净额', '元', '主营业务收入+其他业务收入', 0, 'BN("5101","LJYE","DF")+BN("5101-99","LJYE","JF")+BN("5102","LJYE","DF")+BN("5102-99","LJYE","JF")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '01', '存货周转率（次数）', '次', '销售成本/((期初存货+期末存货)/2)', 1, '(BN("5401","YE","JF")+BN("5401-99","LJYE","DF"))/(BJQS("0000","jb010","本年","同期","10","10","3","3")+BJQS("0000","jb010","本年","同期","10","10","4","4"))');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '02', '06', '流动资产周转率', '次', '销售收入净额/((期初流动资产+期末流动资产)/2)', 1, 'ZB("DB01010102")/((BJQS("0000","jb010","本年","同期","15","15","3","3")+BJQS("0000","jb010","本年","同期","15","15","4","4"))/2)');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '03', '01', '资产负债率', '%', '负债总额/资产总额', 1, '(BJQS("0000","jb010","本年","同期","15","15","8","8")+BJQS("0000","jb010","本年","同期","22","22","8","8"))/BJQS("0000","jb010","本年","同期","34","34","4","4")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '03', '03', '有形净值债务率', '%', '负债总额/(净资产-无形资产)', 1, '(BJQS("0000","jb010","本年","同期","15","15","8","8")+BJQS("0000","jb010","本年","同期","22","22","8","8"))/(BJQS("0000","jb010","本年","同期","33","33","8","8")-BJQS("0000","jb010","本年","同期","27","27","4","4"))');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '03', '04', '已获利息倍数', '%', '息税前利润/债务利息', 1, '(BJQS("0000","jb020","本年","同期","21","21","4","4")-BN("5503-01","LJYE","JF"))/BN("5503-01","LJYE","JF")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '05', '02', '资产负债率', '%', '负债总额/资产总额', 1, '(BJQS("0000","jb010","本年","同期","15","15","8","8")+BJQS("0000","jb010","本年","同期","22","22","8","8"))/BJQS("0000","jb010","本年","同期","34","34","4","4")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '06', '产权比率', '%', '负债总额/股东权益', 1, '(BJQS("0000","jb010","本年","同期","15","15","8","8")+BJQS("0000","jb010","本年","同期","22","22","8","8"))/BJQS("0000","jb010","本年","同期","34","34","8","8")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '06', '07', '净值报酬率', '%', '净利润/股东权益', 1, 'BJQS("0000","jb020","本年","同期","24","24","4","4")/BJQS("0000","jb010","本年","同期","33","33","8","8")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '04', '02', '销售毛利率', '%', '(销售收入-销售成本)/销售收入', 1, '(BJQS("0000","jb020","本年","同期","10","10","4","4")+BJQS("0000","jb020","本年","同期","11","11","4","4"))/ZB("DB01010102")');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '04', '03', '资产净利率', '%', '净利润/((期初资产总额+期末资产总额)/2)', 1, 'BJQS("0000","jb020","本年","同期","24","24","4","4")/(BJQS("0000","jb010","本年","同期","34","34","3","3")+BJQS("0000","jb010","本年","同期","34","34","3","3"))/2');
insert into TFX_RATE (CYEAR, TYPECODE, RATECODE, RATENAME, UNIT, FORMULA, ISSYSDEF, QSFORMULA)
values ('<<YEAR>>', '04', '04', '净资产收益率', '%', '净利润/((期初净资产+期末净资产)/2)', 1, 'BJQS("0000","jb020","本年","同期","24","24","4","4")/(BJQS("0000","jb010","本年","同期","34","34","7","7")+BJQS("0000","jb010","本年","同期","34","34","7","7"))/2');
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', '02', '资产管理比率', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', '03', '负债比率', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', '04', '盈利能力比率', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', '05', '事业单位指标', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', '06', '股份制企业指标', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', 'DB', '杜邦分析指标', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', 'HY', '行业财务指标', -1);
insert into TFX_RATETYPE (CYEAR, TYPECODE, TYPENAME, ISSYSDEF)
values ('<<YEAR>>', '01', '变现能力比率', -1);
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -