----归档单据
DELETE FROM t_cbs_archi_billset WHERE fid=1743492965458069504;
INSERT INTO t_cbs_archi_billset (fid, fentitynumber, fnumber, fis_store, fis_clean, fcreatetime, fpreset) values (1743492965458069504, 'ai_newbuildreporthead', 'ai_newbuildreporthead', '0', '1', {ts'2023-08-03 13:29:06'}, '0');
DELETE FROM t_cbs_archi_billset WHERE fid=1743492853084276736;
INSERT INTO t_cbs_archi_billset (fid, fentitynumber, fnumber, fis_store, fis_clean, fcreatetime, fpreset) values (1743492853084276736, 'ai_newbuildreportentry', 'ai_newbuildreportentry', '0', '1', {ts'2023-08-03 13:29:06'}, '0');
DELETE FROM t_cbs_archi_billset_l WHERE fpkid='3G4X4L3PGFPD';
DELETE FROM t_cbs_archi_billset_l WHERE fpkid='3G4X5E1=DUFN';
INSERT INTO t_cbs_archi_billset_l (fpkid, fid, flocaleid, fname) values ('3G4X4L3PGFPD', 1743492853084276736, 'zh_CN', '凭证生成报告详细信息');
INSERT INTO t_cbs_archi_billset_l (fpkid, fid, flocaleid, fname) values ('3G4X5E1=DUFN', 1743492965458069504, 'zh_CN', '凭证生成报告');

----清除规则
DELETE FROM t_cbs_archi_config WHERE fid=1743493440681101312;
DELETE FROM t_cbs_archi_config WHERE fid=1743493297462396928;
INSERT INTO t_cbs_archi_config (fid, fnumber, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fgroupid, fentitynumber, fcondition, fsyncbasedata, fremark, fmovingtype, fconditiontype, farchiveplugin, ffiltertype, fconditiondesc, fbillsetid, fpreset)
VALUES(1743493440681101312, 'ai_newbuildreportentry', 'C', 13466739, 13466739, '1', {ts'2023-08-03 13:29:06'}, {ts'2023-08-03 13:29:06'}, 1743493440681101312, 0, 'ai_newbuildreportentry', '{"bill":"{\"filterRow\":[{\"id\":\"3G4ZAC9VU+6F\",\"leftBracket\":\"\",\"compareType\":\"501\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3G4ZAC9VTZI6\",\"value\":\"90\"}],\"baseDataIds\":[]}],\"forList\":false}"}', ' ', '清理凭证生成报告分录', '1', ' ', ' ', 'bill', 'opdate < ''2023-05-05 00:00:00''', 1743492853084276736, '0');
INSERT INTO t_cbs_archi_config (fid, fnumber, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fgroupid, fentitynumber, fcondition, fsyncbasedata, fremark, fmovingtype, fconditiontype, farchiveplugin, ffiltertype, fconditiondesc, fbillsetid, fpreset)
VALUES(1743493297462396928, 'ai_newbuildreporthead', 'C', 13466739, 13466739, '1', {ts'2023-08-03 13:29:06'}, {ts'2023-08-03 13:29:06'}, 1743493297462396928, 0, 'ai_newbuildreporthead', '{"bill":"{\"filterRow\":[{\"id\":\"3G7UL9/8IC5W\",\"leftBracket\":\"\",\"compareType\":\"501\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3G7UL9/8G4AT\",\"value\":\"90\"}],\"baseDataIds\":[]}],\"forList\":false}"}', ' ', '清理凭证生成报告', '1', ' ', ' ', 'bill', 'opdate < ''2023-05-06 00:00:00''', 1743492965458069504, '0');
DELETE FROM t_cbs_archi_config_l WHERE fpkid='3G4X7UF5ZEY7';
DELETE FROM t_cbs_archi_config_l WHERE fpkid='3G4X8W3LXXWG';
INSERT INTO t_cbs_archi_config_l (fpkid, fid, flocaleid, fname) values ('3G4X7UF5ZEY7', 1743493297462396928, 'zh_CN', '凭证生成报告');
INSERT INTO t_cbs_archi_config_l (fpkid, fid, flocaleid, fname) values ('3G4X8W3LXXWG', 1743493440681101312, 'zh_CN', '凭证生成报告详细信息');

----清除计划
DELETE FROM t_cbs_archi_schema WHERE fid=1743494876601074688;
DELETE FROM t_cbs_archi_schema WHERE fid=1743493538794260480;
INSERT INTO t_cbs_archi_schema
(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fscheduleplanid, fendtime, fmovingtype, fexecutorid, fexecplan, fpreset)
VALUES(1743494876601074688, 'ARCHIVE_CLN_20230803-133305575_SKDP_S', '清理凭证生成报告分录', 'A', 1, 1, '1', {ts'2023-08-03 13:29:06'}, {ts'2023-08-03 13:29:06'}, 1743494876601074688, '3G4XJMI8LFFX', {ts'2099-08-03 13:33:05'}, '1', 1, 'The event will start on 2023-08-03 13:33:05，Every 1 Weekly’s Saturday 0 Hour(s) Duplicate.
Estimated time of last 10 execution:
2023-08-05 00:33:00,
2023-08-12 00:33:00,
2023-08-19 00:33:00,
2023-08-26 00:33:00,
2023-09-02...', '0');
INSERT INTO t_cbs_archi_schema
(fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fscheduleplanid, fendtime, fmovingtype, fexecutorid, fexecplan, fpreset)
VALUES(1743493538794260480, 'ARCHIVE_CLN_20230803-133026096_SKDP_S', '清理凭证生成报告', 'A', 1, 1, '1', {ts'2023-08-03 13:29:06'}, {ts'2023-08-03 13:29:06'}, 1743493538794260480, '3G4XAPPC+6I5', {ts'2099-08-03 13:30:26'}, '1', 1, 'The event will start on 2023-08-03 13:33:05，Every 1 Weekly’s Saturday 0 Hour(s) Duplicate.
Estimated time of last 10 execution:
2023-08-05 00:30:00,
2023-08-12 00:30:00,
2023-08-19 00:30:00,
2023-08-26 00:30:00,
2023-09-02...', '0');
DELETE FROM t_cbs_archi_schema_l WHERE fpkid='3G4XGYUPL6SZ';
DELETE FROM t_cbs_archi_schema_l WHERE fpkid='3G4XGYUPL6T+';
DELETE FROM t_cbs_archi_schema_l WHERE fpkid='3G4XK1QIJ4M7';
DELETE FROM t_cbs_archi_schema_l WHERE fpkid='3G4XK1QIJ4M8';
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) values ('3G4XGYUPL6SZ', 1743493538794260480, 'zh_CN', '清理凭证生成报告');
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) values ('3G4XGYUPL6T+', 1743493538794260480, 'zh_TW', '清理憑證生成報告');
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) values ('3G4XK1QIJ4M7', 1743494876601074688, 'zh_CN', '清理凭证生成报告分录');
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) values ('3G4XK1QIJ4M8', 1743494876601074688, 'zh_TW', '清理憑證生成報告分錄');
-----清除计划分录
DELETE FROM t_cbs_archi_scheduleentry WHERE fentryid=1743494685357589504;
DELETE FROM t_cbs_archi_scheduleentry WHERE fentryid=1743495114267117568;
INSERT INTO t_cbs_archi_scheduleentry (fid, fentryid, fseq, fconfigid) VALUES (1743493538794260480, 1743494685357589504, 1, 1743493297462396928);
INSERT INTO t_cbs_archi_scheduleentry (fid, fentryid, fseq, fconfigid) VALUES (1743494876601074688, 1743495114267117568, 1, 1743493440681101312);

