DELETE FROM t_tpo_template WHERE FID = 1535360343574841344;
INSERT INTO t_tpo_template(FID,FTYPE,FCONDITIONJSON,FFILTERCONDITION,FMODELID,FSTARTDATE,FCONTENT,FCONTENT_TAG,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FGENERAL,FMODIFIERID,FENABLE,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (1535360343574841344,'sdsjt_jt',' ',' ',1532683517396254720,{ts'2000-01-01  00:00:00'},' ',' ',' ',0,'C','INCOME-TAX-ADJ-JT','所得税计提（集团账簿）',{ts'2022-10-20  00:00:00'},'1',1737581019143598080,'1',{ts'2023-10-08  00:00:00'},NULL,1267221609945529344);
DELETE FROM t_tpo_template WHERE FID = 1551997998211269632;
INSERT INTO t_tpo_template(FID,FTYPE,FCONDITIONJSON,FFILTERCONDITION,FMODELID,FSTARTDATE,FCONTENT,FCONTENT_TAG,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FGENERAL,FMODIFIERID,FENABLE,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (1551997998211269632,'sdsjt_bd',' ',' ',1532683517396254720,{ts'2000-01-01  00:00:00'},' ',' ',' ',0,'C','INCOME-TAX-ADJ-BD','所得税计提（本地账簿）',{ts'2022-11-12  00:00:00'},'0',1737581019143598080,'1',{ts'2023-10-07  00:00:00'},NULL,13466739);

-- 添加递延所得税资产、负债分开入账行维
DELETE FROM t_tpo_row_member WHERE FID = 1790516651356371968;
INSERT INTO t_tpo_row_member(FID,FDIMENSION,FMASTERID,FSTATUS,FPARENTID,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FISLEAF,FMODEL,FREMARK,FMODIFYTIME,FLEVEL,FSYSPRESET,FCREATORID,FLONGNUMBER) VALUES (1790516651356371968,1477594605435224064,1790516651356371968,'C',1535525071140104193,'sjjs_dysdszcfzfkrz','递延所得税资产、负债分开入账',{ts'2023-10-07  00:00:00'},1737581019143598080,'1','1',1532683517396254720,' ',{ts'2023-10-07  00:00:00'},3,'0',1737581019143598080,'sdsjt.sjjs.sjjs_dysdszcfzfkrz');
DELETE FROM t_tpo_row_member_l WHERE FPKID = '3LY6B7795Q54';
INSERT INTO t_tpo_row_member_l(FID,FPKID,FLOCALEID,FREMARK,FFULLNAME,FNAME) VALUES (1790516651356371968,'3LY6B7795Q54','zh_CN',' ','所得税计提.税金计算.递延所得税资产、负债分开入账','递延所得税资产、负债分开入账');
DELETE FROM t_tpo_row_member_l WHERE FPKID = '3LY6B7795Q55';
INSERT INTO t_tpo_row_member_l(FID,FPKID,FLOCALEID,FREMARK,FFULLNAME,FNAME) VALUES (1790516651356371968,'3LY6B7795Q55','zh_TW',' ',' ','遞延所得稅資產、負債分開入賬');

-- 添加报表项数据
DELETE FROM t_tpo_report_item WHERE FID = 1790533801621872640;
INSERT INTO t_tpo_report_item(FID,FMODELID,FMASTERID,FSTATUS,FNUMBER,FNAME,FLONGNAME,FCREATETIME,FROWID,FMODIFIERID,FENABLE,FMODIFYTIME,FFCOLUMNID,FCREATORID) VALUES (1790533801621872640,1532683517396254720,0,'C','sjjs_dysdszcfzfkrz#sjjs_empty','递延所得税资产、负债分开入账#空白列','所得税计提.税金计算.递延所得税资产、负债分开入账#所得税计提.税金计算.空白列',{ts'2023-10-07  00:00:00'},1790516651356371968,1737581019143598080,'1',{ts'2023-10-07  00:00:00'},1761540048123212800,1737581019143598080);
DELETE FROM t_tpo_report_item_l WHERE FPKID = '3LY9J60YX/8S';
INSERT INTO t_tpo_report_item_l(FID,FPKID,FLOCALEID,FNAME,FLONGNAME) VALUES (1790533801621872640,'3LY9J60YX/8S','zh_CN','递延所得税资产、负债分开入账#空白列','所得税计提.税金计算.递延所得税资产、负债分开入账#所得税计提.税金计算.空白列');

-- 添加模板报表项关联表
DELETE FROM t_tpo_temp_rep_relation WHERE FENTRYID = 1790533802536230912;
INSERT INTO t_tpo_temp_rep_relation(FID,FREPORTITEMID,FENTRYID,FSEQ,FROWCOL) VALUES (1551997998211269632,1790533801621872640,1790533802536230912,310,'sjjs_dysdszcfzfkrz#sjjs_empty');
DELETE FROM t_tpo_temp_rep_relation WHERE FENTRYID = 1791337363016806400;
INSERT INTO t_tpo_temp_rep_relation(FID,FREPORTITEMID,FENTRYID,FSEQ,FROWCOL) VALUES (1535360343574841344,1790533801621872640,1791337363016806400,389,'sjjs_dysdszcfzfkrz#sjjs_empty');


-- 添加取数规则数据
DELETE FROM t_tpo_rule_fetch WHERE FID = 1790535601188111360;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (1790535601188111360,1532683517396254720,'text',' ',1790535601188111360,'A','CN-BBXGZ-000139873','{P[递延所得税资产、负债分开入账#空白列]}',{ts'2023-10-07  00:00:00'},1737581019143598080,'1',{ts'2023-10-07  00:00:00'},'BBXGZ',1737581019143598080,'{P[sjjs_dysdszcfzfkrz#sjjs_empty]}');
DELETE FROM t_tpo_rule_fetch_l WHERE FPKID = '3LY9W=H62DES';
INSERT INTO t_tpo_rule_fetch_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1790535601188111360,'3LY9W=H62DES','zh_CN','{P[递延所得税资产、负债分开入账#空白列]}');
DELETE FROM t_tpo_rep_it_fetch_re WHERE FENTRYID = 1790535601255220224;
INSERT INTO t_tpo_rep_it_fetch_re(FID,FREPORTITEMID,FENTRYID,FSEQ) VALUES (1790535601188111360,1790533801621872640,1790535601255220224,0);

-- 添加模板取数规则配置中间表数据
DELETE FROM t_tpo_template_rule_fetch WHERE FID = 1791337452053489664;
INSERT INTO t_tpo_template_rule_fetch(FID,FMODELID,FCREATETIME,FREPORTITEMID,FFORMULAID,FTEMPLATEID,FCREATORID) VALUES (1791337452053489664,1532683517396254720,{ts'2023-10-08  00:00:00'},1790533801621872640,1790535601188111360,1535360343574841344,1737581019143598080);
DELETE FROM t_tpo_template_rule_fetch WHERE FID = 1790535777348771840;
INSERT INTO t_tpo_template_rule_fetch(FID,FMODELID,FCREATETIME,FREPORTITEMID,FFORMULAID,FTEMPLATEID,FCREATORID) VALUES (1790535777348771840,1532683517396254720,{ts'2023-10-07  00:00:00'},1790533801621872640,1790535601188111360,1551997998211269632,1737581019143598080);

-- 修改取数规则【CN-BBXGZ-000000262】对应公式
DELETE FROM t_tpo_rule_fetch WHERE FID = 1542019466701942784;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FFORMULA,FCREATORID) VALUES (1542019466701942784,1532683517396254720,'number',' ',1542019466701942784,'A','CN-BBXGZ-000000262','{Q[可弥补亏损（税后）#本年变动_合计]} + {Q[可弥补亏损（税后）#年初余额_合计]}',{ts'2023-10-11  00:00:00'},1732509738043801600,'1',{ts'2023-10-11  00:00:00'},'BBXGZ','if(sum({Q[dysds_zsxcy_sh_xm#dysds_qmye]}) + sum({Q[dysds_gaapzsxcy_sh_xm#dysds_qmye]})==0,{Q[dysds_kmbks_sh#dysds_bnbd_hj]} + {Q[dysds_kmbks_sh#dysds_ncye_hjje]},{Q[dysds_kmbks_sh#dysds_bnbd_hj]} + {Q[dysds_kmbks_sh#dysds_ncye_hjje]})',1732509738043801600);

