/*差旅报销(卡片+表格)*/
/*特殊数据权限*/
DELETE FROM t_perm_operationrule WHERE FID = '4EUCOQQW+I46';
INSERT INTO t_perm_operationrule(FID,FRULE,FOPERATIONKEY,FENABLED,FOPERATIONTYPE,FISPRESET,FBIZAPPID,FISPUBLIC,FENTITYTYPEID) VALUES ('4EUCOQQW+I46','{"filterRow":[{"id":"4EUCT8EO777P","leftBracket":"","compareType":"103","fieldName":"applier.number","rightBracket":"","logic":"1","value":[{"id":"4EUCT8EOACGH","value":""}],"baseDataIds":[],"lock":false},{"id":"4EUCT8EO777Q","leftBracket":"","compareType":"103","fieldName":"creator.number","rightBracket":"","logic":"1","value":[{"id":"4EUCT8EOACGI","value":""}],"baseDataIds":[],"lock":false},{"id":"4EUCT8EO777R","leftBracket":"","compareType":"106","fieldName":"org.number","rightBracket":"","logic":"0","value":[{"id":"4EUCT8EOACGJ","value":""}],"baseDataIds":[],"lock":false}],"forList":false}','view','1','view','0','0HAJN6NF6DOV','0','er_tripreimburse_cardgrid');
DELETE FROM t_perm_operationrule WHERE FID = '4ECWGSIOES3R';
INSERT INTO t_perm_operationrule(FID,FRULE,FOPERATIONKEY,FENABLED,FOPERATIONTYPE,FISPRESET,FBIZAPPID,FISPUBLIC,FENTITYTYPEID) VALUES ('4ECWGSIOES3R','{"filterRow":[{"id":"4ECWJ1S6YQLG","leftBracket":"","compareType":"103","fieldName":"creator.number","rightBracket":"","logic":"1","value":[{"id":"4EUCK0AU79DJ","value":""}],"baseDataIds":[],"lock":false},{"id":"4ECWJ1S=K4T+","leftBracket":"","compareType":"103","fieldName":"applier.number","rightBracket":"","logic":"1","value":[{"id":"4EUCK0AUAENB","value":""}],"baseDataIds":[],"lock":false},{"id":"4EUCK0AU79DK","leftBracket":"","compareType":"106","fieldName":"org.number","rightBracket":"","logic":"0","value":[{"id":"4EUCK0AUAENC","value":""}],"baseDataIds":[],"lock":false}],"forList":false}','view','1','view','0','18XD+/5EDN8X','0','er_tripreimburse_cardgrid');
DELETE FROM t_perm_operationrule_l WHERE FID = '4ECWGSIOES3R' and FLOCALEID = 'zh_CN';
INSERT INTO t_perm_operationrule_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('4ECWGSIOES3R','4ECWJYUJ0MT5','zh_CN',' ','员工查询全球差旅报销单');
DELETE FROM t_perm_operationrule_l WHERE FID = '4EUCOQQW+I46' and FLOCALEID = 'zh_CN';
INSERT INTO t_perm_operationrule_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('4EUCOQQW+I46','4EUCT8GBGOOZ','zh_CN',' ','查询全球差旅报销单');

/*费用单据类型*/
DELETE FROM t_er_billType WHERE FID = 2037871248670832640;
INSERT INTO t_er_billType(FID,FBITINDEX,FSRCCREATEORGID,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FBILLNUMBER,FCTRLSTRATEGY,FNUMBER,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FISPRESET,FBIZAPPID,FMODIFYTIME,FCREATORID) VALUES (2037871248670832640,0,0,0,0,2037871248670832640,0,'C','er_tripreimburse_cardgrid',' ','er_tripreimburse_cardgrid',{ts'2024-09-12  00:00:00'},0,1924690409268082688,'1','0','10MYBGBYHXDU',{ts'2024-09-12  00:00:00'},1924690409268082688);
DELETE FROM t_er_billType_l WHERE FID = 2037871248670832640 and FLOCALEID = 'zh_CN';
INSERT INTO t_er_billType_l(FID,FPKID,FLOCALEID,FNAME) VALUES (2037871248670832640,'4DA8GY==LNYF','zh_CN','全球差旅报销单');


/*编码规则*/
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '4GV/7FTVWXEU';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('4FPK8UPGWZQY',1,'1',' ','0','4GV/7FTVWXEU',1,'1',' ',0,8,'1','QQCLBX','1',' ',' ','0',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '4GV/7FTVWXEV';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('4FPK8UPGWZQY',1,'2','-','0','4GV/7FTVWXEV',1,'1',' ',1,8,'1','yyyyMMdd','1',' ','bizdate','1',' ');
DELETE FROM T_CR_CodeRuleEntry WHERE FENTRYID = '4GV/7FTVWXEW';
INSERT INTO T_CR_CodeRuleEntry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('4FPK8UPGWZQY',1,'16','-','0','4GV/7FTVWXEW',1,'1',' ',2,8,'1',' ','1',' ',' ','1',' ');
DELETE FROM T_CR_CodeRule WHERE FID = '4FPK8UPGWZQY';
INSERT INTO T_CR_CodeRule(FFILTERCONDITION,FUPDATEMAXNUMBER,FISMATCHCODERULE,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FISCHECKNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISFILLWITHZERO,FISLOG,FSTATUS,FISAUTOINCRLENGTH,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FISPRESET,FUSEINTERRUPTION,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES (' ',' ','0',' ','2','1','0','4FPK8UPGWZQY','0','0',{ts'2024-10-09  00:00:00'},'er_tripreimburse_cardgrid','1','0','1','1','0','0','4FPK8UPGWZQY','1','-','1','0','C','0','4FPK1CB514XI',' ','1',1924690409268082688,'1','0',' ',{ts'2024-10-22  00:00:00'},13466739,' ');
DELETE FROM T_CR_CodeRule_l WHERE FID = '4FPK8UPGWZQY' and FLOCALEID = 'zh_CN';
INSERT INTO T_CR_CodeRule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('4FPK8UPGWZQY','4FPK8UPKIC96','zh_CN','差旅报销单(全球)');

/*单据类型*/
DELETE FROM T_BAS_BILLTYPE WHERE FID = 2036442588743300096;
INSERT INTO T_BAS_BILLTYPE(FID,FISDEFAULT,FDEFPRINTTEMPLATE,FLAYOUTSOLUTIONMOB,FCONTROLPRINTCOUNT,FMASTERID,FSTATUS,FMAXPRINTCOUNT,FBILLFORMID,FBILLINITSETTING,FNUMBER,FCREATETIME,FLAYOUTSOLUTION,FMODIFIERID,FENABLE,FMODIFYTIME,FPRINTAFTERAUDIT,FCREATORID) VALUES (2036442588743300096,'1',' ',' ','0',2036442588743300096,'C',1,'er_tripreimburse_cardgrid',' ','er_tripreimbursebill_n_BT_S',{ts'2024-09-10  00:00:00'},'49YVIC/QUKV2',1924690409268082688,'1',{ts'2024-10-22  00:00:00'},'0',1924690409268082688);
DELETE FROM T_BAS_BILLTYPE_l WHERE FID = 2036442588743300096 and FLOCALEID = 'zh_CN';
INSERT INTO T_BAS_BILLTYPE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (2036442588743300096,'4D4DJA2636W/','zh_CN',' ','全球差旅报销单');



/*交通工具管控视图*/
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 2076248893712194560;
INSERT INTO T_BD_DefaultCtrlStrategy(FMASTERID,FCREATETIME,FUPGRADESTATUS,FENABLE,FISSYNCDATA,FMASTERIDPROPNAME,FAUTOASSIGN,FCHECKSTATUS,FDISABLERID,FISSYSTEM,FENABLESOLIDIFY,FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FSOLIDIFYSTATUS,FASSIGNUNDETAIL,FDATATYPE,FSOLIDIFYOBJ,FDISABLEDATE,FSTATUS,FAPPSYSTEMID,FISLOCKVIEW,FMASTERIDFIELDNAME,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID) VALUES (2076248893712194560,{ts'2024-11-04  00:00:00'},'2','1','0','masterid','0','1',0,'0','0',2076248893712194560,1,'1','0','0','2',' ',NULL,'A','10MYBGBYHXDU','0','fmasterid',' ','5','er_trip_vehicle_standard',1,' ',{ts'2024-11-04  00:00:00'},1);