INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',1,'捐赠收入转净资产','410101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',2,'捐赠收入转净资产','410102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',3,'会费收入转净资产','420101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',4,'会费收入转净资产','420102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',5,'提供服务收入转净资产','430101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',6,'提供服务收入转净资产','430102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',7,'商品销售收入转净资产','440101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',8,'商品销售收入转净资产','440102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',9,'政府补助收入转净资产','450101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',10,'政府补助收入转净资产','450102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',11,'投资收益转净资产','460101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',12,'投资收益转净资产','460102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',13,'其他收入转净资产','490101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',14,'其他收入转净资产','490102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',15,'主营业务成本转净资产','510101','310102','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',16,'主营业务成本转净资产','510102','3102','','一对多','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',17,'管理费用转净资产','520101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',18,'管理费用转净资产','520102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',19,'筹资费用转净资产','530101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',20,'筹资费用转净资产','530102','3102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',19,'其他费用转净资产','540101','310102','','一对一','n','')
INSERT INTO [a_zdzz] ([xz],[sxh],[zy],[ykm],[mdkm],[sm],[dygx],[jzxscb],[srkm]) VALUES ( 'n',20,'其他费用转净资产','540102','3102','','一对一','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 ( '提供捐赠或者资助支付的现金','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 ( '收到的其他和投资活动有关的现金','204',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 ( '支付的其他和投资活动有关的现金','213',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')

INSERT INTO [a_xm] ([xm],[xmbm],[nf],[lb],[mj]) VALUES ( '汇率变动对现金的影响额','401',2019,'xjl','y')

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