DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1888446275951762432;
INSERT INTO T_ER_TRIP_FIELDMAPPING(FID,FSERVER,FDATAJSON_TAG,FURL,FISDEFAULT,FMASTERID,FMETHOD,FSTATUS,FNUMBER,FNAME,FSYNCTYPE,FDATAJSON,FCREATETIME,FPORTTYPE,FENABLE,FMODIFIERID,FFUNCTION,FMODIFYTIME,FPARAMSJSON_TAG,FCLASSFORNAME,FCREATORID,FPARAMSJSON) VALUES (1888446275951762432,0,'{
	"tripSync":{
		"method":"er_checkingbill",
		"data":[
			{
				"formid":"er_planecheckingbill",
				"settlemain":123,
				"periodstartdate":"2024-01-01",
				"billstatus":"A",
				"org":123,
				"billnum":"ipUDv",
				"operationtype":"2",
				"result":"",
				"settlementamount":123,
				"periodenddate":"2024-01-31",
				"currency":123,
				"billno":"X1Ud9",
				"isreconciliation":false
			}
		],
		"service":"XXXX"
	}
}','http://{{localhost}}/kapi/v2/em/tripSync','1',1888446275951762432,'POST','C','Openapi_Checkingbill','开放平台-月结账单获取','1','已录入参数',{ts'2024-02-19  00:00:00'},'pull','1',1205612035459523584,'er_checkingbill',{ts'2024-04-03  00:00:00'},'{
	"1":"1"
}','kd.fi.er.business.trip.v2.server.openapitrip.OpenAPISyncCheckingBillInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3XZC1PLMTIGX';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1888446275951762432,'3XZC1PLMTIGX','zh_CN','开放平台-月结账单获取');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '3XZC1PLMTIGY';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1888446275951762432,'3XZC1PLMTIGY','zh_TW','開放平台-月結賬單獲取');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494663;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.服务商',' ',1888448880119494663,'1',{ts'2024-02-19  00:00:00'},'tripSync.service',{ts'2024-03-05  00:00:00'},' ',8,'1','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494662;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.组织',' ',1888448880119494662,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].settlemain',{ts'2024-03-05  00:00:00'},' ',7,'1','org','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494667;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.币种',' ',1888448880119494667,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].currency',{ts'2024-03-05  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',11,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494664;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.账单编号',' ',1888448880119494664,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].billnum',{ts'2024-03-05  00:00:00'},' ',9,'1','billnum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494665;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.服务类型',' ',1888448880119494665,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].operationtype',{ts'2024-03-05  00:00:00'},' ',10,'1','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494656;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.单据编号',' ',1888448880119494656,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].billno',{ts'2024-02-19  00:00:00'},' ',1,'1','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494657;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.单据状态',' ',1888448880119494657,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].billstatus',{ts'2024-02-19  00:00:00'},' ',2,'1','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494658;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.创建人',' ',1888448880119494658,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].creator',{ts'2024-02-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',3,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494659;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.修改人',' ',1888448880119494659,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].modifier',{ts'2024-02-19  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',4,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494660;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.修改时间',' ',1888448880119494660,'1',{ts'2024-02-19  00:00:00'},' ',{ts'2024-04-03  00:00:00'},'NOW()',5,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494661;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.创建时间',' ',1888448880119494661,'1',{ts'2024-02-19  00:00:00'},' ',{ts'2024-04-03  00:00:00'},'NOW()',6,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494669;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.结算金额',' ',1888448880119494669,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].settlementamount',{ts'2024-02-19  00:00:00'},' ',13,'1','settlementamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494670;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.表单ID',' ',1888448880119494670,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].formid',{ts'2024-02-19  00:00:00'},' ',14,'1','formid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494671;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.账单起始日',' ',1888448880119494671,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].periodstartdate',{ts'2024-02-19  00:00:00'},' ',15,'1','periodstartdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494672;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.账单截止日',' ',1888448880119494672,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].periodenddate',{ts'2024-02-19  00:00:00'},' ',16,'1','periodenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494674;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.账单状态',' ',1888448880119494674,'1',{ts'2024-02-19  00:00:00'},' ',{ts'2024-02-19  00:00:00'},'1',17,'2','billstatusname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1888448880119494668;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1888446275951762432,' ','1',' ',' ','单据头.费用承担公司',' ',1888448880119494668,'1',{ts'2024-02-19  00:00:00'},'tripSync.data.[0].settlemain',{ts'2024-02-19  00:00:00'},' ',12,'1','settlemain','0'); 
