DELETE FROM t_cr_coderuleentry WHERE FID IN (SELECT FID FROM T_cr_coderule WHERE FBIZOBJECTID='srm_supplierreg');
DELETE FROM t_cr_coderule_l WHERE FID IN (SELECT FID FROM T_cr_coderule WHERE FBIZOBJECTID='srm_supplierreg');
DELETE FROM T_cr_coderule WHERE FBIZOBJECTID='srm_supplierreg';

DELETE FROM T_CR_CodeRule WHERE FID = '/LVMVLVBUBOZ';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','/LVMVLVBUBOZ','0','0',{ts'2019-01-01  00:00:00'},'srm_supplierreg','1','0','0','1','0','/LVMVLVBUBOZ','1','-','0','C','DL_CODE_RULE',' ','0',1210710027598321664,'0',{ts'2022-07-21  00:00:00'},0); 

DELETE FROM t_cr_coderule_l WHERE FID = '/LVMVLVBUBOZ';
DELETE FROM t_cr_coderule_l WHERE FPKID = '/LVMVLVBUBP/';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('/LVMVLVBUBOZ','/LVMVLVBUBP/','zh_CN','代录入注册供应商编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '2LHVG3AHWM54';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('/LVMVLVBUBOZ','2LHVG3AHWM54','zh_TW','代錄入注冊供應商編碼規則'); 

DELETE FROM T_CR_CODERULEENTRY WHERE FID = '/LVMVLVBUBOZ';
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2LHW6N9OEIWV';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('/LVMVLVBUBOZ',1,'1',' ','0','2LHW6N9OEIWV',1,'1',' ',0,8,'1','DL','1',' ',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2LHW6N9OEIWW';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('/LVMVLVBUBOZ',1,'2','-','1','2LHW6N9OEIWW',1,'1','1',1,8,'1','yyMMdd','1',' ','createtime','1',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '2LHW6N9OEIWX';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('/LVMVLVBUBOZ',1,'16','-','0','2LHW6N9OEIWX',1,'1','1',2,4,'1',' ','1',' ',' ','1',' '); 
