/**合同变更单默认 单据类型**/

DELETE FROM T_BAS_BILLTYPE WHERE FID = 1439007580596060160;
INSERT INTO T_BAS_BILLTYPE(FID,FISSYSPRESET,FDOCUMENTSTATUS,FDEFWNREPORTTEMPLATE,FISDEFAULT,FDEFPRINTTEMPLATE,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FBILLFORMID,FMAXPRINTCOUNT,FBILLCODERULEID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FPARASETTINGXML,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (1439007580596060160,'0','0',NULL,'0',' ','0',1439007580596060160,'C','er_contractbill',1,' ',' ','er_changecontractbill_BT_S',{ts'2018-08-08 00:00:00'},'2FMX31/D5TCL',NULL,1155765943016650752,'1',{ts'2018-08-08 00:00:00'},'0',1155765943016650752);

DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '2HR4CM1WTEOT';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1439007580596060160,'2HR4CM1WTEOT','zh_CN',' ','合同变更');
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '2HR4CM1WTEOU';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1439007580596060160,'2HR4CM1WTEOU','zh_TW',' ','合同變更');


/** 合同台账 编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '2I3U5N91ZUYF';
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,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','1','2I3U5N91ZUYF','0',NULL,'0',{ts'2018-08-08 00:00:00'},'er_contractbill','1','0','0','1',NULL,'0','2I3U5N91ZUYF','-','1',NULL,'0','C','2I3RMUWOEIYC',' ','1',1155765943016650752,'1',{ts'2018-08-08 00:00:00'},0);
DELETE FROM t_cr_coderule WHERE FID = '2FC+MLL=KA/7';
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,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','1','2FC+MLL=KA/7','0',NULL,'0',{ts'2018-08-08 00:00:00'},'er_contractbill','1','0','0','1',NULL,'0','2FC+MLL=KA/7','-','1',NULL,'0','C','2FC+GYT3XM49',' ','1',1155765943016650752,'1',{ts'2018-08-08 00:00:00'},0);

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I3WF/9X5X2L';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I3U5N91ZUYF',1,'1',' ','0','2I3WF/9X5X2L',1,'1','1',0,8,'1','HTBG',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I3WF/9X5X2M';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I3U5N91ZUYF',1,'9','-','0','2I3WF/9X5X2M',1,'1',' ',1,8,'1','yyyyMMdd',' ','1',' ','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I3WF/9X5X2N';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2I3U5N91ZUYF',1,'16','-','0','2I3WF/9X5X2N',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I3WDYWV=2Y0';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2FC+MLL=KA/7',1,'1',' ','0','2I3WDYWV=2Y0',1,'1','1',0,8,'1','HTTZ',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I3WDYWV=2Y1';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2FC+MLL=KA/7',1,'2','-','0','2I3WDYWV=2Y1',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','bizdate','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '2I3WDYWV=2Y2';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('2FC+MLL=KA/7',1,'16','-','0','2I3WDYWV=2Y2',1,'1',' ',2,6,'1',' ',' ','1',' ','1',' ');

DELETE FROM t_cr_coderule_l WHERE FPKID = '2FC+MLL=M7QO';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2FC+MLL=KA/7','2FC+MLL=M7QO','zh_CN','合同台账单');

DELETE FROM t_cr_coderule_l WHERE FPKID = '2I3U5N95H2W6';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2I3U5N91ZUYF','2I3U5N95H2W6','zh_CN','合同变更单');

/** 编号规则适用条件属性 **/

DELETE FROM t_cr_appcondpro WHERE FID = '2I3VRZLZAPNK';
INSERT INTO t_cr_appcondpro(FID,FBIZOBJECTID,FNUMBER) VALUES ('2I3VRZLZAPNK','er_contractbill','detailtype');

DELETE FROM t_cr_appcondpro_l WHERE FPKID = '2I3VRZLZEVXC';
INSERT INTO t_cr_appcondpro_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2I3VRZLZAPNK','2I3VRZLZEVXC','zh_CN',' ','合同申请类型');
DELETE FROM t_cr_appcondpro_l WHERE FPKID = '2I3VRZLZEVXD';
INSERT INTO t_cr_appcondpro_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2I3VRZLZAPNK','2I3VRZLZEVXD','zh_TW',' ','合同申請類型');


/** 编号规则适用条件属性值 **/
DELETE FROM t_cr_appcondprovalue WHERE FID = '2I3VU=R=ZD7+';
INSERT INTO t_cr_appcondprovalue(FID,FVALUE,FAPPCONDPROID) VALUES ('2I3VU=R=ZD7+','biztype_applybill','2I3VRZLZAPNK');
DELETE FROM t_cr_appcondprovalue WHERE FID = '2I3VVYW1=XJA';
INSERT INTO t_cr_appcondprovalue(FID,FVALUE,FAPPCONDPROID) VALUES ('2I3VVYW1=XJA','biztype_changebill','2I3VRZLZAPNK');


DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '2I3VU=R=V7Z6';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2I3VU=R=ZD7+','2I3VU=R=V7Z6','zh_CN',' ','合同申请');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '2I3VU=R=V7Z7';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2I3VU=R=ZD7+','2I3VU=R=V7Z7','zh_TW',' ','合同申請');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '2I3VVYW16R=I';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2I3VVYW1=XJA','2I3VVYW16R=I','zh_CN',' ','合同变更');
DELETE FROM t_cr_appcondprovalue_l WHERE FPKID = '2I3VVYW16R=J';
INSERT INTO t_cr_appcondprovalue_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2I3VVYW1=XJA','2I3VVYW16R=J','zh_TW',' ','合同變更');


/** 编号规则适用条件基础资料列表**/
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '2FC+MLL=KA/7';
INSERT INTO T_CR_AppCondition(FID,FPROPERTY,FENTRYID,FSEQ,FPROPERTYVALUE) VALUES ('2FC+MLL=KA/7','2I3VRZLZAPNK','2FC+MLL=KA/7',1,'2I3VU=R=ZD7+');
DELETE FROM T_CR_AppCondition WHERE FENTRYID = '2I3U5N91ZUYF';
INSERT INTO T_CR_AppCondition(FID,FPROPERTY,FENTRYID,FSEQ,FPROPERTYVALUE) VALUES ('2I3U5N91ZUYF','2I3VRZLZAPNK','2I3U5N91ZUYF',1,'2I3VVYW1=XJA');
