源系统平台：易快报
源系统接口： 获取指定状态单据列表(包含已删除单据)/api/openapi/v1/docSequences
目标系统平台： 金蝶云星空
目标系统接口： 其他应付单新增batchSave
源平台元数据配置：
{
"id": "id",
"api": "/api/openapi/v1/docSequences",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "object",
"field": "fields",
"label": "需要过滤掉的字段",
"children": [
{
"type": "object",
"field": "docData",
"label": "单据数据",
"parent": "fields",
"children": [
{
"type": "string",
"field": "logs",
"label": "审批日志",
"value": null,
"parent": "docData",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "flowPlan",
"label": "审批流信息",
"value": null,
"parent": "docData",
"describe": null,
"is_required": false
}
],
"describe": "包含所有单据数据",
"is_required": false
}
],
"describe": "指定过滤掉的字段返回空值，\n从而缩小响应数据",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "type",
"label": "type",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "id",
"label": "id",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "corporationId",
"label": "corporationId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "ownerId",
"label": "ownerId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "dataType",
"label": "dataType",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "remark",
"label": "remark",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "title",
"label": "title",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "updateTime",
"label": "updateTime",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "specificationId",
"label": "specificationId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "object",
"field": "owner",
"label": "owner",
"value": null,
"children": [
{
"type": "string",
"field": "id",
"label": "id",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "name",
"label": "name",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "departments",
"label": "departments",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "code",
"label": "code",
"value": null,
"describe": "_autoFillResponse"
}
],
"describe": "_autoFillResponse"
},
{
"type": "object",
"field": "department",
"label": "department",
"value": null,
"children": [
{
"type": "string",
"field": "id",
"label": "id",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "name",
"label": "name",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "code",
"label": "code",
"value": null,
"describe": "_autoFillResponse"
}
],
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "code",
"label": "code",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "object",
"field": "userProps",
"label": "userProps",
"value": null,
"children": [
{
"type": "string",
"field": "payeeId",
"label": "payeeId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "description",
"label": "description",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "submitterId",
"label": "submitterId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay",
"label": "companyRealPay",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "specificationId",
"label": "specificationId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "expenseDepartment",
"label": "expenseDepartment",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_rate",
"label": "companyRealPay_rate",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budget",
"label": "companyRealPay_budget",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_foreign",
"label": "companyRealPay_foreign",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budgetRate",
"label": "companyRealPay_budgetRate",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budgetUnit",
"label": "companyRealPay_budgetUnit",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budgetScale",
"label": "companyRealPay_budgetScale",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_foreignUnit",
"label": "companyRealPay_foreignUnit",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budgetSymbol",
"label": "companyRealPay_budgetSymbol",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_standardUnit",
"label": "companyRealPay_standardUnit",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budgetNumCode",
"label": "companyRealPay_budgetNumCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_budgetStrCode",
"label": "companyRealPay_budgetStrCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_foreignSymbol",
"label": "companyRealPay_foreignSymbol",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_foreignNumCode",
"label": "companyRealPay_foreignNumCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_foreignStrCode",
"label": "companyRealPay_foreignStrCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_standardSymbol",
"label": "companyRealPay_standardSymbol",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_standardNumCode",
"label": "companyRealPay_standardNumCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "companyRealPay_standardStrCode",
"label": "companyRealPay_standardStrCode",
"value": null,
"describe": "_autoFillResponse"
}
],
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "state",
"label": "state",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "project",
"label": "project",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "logs",
"label": "logs",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "flowPlan",
"label": "flowPlan",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "sumAmount",
"label": "sumAmount",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "writeOffAmount",
"label": "writeOffAmount",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "expenseDate",
"label": "expenseDate",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "array",
"field": "details",
"label": "details",
"value": null,
"children": [
{
"type": "string",
"field": "amount",
"label": "amount",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_standardStrCode",
"label": "amount_standardStrCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_standardNumCode",
"label": "amount_standardNumCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_standardSymbol",
"label": "amount_standardSymbol",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_standardUnit",
"label": "amount_standardUnit",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_rate",
"label": "amount_rate",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_foreignStrCode",
"label": "amount_foreignStrCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_foreignNumCode",
"label": "amount_foreignNumCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_foreign",
"label": "amount_foreign",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_foreignSymbol",
"label": "amount_foreignSymbol",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "amount_foreignUnit",
"label": "amount_foreignUnit",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "date",
"label": "date",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "remark",
"label": "remark",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "feeTypeId",
"label": "feeTypeId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "userProps",
"label": "userProps",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "invoiceCount",
"label": "invoiceCount",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "taxAmount",
"label": "taxAmount",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "noTaxAmount",
"label": "noTaxAmount",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "invoices",
"label": "invoices",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "invoiceFormType",
"label": "invoiceFormType",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "payeeInfo",
"label": "payeeInfo",
"value": null,
"describe": "_autoFillResponse"
}
],
"describe": "_autoFillResponse"
},
{
"type": "object",
"field": "writtenOffRecords",
"label": "writtenOffRecords",
"value": null,
"children": [],
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "submitTime",
"label": "submitTime",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "object",
"field": "payeeInfo",
"label": "payeeInfo",
"value": null,
"children": [
{
"type": "string",
"field": "sort",
"label": "sort",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "name",
"label": "name",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "cardNo",
"label": "cardNo",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "bank",
"label": "bank",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "branch",
"label": "branch",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "type",
"label": "type",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "province",
"label": "province",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "city",
"label": "city",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "certificateType",
"label": "certificateType",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "certificateNo",
"label": "certificateNo",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "bankLinkNo",
"label": "bankLinkNo",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "bankName",
"label": "bankName",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "swiftCode",
"label": "swiftCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "bankCode",
"label": "bankCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "branchCode",
"label": "branchCode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "remark",
"label": "remark",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "id",
"label": "id",
"value": null,
"describe": "_autoFillResponse"
}
],
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "payorId",
"label": "payorId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "paymentChannel",
"label": "paymentChannel",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "paymentAccountId",
"label": "paymentAccountId",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "payTime",
"label": "payTime",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "multiplePayeesMode",
"label": "multiplePayeesMode",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "channelTradeNo",
"label": "channelTradeNo",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "payPlan",
"label": "payPlan",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "receiptState",
"label": "receiptState",
"value": null,
"describe": "_autoFillResponse"
},
{
"type": "string",
"field": "paymentAccount",
"label": "paymentAccount",
"value": null,
"describe": "_autoFillResponse"
}
],
"otherRequest": [
{
"type": "string",
"field": "type",
"label": "单据类型",
"value": "expense",
"describe": "expense : 报销单\nloan : 借款单\nrepayment : 还款记录\npayment : 付款单\nrequisition : 申请单\ncustom : 通用审批单\nreceipt : 收款单",
"is_required": true
},
{
"type": "string",
"field": "index",
"label": "分页查询的起始索引序号",
"value": "1610640000",
"describe": "例如 : 当 index = 1484498318240 时，会查询所有\nindex > 1484498318240 的单据",
"is_required": true
},
{
"type": "string",
"field": "count",
"label": "查询数据条数",
"value": "10",
"describe": "最大不能超过 100",
"is_required": true
},
{
"type": "string",
"field": "state",
"label": "单据状态",
"value": null,
"describe": "REJECTED : 已驳回\nPAYING : 待支付\nPROCESSING : 支付中\nPAID : 已支付\n不传值时，查询四种状态单据",
"is_required": false
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "gyfyjsdyf",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{id}}",
"describe": "单据编号",
"is_required": false
},
{
"type": "string",
"field": "FDATE",
"label": "业务日期",
"value": "_function FROM_UNIXTIME( ( {{expenseDate}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' )",
"describe": "业务日期",
"is_required": true
},
{
"type": "string",
"field": "FCONTACTUNITTYPE",
"label": "往来单位类型",
"value": "BD_Supplier",
"describe": "往来单位类型",
"is_required": true
},
{
"type": "string",
"field": "FCONTACTUNIT",
"label": "往来单位",
"value": "2201",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "往来单位",
"is_required": true
},
{
"type": "string",
"field": "FCURRENCYID",
"label": "币别",
"value": "PRE001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "币别",
"is_required": true
},
{
"type": "string",
"field": "FSETTLEORGID",
"label": "结算组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "626265b08f8d6306f078c640",
"describe": "结算组织",
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FPAYORGID",
"label": "付款组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "626265b08f8d6306f078c640",
"describe": "付款组织",
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FRemarks",
"label": "备注",
"value": "{{remark}}",
"describe": "备注",
"is_required": false
},
{
"type": "string",
"field": "FSettleTypeID",
"label": "结算方式",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "结算方式",
"is_required": false
},
{
"type": "string",
"field": "FMAINBOOKSTDCURRID",
"label": "本位币",
"value": "PRE001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "本位币",
"is_required": true
},
{
"type": "string",
"field": "FEXCHANGETYPE",
"label": "汇率类型",
"value": "HLTX01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "汇率类型",
"is_required": true
},
{
"type": "string",
"field": "FExchangeRate",
"label": "汇率",
"value": "1.0",
"describe": "汇率",
"is_required": false
},
{
"type": "string",
"field": "FNOTAXAMOUNT",
"label": "不含税金额本位币",
"value": null,
"describe": "不含税金额本位币",
"is_required": false
},
{
"type": "string",
"field": "FTAXAMOUNT",
"label": "税额本位币",
"value": null,
"describe": "税额本位币",
"is_required": false
},
{
"type": "string",
"field": "FACCNTTIMEJUDGETIME",
"label": "到期日计算日期",
"value": "_function FROM_UNIXTIME( ( {{expenseDate}} / 1000 ) ,'%Y-%m-%d %H:%i:%S' )",
"describe": "到期日计算日期",
"is_required": true
},
{
"type": "string",
"field": "FCancelStatus",
"label": "作废状态",
"value": "A",
"describe": "作废状态",
"is_required": true
},
{
"type": "string",
"field": "FBUSINESSTYPE",
"label": "业务类型",
"value": "T",
"describe": "业务类型",
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "单据明细",
"value": "details",
"children": [
{
"type": "string",
"field": "FCOSTID",
"label": "费用项目编码",
"value": "_findCollection find code from 0e3410bc-d1ad-3810-bd5f-639ce883690a where id={{details.feeTypeId}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "62621b6f27a2b26ffa493c32",
"describe": "费用项目编码",
"is_required": false,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FCOSTDEPARTMENTID",
"label": "费用承担部门",
"value": "BM000002",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"mapping": "62621b6f27a2b26ffa493c32",
"describe": "费用承担部门",
"is_required": true,
"mappingDirection": "positive"
},
{
"type": "string",
"field": "FINVOICETYPE",
"label": "发票类型",
"value": null,
"parent": "FEntity",
"describe": "发票类型",
"is_required": true
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率(%)",
"value": "A",
"parent": "FEntity",
"describe": "税率(%)",
"is_required": false
},
{
"type": "string",
"field": "FNOTAXAMOUNTFOR",
"label": "不含税金额",
"value": "{{details.amount}}",
"parent": "FEntity",
"describe": "不含税金额",
"is_required": false
},
{
"type": "string",
"field": "FTAXAMOUNTFOR",
"label": "税额",
"value": null,
"parent": "FEntity",
"describe": "税额",
"is_required": false
},
{
"type": "string",
"field": "FCOMMENT",
"label": "备注",
"value": null,
"parent": "FEntity",
"describe": "备注",
"is_required": false
},
{
"type": "string",
"field": "FSourceBillNo",
"label": "源单编号",
"value": null,
"parent": "FEntity",
"describe": "源单编号",
"is_required": false
}
],
"describe": "单据明细",
"is_required": true
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "AP_OtherPayable",
"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": []
}
