源系统平台:每刻
源系统接口: 报销单列表查询/api/openapi/form/reimburse
目标系统平台: 金蝶云星空
目标系统接口: 写入空操作写入空操作
源平台元数据配置:
{
"id": "paymentBizCode",
"api": "/api/openapi/paymenttransaction/paid/list",
"type": "QUERY",
"method": "POST",
"number": "payeeTargetBusinessCode",
"idCheck": true,
"request": [
{
"id": "createdAtStart",
"type": "string",
"field": "startPaidTime",
"label": "支付完成时间-开始范围,毫秒的时间戳,非必填",
"value": "{{LAST_SYNC_TIME}}000",
"parent": null
},
{
"id": "createdAtEnd",
"type": "string",
"field": "endPaidTime",
"label": "支付完成时间-结束范围,毫秒的时间戳,非必填",
"value": "{{CURRENT_TIME}}000",
"parent": null
},
{
"id": "pageSize",
"type": "string",
"field": "pageSize",
"label": "分页条数",
"value": "50",
"parent": null
},
{
"id": "offset",
"type": "string",
"field": "pageNum",
"label": "当前页首条数据在所有数据中的偏移量",
"value": "1",
"parent": null
},
{
"id": "formStatus",
"type": "string",
"field": "paymentNo",
"label": "付款单ID,非必填,对应form_pay_order中的payment_order_id",
"value": null,
"parent": null,
"describe": "可选值: APPROVING(审批中),AUDITING(审核中),SIGNING(签收等待)(仅支持报销单),SETTLEMENT(结算中),COMPLETED(已完成),DELETED(已删除),ABANDON(已作废),REJECTED(被驳回)SUBMIT_FAILED(提交失败),DRAFT(草稿)。默认值为所有未删除单据。"
}
],
"response": [
{
"id": "payeeTargetBusinessCode",
"type": "string",
"field": "payeeTargetBusinessCode",
"label": "单据号",
"value": null,
"parent": null,
"display": {
"width": 200,
"aggFunc": "none",
"enableRowGroup": false
},
"enableDisplay": true
},
{
"id": "payeeTargetBusinessCode",
"type": "string",
"field": "payerAccountName",
"label": "支付账户",
"value": null,
"parent": null,
"display": {
"width": 200,
"aggFunc": "none",
"enableRowGroup": true
},
"enableDisplay": true
},
{
"id": "payeeTargetBusinessCode",
"type": "string",
"field": "payerAccountNumber",
"label": "支付账号",
"value": null,
"parent": null,
"display": {
"width": 200,
"aggFunc": "none",
"enableRowGroup": true
},
"enableDisplay": true
}
],
"condition": [
[
{
"field": "formSubTypeName",
"logic": "neqv2",
"value": "借支单"
},
{
"field": "formSubTypeName",
"logic": "neqv2",
"value": "供应商货款付款申请单"
}
]
],
"buildModel": false,
"otherRequest": [],
"otherResponse": [],
"omissionRemedy": {
"crontab": "2 */2 * * *",
"takeOverRequest": [
{
"type": "string",
"field": "startPaidTime",
"label": "修改时间开始段",
"value": "{{HOURE_AGO_2|datetime}}",
"describe": null,
"is_required": true
}
]
},
"autoFillResponse": false
}
目标平台元数据配置:
{
"id": null,
"api": "Push",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "7690c084-f4a1-367f-87c6-3ca0553ec8b3",
"type": "string",
"field": "Ids",
"label": "id集合",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "670fec57-3a81-329d-9d06-fa7dd11b52ee",
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "CN_PAYAPPLY",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"parent_id": null,
"is_required": true
},
{
"id": "4e6f5eac-12e8-38f0-b6bc-b2d0e7ee0de8",
"type": "string",
"field": "Numbers",
"label": "编码集合",
"value": "{{payeeTargetBusinessCode}}",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "a41a57d1-b3e0-3a0e-b11d-076b64e3a900",
"type": "string",
"field": "RuleId",
"label": "单据转换规则内码",
"value": "994f9913-a23f-46fb-b5d9-f1f271b4ef6c",
"describe": "字符串类型,分号分隔,格式:\"flag1;flag2;...\"(非必录) 例如(允许负库存标识:STK_InvCheckResult)",
"parent_id": null,
"is_required": false
},
{
"id": "FPAYORGID",
"type": "string",
"field": "TargetOrgId",
"label": "目标组织内码",
"value": "_findCollection find FUseOrgId from c2b5e68c-1b80-398b-bec8-59612f54e804 where FNumber={{payerAccountNumber}}",
"parent": null
},
{
"id": "TargetFormId",
"type": "string",
"field": "TargetFormId",
"label": "TargetFormId",
"value": "AP_PAYBILL",
"parent": null
},
{
"id": "82ae68d7-3b88-3a69-9ee8-bb7c85eb1efe",
"type": "string",
"field": "IsEnableDefaultRule",
"label": "是否启用默认单据转换",
"value": "true",
"describe": "布尔类型,默认true(非必录)",
"parent_id": null,
"is_required": false
},
{
"id": "IsDraftWhenSaveFail",
"type": "string",
"field": "IsDraftWhenSaveFail",
"label": "IsDraftWhenSaveFail",
"value": "true",
"parent": null
}
],
"response": [
{
"id": "primaryWriteback",
"type": "object",
"field": "primaryWriteback",
"label": "primaryWriteback",
"value": null,
"parent": null,
"children": [
{
"id": "id",
"type": "string",
"field": "id",
"label": "id",
"value": "{{Id}}",
"parent": "primaryWriteback"
},
{
"id": "number",
"type": "string",
"field": "number",
"label": "number",
"value": "{{Number}}",
"parent": "primaryWriteback"
}
]
},
{
"id": "callBack",
"type": "object",
"field": "callBackStrategy",
"label": "回写方案",
"value": null,
"parent": null,
"children": [
{
"type": "string",
"field": "strategyId",
"label": "方案ID",
"value": "718db844-82f4-3b91-bf64-65ce06dc2025",
"parent": "callBackStrategy",
"describe": null,
"is_required": true
},
{
"id": "Number",
"type": "string",
"field": "paymentBizCode",
"label": "原始ID",
"value": "{{paymentBizCode}}",
"parent": "callBackStrategy"
},
{
"id": "Number",
"type": "string",
"field": "payeeTargetBusinessCode",
"label": "原始单据编号",
"value": "{{payeeTargetBusinessCode}}",
"parent": "callBackStrategy"
},
{
"id": "Number",
"type": "string",
"field": "Id",
"label": "目标写入",
"value": "{{primaryWriteback.id}}",
"parent": "callBackStrategy"
},
{
"id": "Number",
"type": "string",
"field": "number",
"label": "目标写入",
"value": "{{primaryWriteback.number}}",
"parent": "callBackStrategy"
},
{
"id": "Number",
"type": "string",
"field": "payerAccountNumber",
"label": "银行账号",
"value": "{{payerAccountNumber}}",
"parent": "callBackStrategy"
},
{
"id": "Number",
"type": "string",
"field": "payableAmount",
"label": "付款金额",
"value": "{{payableAmount}}",
"parent": "callBackStrategy"
},
{
"id": "auditTimeStamp",
"type": "string",
"field": "auditTimeStamp",
"label": "付款时间",
"value": "{{auditTimeStamp}}",
"parent": "callBackStrategy"
}
]
}
],
"otherRequest": [],
"otherResponse": []
}