cf.sql

一个用VB写的财务软件源码

create table TCF_TYPE
(
  CTYPECODE   CHAR(2) not null,
  VCTYPENAME  VARCHAR2(40),
  BADDITIONAL NUMBER default 0,               /*是否附表*/
  BALLOWEDIT  NUMBER default -1 /* 是否允许填入拆分数据 */
)
tablespace CW_TS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
alter table TCF_TYPE
  add constraint PK_CF_TYPE primary key (CTYPECODE)
  using index 
  tablespace CW_TS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 10K
    next 10K
    minextents 1
    maxextents 121
    pctincrease 0
  );
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('04', '四、汇率变动对现金的影响额', 0, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('05', '五、现金及现金等价物净增加额', 0, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('12', '2、不涉及现金收支的投资和筹资活动', -1, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('11', '1、将净利润调节为经营活动的现金流量', -1, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('13', '3、现金及现金等价物净增加情况', -1, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('01', '一、经营活动产生的现金流量', 0, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('02', '二、投资活动产生的现金流量', 0, -1);
insert into TCF_TYPE (CTYPECODE, VCTYPENAME, BADDITIONAL, BALLOWEDIT)
values ('03', '三、筹资活动产生的现金流量', 0, -1);

delete TCF_ITEM WHERE SIYEAR='<<YEAR>>';
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '01', '销售商品、提供劳务收到的现金', 1, 1, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '02', '收到的税费返还', 1, 2, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '03', '收到的其他与经营活动有关的现金', 1, 3, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '10', '现金流入小计', 1, 10, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '11', '购买商品、接受劳务支付的现金', 0, 11, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '12', '支付给职工以及为职工支付的现金', 0, 12, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '13', '支付的各项税费', 0, 13, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '14', '支付的其他与经营活动有关的现金', 0, 14, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '20', '现金流出小计', 0, 20, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '01', '30', '经营活动产生的现金流量净额', 1, 30, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '01', '收回投资所收到的现金', 1, 31, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '02', '取得投资收益所收到的现金', 1, 32, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '03', '处置固定资产、无形资产和其他长期资产收回的现金净额', 1, 33, 0, -1, -1, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '04', '收到的其他与投资活动有关的现金', 1, 34, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '10', '现金流入小计', 1, 40, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '11', '购建固定资产、无形资产和其他长期资产支付的现金', 0, 41, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '12', '投资所支付的现金', 0, 42, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '13', '支付的与其他投资活动有关的现金', 0, 43, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '20', '现金流出小计', 0, 50, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '02', '30', '投资活动产生的现金流量净额', 1, 60, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '01', '吸收投资所收到的现金', 1, 61, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '02', '借款所收到的现金', 1, 62, 0, -1, -1, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '03', '收到的其他与筹资活动有关的现金', 1, 63, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '10', '现金流入小计', 1, 70, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '11', '偿还债务所支付的现金', 0, 71, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '12', '分配股利、利润或偿付利息所支付的现金', 0, 72, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '13', '支付的其他与筹资活动有关的现金', 0, 73, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '20', '现金流出小计', 0, 80, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '03', '30', '筹资活动产生的现金流量净额', 1, 90, 0, -1, 0, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '00', '净利润', 2, 100, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '01', '加: 计提的资产减值准备', 2, 101, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '02', '    固定资产折旧', 2, 102, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '03', '    无形资产摊销', 2, 103, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '04', '    长期待摊费用摊销', 2, 104, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '05', '    待摊费用减少（减：增加）', 2, 105, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '06', '    预提费用增加（减：减少）', 2, 106, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '07', '    处置固定资产、无形资产和其他长期资产的损失（减：收益）', 2, 107, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '08', '    固定资产报废损失', 2, 108, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '09', '    财务费用', 2, 109, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '10', '    投资损失(减：收益)', 2, 110, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '11', '    递延税款贷项(减：借项)', 2, 111, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '12', '    存货的减少(减：增加)', 2, 112, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '13', '    经营性应收项目的减少(减：增加)', 2, 113, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '14', '    经营性应付项目的增加(减：减少)', 2, 114, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '15', '    其他', 2, 115, 0, 0, -1, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '11', '20', '经营活动产生的现金流量净额', 2, 120, 0, -1, -1, -1, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '12', '01', '债务转为资本', 2, 130, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '12', '02', '一年内到期的可转换公司债券', 2, 131, 0, 0, -1, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '12', '03', '融资租入固定资产', 2, 132, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '12', '04', '其他', 2, 133, 0, 0, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '13', '01', '现金的期末余额', 2, 140, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '13', '02', '减: 现金的期初余额', 2, 141, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '13', '03', '加: 现金等价物的期末余额', 2, 142, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '13', '04', '减: 现金等价物的期初余额', 2, 143, 0, -1, 0, 0, -1);
insert into TCF_ITEM (SIYEAR, CTYPECODE, CITEMCODE, VCITEMNAME, BFLOWIN, IROW, BUSED, BSYSDEF, BMAYAPPEND, BFORMULA, BALLOWEDIT)
values (<<YEAR>>, '13', '05', '现金及现金等价物净增加额', 2, 144, 0, -1, -1, -1, -1);

delete TCF_SOURCE WHERE SIYEAR='<<YEAR>>';
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '03', '10', 0, '+', '合计', null, null, null, '0301+0302+0303', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '01', '20', 0, '+', '合计', null, null, null, '0111+0112+0113+0114', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '01', '30', 0, '+', '合计', null, null, null, '0110-0120', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '02', '10', 0, '+', '合计', null, null, null, '0201+0202+0203+0204', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '02', '20', 0, '+', '合计', null, null, null, '0211+0212+0213', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '02', '30', 0, '+', '合计', null, null, null, '0210-0220', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '13', '05', 0, '+', '合计', null, null, null, '1301+1303-1302-1304', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '01', '10', 0, '+', '合计', null, null, null, '0101+0102+0103', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '11', '15', 0, '+', '合计', null, null, null, '0130-1100-1101-1103-1102-1104-1105-1106-1107-1108-1109-1110-1111-1112-1113-1114', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '11', '20', 0, '+', '合计', null, null, null, '0130', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '03', '30', 0, '+', '合计', null, null, null, '0310-0320', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '03', '20', 0, '+', '合计', null, null, null, '0311+0312+0313', null);
insert into TCF_SOURCE (SIYEAR, CTYPECODE, CITEMCODE, TISTEP, CSYMBOL, VCGETMETHOD, VCFORMULANAME, VCFORMULANAMEENG, VCCOMMENT, VCFORMULA, MVALUE)
values (<<YEAR>>, '05', 'AA', 0, '+', '合计', null, null, null, '0130+0230+0330+04', null);