INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',1,'医疗收入转本年利润','5001','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',2,'其他业务收入转本年利润','5051','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',3,'投资收益转本年利润','5111','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',4,'营业外收入转本年利润','5301','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',5,'医疗业务成本转本年利润','5401','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',6,'其他业务成本转本年利润','5402','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',7,'营业税金及附加转本年利润','5403','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',8,'销售费用转本年利润','5601','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',9,'管理费用转本年利润','5602','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',10,'财务费用转本年利润','5603','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',11,'营业外支出转本年利润','5711','3103','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',12,'所得税费用转本年利润','5801','3103','','一对多','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 ( '购买原材料、商品、接受劳务支付的现金','111',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付的职工薪酬','112',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付的税费','113',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '支付其他与经营活动有关的现金','114',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 ( '短期投资、长期债券投资和长期股权投资支付的现金','211',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '购建固定资产、无形资产和其他非流动资产支付的现金','212',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 ( '偿还借款本金支付的现金','311',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '偿还借款利息支付的现金','312',2019,'xjl','y')
INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '分配利润支付的现金','313',2019,'xjl','y')

UPDATE [a_kjkm] SET xjl='y' WHERE kmbm='1001' OR kmbm='1002' OR kmbm='1012'