源系统平台:金蝶云星空
源系统接口: 采购订单查询executeBillQuery
目标系统平台: 奇门WMS-A
目标系统接口: 入库单创建taobao.qimen.entryorder.create
源平台元数据配置:
{
"id": "FID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FBillNo",
"idCheck": false,
"request": [
{
"id": "576c4065-6819-387b-a6e6-9321c643a360",
"type": "string",
"field": "FID",
"label": "FID",
"value": "FID",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "dc7c1bbc-6a41-394a-acf9-df7c8eb90c2b",
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "FBillNo",
"describe": "单据编号",
"parent_id": null,
"is_required": true
},
{
"id": "2708adca-f5e5-3d2c-8ac0-396e34390d1f",
"type": "string",
"field": "FSourceBillNo",
"label": "源单编号",
"value": "FSourceBillNo",
"describe": "源单编号",
"parent_id": null,
"is_required": false
},
{
"id": "8aa887ac-988f-3fe6-9985-ac344ed02f9b",
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": "FBillTypeID.FNumber",
"describe": "单据类型",
"parent_id": null,
"is_required": true
},
{
"id": "d445c3b6-d295-371a-8e85-37fcd112d3bb",
"type": "string",
"field": "FBusinessType",
"label": "业务类型",
"value": "FBusinessType",
"describe": "下拉列表",
"parent_id": null,
"is_required": false
},
{
"id": "5fbe869e-3bde-3c08-bee6-92c2289041fa",
"type": "string",
"field": "FSupplierId_FNumber",
"label": "供应商",
"value": "FSupplierId.FNumber",
"describe": "基础资料",
"parent_id": null,
"is_required": false
},
{
"id": "cfd0fa47-e355-3645-9912-b60f8fa76d6b",
"type": "string",
"field": "FSettleModeId_FNumber",
"label": "结算方式",
"value": "FSettleModeId.FNumber",
"describe": "基础资料",
"parent_id": null,
"is_required": false
},
{
"id": "3e7658b4-7b51-312d-96f4-13087111921c",
"type": "string",
"field": "FPayConditionId_FNumber",
"label": "付款条件",
"value": "FPayConditionId.FNumber",
"describe": "基础资料",
"parent_id": null,
"is_required": false
},
{
"id": "f5e24b6b-ebbd-3f38-982f-e00f3b41f8db",
"type": "string",
"field": "FDate",
"label": "采购日期",
"value": "FDate",
"describe": "日期",
"parent_id": null,
"is_required": false
},
{
"id": "ed1274db-ca58-3158-b73a-7e1a597ef910",
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": "FDocumentStatus",
"describe": "单据状态",
"parent_id": null,
"is_required": false
},
{
"id": "ed1274db-ca58-3158-b73a-7e1a597ef910",
"type": "string",
"field": "FMRPCloseStatus",
"label": "关闭状态",
"value": "FMRPCloseStatus",
"describe": "单据状态",
"parent_id": null,
"is_required": false
}
],
"response": [
{
"id": "576c4065-6819-387b-a6e6-9321c643a360",
"type": "string",
"field": "FID",
"label": "FID",
"value": "FID",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "dc7c1bbc-6a41-394a-acf9-df7c8eb90c2b",
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "FBillNo",
"describe": "单据编号",
"parent_id": null,
"is_required": true
},
{
"id": "2708adca-f5e5-3d2c-8ac0-396e34390d1f",
"type": "string",
"field": "FSourceBillNo",
"label": "源单编号",
"value": "FSourceBillNo",
"describe": "源单编号",
"parent_id": null,
"is_required": false
},
{
"id": "8aa887ac-988f-3fe6-9985-ac344ed02f9b",
"type": "string",
"field": "FBillTypeID_FNumber",
"label": "单据类型",
"value": "FBillTypeID.FNumber",
"describe": "单据类型",
"parent_id": null,
"is_required": true
},
{
"id": "d445c3b6-d295-371a-8e85-37fcd112d3bb",
"type": "string",
"field": "FBusinessType",
"label": "业务类型",
"value": "FBusinessType",
"describe": "下拉列表",
"parent_id": null,
"is_required": false
},
{
"id": "5fbe869e-3bde-3c08-bee6-92c2289041fa",
"type": "string",
"field": "FSupplierId_FNumber",
"label": "供应商",
"value": "FSupplierId.FNumber",
"describe": "基础资料",
"parent_id": null,
"is_required": false
},
{
"id": "cfd0fa47-e355-3645-9912-b60f8fa76d6b",
"type": "string",
"field": "FSettleModeId_FNumber",
"label": "结算方式",
"value": "FSettleModeId.FNumber",
"describe": "基础资料",
"parent_id": null,
"is_required": false
},
{
"id": "3e7658b4-7b51-312d-96f4-13087111921c",
"type": "string",
"field": "FPayConditionId_FNumber",
"label": "付款条件",
"value": "FPayConditionId.FNumber",
"describe": "基础资料",
"parent_id": null,
"is_required": false
},
{
"id": "f5e24b6b-ebbd-3f38-982f-e00f3b41f8db",
"type": "string",
"field": "FDate",
"label": "采购日期",
"value": "FDate",
"describe": "日期",
"parent_id": null,
"is_required": false
},
{
"id": "ed1274db-ca58-3158-b73a-7e1a597ef910",
"type": "string",
"field": "FDocumentStatus",
"label": "单据状态",
"value": "FDocumentStatus",
"describe": "单据状态",
"parent_id": null,
"is_required": false
},
{
"id": "ed1274db-ca58-3158-b73a-7e1a597ef910",
"type": "string",
"field": "FMRPCloseStatus",
"label": "关闭状态",
"value": "FMRPCloseStatus",
"describe": "单据状态",
"parent_id": null,
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"id": "fbbd49c5-219a-32ba-9c25-b1476e174f1f",
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "6c3e209c-a6c2-3d23-8d0a-620ce60e32ca",
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "9e4ba5d6-594a-3590-8551-5c86892bb015",
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": false
},
{
"id": "106ba6ed-153f-3fcc-b171-552a1202bf4b",
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "F_ora_Base.FNumber <> '' and FMRPCloseStatus = 'A'",
"describe": "示例写法 FSupplierId.FNumber = 'VEN00010' and FApproveDate>=",
"parent_id": null,
"is_required": false
},
{
"id": "c0fe7e9c-59c5-3a26-848e-f741b9e3948c",
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"parent_id": null,
"is_required": true
},
{
"id": "c49887af-36f9-31be-89bf-03612e776430",
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "PUR_PurchaseOrder",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"parent_id": null,
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "entryorder.create",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"type": "object",
"field": "entryOrder",
"label": "入库单信息",
"children": [
{
"id": "96dde3d8-b7bb-38dc-8d51-d80ae4fa2327",
"type": "string",
"field": "entryOrderCode",
"label": "入库单号",
"value": "{{FBillNo}}",
"parent": "entryOrder",
"describe": null,
"parent_id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"is_required": true
},
{
"id": "0d7a2892-f838-3984-aff8-b183bfcb0153",
"type": "string",
"field": "ownerCode",
"label": "货主编码",
"value": "GZ202206111",
"parent": "entryOrder",
"describe": null,
"parent_id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"is_required": true
},
{
"id": "dd93ecf3-705f-33fe-9908-cdc6bd0fd97a",
"type": "string",
"field": "purchaseOrderCode",
"label": "采购单号",
"value": "{{FBillNo}}",
"parent": "entryOrder",
"describe": "当orderType=CGRK时使用",
"parent_id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"is_required": false
},
{
"id": "f0605b3f-48a9-3068-9a61-652279dfad3a",
"type": "string",
"field": "warehouseCode",
"label": "入库仓库编码",
"value": "{{F_ora_Base_FNumber}}",
"parent": "entryOrder",
"describe": "统仓统配等无需ERP指定仓储编码的情况填OTHER",
"parent_id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"is_required": true
},
{
"id": "0a916be5-5e29-3bdc-8a64-310fc26c3629",
"type": "string",
"field": "orderCreateTime",
"label": "订单创建时间",
"value": "{{FDate}}",
"parent": "entryOrder",
"describe": "YYYY-MM-DD HH:MM:SS",
"parent_id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"is_required": false
},
{
"id": "ea8df18c-b7f3-32bc-8ba0-9bdd3ca2adcf",
"type": "string",
"field": "orderType",
"label": "业务类型",
"value": "CGRK",
"parent": "entryOrder",
"describe": "SCRK=生产入库;LYRK=领用入库;CCRK=残次品入库;CGRK=采购入库;DBRK=调拨入库;QTRK=其他入库;B2BRK=B2B入 库;XNRK=虚拟入库;只传英文编码",
"parent_id": "3d42dc39-b6d0-39f3-8dd9-ab18f5f97124",
"is_required": false
}
],
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"type": "array",
"field": "orderLines",
"label": "入库单详情",
"value": "details_list",
"children": [
{
"type": "array",
"field": "orderLine",
"label": "orderLine",
"parent": "orderLines",
"children": [
{
"id": "ca5b4280-a300-3a76-8523-b48152ef9dcb",
"type": "string",
"field": "outBizCode",
"label": "外部业务编码",
"value": null,
"parent": "orderLine",
"describe": "消息ID;用于去重;当单据需要分批次发送时使用",
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "27a072e0-ffb0-3198-a8a5-b44b16824302",
"type": "string",
"field": "orderLineNo",
"label": "入库单的行号",
"value": null,
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "eaec3af9-6046-3158-937f-059f06b4b561",
"type": "string",
"field": "ownerCode",
"label": "货主编码",
"value": "GZ202206111",
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": true
},
{
"id": "ac93e95a-aa8b-3922-b9af-4488a2d2336c",
"type": "string",
"field": "itemCode",
"label": "商品编码",
"value": "{{details_list.FMaterialId_FNumber}}",
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": true
},
{
"id": "2f1a187b-e720-3046-bb40-30a07d2746f9",
"type": "string",
"field": "itemId",
"label": "仓储系统商品ID",
"value": null,
"parent": "orderLines",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "f6e7d223-9d78-3778-9356-a50c5b5b6314",
"type": "string",
"field": "itemName",
"label": "商品名称",
"value": null,
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "9addc974-f625-3ccf-84df-1c512d7c4457",
"type": "string",
"field": "planQty",
"label": "应收商品数量",
"value": "{{details_list.FQty}}",
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": true
},
{
"id": "f2169e0f-771d-3347-b80c-08a23f45d883",
"type": "string",
"field": "skuProperty",
"label": "商品属性",
"value": null,
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "40641b67-6e11-3995-90b4-c7f1ad7a8d8e",
"type": "string",
"field": "purchasePrice",
"label": "采购价",
"value": "{{details_list.FTaxPrice}}",
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "f7b299bb-5f90-30d1-bbbc-259da9c028fb",
"type": "string",
"field": "retailPrice",
"label": "零售价",
"value": null,
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "461dcef1-5f30-3f6a-a696-d75d446aa96b",
"type": "string",
"field": "inventoryType",
"label": "库存类型",
"value": "ZP",
"parent": "orderLine",
"describe": "ZP=正品;CC=残次;JS=机损;XS=箱损;默认为ZP",
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "d18a5e2b-8a91-30f1-977a-76ce7346b915",
"type": "string",
"field": "productDate",
"label": "商品生产日期",
"value": null,
"parent": "orderLine",
"describe": "YYYY-MM-DD",
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "635f331f-7927-38b0-bba2-c89c4d7b0603",
"type": "string",
"field": "expireDate",
"label": "商品过期日期",
"value": null,
"parent": "orderLine",
"describe": "YYYY-MM-DD",
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "5b8e208d-667f-32f2-84a1-f1503d5d8225",
"type": "string",
"field": "produceCode",
"label": "生产批号",
"value": "{{details_list.FLot_FNumber}}",
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "23644ec1-4be2-305c-9a02-469ea4db0a1d",
"type": "string",
"field": "batchCode",
"label": "批次编码",
"value": null,
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
},
{
"id": "dc3eb5ae-59f6-37b8-a627-169035d52407",
"type": "string",
"field": "unit",
"label": "单位",
"value": null,
"parent": "orderLine",
"describe": null,
"parent_id": "87b0370b-fd5f-3cff-b078-3fcea0eaa323",
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"describe": null,
"parent_id": null,
"is_required": false
}
],
"response": [],
"operation": {
"body": [
"FMaterialId_FNumber",
"FQty",
"FTaxPrice"
],
"field": "FBillNo,F_ora_Base_FNumber,FSupplierId_FNumber,FDate",
"header": [
"FBillNo",
"F_ora_Base_FNumber",
"FSupplierId_FNumber",
"FDate"
],
"method": "merge",
"bodySum": [
"FQty"
],
"bodyName": "details_list"
},
"otherRequest": [],
"otherResponse": []
}