-- kd_1.5.57_cas_cashcount_coderule.sql
DELETE FROM T_CR_CodeRule WHERE FID = '105GE39L5IC3';
DELETE FROM T_CR_CodeRule WHERE FID = '10BEOKOBKXYC';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '105GE39L5/UP';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '105GE39L5/UO';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10BEOKOBKTWV';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10BEOKOBKTWU';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEWY36SC=Y';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEWY36SC=Z';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEOKQ=QN+4';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEOKQ=QN+5';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEOKQ=QN+6';

-- kd_1.5.57_1_cas_cashcount_coderule.sql
DELETE FROM T_CR_CodeRule WHERE FID = '10ZEWKAGTMS0';
DELETE FROM T_CR_CodeRule WHERE FID = '10ZLP+PSWG=H';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZEWKAGUDDB';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZEWKAGUDDA';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZLP+PWHX5=';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZLP+PWHX59';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZEWYJU3ANW';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZEWYJU3ANX';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZEWYJU3ANY';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZLPB0M/X/P';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZLPB0M/X/Q';

-- kd_1.5.57_2_cas_cashcount_coderule.sql
DELETE FROM T_CR_CodeRule WHERE FID = '10ZEWKAGTMS0';
DELETE FROM T_CR_CodeRule WHERE FID = '10ZLP+PSWG=H';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZEWKAGUDDB';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZEWKAGUDDA';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZLP+PWHX5=';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '10ZLP+PWHX59';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZEWYJU3ANW';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZEWYJU3ANX';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZEWYJU3ANY';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZLPB0M/X/P';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10ZLPB0M/X/Q';

-- kd_1.5.57_3_cas_cashcount_coderule.sql
DELETE FROM T_CR_CodeRule WHERE FID = '105GE39L5IC3';
DELETE FROM T_CR_CodeRule WHERE FID = '11+1IAB0WFZT';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '105GE39L5/UP';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '105GE39L5/UO';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11+1IABED1Q3';
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11+1IABED1Q2';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEWY36SC=Y';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '10BEWY36SC=Z';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11+1IAEH0U2S';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11+1IAEH0U2T';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11+1IAEH0U2U';

--- 新的数据
DELETE FROM T_CR_CodeRule WHERE FID = '11S9BPHXBXXH';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','11S9BPHXBXXH','0',NULL,'0',{ts'2020-09-18  19:20:55'},'cas_cash_verification','1','0','0','1',NULL,'0','11S9BPHXBXXH','-','1',NULL,'0','C','11S9=K7FG29F',' ',0,'0',{ts'2020-09-18  19:20:55'},0); 
DELETE FROM T_CR_CodeRule WHERE FID = '11S9ELTN27PF';
INSERT INTO T_CR_CodeRule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','11S9ELTN27PF','0',NULL,'0',{ts'2020-09-18  19:21:43'},'cas_currencyfacevalue','1','0','0','1',NULL,'0','11S9ELTN27PF','-','1',NULL,'0','C','11S9CU+3S+UY',' ',0,'0',{ts'2020-09-18  19:21:43'},0); 

DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11S9BPHXBYKS';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('11S9BPHXBXXH','11S9BPHXBYKS','zh_CN','现金盘点编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11S9BPHXBYKR';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('11S9BPHXBXXH','11S9BPHXBYKR','zh_TW','現金盤點編碼規則'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11S9ELTQPM7Q';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('11S9ELTN27PF','11S9ELTQPM7Q','zh_CN','货币面额编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '11S9ELTQPM7P';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('11S9ELTN27PF','11S9ELTQPM7P','zh_TW','貨幣麵額編碼規則'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11S9BPJKMDCQ';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11S9BPHXBXXH',1,'1',' ','0','11S9BPJKMDCQ',1,'1','1',0,8,'1','XJPD',' ','1',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11S9BPJKMDCR';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11S9BPHXBXXH',1,'9','-','0','11S9BPJKMDCR',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11S9BPJKMDCS';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11S9BPHXBXXH',1,'16','-','0','11S9BPJKMDCS',1,'1',' ',2,3,'1',' ',' ','1',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11S9ELVSGS48';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11S9ELTN27PF',1,'1',' ','0','11S9ELVSGS48',1,'1','1',0,8,'1','MESZ',' ','1',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '11S9ELVSGS49';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('11S9ELTN27PF',1,'16','-','0','11S9ELVSGS49',1,'1',' ',1,3,'1',' ',' ','1',' ','1',' '); 

