源系统平台:阿里宜搭
源系统接口: 搜索表单实例详情列表/yida_vpc/form/searchFormDatas.json
目标系统平台: 金蝶云星空
目标系统接口: 费用申请新增batchSave
源平台元数据配置:
{
"id": "id",
"api": "/yida_vpc/process/getInstances.json",
"type": "QUERY",
"method": "POST",
"number": "title",
"idCheck": true,
"request": [
{
"type": "string",
"field": "appType",
"label": "应用ID",
"value": "APP_DYCTQDDB8CX2SDQ6YRJH",
"describe": "示例:APP_PBKT0MFBEBTDO8T7SLVP",
"is_required": true
},
{
"type": "string",
"field": "systemToken",
"label": "应用秘钥",
"value": "QQ766LD1J92V5NCVVQ5WZ20GDSL2201TCBWVK3W1",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "userId",
"label": "管理员用户钉钉ID",
"value": "016654026426409112",
"describe": "钉钉的userId",
"is_required": true
},
{
"type": "string",
"field": "language",
"label": "语言",
"value": "zh_CN",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "formUuid",
"label": "表单ID",
"value": "FORM-FV966U91LS2V8ZZZ2JLRL4GS7BE432SHUDXVK41",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "instanceStatus",
"label": "实例状态",
"value": "COMPLETED",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "currentPage",
"label": "当前页",
"value": "{{PAGINATION_START_PAGE}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "pageSize",
"label": "每页记录数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "originatorId",
"label": "数据提交人工号",
"value": null,
"describe": "用户钉钉ID",
"is_required": false
},
{
"type": "string",
"field": "createFrom",
"label": "创建开始时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "createTo",
"label": "创建结束时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modifiedFrom",
"label": "修改开始时间",
"value": "{{LAST_SYNC_TIME|date}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modifiedTo",
"label": "修改结束时间",
"value": "2025-08-25 09:24:14",
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "searchFieldJson",
"label": "条件",
"children": [
{
"type": "string",
"field": "radioField_kvxrloar",
"label": "申请类型",
"value": "客户",
"parent": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "gmtCreate",
"label": "创建时间",
"value": null
},
{
"type": "string",
"field": "gmtModified",
"label": "最近修改时间",
"value": null
},
{
"type": "string",
"field": "originatorUserId",
"label": "创建人ID",
"value": null
},
{
"type": "string",
"field": "originator",
"label": "创建人",
"value": null
},
{
"type": "string",
"field": "attachmentField_kvx7pmjz",
"label": "附件",
"value": null
},
{
"type": "string",
"field": "imageField_kvx7pmjy",
"label": "图片上传",
"value": null
},
{
"type": "string",
"field": "dateField_kw0bado7",
"label": "付款日期",
"value": null
},
{
"type": "string",
"field": "selectField_kvx7pml8",
"label": "支付银行账号",
"value": null
},
{
"type": "string",
"field": "textField_kwc795b4",
"label": "结算方式编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvx7pml7",
"label": "结算方式",
"value": null
},
{
"type": "string",
"field": "textareaField_kvx7pmjp",
"label": "事由",
"value": null
},
{
"type": "string",
"field": "numberField_kvxgr707",
"label": "核销后还需付款金额",
"value": null
},
{
"type": "string",
"field": "numberField_kvxgr706",
"label": "核销金额",
"value": null
},
{
"type": "string",
"field": "numberField_kw2uuo99",
"label": "总申请金额",
"value": null
},
{
"type": "string",
"field": "textareaField_kvx7pmjj",
"label": "业务描述",
"value": null
},
{
"type": "string",
"field": "textField_kw1faw4z",
"label": "银行账号",
"value": null
},
{
"type": "string",
"field": "textField_kvx7pmiw",
"label": "开户行名称",
"value": null
},
{
"type": "string",
"field": "textField_kvx7pmkl",
"label": "收款人",
"value": null
},
{
"type": "string",
"field": "textField_kwc795ay",
"label": "客户编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvxrloav",
"label": "客户",
"value": null
},
{
"type": "string",
"field": "textField_kwc795aw",
"label": "供应商编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvxrloau",
"label": "供应商",
"value": null
},
{
"type": "string",
"field": "textField_kwbwf1sp",
"label": "员工编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvxrloas",
"label": "员工",
"value": null
},
{
"type": "string",
"field": "radioField_kvxrloar",
"label": "往来单位类型",
"value": null
},
{
"type": "string",
"field": "dateField_kvx7pmkc",
"label": "预计核销日期",
"value": null
},
{
"type": "string",
"field": "selectField_kvx7pmke",
"label": "申请借款",
"value": null
},
{
"type": "string",
"field": "selectField_kvx7pmj8",
"label": "付款类别",
"value": null
},
{
"type": "string",
"field": "textField_kw01ezvb",
"label": "付款类别-文本",
"value": null
},
{
"type": "string",
"field": "textField_kwc795b1",
"label": "申请部门编码",
"value": null
},
{
"type": "string",
"field": "dateField_kvx7pmi1",
"label": "申请日期",
"value": null
},
{
"type": "string",
"field": "selectField_kvx7pmkd",
"label": "申请部门",
"value": null
},
{
"type": "string",
"field": "textField_kvxjvp6n",
"label": "部门-文本",
"value": null
},
{
"type": "string",
"field": "textField_kwc795b0",
"label": "申请人编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvx6398f",
"label": "申请人",
"value": null
},
{
"type": "string",
"field": "textField_kvxjvp6m",
"label": "组织-文本",
"value": null
},
{
"type": "string",
"field": "textField_kwc795az",
"label": "组织编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvx6398d",
"label": "申请组织",
"value": null
},
{
"type": "array",
"field": "tableField_kvxg1udz",
"label": "明细",
"value": null,
"children": [
{
"type": "string",
"field": "dateField_kvx7pmka",
"label": "明细-预算日期",
"value": null
},
{
"type": "string",
"field": "textareaField_kvx7pmjo",
"label": "明细-财务备注",
"value": null
},
{
"type": "string",
"field": "numberField_kwd8kkl9",
"label": "明细-税额",
"value": null
},
{
"type": "string",
"field": "numberField_kwd8kkl8",
"label": "明细-税率",
"value": null
},
{
"type": "string",
"field": "numberField_kvx63996",
"label": "明细-申请金额",
"value": null
},
{
"type": "string",
"field": "textField_kwc795b3",
"label": "明细-费用承担部门编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvx7pmk9",
"label": "明细-费用承担部门",
"value": null
},
{
"type": "string",
"field": "textField_kwc795b2",
"label": "明细-费用项目编码",
"value": null
},
{
"type": "string",
"field": "selectField_kvx63994",
"label": "明细-费用项目",
"value": null
}
]
}
],
"condition": [
[
{
"field": "extend.approvedResult",
"logic": "eq",
"value": "agree"
}
]
],
"pagination": {
"pageSize": 100
},
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "_function FROM_UNIXTIME( ( {{dateField_kvx7pmi1}} / 1000 ) ,'%Y-%m-%d' )",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStaffID",
"label": "申请人",
"value": "{{textField_kwc795b0}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FSTAFFNUMBER"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDeptID",
"label": "申请部门",
"value": "{{textField_kwc795b1}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FReason",
"label": "事由",
"value": "{{textareaField_kvx7pmjp}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrgID",
"label": "申请组织",
"value": "{{textField_kwc795az}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCurrencyID",
"label": "币别",
"value": "PRE001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSettleTypeID",
"label": "结算方式",
"value": "{{textField_kwc795b4}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPayOrgID",
"label": "付款组织",
"value": "{{textField_kwc795az}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FIsBorrow",
"label": "申请借款",
"value": "_function case '{{selectField_kvx7pmke}}' when '是' then 'true' when '否' then 'false' else 'false' end",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTOCONTACTUNITTYPE",
"label": "往来单位类型",
"value": "BD_Customer",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTOCONTACTUNIT",
"label": "往来单位",
"value": "{{textField_kwc795ay}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLocCurrencyID",
"label": "本位币",
"value": "PRE001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExchangeRate",
"label": "汇率",
"value": "1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExchangeTypeID",
"label": "汇率类型",
"value": "HLTX01_SYS",
"parent": "HLTX01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "FYSQ001_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"id": "F_PAEZ_Base1",
"type": "string",
"field": "F_PAEZ_Base1",
"label": "部门经理/店长审核",
"value": "test钉钉测试",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FSTAFFNUMBER"
}
},
{
"id": "F_PAEZ_Assistant",
"type": "string",
"field": "F_PAEZ_Assistant",
"label": "付款类别",
"value": "{{textField_kwn8dvvc}}",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"id": "F_PAEZ_Text",
"type": "string",
"field": "F_PAEZ_Text",
"label": "收款方",
"value": "{{textField_kvx7pmkl}}",
"parent": null
},
{
"id": "F_PAEZ_Text1",
"type": "string",
"field": "F_PAEZ_Text1",
"label": "开户行名称",
"value": "{{textField_kvx7pmiw}}",
"parent": null
},
{
"id": "F_PAEZ_Text11",
"type": "string",
"field": "F_PAEZ_Text11",
"label": "收款银行账号",
"value": "{{textField_kw1faw4z}}",
"parent": null
},
{
"id": "F_YDID",
"type": "string",
"field": "F_YDID",
"label": "宜搭ID",
"value": "{{id}}",
"parent": null
},
{
"id": "FACCOUNTID",
"type": "string",
"field": "FACCOUNTID",
"label": "银行账号",
"value": "{{selectField_kvx7pml8}}",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"id": "F_PAEZ_Remarks",
"type": "string",
"field": "F_PAEZ_Remarks",
"label": "业务备注",
"value": "{{textareaField_kvx7pmjj}}",
"parent": null
},
{
"type": "array",
"field": "FEntity",
"label": "明细",
"value": "tableField_kvxg1udz",
"children": [
{
"type": "string",
"field": "FExpenseItemID",
"label": "费用项目",
"value": "{{tableField_kvxg1udz.textField_kwc795b2}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOrgAmount",
"label": "金额",
"value": "{{tableField_kvxg1udz.numberField_kvx63996}}",
"parent": "FEntity",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRemark",
"label": "备注",
"value": "{{tableField_kvxg1udz.textareaField_kvx7pmjo}}",
"parent": "FEntity",
"describe": null,
"is_required": false
},
{
"id": "FTAXRATE",
"type": "string",
"field": "FTAXRATE",
"label": "税率%",
"value": "{{tableField_kvxg1udz.numberField_kwd8kkl8}}",
"parent": "FEntity"
},
{
"id": "FTaxAmt",
"type": "string",
"field": "FTaxAmt",
"label": "税额",
"value": "{{tableField_kvxg1udz.numberField_kwd8kkl9}}",
"parent": "FEntity"
},
{
"id": "F_PAEZ_Date1",
"type": "string",
"field": "F_PAEZ_Date1",
"label": "预算日期",
"value": "_function FROM_UNIXTIME( ( {{tableField_kvxg1udz.dateField_kvx7pmka}} / 1000 ) ,'%Y-%m-%d' )",
"parent": "FEntity"
},
{
"id": "FEntryCostDeptID",
"type": "string",
"field": "FEntryCostDeptID",
"label": "费用承担部门",
"value": "{{tableField_kvxg1udz.textField_kwc795b3}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"describe": null,
"is_required": false
},
{
"id": "FYDNUM",
"type": "string",
"field": "FYDNUM1",
"label": "流水号",
"value": "{{textField_kwn9b11j}}",
"parent": null
},
{
"id": "F_PAEZ_Date",
"type": "string",
"field": "F_PAEZ_Date",
"label": "付款日期",
"value": "_function FROM_UNIXTIME( ( {{dateField_kw0bado7}} / 1000 ) ,'%Y-%m-%d' )",
"parent": null
},
{
"id": "F_PAEZ_Base",
"type": "string",
"field": "F_PAEZ_Base",
"label": "结算方式1",
"value": "{{textField_kwc795b4}}",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "ER_ExpenseRequest",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "BatchSave",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性,布尔类,默认false(非必录)",
"is_required": false
}
],
"otherResponse": []
}