/** 预付单 默认单据类型**/
DELETE FROM T_BAS_BILLTYPE WHERE FID = 1118092363726588928;
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 (1118092363726588928,'0','0',NULL,'1',' ','0',1118092363726588928,'C','er_prepaybill',1,' ',' ','er_prepaybill_BT_S',{ts'2021-03-23 16:06:58'},'XYK5T7CWXXO0',NULL,1063622153817286656,'1',{ts'2021-03-23 16:32:21'},'0',1063622153817286656); 

/**多语言*/
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1HANQXWPF8NX';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1118092363726588928,'1HANQXWPF8NX','zh_CN',' ','预付单'); 
DELETE FROM T_BAS_BILLTYPE_L WHERE FPKID = '1HANQXWPF8NY';
INSERT INTO T_BAS_BILLTYPE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1118092363726588928,'1HANQXWPF8NY','zh_TW',' ','預付單'); 



/**编号规则**/
DELETE FROM t_cr_coderule WHERE FID = '1GLIV15=JNLU';
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 ('1GLIV15=JNLU','-','1',' ','2',NULL,'1GLIV15=JNLU','C','1GLIJ8/JUSD2',NULL,' ',{ts'2021-03-15 13:46:07'},'er_prepaybill','1',1063622153817286656,'0',{ts'2021-03-15 13:47:07'},0,NULL); 
/**多语言*/
DELETE FROM t_cr_coderule_l WHERE FPKID = '1GLIV15=PL70';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1GLIV15=JNLU','1GLIV15=PL70','zh_CN','预付单'); 

DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GLIYODPI=4L';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1GLIV15=JNLU',1,'1',' ','0','1GLIYODPI=4L',1,'1','1',0,8,'1','PP',' ','1',' ','0',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GLIYODPI=4M';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1GLIV15=JNLU',1,'2','-','0','1GLIYODPI=4M',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','1',' ');
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '1GLIYODPI=4N';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('1GLIV15=JNLU',1,'16','-','0','1GLIYODPI=4N',1,'1',' ',2,4,'1',' ',' ','1',' ','1',' ');






/** 预付单 费用单据类型新增一条数据**/
DELETE FROM t_er_billtype WHERE FID = 1113568000750927872;
INSERT INTO t_er_billtype(FID,FCREATEORGID,FORGID,FMASTERID,FSTATUS,FCTRLSTRATEGY,FNAME,FNUMBER,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID) VALUES (1113568000750927872,0,0,1113568000750927872,'C',' ','预付单','er_prepaybill',{ts'2021-03-17 10:20:32'},'1',1063622153817286656,{ts'2021-03-17 10:20:50'},1063622153817286656); 

DELETE FROM t_er_billtype_l WHERE FPKID = '1GS+CZKQP/U4';
INSERT INTO t_er_billtype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1113568000750927872,'1GS+CZKQP/U4','zh_CN','预付单'); 



/**特殊数据权限 */
DELETE FROM t_perm_operationrule WHERE FID = '1I3/ODF1UX=Y';
INSERT INTO t_perm_operationrule(FID,FRULE,FENABLED,FOPERATIONTYPE,FBIZAPPID,FISPUBLIC,FENTITYTYPEID) VALUES ('1I3/ODF1UX=Y','{"filterRow":[{"id":"1I3/MA12DZ29","leftBracket":"","compareType":"103","fieldName":"applier.number","rightBracket":"","logic":"1","value":[{"id":"1I3/MA12K1E0","value":""}],"baseDataIds":[]},{"id":"1I3/MA12DZ2=","leftBracket":"","compareType":"103","fieldName":"creator.number","rightBracket":"","logic":"1","value":[{"id":"1I3/MA12K1E1","value":""}],"baseDataIds":[]},{"id":"1I3/MA12DZ2A","leftBracket":"","compareType":"953718393159160832","fieldName":"creator.number","rightBracket":"","logic":"0","value":[{"id":"1I3/MA12K1E2","value":""}],"baseDataIds":[]}],"forList":false}','1','view','1GARA29DA8+R','0','er_prepaybill');

DELETE FROM t_perm_operationruleobj WHERE FID = '1I3/PC2WW5KG';
INSERT INTO t_perm_operationruleobj(FID,FOPERATIONRULEID,FBIZAPPID,FSEQ,FOBJENABLED,FENTITYTYPEID) VALUES ('1I3/PC2WW5KG','1I3/ODF1UX=Y','1GARA29DA8+R',0,'1','er_prepaybill');

DELETE FROM t_perm_operationrule_l WHERE FPKID = '1I3/ODF2//MP';
INSERT INTO t_perm_operationrule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1I3/ODF1UX=Y','1I3/ODF2//MP','zh_CN','预付单特殊数据查看权限');








