DELETE FROM t_cr_coderule WHERE FID = '20DX1I07M68T';
INSERT INTO t_cr_coderule(FISADDVIEW,FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1','20DX1I07M68T','-','1',' ','2',NULL,'20DX1I07M68T','C','pmbd_projectstage',NULL,' ',{ts'2021-11-15  00:00:00'},'pmbd_projectstage','1',0,'0',{ts'2021-11-15  00:00:00'},22129013,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '20DXMAU=1OIP';
INSERT INTO t_cr_coderule(FISADDVIEW,FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1','20DXMAU=1OIP','-','1',' ','2',NULL,'20DXMAU=1OIP','C','pmbd_projectwbstype',NULL,' ',{ts'2021-11-15  00:00:00'},'pmbd_projectwbstype','1',0,'0',{ts'2021-11-15  00:00:00'},22129013,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '20DY52UJ45T8';
INSERT INTO t_cr_coderule(FISADDVIEW,FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1','20DY52UJ45T8','-','1',' ','2',NULL,'20DY52UJ45T8','C','pmbd_jobtype',NULL,' ',{ts'2021-11-15  00:00:00'},'pmbd_jobtype','1',0,'0',{ts'2021-11-15  00:00:00'},22129013,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '1+X/DNV9J+PQ';
INSERT INTO t_cr_coderule(FISADDVIEW,FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1','1+X/DNV9J+PQ','-','1',' ','2',NULL,'1+X/DNV9J+PQ','C','pmbd_calendar',NULL,' ',{ts'2020-08-17  00:00:00'},'pmbd_calendar','1',22129013,'0',{ts'2021-11-15  00:00:00'},11850374,NULL); 
DELETE FROM t_cr_coderule WHERE FID = '20EN9CMEZ3H8';
INSERT INTO t_cr_coderule(FISADDVIEW,FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1','20EN9CMEZ3H8','-','1',' ','2',NULL,'20EN9CMEZ3H8','C','pmbd_orgpros',NULL,' ',{ts'2021-11-15  00:00:00'},'pmbd_orgpros','1',0,'0',{ts'2021-11-15  00:00:00'},22129013,NULL); 


DELETE FROM t_cr_coderule_l WHERE FPKID = '1+X/DNV9KD8I';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1+X/DNV9J+PQ','1+X/DNV9KD8I','zh_CN','项目日历编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '20DX1I07KCJW';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('20DX1I07M68T','20DX1I07KCJW','zh_CN','项目阶段'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '20DXMAU=/VUS';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('20DXMAU=1OIP','20DXMAU=/VUS','zh_CN','项目WBS类型'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '20DY52UJ2C3A';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('20DY52UJ45T8','20DY52UJ2C3A','zh_CN','任务类型'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '20EN9CMF+Y65';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('20EN9CMEZ3H8','20EN9CMF+Y65','zh_CN','企业项目结构'); 


DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20DX1I1ERKRG';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20DX1I07M68T',1,'1',' ','0','20DX1I1ERKRG',1,'1','1',0,8,'1','XMJD',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20DX1I1ERKRH';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20DX1I07M68T',1,'16','-','0','20DX1I1ERKRH',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20DXMAUNKB=R';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20DXMAU=1OIP',1,'1',' ','0','20DXMAUNKB=R',1,'1','1',0,8,'1','WBSLX',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20DXMAUNKB=S';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20DXMAU=1OIP',1,'16','-','0','20DXMAUNKB=S',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20DY52V2WNZA';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20DY52UJ45T8',1,'1',' ','0','20DY52V2WNZA',1,'1','1',0,8,'1','RWLX',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20DY52V2WNZB';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20DY52UJ45T8',1,'16','-','0','20DY52V2WNZB',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' '); 

--由于1.5.50脚本有执行过编码规则，先将1.5.50的删除掉，不然可能会生成4个分录规则  kd_1.5.50_pmbd_coderule.sql
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1+X/DNXHJZB0';
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1+X/DNXHJZB1';

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20EKERNZFJ8M';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1+X/DNV9J+PQ',1,'1',' ','0','20EKERNZFJ8M',1,'1',' ',0,8,'1','XMRL',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20EKERNZFJ8N';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1+X/DNV9J+PQ',1,'16','-','0','20EKERNZFJ8N',1,'1','1',1,8,'1',' ',' ','1',' ','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20EN9CNFUOLW';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20EN9CMEZ3H8',1,'1',' ','0','20EN9CNFUOLW',1,'1','1',0,8,'1','XMJG',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '20EN9CNFUOLX';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('20EN9CMEZ3H8',1,'16','-','0','20EN9CNFUOLX',1,'1',' ',1,6,'1',' ',' ','1',' ','1',' '); 


