--中英文质量整改-预置数据
--kd_1.5.0_bei_data_importtemplate_add.sql
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588145071430393857;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (588145943023567872,'currency','1','1',588145071430393857,'币种*','number',588145071380087808,' ',7,'1'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588145071505916928;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (588145943023567872,'basecurrency','0','0',588145071505916928,'本位币币种','number',588145071380087808,' ',34,'1'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588228193283064834;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (588228947217571840,'currency','1','1',588228193283064834,'币种*','number',588228192620339200,' ',7,'1'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588228193299816454;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (588228947217571840,'basecurrency','0','0',588228193299816454,'本位币币种','number',588228192620339200,' ',34,'1'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 591153532216811520;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (591153732067132416,'currency','1','1',591153532216811520,'币种*','number',591153531797505024,' ',7,'1'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 591153532250489856;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (591153732067132416,'basecurrency','0','0',591153532250489856,'本位币币种','number',591153531797505024,' ',34,'1'); 

--kd_1.5.212_bei_data_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588145071430393857;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (588145943023567872,0,'number',588145071430393857,'1','0',' ','name','1','1',' ',' ',588145071380087808,'currency',8,'币种*',' ',' ');

--kd_1.5.0_bei_data_importtemplate_add.sql
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588145043806707712;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (588145943023567872,'bei_betransdetail_imp','0','0',588145043806707712,'交易明细导入','number',0,' ',1,'0'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588228168763163648;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (588228947217571840,'bei_betransdetail_imp','0','0',588228168763163648,'交易明细导入','number',0,' ',1,'0'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 591153509181693952;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FFIELDKEY,FMUSTINPUT,FISIMPORT,FENTRYID,FFIELDNAME,FIMPORTPROP,FPARENTENTRYID,FDESCRIPTION,FSEQ,FISFIELD) VALUES (591153732067132416,'bei_betransdetail_imp','0','0',591153509181693952,'交易明细导入','number',0,' ',1,'0'); 

--kd_1.5.40_bei_data_importtemplate_add.sql
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0RUMLUB3R0X2';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (886189104272862208,'0RUMLUB3R0X2','zh_CN',' ','交易明细导入'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0RUMLUB3R0X3';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (886189104272862208,'0RUMLUB3R0X3','zh_TW',' ','交易明細導入'); 

--kd_1.5.212_bei_data_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 588145943023567872;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FOVERRIDEENTRY,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (588145943023567872,'1','0','1',588145943023567872,'0','C','bei_betransdetail_imp_IMPT_S','IMPT','交易明细导入',{ts'2022-11-24  00:00:00'},'0',1632483539985373184,'1','0','0','0',' ',{ts'2023-08-22  00:00:00'},' ',0,'bei_betransdetail_imp');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 588145043806707712;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (588145943023567872,0,'number',588145043806707712,'0','0',' ',' ','0','0',' ',' ',0,'bei_betransdetail_imp',1,'交易明细导入',' ',' ');

--kd_1.5.168_bei_coderule.sql
DELETE FROM t_cr_coderule_l WHERE FPKID = '2TM2+OLBPWN2';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2TM2+OLBMQF4','2TM2+OLBPWN2','zh_CN','离线明细导入编码规则');
DELETE FROM t_cr_coderule_l WHERE FPKID = '2TM2+OLBPWN1';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2TM2+OLBMQF4','2TM2+OLBPWN1','zh_TW','離線明細導入編碼規則');

--kd_1.5.184_bei_coderule.sql
DELETE FROM T_CR_CodeRule_L WHERE FPKID = '31/ZMRB+J0NP';
INSERT INTO T_CR_CodeRule_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('31/ZMRB+EXRE','31/ZMRB+J0NP','zh_CN','文件识别导入日志');

--kd_1.5.18_bei_update_data_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0CEIS9ICQHWQ';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (591153732067132416,'0CEIS9ICQHWQ','zh_CN',' ','导入模板一'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0CEIS9ICQHWR';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (591153732067132416,'0CEIS9ICQHWR','zh_TW',' ','导入模板一'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0CEMVE+16IQ7';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588228947217571840,'0CEMVE+16IQ7','zh_CN',' ','导入模板二'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0CEMVE+16IQ8';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588228947217571840,'0CEMVE+16IQ8','zh_TW',' ','导入模板二'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0C28=VOT6ON/';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588145943023567872,'0C28=VOT6ON/','zh_CN',' ','导入模板三'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0C28=VOT6ON0';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588145943023567872,'0C28=VOT6ON0','zh_TW',' ','导入模板三'); 

--kd_1.5.218_bei_permitem.sql
DELETE FROM T_PERM_PERMITEM WHERE FID = '18EI89ZDDZC9';
INSERT INTO T_PERM_PERMITEM (FID, FNUMBER, FINHERITMODE, FGROUP, FPREPERMITEMID, FDESCRIPTION, FBIZAPPID) VALUES ('18EI89ZDDZC9', 'QXBEI0033', '20', '20', '47150e89000000ac', '识别导入', '/LSWHQ7US+Q6');
DELETE FROM T_PERM_PERMITEM_L WHERE FID = '18EI89ZDDZC9';
INSERT INTO T_PERM_PERMITEM_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('3M0LCXBUTM96', '18EI89ZDDZC9', 'zh_CN', '识别导入');

--kd_1.5.228_bei_transdetail_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 588145943023567872;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FOVERRIDEENTRY,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (588145943023567872,'1','0','1',588145943023567872,'0','C','bei_betransdetail_imp_IMPT_S','IMPT','离线明细导入预置模板',{ts'2022-11-24  00:00:00'},'0',1632483539985373184,'1','0','0','0',' ',{ts'2023-08-22  00:00:00'},' ',0,'bei_betransdetail_imp');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '3HUXOAG7=YNK';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588145943023567872,'3HUXOAG7=YNK','zh_CN','导入模板（标准预置数据）','离线明细导入预置模板');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '3HUXOAG7=YNL';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588145943023567872,'3HUXOAG7=YNL','zh_TW','導入模板（標準預置數據）','離線明細導入預置模板');

--kd_1.5.229_bei_webapi.sql
delete from t_open_apiservice_L where fpkid =  '3SF8QP83JUYZ' ;
insert into t_open_apiservice_L ( fid, fdiscription, fname, flocaleid, fpkid) values ( 1843546470297496576, '电子回单文件导入 ElecReceiptFileInfo有两个属性：String fileName - 文件名称（非路径）； byte[] fileData - 文件字节流', '电子回单文件导入', 'zh_CN', '3SF8QP83JUYZ');
delete from t_open_apiservice_L where fpkid =  '3SF8QP83JUZ+' ;
insert into t_open_apiservice_L ( fid, fdiscription, fname, flocaleid, fpkid) values ( 1843546470297496576, '電子回單文件導入 ElecReceiptFileInfo有兩個屬性：String fileName - 文件名稱（非路徑）； byte[] fileData - 文件字節流', '電子回單文件導入', 'zh_TW', '3SF8QP83JUZ+');

--kd_1.5.7_bei_permitem.sql
DELETE FROM t_perm_permitem_l WHERE FPKID = '05LMFL5ALJ33';
INSERT INTO t_perm_permitem_l(FPKID,FNAME,FLOCALEID,FID) VALUES ('05LMFL5ALJ33','导入明细','zh_CN','05LMFL5ALKFM'); 
DELETE FROM t_perm_permitem_l WHERE FPKID = '05LMFL5ALJ34';
INSERT INTO t_perm_permitem_l(FPKID,FNAME,FLOCALEID,FID) VALUES ('05LMFL5ALJ34','導入明細','zh_TW','05LMFL5ALKFM'); 

--kd_1.5.72_bei_permitem.sql
DELETE FROM t_perm_permitem WHERE FID = '1=42NDA=DARI';
INSERT INTO t_perm_permitem(FID,FPREPERMITEMID,FINHERITMODE,FBIZAPPID,FORDER,FDESCRIPTION,FGROUP,FBIZDOMAINID,FNUMBER) VALUES ('1=42NDA=DARI','47150e89000000ac','20',' ',0,'收款入账中心按列表导出','20',0,'QXBEI0035'); 
DELETE FROM t_perm_permitem_l WHERE FPKID = '1=42NDA=BHDB';
INSERT INTO t_perm_permitem_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1=42NDA=DARI','1=42NDA=BHDB','zh_CN','按列表导出'); 
DELETE FROM t_perm_permitem_l WHERE FPKID = '1=42NDA=BHDC';
INSERT INTO t_perm_permitem_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1=42NDA=DARI','1=42NDA=BHDC','zh_TW','按列表導出');