DELETE AFSFRG_I WHERE CO_CD = '1000' AND FS_TY = '40' AND FS_CD = '000'
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1000','','0','0',N'一、经营活动产生的现金流量：','0',N'1.영업활동에서 생성한 현금흐름：')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1005','1','0','2',N'  销售商品、提供劳务收到的现金','3',N'  상품매출、노무제공으로 받은 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1010','3','0','2',N'  收到的税费返还','3',N'  받은 세금 반환')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1015','8','0','2',N'  收到其他与经营活动有关的现金','3',N'  받은 기타 영업활동과 관련된 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1020','9','0','1',N'    经营活动现金流入小计','2',N'    영업활동으로 인한 현금유입소계')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1025','10','0','2',N'  购买商品、接受劳务支付的现金','4',N'  상품구매、노무접수로 지급한 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1030','12','0','2',N'  支付给职工以及为职工支付的现金','4',N'  직원에게 직접 혹은 간접한 지급한 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1035','13','0','2',N'  支付的各项税费','4',N'  지급한 각 항 세금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1040','18','0','2',N'  支付其他与经营活动有关的现金','4',N'  지급한 기타 영업활동과 관련된 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1045','20','0','1',N'    经营活动现金流出小计','2',N'    영업활동으로 인한 현금유출소계')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1050','21','0','1',N'      经营活动产生的现金流量净额','2',N'      영업활동으로 인한 현금흐름순액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1100','','0','0',N'二、投资活动产生的现金流量：','0',N'2.투자활동으로 인한 현금흐름：')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1105','22','0','2',N'  收回投资收到的现金','3',N'  투자회수로 받은 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1110','23','0','2',N'  取得投资收益收到的现金','3',N'  투자수익취득으로 받은 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1115','25','0','2',N'  处置固定资产、无形资产和其他长期资产收回的现金净额','3',N'  고정자산처분, 무형자산과 기타 장기자산회수로 받은현금순액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1120','26','0','2',N'  处置子公司及其他营业单位收到的现金净额','3',N'  지점 및 기타 사업장처분으로 받은 현금 순액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1125','28','0','2',N'  收到其他与投资活动有关的现金','3',N'  받은 기타 투자활동과 관련된 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1130','29','0','1',N'    投资活动现金流入小计','2',N'    투자활동으로 인한 현금유입소계')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1135','30','0','2',N'  购建固定资产、无形资产和其他长期资产支付的现金','4',N'  고정자산, 무형자산 및 기타 장기자산구매건설에 지급한 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1140','31','0','2',N'  投资支付的现金','4',N'  투자에 지급한 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1145','32','0','2',N'  取得子公司及其他营业单位支付的现金净额','5',N'  지점 및 기타 사업장취득에 지급한 현금 순액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1150','35','0','2',N'  支付其他与投资活动有关的现金','4',N'  지급한 기타 투자활동과 관련된 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1155','36','0','1',N'    投资活动现金流出小计','2',N'    투자활동으로 인한 현금유출소계')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1160','37','0','1',N'      投资活动产生的现金流量净额','2',N'      투자활동으로 인한 현금흐름순액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1200','','0','0',N'三、筹资活动产生的现金流量：','0',N'3.자금조달활동으로 인한 현금흐름')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1205','38','0','2',N'  吸收投资收到的现金','3',N'  투자흡수로 받은 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1210','40','0','2',N'  取得借款收到的现金','3',N'  차입금으로 받은 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1215','43','0','2',N'  收到其他与筹资活动有关的现金','3',N'  받은 기타 조달활동과 관련된 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1220','44','0','1',N'    筹资活动现金流入小计','2',N'    조달활동으로 인한 현금유입소계')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1225','45','0','2',N'  偿还债务支付的现金','4',N'  채무상환으로 지급한 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1230','46','0','2',N'  分配股利、利润或偿付利息支付的现金','4',N'  주식배당금,이윤배분 혹은 이자상환등 지급한 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1235','52','0','2',N'  支付其他与筹资活动有关的现金','4',N'  지급한 기타 조달활동과 관련된 현금')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1240','53','0','1',N'    筹资活动现金流出小计','2',N'    조달활동으로 인한 현금유출소계')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1245','54','0','1',N'      筹资活动产生的现金流量净额','2',N'      조달활동으로 인한 현금흐름순액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1300','55','0','2',N'四、汇率变动对现金的影响','3',N'4.환율변동이 현금에 대한 영향액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1400','56','0','0',N'五、现金及现金等价物净增加额','2',N'5.현금및현금등가물순증가액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1405','57','0','2',N'    加：期初现金及现金等价物余额','8',N'  가:기초현금 및 현금등가물 잔액')
INSERT INTO AFSFRG_I(CO_CD,FS_TY,FS_CD,LINE_NO,DISP_NO,EXP_TY,LEVEL_CD,DISP_NM,CALC_TY,DISP_NMK) VALUES('1000','40','000','1500','58','0','2',N'六、期末现金及现金等价物余额','9',N'6.기말현금 및 현금등가물 잔액')
GO
DELETE AFSFRG_I_D WHERE CO_CD = '1000' AND FS_TY = '40' AND FS_CD = '001' 
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1020','0','1005')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1020','0','1010')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1020','0','1015')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1045','0','1025')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1045','0','1030')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1045','0','1035')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1045','0','1040')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1050','0','1020')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1050','1','1045')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1130','0','1105')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1130','0','1110')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1130','0','1115')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1130','0','1120')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1130','0','1125')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1155','0','1135')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1155','0','1140')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1155','0','1145')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1155','0','1150')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1160','0','1130')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1160','1','1155')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1220','0','1205')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1220','0','1210')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1220','0','1215')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1240','0','1225')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1240','0','1230')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1240','0','1235')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1245','0','1220')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1245','1','1240')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1400','0','1050')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1400','0','1160')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1400','0','1245')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1400','0','1300')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1405','0','1001')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1405','0','1002')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1500','0','1001')
INSERT INTO AFSFRG_I_D(CO_CD,FS_TY,FS_CD,ACCT_TY,LINE_NO,ID_FG,ACCT_CD) VALUES('1000','40','000','0001','1500','0','1002')
GO