源系统平台：管易云
源系统接口： 盘点单查询gy.erp.stock.count.order.get
目标系统平台： 金蝶云星空
目标系统接口： 其他出库新增batchSave
源平台元数据配置：
{
"id": "code",
"api": "gy.erp.stock.count.order.get",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "start_date",
"label": "修改时间开始段",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "end_date",
"label": "修改时间结束段",
"value": "{{CURRENT_TIME|datetime}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "code",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "是否审核",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "note",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_code",
"label": "仓库代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type_name",
"label": "盘点类型名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "create_date",
"label": "创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modify_date",
"label": "修改时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "approve_date",
"label": "审核时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details",
"label": "明细",
"children": [
{
"type": "string",
"field": "item_id",
"label": "商品ID",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_sku_id",
"label": "规格ID",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_code",
"label": "商品代码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "sku_code",
"label": "规格代码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "qty_diff",
"label": "盈亏数量",
"value": "商品ID",
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "cost_diff",
"label": "盈亏总成本",
"value": "规格ID",
"parent": "details",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"condition": [
[
{
"field": "status",
"logic": "eq",
"value": "1"
},
{
"field": "details.qty_diff",
"logic": "elt",
"value": 0
}
]
],
"pagination": {
"pageSize": 1
},
"otherRequest": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "默认为10",
"is_required": false
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}",
"describe": "默认1",
"is_required": false
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{code}}",
"describe": "单据编号",
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "PKD002",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId",
"label": "库存组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FPickOrgId",
"label": "领用组织",
"value": "100",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{create_date}}",
"describe": "日期",
"is_required": false
},
{
"type": "string",
"field": "FDeptId",
"label": "领料部门",
"value": "BM000001",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "details",
"children": [
{
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "{{details.item_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "实发数量",
"value": "_function {{details_list.qty_diff}} * (-1)",
"parent": "FEntity",
"describe": "数量",
"is_required": false
},
{
"type": "string",
"field": "FStockId",
"label": "发货仓库",
"value": "{{warehouse_code}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FEntryNote",
"label": "备注",
"value": null,
"parent": "FEntity",
"describe": "多行文本",
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 20,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_MisDelivery",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "false",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
"is_required": false
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"describe": null,
"is_required": true
}
],
"otherResponse": []
}
