-- 归档单据
DELETE FROM t_cbs_archi_billset WHERE FID = 1692693624065995776;
INSERT INTO t_cbs_archi_billset(FID,FCREATETIME,FIS_STORE,FPRESET,FENTITYNUMBER,FIS_CLEAN,FNUMBER) VALUES (1692693624065995776,{ts'2023-05-25  00:00:00'},'0','0','er_caswblog','1','er_caswblog');

DELETE FROM t_cbs_archi_billset_l WHERE FPKID = '3=XIIGP+LV7Q';
INSERT INTO t_cbs_archi_billset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692693624065995776,'3=XIIGP+LV7Q','zh_CN','资金反写费用日志');

-- 清除规则
DELETE FROM t_cbs_archi_config WHERE FID = 1692696714647286784;
INSERT INTO t_cbs_archi_config(FID,FCONDITION,FENTITYNUMBER,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FFILTERTYPE,FREMARK,FMODIFYTIME,FMOVINGTYPE,FBILLSETID,FCREATORID,FCONDITIONDESC) VALUES (1692696714647286784,'{"bill":"{\"filterRow\":[{\"id\":\"3=XJ23/RPIZZ\",\"leftBracket\":\"\",\"compareType\":\"501\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3=XJ23/RRMF+\",\"value\":\"365\"}],\"baseDataIds\":[]}],\"forList\":false}"}','er_caswblog',1692696714647286784,'C','er_caswblog',{ts'2023-05-25  00:00:00'},'1',1680468111436139520,'bill','日志保留一年',{ts'2023-05-25  00:00:00'},'1',1692693624065995776,1680468111436139520,'opdate < ''2022-05-25 00:00:00''');

DELETE FROM t_cbs_archi_config_l WHERE FPKID = '3=XJ3/107URV';
INSERT INTO t_cbs_archi_config_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692696714647286784,'3=XJ3/107URV','zh_CN','资金反写费用日志');


-- 调度计划
DELETE FROM t_cbs_archi_scheduleentry WHERE FENTRYID = 1692698591346668544;
INSERT INTO t_cbs_archi_scheduleentry(FID,FENTRYID,FSEQ,FCONFIGID) VALUES (1692697205330399232,1692698591346668544,1,1692696714647286784);

DELETE FROM t_cbs_archi_schema WHERE FID = 1692697205330399232;
INSERT INTO t_cbs_archi_schema(FID,FSCHEDULEPLANID,FEXECUTORID,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FMOVINGTYPE,FCREATORID,FENDTIME,FEXECPLAN) VALUES (1692697205330399232,'3=XJE4MQGACO',1680468111436139520,1692697205330399232,'A','ARCHIVE_CLN_20230525-112711272_SKDP_S',{ts'2023-05-25  00:00:00'},1680468111436139520,'1',{ts'2023-06-01  00:00:00'},'1',1680468111436139520,{ts'2099-12-31  00:00:00'},'事件将于2023-05-25 11:27:11起，每1天2时重复。
预计最近十次执行时间：
2023-05-26 02:27:00,
2023-05-27 02:27:00,
2023-05-28 02:27:00,
2023-05-29 02:27:00,
2023-05-30 02:...');

DELETE FROM t_cbs_archi_schema_l WHERE FPKID = '3=XJFOBV5D3B';
INSERT INTO t_cbs_archi_schema_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692697205330399232,'3=XJFOBV5D3B','zh_CN','资金反写费用日志清除');
DELETE FROM t_cbs_archi_schema_l WHERE FPKID = '3=XJFOBV5D3C';
INSERT INTO t_cbs_archi_schema_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692697205330399232,'3=XJFOBV5D3C','zh_TW','資金反寫費用日誌清除');

