--产品中英文质量提升
--kd_1.5.193_sys_t_open_apiservice.sql
delete from t_open_apibodyentry where FENTRYID =  1655809612957630464;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1655809881300811776', '"1403160047036403712"', 'LongProp', '1655809612957630464', '0', 'currency.id', '0', '0', '1', '0', 'Long', '0', '币种.id', '49', ' ', 'currency_id');
delete from t_open_apirespentry where FENTRYID =  1655821510369361921;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655826543274114048', 'Long', '1655821510369361921', '0', '"7160026515490009088"', 'currency_id', '1', '0', '0', '84', 'LongProp', '1', '币种.id', 'currency.id');
delete from t_open_apirespentry where FENTRYID =  1655821510377749504;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655826543274114048', 'String', '1655821510377749504', '0', '"ZFrnN"', 'currency_number', '1', '0', '0', '85', 'TextProp', '1', '币种.货币代码', 'currency.number');
delete from t_open_apirespentry where FENTRYID =  1655821510377750528;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655826543274114048', 'String', '1655821510377750528', '0', '"nLmKb"', 'currency_name', '1', '0', '0', '86', 'MuliLangTextProp', '1', '币种.名称', 'currency.name');
delete from t_open_apirespentry where FENTRYID =  1655925664685244417;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655925838555921408', 'Long', '1655925664685244417', '0', '"2762869083219589120"', 'currency_id', '1', '0', '0', '84', 'LongProp', '1', '币种.id', 'currency.id');
delete from t_open_apirespentry where FENTRYID =  1655925664685243394;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655925838555921408', 'String', '1655925664685243394', '0', '"DDqlK"', 'currency_number', '1', '0', '0', '85', 'TextProp', '1', '币种.货币代码', 'currency.number');
delete from t_open_apirespentry where FENTRYID =  1655925664685244418;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655925838555921408', 'String', '1655925664685244418', '0', '"0e2IF"', 'currency_name', '1', '0', '0', '86', 'MuliLangTextProp', '1', '币种.名称', 'currency.name');

--kd_1.5.223_cas_checkimporttemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753699548966277121;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (539650586916698112,'1','1','number',753699548966279168,753699548966277121,'currency',6,'1',' ','name','币种');

--kd_1.5.163_sys_t_open_apiservice.sql
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465919;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"0"',1495675416185465919,'ComboProp','0','dppayquotation','0','1','0','String',0,'异币种付款汇率换算方式：[0：直接汇率，1：间接汇率]',51,'dppayquotation'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465895;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'false',1495675416185465895,'BooleanProp','0','isdiffcur','0','1','0','Boolean',0,'异币种付款',29,'isdiffcur'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465896;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"2022-08-24"',1495675416185465896,'DateProp','0','dpexratedate','0','1','0','Date',0,'异币种付款汇率日期',30,'dpexratedate'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465897;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"5.05"',1495675416185465897,'ExchangeRateProp','0','dpexchangerate','0','1','0','Decimal',0,'异币种付款汇率',31,'dpexchangerate'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465898;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"0.00"',1495675416185465898,'AmountProp','0','dpamt','0','1','0','Decimal',0,'异币种付款金额',32,'dpamt'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465899;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"0.00"',1495675416185465899,'AmountProp','0','dplocalamt','0','1','0','Decimal',0,'异币种付款金额折本位币',33,'dplocalamt'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465905;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"5014192422174247936"',1495675416185465905,'BigIntProp','0','payeecurrency','0','1','0','Long',0,'收款账号币种',39,'payeecurrency'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465945;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"1"',1495675416185465945,'LongProp','0','currency.id','0','1','1','Long',0,'付款币种.id',76,'currency_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465996;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"2"',1495675416185465996,'LongProp','0','dpcurrency.id','0','1','0','Long',0,'异币种付款币种.id',123,'dpcurrency_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465997;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"346173531320483840"',1495675416185465997,'LongProp','0','dpexratetable.id','0','1','0','Long',0,'异币种付款汇率表.id',124,'dpexratetable_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1495675416185465999;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1495675571290826752,'"924822051772333056"',1495675416185465999,'LongProp','0','feecurrency.id','0','1','0','Long',0,'手续费币种.id',126,'feecurrency_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505118627048121345;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505119279228838912,'"人民币"',1505118627048121345,'TextProp','0','inneraccountcurrency','0','1','0','String',0,'币种',31,'inneraccountcurrency'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505118627266225152;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505119279228838912,'"1"',1505118627266225152,'LongProp','0','currency.id','0','1','1','Long',0,'币种.id',87,'currency_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166726513664;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'false',1505203166726513664,'BooleanProp','0','isdiffcur','0','1','0','Boolean',0,'异币种付款',18,'isdiffcur'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166726513665;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"295.75"',1505203166726513665,'ExchangeRateProp','0','dpexchangerate','0','1','0','Decimal',0,'异币种付款汇率',20,'dpexchangerate'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166734655488;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"694.63"',1505203166734655488,'AmountProp','0','dpamt','0','1','0','Decimal',0,'异币种付款金额',21,'dpamt'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166734902272;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"794.78"',1505203166734902272,'AmountProp','0','dplocalamt','0','1','0','Decimal',0,'异币种付款金额折本位币',22,'dplocalamt'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166944370689;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"1"',1505203166944370689,'LongProp','0','currency.id','0','1','0','Long',0,'付款币种.id',86,'currency_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166969783297;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"1"',1505203166969783297,'LongProp','0','dpcurrency.id','0','1','0','Long',0,'异币种付款币种.id',97,'dpcurrency_id'); 
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166969783298;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"1"',1505203166969783298,'LongProp','0','feecurrency.id','0','1','0','Long',0,'手续费币种.id',99,'feecurrency_id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086974514179;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Boolean',1505138086974514179,'0','false','isdiffcur','1',0,56,'1','异币种付款','BooleanProp','isdiffcur'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086974267396;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Date',1505138086974267396,'0','"2022-09-08"','dpexratedate','1',0,57,'1','异币种付款汇率日期','DateProp','dpexratedate'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086982902784;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Decimal',1505138086982902784,'0','"830.47"','dpexchangerate','1',0,58,'1','异币种付款汇率','ExchangeRateProp','dpexchangerate'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086982656000;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Decimal',1505138086982656000,'0','"732.37"','dpamt','1',0,59,'1','异币种付款金额','AmountProp','dpamt'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086982902785;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Decimal',1505138086982902785,'0','"512.56"','dplocalamt','1',0,60,'1','异币种付款金额折本位币','AmountProp','dplocalamt'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086991291392;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Long',1505138086991291392,'0','"8735001598672759808"','payeecurrency','1',0,66,'1','收款账号币种','BigIntProp','payeecurrency'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087008068610;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'String',1505138087008068610,'0','"0"','dppayquotation','1',0,88,'1','异币种付款汇率换算方式','ComboProp','dppayquotation'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138086999433220;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'String',1505138086999433220,'0','"NmuRH"','inneraccountcurrency','1',0,81,'1','币种','TextProp','inneraccountcurrency'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087066542082;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Long',1505138087066542082,'0','"1862258411332653056"','currency_id','1',0,139,'1','付款币种.id','LongProp','currency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087066788866;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'String',1505138087066788866,'0','"g8lyE"','currency_name','1',0,140,'1','付款币种.名称','MuliLangTextProp','currency.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087150428161;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Long',1505138087150428161,'0','"6708788351669392384"','dpcurrency_id','1',0,207,'1','异币种付款币种.id','LongProp','dpcurrency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087150674945;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'String',1505138087150674945,'0','"yZpfI"','dpcurrency_name','1',0,208,'1','异币种付款币种.名称','MuliLangTextProp','dpcurrency.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087150428162;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Long',1505138087150428162,'0','"5821154928648212480"','dpexratetable_id','1',0,209,'1','异币种付款汇率表.id','LongProp','dpexratetable.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087150674946;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'String',1505138087150674946,'0','"IQ17b"','dpexratetable_name','1',0,210,'1','异币种付款汇率表.名称','MuliLangTextProp','dpexratetable.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087158816768;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'Long',1505138087158816768,'0','"8131089901940868096"','feecurrency_id','1',0,213,'1','手续费币种.id','LongProp','feecurrency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505138087159063552;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1496383569621519360,'String',1505138087159063552,'0','"FCQGP"','feecurrency_name','1',0,214,'1','手续费币种.名称','MuliLangTextProp','feecurrency.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505132416954736640;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505132438580814848,'String',1505132416954736640,'0','"14q9y"','inneraccountcurrency','1',0,52,'1','币种','TextProp','inneraccountcurrency'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505132417097589763;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505132438580814848,'Long',1505132417097589763,'0','"5406110706856231936"','currency_id','1',0,143,'1','币种.id','LongProp','currency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505132417097342980;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505132438580814848,'String',1505132417097342980,'0','"O5J1i"','currency_name','1',0,144,'1','币种.名称','MuliLangTextProp','currency.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624587735043;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Boolean',1505226624587735043,'0','false','isdiffcur','1',0,44,'1','异币种付款','BooleanProp','isdiffcur'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624587735044;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Decimal',1505226624587735044,'0','"158.91"','dpexchangerate','1',0,46,'1','异币种付款汇率','ExchangeRateProp','dpexchangerate'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624587981828;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Decimal',1505226624587981828,'0','"936.28"','dpamt','1',0,47,'1','异币种付款金额','AmountProp','dpamt'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624596123648;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Decimal',1505226624596123648,'0','"30.40"','dplocalamt','1',0,48,'1','异币种付款金额折本位币','AmountProp','dplocalamt'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624612900864;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'String',1505226624612900864,'0','"0"','dppayquotation','1',0,68,'1','异币种付款汇率换算方式','ComboProp','dppayquotation'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624696786945;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Long',1505226624696786945,'0','"942540634505848832"','currency_id','1',0,152,'1','付款币种.id','LongProp','currency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624697033730;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'String',1505226624697033730,'0','"lnXj5"','currency_name','1',0,153,'1','付款币种.名称','MuliLangTextProp','currency.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624730341376;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Long',1505226624730341376,'0','"7990390283816847360"','dpcurrency_id','1',0,178,'1','异币种付款币种.id','LongProp','dpcurrency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624730588160;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'String',1505226624730588160,'0','"34KKs"','dpcurrency_name','1',0,179,'1','异币种付款币种.名称','MuliLangTextProp','dpcurrency.name'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624730341378;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'Long',1505226624730341378,'0','"872251959979260928"','feecurrency_id','1',0,182,'1','手续费币种.id','LongProp','feecurrency.id'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624738976768;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'String',1505226624738976768,'0','"TiW8k"','feecurrency_name','1',0,183,'1','手续费币种.名称','MuliLangTextProp','feecurrency.name'); 

--kd_1.5.139_cas_manualjournalimport.sql
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 753373331394135044;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753374185035661312,'1','1','number',753373331394135040,753373331394135044,'currency',10,'1',' ','name','币种'); 

--kd_1.5.190_cas_initimporttemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 748301209529595904;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (746789100895571968,'0','1','number',748301209521210374,748301209529595904,'cash_currency',25,'0',' ','name','币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 753697899086469125;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (746789100895571968,'1','1','number',753697899086467076,753697899086469125,'bank_currency',34,'1',' ','name','币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 748301209521207298;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (746789100895571968,'0','1','number',748301209512821760,748301209521207298,'standardcurrency',8,'0',' ','name','业务主币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 754065752750936066;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (754064772542091264,'0','1','number',754065752750938112,754065752750936066,'standardcurrency',8,'0',' ','name','业务主币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 754065752750936072;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (754064772542091264,'1','1','number',754065752750938119,754065752750936072,'cash_currency',25,'1',' ','name','币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 754065752759324673;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (754064772542091264,'1','1','number',754065752759326720,754065752759324673,'bank_currency',34,'1',' ','name','币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 754054404197437442;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753696676295858176,'0','1','number',754054404197439488,754054404197437442,'standardcurrency',7,'0',' ','name','业务主币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 754054404205826049;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753696676295858176,'1','1','number',754054404205828096,754054404205826049,'cash_currency',19,'1',' ','name','币种');
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 754054404205826053;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (753696676295858176,'0','1','number',754054404205828100,754054404205826053,'bank_currency',27,'0',' ','name','币种');

--kd_1.5.33_cas_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 560713644313161741;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (470136528312498176,'1','1','number',560713644246065152,560713644313161741,'currency',40,'1',' ','name','币种*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 560714810992373780;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (470147897778772992,'1','1','number',560714810925277184,560714810992373780,'currency',40,'1',' ','name','币种*'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 560715050428411913;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (470651842976576512,'1','1','number',560715050386481152,560715050428411913,'currency',40,'1',' ','name','币种*'); 

--kd_1.5.192_cas_applypaybill_openapi.sql
delete from t_open_apibodyentry where FENTRYID =  '1655812484109447168' ;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1655813786323398656', 'false', 'BooleanProp', '1655812484109447168', '0', 'cas_payinfo.entry_isdiffcur', '0', '0', '2', '0', 'Boolean', '1655812483950170112', '付款明细分录.异币种付款', '77', ' ', 'entry_isdiffcur');
delete from t_open_apibodyentry where FENTRYID =  '1662968283453954048' ;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1655813786323398656', '"0z8af"', 'TextProp', '1662968283453954048', '0', 'cas_payinfo.entry_paycurrency.number', '0', '0', '2', '0', 'String', '1655812483950170112', '付款币种.货币代码', '112', ' ', 'entry_paycurrency_number');
delete from t_open_apibodyentry where FENTRYID =  '1671751551166950400' ;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1655813786323398656', '"DCE04"', 'TextProp', '1671751551166950400', '0', 'payeecurrency.number', '0', '0', '1', '1', 'String', '0', '收款币种.货币代码', '16', ' ', 'payeecurrency_number');

--kd_1.5.163_sys_t_open_apiservice.sql
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1505203166868873216;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FPARAMNAME) VALUES (1505203498428604416,'"bos_user"',1505203166868873216,'ItemClassTypeProp','0','entry.importpayeetype','0','2','0','String',1505203166802011136,'分录.收款人类型(多类别基础类型,导入) [bos_org:公司, bd_supplier:供应商, bd_customer:客户, bos_user:职员]',56,'importpayeetype'); 
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1505226624646455300;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FPARENTENTRYID,FSEQ,FRESP_LEVEL,FRESPDES,FRESP_DATA_MODEL,FRESPOBJPROPNAME) VALUES (1505226648579400704,'String',1505226624646455300,'0','"bos_user"','importpayeetype','1',1505226624612900868,114,'2','分录.收款人类型(多类别基础类型,导入) [bos_org:公司, bd_supplier:供应商, bd_customer:客户, bos_user:职员]','ItemClassTypeProp','entry.importpayeetype'); 

--kd_1.5.153_cas_accountcashimport.sql
DELETE FROM t_bas_importtemplate_L WHERE FPKID = '2KBF5V1SW9=R';
INSERT INTO t_bas_importtemplate_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1460152302819243008,'2KBF5V1SW9=R','zh_CN','现金账户导入模板','现金账户'); 
DELETE FROM t_bas_importtemplate_L WHERE FPKID = '2KBF5V1SW9=S';
INSERT INTO t_bas_importtemplate_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1460152302819243008,'2KBF5V1SW9=S','zh_TW','現金賬戶導入模板','現金賬戶'); 

--kd_1.5.191_2_cas_recbank_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1656428912462580736;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1656428912462580736,'1',1656428912462580736,'C','cas_rec_init_bankunreach_IMPT_S','银行初始未达导入','IMPT',{ts'2023-04-05  00:00:00'},13466739,'1',{ts'2023-04-07  00:00:00'},' ',13466739,'cas_rec_init');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '36FSM4OPAA1A';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1656428912462580736,'36FSM4OPAA1A','zh_CN',' ','银行初始未达导入');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '36FSM4OPAA1B';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1656428912462580736,'36FSM4OPAA1B','zh_TW',' ','銀行初始未達導入');

--kd_1.5.191_2_cas_reccampany_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1657149820726447104;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1657149820726447104,'1',1657149820726447104,'C','cas_rec_init_companyunreach_IMPT_S','企业初始未达导入','IMPT',{ts'2023-04-06  00:00:00'},13466739,'1',{ts'2023-04-07  00:00:00'},' ',13466739,'cas_rec_init');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '36J8AD=5DB5P';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1657149820726447104,'36J8AD=5DB5P','zh_CN',' ','企业初始未达导入');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '36J8AD=5DB5Q';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1657149820726447104,'36J8AD=5DB5Q','zh_TW',' ','企業初始未達導入');

--kd_1.5.193_sys_t_open_apiservice.sql
delete from t_open_apiservice_L where fpkid =  '36CTZ9S=AZCL' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( '1655809881300811776', '离线明细导入保存', ' ', 'zh_CN', '36CTZ9S=AZCL');
delete from t_open_apiservice_L where fpkid =  '36CTZ9S=AZCM' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( '1655809881300811776', '離線明細導入保存', ' ', 'zh_TW', '36CTZ9S=AZCM');
delete from t_open_apibodyentry where FENTRYID =  '1655809612714360832' ;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1655809881300811776', '"import"', 'ComboProp', '1655809612714360832', '0', 'datasource', '0', '0', '1', '0', 'String', '0', '数据来源 [import:模板导入, fromimg:图片导入, receiptgen:电子回单生成]', '22', ' ', 'datasource');
delete from t_open_apirespentry where FENTRYID =  '1655821510285474817' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655826543274114048', 'String', '1655821510285474817', '0', '"frombank"', 'datasource', '1', '0', '0', '27', 'ComboProp', '1', '数据来源 [frombank:银企接口, import:模板导入, receiptgen:电子回单生成, fromifm:内部金融]', 'datasource');
delete from t_open_apirespentry where FENTRYID =  '1655925664584580096' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1655925838555921408', 'String', '1655925664584580096', '0', '"frombank"', 'datasource', '1', '0', '0', '27', 'ComboProp', '1', '数据来源 [frombank:银企接口, import:模板导入, receiptgen:电子回单生成, fromifm:内部金融]', 'datasource');

--kd_1.5.35_cas_data_importtemplate.sql
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0LDN+OTTL58T';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (833800324652541952,'0LDN+OTTL58T','zh_CN','出纳_代发单_分录导入模板','出纳_代发单_分录导入'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '0LDN+OTTL58U';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (833800324652541952,'0LDN+OTTL58U','zh_TW','出納_代發單_分錄導入模板','出納_代發單_分錄導入'); 

--kd_1.5.52_cas_claim_import.sql
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0ZRSL1EYLSB9';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (950718174700168192,'0ZRSL1EYLSB9','zh_CN','认领单分录预置导入模板','收款认领单分录导入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '0ZRSL1EYLSB=';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (950718174700168192,'0ZRSL1EYLSB=','zh_TW','認領單分錄預置導入模板','收款認領單分錄導入模板'); 

