DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309824;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309824,'string',1,'1','settlementId',' ','结算单号balanceId'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309825;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309825,'string',2,'1','supplierOrder',' ','发票请求子订单号批量以 ,号分割balanceOrderDetail'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309826;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309826,'string',3,'1','invoiceNum',' ','结算单子订单总数markOrderNum'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309827;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309827,'string',4,'1','amount',' ','结算单不含税总金额（裸价）balanceNakedPrice'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309828;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309828,'string',5,'1','tax',' ','结算单总税价balanceTaxPrice'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309829;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309829,'string',6,'1','invoiceType',' ','发票类型   1增值税普通发票2增值税专用发票 3电子普通发票invoiceType'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309830;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309830,'string',7,'1','bizInvoiceContent',' ','开票内容：明细办公用品电脑配件耗材invoiceContent'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309831;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309831,'string',8,'1','title',' ','发票抬头invoiceTitle'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309832;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309832,'string',9,'1','invoicePhone',' ','发票电话invoiceTelephone'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309833;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309833,'string',10,'1','enterpriseTaxpayer',' ','税号invoiceIdNo'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309834;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309834,'string',11,'1','enterpriseBankName',' ','发票开户行invoiceBankName'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309835;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309835,'string',12,'1','enterpriseBankAccount',' ','银行账号invoiceBankNo'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309836;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309836,'string',13,'1','billToParty',' ','收票单位billToPart'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309837;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309837,'string',14,'1','billToer',' ','收票人billToer'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309838;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309838,'string',15,'1','billToContact',' ','收票人联系方式billToMobile'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309839;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309839,'string',16,'1','billToProvince',' ','收票人地址（省）billToProvince'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309840;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309840,'string',17,'1','billToCity',' ','收票人地址（市）billToCity'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309841;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309841,'string',18,'1','billToCounty',' ','收票人地址（区）billToCounty'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309842;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309842,'string',19,'1','billToAddress',' ','收票人全量地址billToAddress'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309843;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309843,'string',20,'1','invoicePrice',' ','结算单含税总金额balancePrice'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309844;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309844,'string',21,'1','companyName',' ','发起结算单位companyName'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309845;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309845,'string',22,'1','billToEmail',' ','收票人邮箱billToEmial'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305764981727309846;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135781181925376,'0',1305764981727309846,'string',23,'1','remark',' ','发票备注invoiceRemark'); 
DELETE FROM t_mal_extsysapi_inputs WHERE FENTRYID = 1305811898867909632;
INSERT INTO t_mal_extsysapi_inputs(FID,FINPUT_IS_ARRAY,FENTRYID,FINPUT_DATA_TYPE,FSEQ,FREQUIRED,FINPUT_FIELD,FDEFAULT_VALUE,FINPUT_DESCRIPTION) VALUES (1305135926933989376,'0',1305811898867909632,'string',1,'1','markId',' ','结算单号balanceId'); 


DELETE FROM t_mal_extsys_api WHERE FID = 1305135781181925376;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FISDEBUG,FCREATORID) VALUES (1305135781181925376,'isc_metadata_schema','1','采购平台向供应商系统提交结算单时调用本接口',1305135781181925376,'C',1512306056248268752,'/submitBalance','SRM_DL_INVOICE_submitBalance',1292006463543236608,{ts'2021-12-06  00:00:00'},1172968486918422528,'1','1',{ts'2021-12-07  00:00:00'},'0',1172968486918422528); 
DELETE FROM t_mal_extsys_api WHERE FID = 1305135926933989376;
INSERT INTO t_mal_extsys_api(FID,FCONTYPE,FRECORD_LOG,FDESCRIPTION,FMASTERID,FSTATUS,FCONCONFIG,FFULL_NAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FISDEBUG,FCREATORID) VALUES (1305135926933989376,'isc_metadata_schema','0','根据采购平台结算单id查询结算单状态。',1305135926933989376,'C',1463436535377387342,'/getBalanceState','SRM_DL_INVOICE_getBalanceState',1292006463543236608,{ts'2021-12-06  00:00:00'},1172968486918422528,'1','1',{ts'2021-12-07  00:00:00'},'0',1172968486918422528); 

DELETE FROM t_mal_extsys_api_l WHERE FPKID = '22=S/3/LR/X1';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1305135781181925376,'22=S/3/LR/X1','zh_CN','得力结算单提交'); 
DELETE FROM t_mal_extsys_api_l WHERE FPKID = '22=S05EKX++R';
INSERT INTO t_mal_extsys_api_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1305135926933989376,'22=S05EKX++R','zh_CN','得力查询结算单状态接口');

-- 接口组

DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1305136357974222848;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1305135781181925376,1005817789182653440,1305136357974222848,5,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','1','4'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1305138204625610752;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1305135926933989376,1010819042207908864,1305138204625610752,5,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','1','4'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1078163924282558464;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1078163384995729408,1005817789182653440,1078163924282558464,3,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','1','5'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1078164386746517504;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1078163635202738176,1010819042207908864,1078164386746517504,3,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','1','5'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1005817789241373696;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1006511274676250624,1005817789182653440,1005817789241373696,1,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','1','3'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1010819042233074689;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985478328087478272,1010819042207908864,1010819042233074689,2,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','1','3'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1010802064764224512;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985463384596021248,1005817789182653440,1010802064764224512,2,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','1','2'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1010819042233074688;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (985464068779278336,1010819042207908864,1010819042233074688,1,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','1','2'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1168760446497347584;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1167901792441214976,1005817789182653440,1168760446497347584,4,'kd.scm.common.helper.apiconnector.apihandle.AddInvoiceHandleProcessor','1','6'); 
DELETE FROM t_mal_ext_apisetentry WHERE FENTRYID = 1168814653967456256;
INSERT INTO t_mal_ext_apisetentry(FEXTSYSAPI,FID,FENTRYID,FSEQ,FHANDLECLASS,FVALID,FSYSTYPE) VALUES (1167901938990219264,1010819042207908864,1168814653967456256,4,'kd.scm.common.helper.apiconnector.apihandle.QueryInvoiceHandleProcessor','1','6'); 

DELETE FROM t_mal_extapiset WHERE FID = 1005817789182653440;
INSERT INTO t_mal_extapiset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1005817789182653440,{ts'2020-10-19  00:00:00'},1172968486918422528,'1','1',{ts'2021-12-08  00:00:00'},'电商申请开票接口接口',1005817789182653440,'C',13466739,'SRM_EC_ADDINVOICE'); 
DELETE FROM t_mal_extapiset WHERE FID = 1010819042207908864;
INSERT INTO t_mal_extapiset(FID,FCREATETIME,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FDESCRIPTION,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1010819042207908864,{ts'2020-10-26  00:00:00'},1172968486918422528,'1','1',{ts'2021-12-08  00:00:00'},'电商查询发票概要',1010819042207908864,'C',13466739,'SRM_EC_QUERYINVOICE'); 

DELETE FROM t_mal_extapiset_l WHERE FPKID = '14IRQ/FMC1/B';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1005817789182653440,'14IRQ/FMC1/B','zh_CN','电商申请开票接口'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '14IRQ/FMC1/C';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1005817789182653440,'14IRQ/FMC1/C','zh_TW','電商申請開票接口'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '154Q6175J2L4';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1010819042207908864,'154Q6175J2L4','zh_CN','电商查询发票概要'); 
DELETE FROM t_mal_extapiset_l WHERE FPKID = '154Q6175J2L5';
INSERT INTO t_mal_extapiset_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1010819042207908864,'154Q6175J2L5','zh_TW','電商查詢發票概要'); 

 



