-- 新增项目取数【year_items_2020_zctz】汇算清缴-资产调整-2020  明细
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635569381629077504;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',92,' ',0,'701.70102.7010206.701020618',1033269189877480448,1635569381629077504,'C',1047845728631819264,'701020618',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635569381629077505;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',93,' ',0,'701.70102.7010206.701020619',1033269189877480448,1635569381629077505,'C',1047845728631819264,'701020619',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215552;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',94,' ',0,'701.70102.7010206.701020620',1033269189877480448,1635570807944215552,'C',1047845728631819264,'701020620',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215553;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',95,' ',0,'701.70102.7010206.701020621',1033269189877480448,1635570807944215553,'C',1047845728631819264,'701020621',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215554;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',96,' ',0,'701.70102.7010206.701020622',1033269189877480448,1635570807944215554,'C',1047845728631819264,'701020622',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215555;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',97,' ',0,'701.70102.7010206.701020623',1033269189877480448,1635570807944215555,'C',1047845728631819264,'701020623',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215556;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',98,' ',0,'701.70102.7010206.701020624',1033269189877480448,1635570807944215556,'C',1047845728631819264,'701020624',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215557;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',99,' ',0,'701.70102.7010206.701020625',1033269189877480448,1635570807944215557,'C',1047845728631819264,'701020625',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215558;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',100,' ',0,'701.70102.7010206.701020626',1033269189877480448,1635570807944215558,'C',1047845728631819264,'701020626',' ',0,'1',NULL,' ',0); 
DELETE FROM t_tpo_yearitem_detail WHERE FENTRYID = 1635570807944215559;
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 (' ','zcajust',' ',0,' ',{ts'2018-01-01  00:00:00'},NULL,'1',NULL,'配置','qysdsnb',101,' ',0,'701.70102.7010206.701020627',1033269189877480448,1635570807944215559,'C',1047845728631819264,'701020627',' ',0,'1',NULL,' ',0); 


DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WV32YTMKKT';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WV32YTMKKT','zh_CN',1635569381629077504,'横琴粤澳深度合作区企业固定资产加速折旧');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WV32YTMKKU';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WV32YTMKKU','zh_TW',1635569381629077504,'橫琴粵澳深度合作區企業固定資產加速折舊');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WV32YTMKKV';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WV32YTMKKV','zh_CN',1635569381629077505,'高新技术企业 2022 年第四季度(10 月-12 月） 购置单价 500 万元以下设备器具一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WV32YTMKKW';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WV32YTMKKW','zh_TW',1635569381629077505,'高新技術企業 2022 年第四季度(10 月-12 月） 購置單價 500 萬元以下設備器具一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWL5';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWL5','zh_CN',1635570807944215552,'购置单价 500 万元以下设备器具一次性扣除 (不包含高新技术企业 2022 年第四季度购置)');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWL6';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWL6','zh_TW',1635570807944215552,'購置單價 500 萬元以下設備器具一次性扣除 (不包含高新技術企業 2022 年第四季度購置)');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWL7';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWL7','zh_CN',1635570807944215553,'中小微企业购 置单价 500 万 元以上设备器具.最低折旧年限为 3 年的设备 器具一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWL8';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWL8','zh_TW',1635570807944215553,'中小微企業購 置單價 500 萬 元以上設備器具.最低折舊年限為 3 年的設備 器具一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWL9';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWL9','zh_CN',1635570807944215554,'中小微企业购 置单价 500 万 元以上设备器具.最低折旧年限为 4、5 年的设 备器具 50%部分一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWL=';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWL=','zh_TW',1635570807944215554,'中小微企業購 置單價 500 萬 元以上設備器具.最低折舊年限為 4、5 年的設 備器具 50%部分一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLA';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLA','zh_CN',1635570807944215555,'中小微企业购 置单价 500 万 元以上设备器具.最低折旧年限为 10 年的设备 器具 50%部分一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLB';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLB','zh_TW',1635570807944215555,'中小微企業購 置單價 500 萬 元以上設備器具.最低折舊年限為 10 年的設備 器具 50%部分一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLC';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLC','zh_CN',1635570807944215556,'高新技术企业 2022 年第四季度（10 月-12 月） 购置单价 500 万元以上设备器具一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLD';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLD','zh_TW',1635570807944215556,'高新技術企業 2022 年第四季度（10 月-12 月） 購置單價 500 萬元以上設備器具一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLE';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLE','zh_CN',1635570807944215557,'横琴粤澳深度合作区企业固定资产一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLF';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLF','zh_TW',1635570807944215557,'橫琴粵澳深度合作區企業固定資產一次性扣除');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLG';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLG','zh_CN',1635570807944215558,'横琴粤澳深度合作区企业无形资产加速摊销');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLH';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLH','zh_TW',1635570807944215558,'橫琴粵澳深度合作區企業無形資產加速攤銷');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLI';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLI','zh_CN',1635570807944215559,'横琴粤澳深度合作区企业无形资产一次性摊销');
DELETE FROM T_TPO_YEARITEM_DETAIL_L WHERE FPKID = '33WVCH=9YWLJ';
INSERT INTO T_TPO_YEARITEM_DETAIL_L(FPKID,FLOCALEID,FENTRYID,FPROJNAME) VALUES ('33WVCH=9YWLJ','zh_TW',1635570807944215559,'橫琴粵澳深度合作區企業無形資產一次性攤銷');
