INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',1,'主营业务收入转本年利润','501','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',2,'其他业务收入转本年利润','502','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',3,'投资收益转本年利润','503','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',4,'营业外收入转本年利润','504','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',5,'主营业务成本转本年利润','511','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',6,'其他业务成本转本年利润','512','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',7,'营业税金及附加转本年利润','521','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',8,'销售费用转本年利润','522','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',9,'管理费用转本年利润','531','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',10,'财务费用转本年利润','541','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',11,'营业外支出转本年利润','542','321','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',12,'所得税转本年利润','543','321','','一对多','n','')

INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '销售商品、提供劳务收到的现金','101',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '收到的税费返还','102',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '收到其他与经营活动有关的现金','103',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '购买商品、接受劳务支付的现金','104',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付给职工以及为职工支付的现金','105',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付的各项税费','106',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付其他与经营活动有关的现金','107',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '收回投资收到的现金','201',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '取得投资收益收到的现金','202',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '处置固定资产、无形资产和其他长期资产收回的现金净额','203',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '处置子公司及其他营业单位收到的现金净额','204',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '收到其他与投资活动有关的现金','205',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '购建固定资产、无形资产和其他长期资产支付的现金','206',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '投资支付的现金','207',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '取得子公司及其他营业单位支付的现金净额','208',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付其他与投资活动有关的现金','209',2019,'xjl','y')

INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '吸收投资收到的现金','301',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '取得借款收到的现金','302',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '收到其他与筹资活动有关的现金','303',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '偿还债务支付的现金','304',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '分配股利、利润或偿付利息支付的现金','305',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付其他与筹资活动有关的现金','306',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '汇率变动对现金的影响','401',2019,'xjl','y')

UPDATE [a_kjkm] SET xjl='y' WHERE kmbm='101' OR kmbm='102' OR kmbm='109'