DELETE FROM t_cr_coderule WHERE FID='0MUX2IS3D22C';
INSERT INTO t_cr_coderule (FID, FNUMBER, FRULETYPE, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISUPDATERECOVER) VALUES ('0MUX2IS3D22C', ' ', NULL, 'srm_supplier', '-', '1', '2', ' ', ' ', '1', 'C', 13466739, {ts'2020-03-12 15:03:19'}, 13466739, {ts'2020-03-12 15:03:19'}, NULL, NULL, '0MUX2IS3D22C', '0');
DELETE FROM t_cr_coderule_l WHERE FPKID='0MUX2IS7/GLN';
INSERT INTO t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('0MUX2IS7/GLN', '0MUX2IS3D22C', 'zh_CN', '供应商查询编码规则');
DELETE FROM t_cr_coderule_l WHERE FPKID='0MUX2IS7/GLM';
INSERT INTO t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME) VALUES ('0MUX2IS7/GLM', '0MUX2IS3D22C', 'zh_TW', '供應商查詢編碼規則');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID='0MUX2JBPHZ7Q';
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0MUX2JBPHZ7Q', '0MUX2IS3D22C', 0, '1', ' ', ' ', 'ZC', ' ', 8, 1, 1, ' ', '0', '1', '1', '0', ' ', '1');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID='0MUX2JBPHZ7R';
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0MUX2JBPHZ7R', '0MUX2IS3D22C', 1, '2', '1', 'createtime', 'yyyyMMdd', ' ', 8, 1, 1, ' ', '1', '1', '1', '1', '-', '1');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID='0MUX2JBPHZ7S';
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0MUX2JBPHZ7S', '0MUX2IS3D22C', 2, '16', '1', ' ', ' ', ' ', 4, 1, 1, ' ', '1', '1', '1', '0', '-', '1');