/*商旅付款申请单编号规则预置 2019/12/06  */
delete from T_CR_CODERULE where fid = '0E6XE+TNWBS6';
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 ('0E6XE+TNWBS6', ' ', NULL, 'er_checkingpaybill', '-', '1', '2', ' ', ' ', '1', 'C', '467068', {ts'2019-12-06 13:50:48'}, '467068', {ts'2019-12-06 13:51:25'}, NULL, NULL, '0E6XE+TNWBS6', '0');

delete from T_CR_CODERULE_L where fid = '0E6XE+TNWBS6';
INSERT INTO T_CR_CODERULE_L ( FPKID ,  FID ,  FLOCALEID ,  FNAME ) VALUES ('0E6XE+TNWB2Z', '0E6XE+TNWBS6', 'zh_CN', '商旅付款申请单编号规则');

delete from t_cr_coderuleentry where fid = '0E6XE+TNWBS6';
INSERT INTO  t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0E6XG8TJXQKJ', '0E6XE+TNWBS6', '0', '1', ' ', ' ', 'SLFK', ' ', '8', '1', '1', ' ', '0', '1', '1', '0', ' ', '1');
INSERT INTO  t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0E6XG8TJXQKK', '0E6XE+TNWBS6', '1', '2', '1', 'bizdate', 'yyMMdd', ' ', '8', '1', '1', ' ', '1', '1', '1', '0', '-', '1');
INSERT INTO  t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0E6XG8TJXQKL', '0E6XE+TNWBS6', '2', '16', '1', ' ', ' ', ' ', '5', '1', '1', ' ', '1', '1', '1', '0', '-', '1');
