/** 额度申请单 默认单据类型**/
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1139881680866165760;
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 (1139881680866165760,'0','0',NULL,'1',' ','0',1139881680866165760,'C','er_reimctlapplybill',1,' ',' ','er_reimctlapplybill_BT_S',{ts'2021-04-22  17:39:17'},'17YFYBMXCXDW',NULL,1063622672501573632,'1',{ts'2021-04-22  17:41:32'},'0',1063622672501573632); 

/**多语言**/
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1K/1+=N3QHXL';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1139881680866165760,'1K/1+=N3QHXL','zh_CN','额度申请','额度申请'); 
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1K/1+=N3QHXM';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1139881680866165760,'1K/1+=N3QHXM','zh_TW','額度申請','額度申請'); 



/**编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '1K/05VQP86VY';
INSERT INTO t_cr_coderule(FID,FSPLITSIGN,FCTRLMODE,FEXAMPLE,FAPPMODE,FDISABLEDATE,FMASTERID,FSTATUS,FNUMBER,FRULETYPE,FEXAMPLELENGTH,FCREATETIME,FBIZOBJECTID,FENABLE,FMODIFIERID,FISUPDATERECOVER,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES ('1K/05VQP86VY','-','1',' ','2',NULL,'1K/05VQP86VY','C','1K//H+28YZHI',NULL,' ',{ts'2021-04-22  17:32:51'},'er_reimctlapplybill','1',1063622672501573632,'0',{ts'2021-04-28  19:15:07'},0,NULL); 

/**多语言**/
DELETE FROM t_cr_coderule_l WHERE FPKID = '1K/05VQP67FF';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1K/05VQP86VY','1K/05VQP67FF','zh_CN','额度申请单编号规则');
DELETE FROM t_cr_coderule_l WHERE FPKID = '1KJ3AJO6XSIE';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1K/05VQP86VY','1KJ3AJO6XSIE','zh_TW','額度申請單編碼規則'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KJ3AJQPU/DI';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1K/05VQP86VY',1,'1',' ','0','1KJ3AJQPU/DI',1,'1','1',0,8,'1','EDSQ',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KJ3AJQPU/DJ';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1K/05VQP86VY',1,'2','-','1','1KJ3AJQPU/DJ',1,'1',' ',1,8,'1','yyMMdd',' ','1','bizdate','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1KJ3AJQPU/DK';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1K/05VQP86VY',1,'16','-','0','1KJ3AJQPU/DK',1,'1',' ',2,4,'1',' ',' ','1',' ','1',' '); 





/** 额度申请单 费用单据类型新增一条数据**/
DELETE FROM t_er_billtype WHERE FID = 1144311016692182016;
INSERT INTO t_er_billtype(FID,FCREATEORGID,FORGID,FMASTERID,FSTATUS,FCTRLSTRATEGY,FNAME,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID) VALUES (1144311016692182016,0,0,1144311016692182016,'C',' ','额度申请单','er_reimctlapplybill',{ts'2021-04-28  20:21:22'},'1',1063622672501573632,{ts'2021-04-28  20:21:43'},1063622672501573632); 

DELETE FROM t_er_billtype_l WHERE FPKID = '1KJ9KSYG2APP';
INSERT INTO t_er_billtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1144311016692182016,'1KJ9KSYG2APP','zh_CN','额度申请单'); 



/**特殊数据权限 **/
DELETE FROM t_perm_operationrule WHERE FID = '1KIOKG+TBD0I';
INSERT INTO t_perm_operationrule(FID,FRULE,FENABLED,FOPERATIONTYPE,FBIZAPPID,FISPUBLIC,FENTITYTYPEID) VALUES ('1KIOKG+TBD0I','{"filterRow":[{"id":"1KIOKG+TBD0F","leftBracket":"","compareType":"103","fieldName":"creator.number","rightBracket":"","logic":"1","value":[{"id":"1KIOKG+TBCC6","value":""}],"baseDataIds":[]},{"id":"1KIOKG+TBD0G","leftBracket":"","compareType":"103","fieldName":"applier.number","rightBracket":"","logic":"1","value":[{"id":"1KIOKG+TBCC7","value":""}],"baseDataIds":[]},{"id":"1KIOKG+TBD0H","leftBracket":"","compareType":"953718393159160832","fieldName":"creator.number","rightBracket":"","logic":"0","value":[{"id":"1KIOKG+TBCC8","value":""}],"baseDataIds":[]}],"forList":false}','1','view','18X6P1ZSXS44','0','er_reimctlapplybill'); 

DELETE FROM t_perm_operationruleobj WHERE FID = '1KIOT0RYAO6S';
INSERT INTO t_perm_operationruleobj(FID,FOPERATIONRULEID,FBIZAPPID,FSEQ,FOBJENABLED,FENTITYTYPEID) VALUES ('1KIOT0RYAO6S','1KIOKG+TBD0I','18X6P1ZSXS44',0,'1','er_reimctlapplybill'); 

DELETE FROM t_perm_operationrule_l WHERE FPKID = '1KIOKG+TBCC9';
INSERT INTO t_perm_operationrule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1KIOKG+TBD0I','1KIOKG+TBCC9','zh_CN','额度申请单查看特殊数据权限'); 
