DELETE FROM T_CR_CODERULE WHERE FID = '3=R27ODOP2/K';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3=R27ODOP2/K','0','0',{ts'2023-05-23  00:00:00'},'hdm_parttimebillentry','1','0','0','1','0','3=R27ODOP2/K','-','1','0','C','3=R23E7GQBKO',' ',13466739,'0',{ts'2023-05-23  00:00:00'},0); 
DELETE FROM T_CR_CODERULE WHERE FID = '3=QYB3Q6K98I';
INSERT INTO T_CR_CODERULE(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3=QYB3Q6K98I','0','0',{ts'2023-05-23  00:00:00'},'hdm_batchparttime','1','0','0','1','0','3=QYB3Q6K98I','-','1','0','C','3=QY6RN2EXPF',' ',13466739,'0',{ts'2023-05-23  00:00:00'},0); 
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '3=R27ODOP81X';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=R27ODOP2/K','3=R27ODOP81X','zh_CN','兼职申请单分录编码规则');
DELETE FROM T_CR_CODERULE_L WHERE FPKID = '3=QYB3Q6KE=U';
INSERT INTO T_CR_CODERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=QYB3Q6K98I','3=QYB3Q6KE=U','zh_CN','批量兼职单编码规则');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '3=R27OELZ7YP';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=R27ODOP2/K',1,'1',' ','0','3=R27OELZ7YP',1,'1','1',0,8,'1','EPAR',' ','1',' ','0',' ');
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '3=R27OELZ7YQ';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=R27ODOP2/K',1,'9','-','0','3=R27OELZ7YQ',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '3=R27OELZ7YR';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=R27ODOP2/K',1,'16','-','0','3=R27OELZ7YR',1,'1',' ',2,5,'1',' ',' ','1',' ','1',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '3=QYKTPL+D48';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=QYB3Q6K98I',1,'1',' ','0','3=QYKTPL+D48',1,'1','1',0,8,'1','BPAR',' ','1',' ','0',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '3=QYKTPL+D49';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=QYB3Q6K98I',1,'9','-','0','3=QYKTPL+D49',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '3=QYKTPL+D4=';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=QYB3Q6K98I',1,'16','-','0','3=QYKTPL+D4=',1,'1',' ',2,5,'1',' ',' ','1',' ','1',' ');
