源系统平台:金蝶云星空
源系统接口: 调拨单查询executeBillQuery
目标系统平台: 管易云
目标系统接口: 其他出库单新增完结接口gy.erp.stock.other.out.add
源平台元数据配置:
{
"id": "FBillEntry_FEntryID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FBillNo",
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillEntry_FEntryID",
"label": "FEntryID",
"value": "FBillEntry_FEntryID",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FID",
"label": "实体主键",
"value": "FID",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "FBillNo",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": "FDocumentStatus",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "调入库存组织",
"value": "FStockOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "FDate",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": "FBillTypeID.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": "FTransferBizType",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FStockOutOrgId_FNumber",
"label": "调出库存组织",
"value": "FStockOutOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": "FTransferDirect",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": "FNote",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": "FBizType",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSaleOrgId_FNumber",
"label": "销售组织",
"value": "FSaleOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSettleOrgId_FNumber",
"label": "结算组织",
"value": "FSettleOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": "FCustID.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": "FSUPPLIERID.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": "FThirdSrcId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": "FThirdSrcBillNo",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": "FThirdSystem",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FMaterialId_FNumber",
"label": "物料编码",
"value": "FMaterialId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FLot_FNumber",
"label": "调出批号",
"value": "FLot.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcStockId_FNumber",
"label": "调出仓库",
"value": "FSrcStockId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcStockLocId",
"label": "调出仓位",
"value": "FSrcStockLocId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestStockId_FNumber",
"label": "调入仓库",
"value": "FDestStockId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": "FDestStockLocId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FQty",
"label": "调拨数量",
"value": "FQty",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": "FPrice",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": "FAmount",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBomId",
"label": "BOM版本",
"value": "FBomId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "FProduceDate",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": "FExpiryDate",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FMtoNo",
"label": "计划跟踪号",
"value": "FMtoNo",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcStockStatusId",
"label": "调出库存状态",
"value": "FSrcStockStatusId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestStockStatusId",
"label": "调入库存状态",
"value": "FDestStockStatusId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FOwnerId_FNumber",
"label": "调入货主",
"value": "FOwnerId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FOwnerOutId_FNumber",
"label": "调出货主",
"value": "FOwnerOutId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": "FSrcBillTypeId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcSeq",
"label": "源单行号",
"value": "FSrcSeq",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FOrderNo",
"label": "订单编号",
"value": "FOrderNo",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": "FNoteEntry",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": "FSrcBillNo",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBFLowId",
"label": "业务流程",
"value": "FBFLowId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FConsignPrice",
"label": "单价",
"value": "FConsignPrice",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": "FTaxPrice",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTaxRate",
"label": "税率%",
"value": "FTaxRate",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestLot_FNumber",
"label": "调入批号",
"value": "FDestLot.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FQmEntryId",
"label": "库存请检单EntryId",
"value": "FQmEntryId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FConvertEntryId",
"label": "库存状态转换EntryId",
"value": "FConvertEntryId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSOEntryId",
"label": "销售订单EntryId",
"value": "FSOEntryId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": "FThirdSrcEntryId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FISFREE",
"label": "赠品",
"value": "FISFREE",
"describe": null,
"is_required": true
},
{
"id": "FMaterialld_FBARCODE",
"type": "string",
"field": "FMaterialId_FBARCODE",
"label": "条码",
"value": "FMaterialId.FBARCODE",
"parent": null
},
{
"type": "string",
"field": "FLot_FInStockDate",
"label": "调出批号入库日",
"value": "FLot.FInStockDate",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestLot_FInStockDate",
"label": "调入批号入库日",
"value": "FDestLot.FInStockDate",
"describe": null,
"is_required": true
}
],
"response": [
{
"type": "string",
"field": "FBillEntry_FEntryID",
"label": "FEntryID",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FID",
"label": "实体主键",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "调入库存组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FStockOutOrgId_FNumber",
"label": "调出库存组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSaleOrgId_FNumber",
"label": "销售组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSettleOrgId_FNumber",
"label": "结算组织",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FMaterialId_FNumber",
"label": "物料编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FLot_FNumber",
"label": "调出批号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcStockId_FNumber",
"label": "调出仓库",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcStockLocId",
"label": "调出仓位",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestStockId_FNumber",
"label": "调入仓库",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FQty",
"label": "调拨数量",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBomId",
"label": "BOM版本",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FExpiryDate",
"label": "有效期至",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FMtoNo",
"label": "计划跟踪号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcStockStatusId",
"label": "调出库存状态",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestStockStatusId",
"label": "调入库存状态",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FOwnerId_FNumber",
"label": "调入货主",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FOwnerOutId_FNumber",
"label": "调出货主",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcBillTypeId",
"label": "源单类型",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcSeq",
"label": "源单行号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FOrderNo",
"label": "订单编号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNoteEntry",
"label": "备注",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FBFLowId",
"label": "业务流程",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FConsignPrice",
"label": "单价",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FTaxRate",
"label": "税率%",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestLot_FNumber",
"label": "调入批号",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FQmEntryId",
"label": "库存请检单EntryId",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FConvertEntryId",
"label": "库存状态转换EntryId",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSOEntryId",
"label": "销售订单EntryId",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FISFREE",
"label": "赠品",
"value": null,
"describe": null,
"is_required": true
},
{
"id": "FMaterialld_FBARCODE",
"type": "string",
"field": "FMaterialId_FBARCODE",
"label": "条码",
"value": null,
"parent": null
},
{
"type": "string",
"field": "FLot_FInStockDate",
"label": "调出批号入库日",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FDestLot_FInStockDate",
"label": "调入批号入库日",
"value": null,
"describe": null,
"is_required": true
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"is_required": true
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"is_required": false
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FApproveDate>='{{LAST_SYNC_TIME|dateTime}}' AND FDocumentStatus = 'C' and FDestStockId <> FSrcStockId",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"is_required": false
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_TransferDirect",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "gy.erp.stock.other.out.add",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "warehouse_code",
"label": "仓库代码",
"value": "{{FSrcStockId_FNumber}}",
"describe": "仓库代码",
"is_required": true
},
{
"type": "string",
"field": "type",
"label": "出库类型代码",
"value": null,
"describe": "出库类型代码",
"is_required": false
},
{
"type": "string",
"field": "note",
"label": "备注",
"value": "百世多利金蝶调拨出库{{FBillNo}}{{FSrcStockId_FNumber}}",
"describe": "出库类型代码",
"is_required": false
},
{
"type": "string",
"field": "wms_bizcode",
"label": "第三方系统单号",
"value": "BSDL{{FBillNo}}{{FSrcStockId_FNumber}}",
"describe": "第三方系统单号",
"is_required": false
},
{
"type": "string",
"field": "receiver_name",
"label": "收货人",
"value": null,
"describe": "收货人",
"is_required": false
},
{
"type": "string",
"field": "receiver_mobile",
"label": "收货人手机",
"value": null,
"describe": "收货人手机",
"is_required": false
},
{
"type": "string",
"field": "receiver_zip",
"label": "收货人邮编",
"value": null,
"describe": "收货人邮编",
"is_required": false
},
{
"type": "string",
"field": "receiver_address",
"label": "收货人地址",
"value": null,
"describe": "收货人地址",
"is_required": false
},
{
"type": "string",
"field": "receiver_province",
"label": "收货人省名称",
"value": null,
"describe": "收货人省名称",
"is_required": false
},
{
"type": "string",
"field": "receiver_citye",
"label": "收货人市名称",
"value": null,
"describe": "收货人市名称",
"is_required": false
},
{
"type": "string",
"field": "receiver_district",
"label": "收货人区名称",
"value": null,
"describe": "收货人区名称",
"is_required": false
},
{
"type": "array",
"field": "details",
"label": "出库明细",
"value": "details",
"children": [
{
"type": "string",
"field": "note",
"label": "备注",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "item_code",
"label": "商品代码",
"value": "{{details.FMaterialId_FNumber}}",
"parent": "details",
"describe": "商品代码与商品条码二者必选其一,当两者都提供时,以商品条码为准",
"is_required": true
},
{
"type": "string",
"field": "sku_code",
"label": "规格代码",
"value": null,
"parent": "details",
"describe": "有规格的商品此字段必填",
"is_required": false
},
{
"type": "string",
"field": "barcode",
"label": "商品条码",
"value": null,
"parent": "details",
"describe": "商品条码与商品代码二者必选其一,当两者都提供时,以商品条码为准",
"is_required": false
},
{
"type": "string",
"field": "location_code",
"label": "库位代码(库位名称)",
"value": null,
"parent": "details",
"describe": "只有开启库位库存的仓库必填此字段,未开启库位库存的仓库不开启此字段",
"is_required": false
},
{
"type": "string",
"field": "qty",
"label": "数量",
"value": "{{details.FQty}}",
"parent": "details",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "uniqueCode",
"label": "唯一码",
"value": null,
"parent": "details",
"describe": "若当前商品为全程唯一码的商品,此参数必填",
"is_required": false
},
{
"type": "string",
"field": "batchNumber",
"label": "批次号",
"value": null,
"parent": "details",
"describe": "若当前商品为批次商品,此参数必填",
"is_required": false
},
{
"type": "string",
"field": "manufacturingDate",
"label": "生产日期",
"value": null,
"parent": "details",
"describe": "若当前商品为批次商品,此参数必填",
"is_required": false
},
{
"type": "string",
"field": "shelfLife",
"label": "有效期",
"value": null,
"parent": "details",
"describe": "若当前商品为批次商品,此参数必填",
"is_required": false
},
{
"type": "string",
"field": "stockDate",
"label": "入库日期",
"value": null,
"parent": "details",
"describe": "批次商品专用属性,参数选填。不填写时,程序默认当天",
"is_required": false
}
],
"describe": "出库明细",
"is_required": true
}
],
"response": [
{
"type": "string",
"field": "success",
"label": "成功与否",
"value": null,
"describe": "成功与否",
"is_required": false
},
{
"type": "string",
"field": "errorCode",
"label": "错误代码",
"value": null,
"describe": "错误代码",
"is_required": false
},
{
"type": "string",
"field": "subErrorCode",
"label": "子错误代码",
"value": null,
"describe": "子错误代码",
"is_required": false
},
{
"type": "string",
"field": "errorDesc",
"label": "错误描述",
"value": null,
"describe": "错误描述",
"is_required": false
},
{
"type": "string",
"field": "subErrorDesc",
"label": "子错误描述",
"value": null,
"describe": "子错误描述",
"is_required": false
},
{
"type": "string",
"field": "requestMethod",
"label": "请求方法",
"value": null,
"describe": "请求方法",
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "其他出库单单据编号",
"value": null,
"describe": "其他出库单单据编号",
"is_required": false
}
],
"operation": {
"body": [
"FMaterialId_FNumber",
"FQty",
"FLot_FNumber",
"FLot_FInStockDate"
],
"field": "FBillNo,FSrcStockId_FNumber",
"header": [
"FBillNo",
"FSrcStockId_FNumber"
],
"method": "merge",
"bodySum": [
"FQty"
],
"bodyName": "details"
},
"otherRequest": [],
"otherResponse": []
}