DELETE FROM T_CR_CodeRule WHERE FID = '105GE39L5IC3';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('105GE39L5IC3','1','-',' ',NULL,'2','105GE39L5IC3','C',' ',NULL,' ',{ts'2020-08-31  17:20:10'},'cas_currencyfacevalue','0',13466739,'1',{ts'2020-09-02  17:26:58'},13466739,NULL); 
DELETE FROM T_CR_CodeRule WHERE FID = '11+1IAB0WFZT';
INSERT INTO T_CR_CodeRule(FID,FCTRLMODE,FSPLITSIGN,FEXAMPLE,FDISABLEDATE,FAPPMODE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('11+1IAB0WFZT','1','-',' ',NULL,'2','11+1IAB0WFZT','C',' ',NULL,' ',{ts'2020-09-09  19:41:46'},'cas_cash_verification','0',13466739,'1',{ts'2020-09-09  19:41:46'},13466739,NULL); 

DELETE FROM T_CR_CodeRule_L WHERE FPKID = '105GE39L5/UP';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('105GE39L5IC3','105GE39L5/UP','zh_CN','面额维护的编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '105GE39L5/UO';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('105GE39L5IC3','105GE39L5/UO','zh_TW','麵額維護的編碼規則'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11+1IABED1Q3';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('11+1IAB0WFZT','11+1IABED1Q3','zh_CN','现金盘点处理编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11+1IABED1Q2';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('11+1IAB0WFZT','11+1IABED1Q2','zh_TW','現金盤點處理編碼規則'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEWY36SC=Y';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('105GE39L5IC3',1,'1',' ','0','10BEWY36SC=Y',1,'1',' ',0,8,'1','MESZ',' ','1',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEWY36SC=Z';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('105GE39L5IC3',1,'16','-','0','10BEWY36SC=Z',1,'1','1',1,3,'1',' ',' ','1',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11+1IAEH0U2S';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11+1IAB0WFZT',1,'1',' ','0','11+1IAEH0U2S',1,'1',' ',0,8,'1','XJPD',' ','1',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11+1IAEH0U2T';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11+1IAB0WFZT',1,'2','-','0','11+1IAEH0U2T',1,'1','1',1,8,'1','yyyyMMdd',' ','1','createtime','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11+1IAEH0U2U';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11+1IAB0WFZT',1,'16','-','0','11+1IAEH0U2U',1,'1','1',2,3,'1',' ',' ','1',' ','1',' '); 

