DELETE FROM T_CR_CodeRule WHERE fid = '1S9/6NVSR/7Q';
INSERT INTO T_CR_CodeRule(fid,fctrlmode,fsplitsign,fexample,fdisabledate,fappmode,fisaddview,fmasterid,fstatus,fnumber,fruletype,fexamplelength,fcreatetime,fbizobjectid,fmodifierid,fisupdaterecover,fenable,fmodifytime,fcreatorid,fdisablerid) VALUES ('1S9/6NVSR/7Q','1','-',' ',NULL,'2','1','1S9/6NVSR/7Q','C','1S9+=F3EAXN+',NULL,' ',{ts'2021-07-24  00:00:00'},'fpm_report',0,'0','1',{ts'2021-07-24  00:00:00'},0,NULL); 

DELETE FROM T_CR_CodeRule_L WHERE fpkid = '1S9/6NVWCSJN';
INSERT INTO T_CR_CodeRule_L(fid,fpkid,flocaleid,fname) VALUES ('1S9/6NVSR/7Q','1S9/6NVWCSJN','zh_CN','计划编制表编码规则'); 
DELETE FROM T_CR_CodeRule_L WHERE fpkid = '1S9/6NVWCSJM';
INSERT INTO T_CR_CodeRule_L(fid,fpkid,flocaleid,fname) VALUES ('1S9/6NVSR/7Q','1S9/6NVWCSJM','zh_TW','計劃編製表編碼規則'); 

DELETE FROM T_CR_CodeRuleEntry WHERE fentryid = '1S9/6NXN9A2+';
INSERT INTO T_CR_CodeRuleEntry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1S9/6NVSR/7Q',1,'8',' ','0','1S9/6NXN9A2+',1,'1','3',0,'1',8,' ','1',' ','reportorg.number','0',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE fentryid = '1S9/6NXN9A2/';
INSERT INTO T_CR_CodeRuleEntry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1S9/6NVSR/7Q',1,'9','-','0','1S9/6NXN9A2/',1,'1',' ',1,'1',8,'yyyyMMdd','1',' ',' ','1',' '); 
DELETE FROM T_CR_CodeRuleEntry WHERE fentryid = '1S9/6NXN9A20';
INSERT INTO T_CR_CodeRuleEntry(fid,finitial,fattributetype,fsplitsign,fissortitem,fentryid,fstep,fcutstyle,fattusingmode,fseq,fisvisable,flength,fformat,faddstyle,fsettingvalue,fvalueatribute,fissplitsign,faddchar) VALUES ('1S9/6NVSR/7Q',1,'16','-','0','1S9/6NXN9A20',1,'1',' ',2,'1',3,' ','1',' ',' ','1',' '); 

