源系统平台：金蝶云星空
源系统接口： 调拨单查询executeBillQuery
目标系统平台： 旺店通·企业版
目标系统接口： 创建调拨单stock_transfer_push
源平台元数据配置：
{
"id": "FBillEntry_FEntryID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FBillNo",
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillEntry_FEntryID",
"label": "FEntryID",
"value": "FBillEntry_FEntryID"
},
{
"type": "string",
"field": "FID",
"label": "实体主键",
"value": "FID"
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "FBillNo"
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": "FDocumentStatus"
},
{
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "调入库存组织",
"value": "FStockOrgId.FNumber"
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "FDate"
},
{
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": "FBillTypeID.FNumber"
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": "FTransferBizType"
},
{
"type": "string",
"field": "FStockOutOrgId_FNumber",
"label": "调出库存组织",
"value": "FStockOutOrgId.FNumber"
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": "FTransferDirect"
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": "FNote"
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": "FBizType"
},
{
"type": "string",
"field": "FSaleOrgId_FNumber",
"label": "销售组织",
"value": "FSaleOrgId.FNumber"
},
{
"type": "string",
"field": "FSettleOrgId_FNumber",
"label": "结算组织",
"value": "FSettleOrgId.FNumber"
},
{
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": "FCustID.FNumber"
},
{
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": "FSUPPLIERID.FNumber"
},
{
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": "FThirdSrcId"
},
{
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": "FThirdSrcBillNo"
},
{
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": "FThirdSystem"
},
{
"type": "string",
"field": "FMaterialId_FNumber",
"label": "物料编码",
"value": "FMaterialId.FNumber"
},
{
"type": "string",
"field": "FLot",
"label": "调出批号",
"value": "FLot"
},
{
"type": "string",
"field": "FSrcStockId_FNumber",
"label": "调出仓库",
"value": "FSrcStockId.FNumber"
},
{
"type": "string",
"field": "FSrcStockLocId",
"label": "调出仓位",
"value": "FSrcStockLocId"
},
{
"type": "string",
"field": "FDestStockId_FNumber",
"label": "调入仓库",
"value": "FDestStockId.FNumber"
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": "FDestStockLocId"
},
{
"type": "string",
"field": "FQty",
"label": "调拨数量",
"value": "FQty"
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": "FPrice"
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": "FAmount"
},
{
"type": "string",
"field": "FBomId",
"label": "BOM版本",
"value": "FBomId"
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "FProduceDate"
},
{
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": "FExpiryDate"
},
{
"type": "string",
"field": "FMtoNo",
"label": "计划跟踪号",
"value": "FMtoNo"
},
{
"type": "string",
"field": "FSrcStockStatusId",
"label": "调出库存状态",
"value": "FSrcStockStatusId"
},
{
"type": "string",
"field": "FDestStockStatusId",
"label": "调入库存状态",
"value": "FDestStockStatusId"
},
{
"type": "string",
"field": "FOwnerId_FNumber",
"label": "调入货主",
"value": "FOwnerId.FNumber"
},
{
"type": "string",
"field": "FOwnerOutId_FNumber",
"label": "调出货主",
"value": "FOwnerOutId.FNumber"
},
{
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": "FSrcBillTypeId"
},
{
"type": "string",
"field": "FSrcSeq",
"label": "源单行号",
"value": "FSrcSeq"
},
{
"type": "string",
"field": "FOrderNo",
"label": "订单编号",
"value": "FOrderNo"
},
{
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": "FNoteEntry"
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": "FSrcBillNo"
},
{
"type": "string",
"field": "FBFLowId",
"label": "业务流程",
"value": "FBFLowId"
},
{
"type": "string",
"field": "FConsignPrice",
"label": "单价",
"value": "FConsignPrice"
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": "FTaxPrice"
},
{
"type": "string",
"field": "FTaxRate",
"label": "税率%",
"value": "FTaxRate"
},
{
"type": "string",
"field": "FDestLot",
"label": "调入批号",
"value": "FDestLot"
},
{
"type": "string",
"field": "FQmEntryId",
"label": "库存请检单EntryId",
"value": "FQmEntryId"
},
{
"type": "string",
"field": "FConvertEntryId",
"label": "库存状态转换EntryId",
"value": "FConvertEntryId"
},
{
"type": "string",
"field": "FSOEntryId",
"label": "销售订单EntryId",
"value": "FSOEntryId"
},
{
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": "FThirdSrcEntryId"
},
{
"type": "string",
"field": "FISFREE",
"label": "赠品",
"value": "FISFREE"
}
],
"response": [
{
"type": "string",
"field": "FBillEntry_FEntryID",
"label": "FEntryID",
"value": null
},
{
"type": "string",
"field": "FID",
"label": "实体主键",
"value": null
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": null
},
{
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "调入库存组织",
"value": null
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": null
},
{
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": null
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": null
},
{
"type": "string",
"field": "FStockOutOrgId_FNumber",
"label": "调出库存组织",
"value": null
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": null
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": null
},
{
"type": "string",
"field": "FSaleOrgId_FNumber",
"label": "销售组织",
"value": null
},
{
"type": "string",
"field": "FSettleOrgId_FNumber",
"label": "结算组织",
"value": null
},
{
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": null
},
{
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": null
},
{
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": null
},
{
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": null
},
{
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": null
},
{
"type": "string",
"field": "FMaterialId_FNumber",
"label": "物料编码",
"value": null
},
{
"type": "string",
"field": "FLot",
"label": "调出批号",
"value": null
},
{
"type": "string",
"field": "FSrcStockId_FNumber",
"label": "调出仓库",
"value": null
},
{
"type": "string",
"field": "FSrcStockLocId",
"label": "调出仓位",
"value": null
},
{
"type": "string",
"field": "FDestStockId_FNumber",
"label": "调入仓库",
"value": null
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": null
},
{
"type": "string",
"field": "FQty",
"label": "调拨数量",
"value": null
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": null
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": null
},
{
"type": "string",
"field": "FBomId",
"label": "BOM版本",
"value": null
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": null
},
{
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": null
},
{
"type": "string",
"field": "FMtoNo",
"label": "计划跟踪号",
"value": null
},
{
"type": "string",
"field": "FSrcStockStatusId",
"label": "调出库存状态",
"value": null
},
{
"type": "string",
"field": "FDestStockStatusId",
"label": "调入库存状态",
"value": null
},
{
"type": "string",
"field": "FOwnerId_FNumber",
"label": "调入货主",
"value": null
},
{
"type": "string",
"field": "FOwnerOutId_FNumber",
"label": "调出货主",
"value": null
},
{
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": null
},
{
"type": "string",
"field": "FSrcSeq",
"label": "源单行号",
"value": null
},
{
"type": "string",
"field": "FOrderNo",
"label": "订单编号",
"value": null
},
{
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": null
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": null
},
{
"type": "string",
"field": "FBFLowId",
"label": "业务流程",
"value": null
},
{
"type": "string",
"field": "FConsignPrice",
"label": "单价",
"value": null
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": null
},
{
"type": "string",
"field": "FTaxRate",
"label": "税率%",
"value": null
},
{
"type": "string",
"field": "FDestLot",
"label": "调入批号",
"value": null
},
{
"type": "string",
"field": "FQmEntryId",
"label": "库存请检单EntryId",
"value": null
},
{
"type": "string",
"field": "FConvertEntryId",
"label": "库存状态转换EntryId",
"value": null
},
{
"type": "string",
"field": "FSOEntryId",
"label": "销售订单EntryId",
"value": null
},
{
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": null
},
{
"type": "string",
"field": "FISFREE",
"label": "赠品",
"value": null
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}"
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
}
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0"
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FApproveDate>='{{LAST_SYNC_TIME|datetime}}'"
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_TransferDirect"
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}"
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"api": "stock_transfer_push",
"type": "EXECUTE",
"method": "POST",
"request": [
{
"type": "string",
"field": "outer_no",
"label": "外部单号",
"value": "{{FBillNo}}demo2"
},
{
"type": "string",
"field": "from_warehouse_no",
"label": "源仓库",
"value": "{{FDestStockId_FNumber}}"
},
{
"type": "string",
"field": "to_warehouse_no",
"label": "目标仓库",
"value": "{{FSrcStockId_FNumber}}"
},
{
"type": "string",
"field": "address",
"label": "地址",
"value": null
},
{
"type": "string",
"field": "contact",
"label": "联系人",
"value": null
},
{
"type": "string",
"field": "telno",
"label": "联系电话",
"value": null
},
{
"type": "string",
"field": "transfer_type",
"label": "调拨类型",
"value": "1"
},
{
"type": "string",
"field": "mode",
"label": "调拨方式",
"value": null
},
{
"type": "string",
"field": "autocheck",
"label": "是否审核",
"value": "1"
},
{
"type": "array",
"field": "skus",
"label": "货品列表节点",
"value": "skus",
"children": [
{
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"parent": "skus"
},
{
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": "{{skus.FMaterialId_FNumber}}",
"parent": "skus"
},
{
"type": "string",
"field": "from_position_no",
"label": "调出货位",
"value": null,
"parent": "skus"
},
{
"type": "string",
"field": "to_position_no",
"label": "调入货位",
"value": null,
"parent": "skus"
},
{
"type": "string",
"field": "num",
"label": "调拨数量",
"value": "{{skus.FQty}}",
"parent": "skus"
}
]
}
],
"response": [],
"operation": {
"body": [
"FMaterialId_FNumber",
"FLot",
"FQty",
"FPrice",
"FProduceDate",
"FSrcSeq",
"FOrderNo",
"FNoteEntry",
"FSrcBillNo",
"FDestLot",
"FISFREE"
],
"field": "FBillNo,FDestStockId_FNumber,FSrcStockId_FNumber",
"header": [
"FID",
"FBillNo",
"FDocumentStatus",
"FDate",
"FStockOrgId_FNumber",
"FStockOutOrgId_FNumber",
"FNote",
"FCustID_FNumber",
"FBizType",
"FDestStockId_FNumber",
"FSrcStockId_FNumber"
],
"method": "merge",
"bodyName": "skus"
},
"otherRequest": [
{
"type": "string",
"field": "transfer_info",
"label": "调拨单信息",
"value": null
}
],
"otherResponse": []
}
