-- 利库建议编码规则预置

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '39HNKXHBU7C2';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '39HNKXHBU7C3';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '39HNKXHBU7C4';
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '39I8VD0057OD';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('39HNKXEGEBD6',1,'1',' ','0','39I8VD0057OD',1,'1','1',0,8,'1','LKJY','1',' ',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '39I8VD0057OE';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('39HNKXEGEBD6',1,'9','-','0','39I8VD0057OE',1,'1',' ',1,8,'1','yyMMdd','1',' ',' ','1',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '39I8VD0057OF';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('39HNKXEGEBD6',1,'16','-','0','39I8VD0057OF',1,'1',' ',2,9,'1',' ','1',' ',' ','1',' ');


DELETE FROM T_CR_CodeRule WHERE FID = '39HNKXEGEBD6';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,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,FCONDITIONDESC) VALUES (' ',' ','2','0','0','39HNKXEGEBD6','0','0',{ts'2023-05-09  00:00:00'},'im_balanceinv_advice','1','0','0','1','0','39HNKXEGEBD6','1','-','0','C','39HNGOIV/AOZ',' ','1',1626654663757757440,'0',{ts'2023-05-09  00:00:00'},0,' ');


DELETE FROM T_CR_CodeRule_l WHERE FPKID = '39HNKXEK2UCH';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('39HNKXEGEBD6','39HNKXEK2UCH','zh_CN','利库建议编码规则');
DELETE FROM T_CR_CodeRule_l WHERE FPKID = '39HNKXEK2UCG';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('39HNKXEGEBD6','39HNKXEK2UCG','zh_TW','利庫建議編碼規則');



--平衡利库匹配明细预设编码规则
DELETE FROM T_CR_CodeRule WHERE FID = '3=13FHSI1VBR';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,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,FCONDITIONDESC) VALUES (' ',' ','2','1','0','3=13FHSI1VBR','0','0',{ts'2023-05-15  00:00:00'},'im_balanceinv_matchdetail','1','0','0','1','0','3=13FHSI1VBR','1','-','0','C','3=13D+D4XGO3',' ','1',13466739,'0',{ts'2023-05-15  00:00:00'},0,' '); 

DELETE FROM T_CR_CodeRule_l WHERE FPKID = '3=13FHSI1W0/';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=13FHSI1VBR','3=13FHSI1W0/','zh_CN','平衡利库匹配明细'); 

DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3=13FI/8XWFZ';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=13FHSI1VBR',1,'1',' ','0','3=13FI/8XWFZ',1,'1','1',0,8,'1','PHLKPPMX','1',' ',' ','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3=13FI/8XWG+';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=13FHSI1VBR',1,'9','-','1','3=13FI/8XWG+',1,'1',' ',1,8,'1','yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '3=13FI/8XWG/';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3=13FHSI1VBR',1,'16','-','0','3=13FI/8XWG/',1,'1',' ',2,8,'1',' ','1',' ',' ','1',' '); 
