DELETE FROM t_tpo_tccit_yearitems WHERE FID = 1018740135224688640;
INSERT INTO t_tpo_tccit_yearitems(FID,FTYPE,FMASTERID,FSTATUS,FPARENTID,FENTITY,FNUMBER,FSTART,FCREATETIME,FMODIFIERID,FENABLE,FISLEAF,FEND,FTEMPLATE,FMODIFYTIME,FFIELD,FLEVEL,FCREATORID,FLONGNUMBER) VALUES (1018740135224688640,'dsale',1018740135224688640,'A',0,' ','year_items_2020_stxs',{ts'2018-01-01  00:00:00'},{ts'2020-11-06  14:08:34'},13466739,'1','1',NULL,'qysdsnb',{ts'2020-11-06  14:26:05'},' ',1,13466739,'year_items_2020_stxs'); 

DELETE FROM t_tpo_tccit_yearitems_l WHERE FPKID = '163O7/1NN2LX';
INSERT INTO t_tpo_tccit_yearitems_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018740135224688640,'163O7/1NN2LX','zh_CN','2020视同销售类型','2020视同销售类型'); 
DELETE FROM t_tpo_tccit_yearitems_l WHERE FPKID = '163O7/1NN2LY';
INSERT INTO t_tpo_tccit_yearitems_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018740135224688640,'163O7/1NN2LY','zh_TW',' ','2020視同銷售類型'); 

DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018741145959678976;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',1,' ',1,'501',1018740135224688640,1018741145959678976,'C',0,'501',' ',0,'0',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045888;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',2,' ',2,'501.50101',1018740135224688640,1018745515099045888,'C',1018741145959678976,'50101',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045889;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',3,' ',2,'501.50102',1018740135224688640,1018745515099045889,'C',1018741145959678976,'50102',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045890;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',4,' ',2,'501.50103',1018740135224688640,1018745515099045890,'C',1018741145959678976,'50103',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045891;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',5,' ',2,'501.50104',1018740135224688640,1018745515099045891,'C',1018741145959678976,'50104',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045892;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',6,' ',2,'501.50105',1018740135224688640,1018745515099045892,'C',1018741145959678976,'50105',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045893;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',7,' ',2,'501.50106',1018740135224688640,1018745515099045893,'C',1018741145959678976,'50106',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045894;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',8,' ',2,'501.50107',1018740135224688640,1018745515099045894,'C',1018741145959678976,'50107',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045895;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',9,' ',2,'501.50108',1018740135224688640,1018745515099045895,'C',1018741145959678976,'50108',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1018745515099045896;
INSERT INTO t_tpo_yearitem_detail(FPROJTYPE,FTYPE,FDESCRIPTION,FMASTERID,FENTITY,FSTART,FCREATETIME,FENABLE,FEND,FSETTING,FTEMPLATE,FSEQ,FCOSTCOLLECT,FLEVEL,FLONGNUMBER,FID,FENTRYID,FSTATUS,FPARENTID,FPROJNUMBER,FFILTER,FMODIFIERID,FISLEAF,FMODIFYTIME,FFIELD,FCREATORID) VALUES (' ','dsale',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',10,' ',2,'501.50109',1018740135224688640,1018745515099045896,'C',1018741145959678976,'50109',' ',0,'1',NULL,' ',0); 

DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163OD=BRJBFG';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163OD=BRJBFG','zh_CN',1018741145959678976,'视同销售',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163OD=BRJBFH';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163OD=BRJBFH','zh_TW',1018741145959678976,'視同銷售',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS96';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS96','zh_CN',1018745515099045888,'市场推广或销售',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS97';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS97','zh_TW',1018745515099045888,'市場推廣或銷售',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS98';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS98','zh_CN',1018745515099045889,'交际应酬',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS99';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS99','zh_TW',1018745515099045889,'交際應酬',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9=';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9=','zh_CN',1018745515099045890,'职工奖励或福利',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9A';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9A','zh_TW',1018745515099045890,'職工獎勵或福利',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9B';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9B','zh_CN',1018745515099045891,'股息分配',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9C';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9C','zh_TW',1018745515099045891,'股息分配',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9D';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9D','zh_CN',1018745515099045892,'对外捐赠',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9E';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9E','zh_TW',1018745515099045892,'對外捐贈',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9F';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9F','zh_CN',1018745515099045893,'对外投资项目',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9G';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9G','zh_TW',1018745515099045893,'對外投資項目',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9H';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9H','zh_CN',1018745515099045894,'提供劳务',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9I';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9I','zh_TW',1018745515099045894,'提供勞務',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9J';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9J','zh_CN',1018745515099045895,'非货币性资产交换',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9K';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9K','zh_TW',1018745515099045895,'非貨幣性資產交換',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9L';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9L','zh_CN',1018745515099045896,'其他',' '); 
DELETE FROM t_tpo_yearitem_detail_l WHERE FPKID = '163P7403LS9M';
INSERT INTO t_tpo_yearitem_detail_l(FPKID,FLOCALEID,FENTRYID,FPROJNAME,FFULLNAME) VALUES ('163P7403LS9M','zh_TW',1018745515099045896,'其他',' '); 

