源系统平台：金蝶云星空
源系统接口： 分布式调入单查询executeBillQuery
目标系统平台： 管易云
目标系统接口： 其他入库单新增完结接口gy.erp.stock.other.in.add
源平台元数据配置：
{
"id": "FSTKTRSINENTRY_FEntryID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FBillNo",
"idCheck": true,
"request": [
{
"type": "string",
"field": "FSTKTRSINENTRY_FEntryID",
"label": "FEntryID",
"value": "FSTKTRSINENTRY_FEntryID",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FID",
"label": "实体主键",
"value": "FID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "FBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": "FDocumentStatus",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockOrgID_FNumber",
"label": "调入库存组织",
"value": "FStockOrgID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "FDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "FBillTypeID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": "FTransferDirect",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNOTE",
"label": "备注",
"value": "FNOTE",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCreateDate",
"label": "创建日期",
"value": "FCreateDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FApproveDate",
"label": "审核日期",
"value": "FApproveDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferMode",
"label": "调拨方式",
"value": "FTransferMode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": "FTransferBizType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": "FBizType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": "FCustID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": "FSUPPLIERID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": "FThirdSystem",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": "FThirdSrcId",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": "FThirdSrcBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaterialID_FNumber",
"label": "物料编码",
"value": "FMaterialID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCMKBarCode",
"label": "零售条形码",
"value": "FCMKBarCode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcStockID_FNumber",
"label": "调出仓库",
"value": "FSrcStockID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestStockID_FNumber",
"label": "调入仓库",
"value": "FDestStockID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "调入数量",
"value": "FQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": "FPrice",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": "FAmount",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBOMID",
"label": "BOM版本",
"value": "FBOMID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "FProduceDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEXPIRYDATE",
"label": "有效期至",
"value": "FEXPIRYDATE",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMTONO",
"label": "计划跟踪号",
"value": "FMTONO",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOwnerID_FNumber",
"label": "调入货主",
"value": "FOwnerID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": "FUnitID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockOutFlag",
"label": "出库库存更新标识",
"value": "FStockOutFlag",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockInFlag",
"label": "入库库存更新标识",
"value": "FStockInFlag",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": "FDestStockLocId",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCStockLocId",
"label": "调出仓位",
"value": "FSRCStockLocId",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcBillType",
"label": "源单类型",
"value": "FSrcBillType",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": "FSrcBillNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOwnerOutID_FNumber",
"label": "调出货主",
"value": "FOwnerOutID.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLOT_FNumber",
"label": "调出批号",
"value": "FLOT.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEntryNote",
"label": "备注",
"value": "FEntryNote",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCBILLNAME",
"label": "源单单据类型",
"value": "FSRCBILLNAME",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcBillDate",
"label": "源单日期",
"value": "FSrcBillDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestLot_FNumber",
"label": "调入批号",
"value": "FDestLot.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcMaterialId_FNumber",
"label": "调出物料",
"value": "FSrcMaterialId.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCBOMID",
"label": "调出BOM",
"value": "FSRCBOMID",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcProduceDate",
"label": "调出生产日期",
"value": "FSrcProduceDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcExpiryDate",
"label": "调出有效期至",
"value": "FSrcExpiryDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCMTONO",
"label": "调出计划跟踪号",
"value": "FSRCMTONO",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcProjectNo",
"label": "调出项目编号",
"value": "FSrcProjectNo",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPlanTransferQty",
"label": "计划调拨数量",
"value": "FPlanTransferQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBusinessDate",
"label": "入库日期",
"value": "FBusinessDate",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExtAuxUnitQty",
"label": "调入数量（辅单位）",
"value": "FExtAuxUnitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWayAuxUnitQty",
"label": "途损数量（辅单位）",
"value": "FWayAuxUnitQty",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": "FThirdSrcEntryId",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRowId",
"label": "行标识",
"value": "FRowId",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FParentRowId",
"label": "父行标识",
"value": "FParentRowId",
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "FSTKTRSINENTRY_FEntryID",
"label": "FEntryID",
"value": null,
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FID",
"label": "实体主键",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockOrgID_FNumber",
"label": "调入库存组织",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferDirect",
"label": "调拨方向",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FNOTE",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCreateDate",
"label": "创建日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FApproveDate",
"label": "审核日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferMode",
"label": "调拨方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FTransferBizType",
"label": "调拨类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBizType",
"label": "业务类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCustID_FNumber",
"label": "对应客户",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSUPPLIERID_FNumber",
"label": "对应供应商",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSystem",
"label": "第三方系统",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSrcId",
"label": "第三方源单内码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSrcBillNo",
"label": "第三方源单编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaterialID_FNumber",
"label": "物料编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FCMKBarCode",
"label": "零售条形码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcStockID_FNumber",
"label": "调出仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestStockID_FNumber",
"label": "调入仓库",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FQty",
"label": "调入数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPrice",
"label": "成本价",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FAmount",
"label": "总成本",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBOMID",
"label": "BOM版本",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEXPIRYDATE",
"label": "有效期至",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMTONO",
"label": "计划跟踪号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOwnerID_FNumber",
"label": "调入货主",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FUnitID",
"label": "单位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockOutFlag",
"label": "出库库存更新标识",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FStockInFlag",
"label": "入库库存更新标识",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestStockLocId",
"label": "调入仓位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCStockLocId",
"label": "调出仓位",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcBillType",
"label": "源单类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcBillNo",
"label": "源单编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FOwnerOutID_FNumber",
"label": "调出货主",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLOT_FNumber",
"label": "调出批号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FEntryNote",
"label": "备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCBILLNAME",
"label": "源单单据类型",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcBillDate",
"label": "源单日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDestLot_FNumber",
"label": "调入批号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcMaterialId_FNumber",
"label": "调出物料",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCBOMID",
"label": "调出BOM",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcProduceDate",
"label": "调出生产日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcExpiryDate",
"label": "调出有效期至",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSRCMTONO",
"label": "调出计划跟踪号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FSrcProjectNo",
"label": "调出项目编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FPlanTransferQty",
"label": "计划调拨数量",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBusinessDate",
"label": "入库日期",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FExtAuxUnitQty",
"label": "调入数量（辅单位）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWayAuxUnitQty",
"label": "途损数量（辅单位）",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FThirdSrcEntryId",
"label": "第三方源单分录编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FRowId",
"label": "行标识",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FParentRowId",
"label": "父行标识",
"value": null,
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 500
},
"otherRequest": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"is_required": true
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"is_required": false
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FBillTypeID.FNUMBER='FBDR03_SYS' and FDOCUMENTSTATUS='C' and FApproveDate>='{{LAST_SYNC_TIME|date}}'",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"is_required": false
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式：FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"is_required": true
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_TRANSFERIN",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "gy.erp.stock.other.in.add",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "warehouse_code",
"label": "仓库代码",
"value": "{{FDestStockID_FNumber}}",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "type",
"label": "入库类型代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "note",
"label": "备注",
"value": "{{FBillNo}}",
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details",
"label": "入库明细",
"value": "details",
"children": [
{
"type": "string",
"field": "item_code",
"label": "商品代码",
"value": "{{FMaterialID_FNumber}}",
"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": "barcode",
"label": "商品条码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "qty",
"label": "数量",
"value": "{{FQty}}",
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "uniqueCode",
"label": "唯一码",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "batchNumber",
"label": "批次号",
"value": "{{FDestLot_FNumber}}",
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "manufacturingDate",
"label": "生产日期",
"value": "{{FProduceDate|datetime}}",
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shelfLife",
"label": "有效期",
"value": "_function timestampdiff(day,'{{FProduceDate|date}}','{{FEXPIRYDATE|date}}')",
"parent": "details",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "stockDate",
"label": "入库日期",
"value": null,
"parent": "details",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "wms_bizcode",
"label": "第三方系统单号",
"value": "{{FBillNo}}",
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "success",
"label": "成功与否",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "errorCode",
"label": "错误代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "subErrorCode",
"label": "子错误代码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "errorDesc",
"label": "错误描述",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "subErrorDesc",
"label": "子错误描述",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "requestMethod",
"label": "请求方法",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "code",
"label": "其他入库单单据编号",
"value": null,
"describe": null,
"is_required": false
}
],
"operation": {
"body": [
"FMaterialID_FNumber",
"FQty",
"FDestLot_FNumber",
"FProduceDate",
"FEXPIRYDATE"
],
"field": "FBillNo",
"header": [
"FID",
"FBillNo",
"FDocumentStatus",
"FDestStockID_FNumber"
],
"method": "merge",
"bodyName": "details"
},
"otherRequest": [],
"otherResponse": []
}
