源系统平台:金蝶云星空
源系统接口: 库存查询executeBillQuery
目标系统平台: 新宝-产业链协同平台
目标系统接口: 通用写入接口/production/materialSet
源平台元数据配置:
{
"id": "FID",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FID",
"idCheck": false,
"request": [
{
"id": "7c919b67-ba32-37a4-b7b2-abefe54d609b",
"type": "string",
"field": "FID",
"label": "FID",
"value": "FID",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6a480124-0047-33cf-b204-0dde021ee5fb",
"type": "string",
"field": "FStockId",
"label": "仓库编码",
"value": "FStockId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "067d1cff-71f1-3625-816f-83eacdaa8028",
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "FMaterialId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "27a19612-1148-3633-aea9-41cf27b97be7",
"type": "string",
"field": "FQty",
"label": "库存量",
"value": "FQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "146c4b81-e7a6-3748-9ed1-47af07bc4907",
"type": "string",
"field": "FBaseQty",
"label": "库存基本单位数量",
"value": "FBaseQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "adaec971-6463-3b04-8c28-a643efe8bfea",
"type": "string",
"field": "FMaterialId_FName",
"label": "物料名称",
"value": "FMaterialId.FName",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "5109459f-0fbb-3963-aa91-186a9010319c",
"type": "string",
"field": "FUpdateTime",
"label": "最后更新日期",
"value": "FUpdateTime",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6f9408b8-7a40-3a48-bdce-9095ecbe6166",
"type": "string",
"field": "FOwnerId",
"label": "货主ID",
"value": "FOwnerId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "2859dae4-2f2f-38cd-8056-cf87e769309a",
"type": "string",
"field": "FKeeperId",
"label": "保管者ID",
"value": "FKeeperId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1e002fc2-575b-3437-88dd-9d4068c70638",
"type": "string",
"field": "FStockOrgId",
"label": "库存组织ID",
"value": "FStockOrgId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "cc6d749a-b380-3414-b99e-3aaae365b2fa",
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型ID",
"value": "FOwnerTypeId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "c7c7cffb-88ba-34e9-bd4f-119263874ad8",
"type": "string",
"field": "FStockId_FName",
"label": "仓库名称",
"value": "FStockId.FName",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "df0a4069-78ec-370b-9c79-f92039ee2384",
"type": "string",
"field": "FMaterialId_FSpecification",
"label": "物料的物料名称",
"value": "FMaterialId.FSpecification",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "80a12269-6e2f-3c77-9867-7d143ce31dbb",
"type": "string",
"field": "FOwnerId_FNumber",
"label": "货主编码",
"value": "FOwnerId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b1efde45-6e1b-3f6b-9980-e67a173d7591",
"type": "string",
"field": "FKeeperId_FNumber",
"label": "保管者编码",
"value": "FKeeperId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "994a9b39-8ba5-3981-8d22-50a3d04bdbd2",
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "库存组织编码",
"value": "FStockOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "facfa963-c424-3a96-af3a-1202ce3e89a6",
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "FProduceDate",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "929e4b1e-ba94-3142-97f6-234e0ea1952c",
"type": "string",
"field": "FMaterialId_F_GZHQ_Text_DXGG",
"label": "电线规格",
"value": "FMaterialId.F_GZHQ_Text_DXGG",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "19e170ea-2882-3dc9-87ae-a3f9bad15cef",
"type": "string",
"field": "FStockStatusId",
"label": "库存状态",
"value": "FStockStatusId",
"describe": null,
"parent_id": null,
"is_required": false
}
],
"id_check": true,
"response": [
{
"id": "7c919b67-ba32-37a4-b7b2-abefe54d609b",
"type": "string",
"field": "FID",
"label": "FID",
"value": "FID",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6a480124-0047-33cf-b204-0dde021ee5fb",
"type": "string",
"field": "FStockId",
"label": "仓库编码",
"value": "FStockId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "067d1cff-71f1-3625-816f-83eacdaa8028",
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": "FMaterialId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "27a19612-1148-3633-aea9-41cf27b97be7",
"type": "string",
"field": "FQty",
"label": "库存量",
"value": "FQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "146c4b81-e7a6-3748-9ed1-47af07bc4907",
"type": "string",
"field": "FBaseQty",
"label": "库存基本单位数量",
"value": "FBaseQty",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "adaec971-6463-3b04-8c28-a643efe8bfea",
"type": "string",
"field": "FMaterialId_FName",
"label": "物料名称",
"value": "FMaterialId.FName",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "5109459f-0fbb-3963-aa91-186a9010319c",
"type": "string",
"field": "FUpdateTime",
"label": "最后更新日期",
"value": "FUpdateTime",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6f9408b8-7a40-3a48-bdce-9095ecbe6166",
"type": "string",
"field": "FOwnerId",
"label": "货主ID",
"value": "FOwnerId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "2859dae4-2f2f-38cd-8056-cf87e769309a",
"type": "string",
"field": "FKeeperId",
"label": "保管者ID",
"value": "FKeeperId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "1e002fc2-575b-3437-88dd-9d4068c70638",
"type": "string",
"field": "FStockOrgId",
"label": "库存组织ID",
"value": "FStockOrgId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "cc6d749a-b380-3414-b99e-3aaae365b2fa",
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型ID",
"value": "FOwnerTypeId",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "c7c7cffb-88ba-34e9-bd4f-119263874ad8",
"type": "string",
"field": "FStockId_FName",
"label": "仓库名称",
"value": "FStockId.FName",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "df0a4069-78ec-370b-9c79-f92039ee2384",
"type": "string",
"field": "FMaterialId_FSpecification",
"label": "物料的物料名称",
"value": "FMaterialId.FSpecification",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "80a12269-6e2f-3c77-9867-7d143ce31dbb",
"type": "string",
"field": "FOwnerId_FNumber",
"label": "货主编码",
"value": "FOwnerId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "b1efde45-6e1b-3f6b-9980-e67a173d7591",
"type": "string",
"field": "FKeeperId_FNumber",
"label": "保管者编码",
"value": "FKeeperId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "994a9b39-8ba5-3981-8d22-50a3d04bdbd2",
"type": "string",
"field": "FStockOrgId_FNumber",
"label": "库存组织编码",
"value": "FStockOrgId.FNumber",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "facfa963-c424-3a96-af3a-1202ce3e89a6",
"type": "string",
"field": "FProduceDate",
"label": "生产日期",
"value": "FProduceDate",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "929e4b1e-ba94-3142-97f6-234e0ea1952c",
"type": "string",
"field": "FMaterialId_F_GZHQ_Text_DXGG",
"label": "电线规格",
"value": "FMaterialId.F_GZHQ_Text_DXGG",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "19e170ea-2882-3dc9-87ae-a3f9bad15cef",
"type": "string",
"field": "FStockStatusId",
"label": "库存状态",
"value": "FStockStatusId",
"describe": null,
"parent_id": null,
"is_required": false
}
],
"buildModel": false,
"pagination": {
"pageSize": 500
},
"otherRequest": [
{
"id": "8d9220f1-4e3e-31eb-bc1d-0a03b0fc3517",
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "9f7563fa-1c75-3a15-8ba1-00c0eeaec557",
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": true
},
{
"id": "8b3e8ed4-9c31-362e-8c60-be84ff88fe32",
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0",
"describe": "金蝶的查询分页参数",
"parent_id": null,
"is_required": false
},
{
"id": "e2f91f84-87fa-3c3c-a782-40e734d0abd7",
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FMATERIALID.F_GZHQ_CheckBox5 = 1 and FBaseQty <>0 and Fsecqty <>0",
"describe": "FUpdateTime是库存的最近更新日期",
"parent_id": null,
"is_required": false
},
{
"id": "479f9443-3860-39c3-82cd-8d04a78fe114",
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
},
"describe": "金蝶分录主键ID格式:FPOOrderEntry_FEntryId,其它格式 FPurchaseOrgId.FNumber",
"parent_id": null,
"is_required": true
},
{
"id": "7097e071-623b-3e70-b2aa-ef4af8619cb4",
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "STK_Inventory",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"parent_id": null,
"is_required": true
}
],
"otherResponse": [],
"autoFillResponse": false
}
目标平台元数据配置:
{
"id": null,
"api": "/wms/inventory",
"sdk": "\\Adapter\\Donlim\\SDK\\DonlimSDK",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "data",
"type": "object",
"field": "data",
"label": "data",
"value": null,
"parent": null,
"children": [
{
"id": "7dd8e717-a769-39aa-bcaf-63cfe97e6997",
"type": "string",
"field": "supplyCode",
"label": "供应商编号",
"value": "VHQ013",
"describe": "供应商编号",
"parent_id": null,
"is_required": false
},
{
"id": "7b01dd99-9733-3c89-8106-324a77dfe55c",
"type": "string",
"field": "supplyName",
"label": "供应商",
"value": "广州环球电业电器有限公司",
"describe": "供应商",
"parent_id": null,
"is_required": false
},
{
"id": "773daa16-975f-3269-b054-1a6d51e5adb0",
"type": "string",
"field": "warehouseNo",
"label": "仓库编码",
"value": "{{FStockId}}",
"describe": "仓库编码",
"parent_id": null,
"is_required": false
},
{
"id": "1677eb63-99e6-34ff-980f-b01702153b6d",
"type": "string",
"field": "warehouseName",
"label": "仓库名称",
"value": "{{FStockId_FName}}",
"describe": "仓库名称",
"parent_id": null,
"is_required": false
},
{
"id": "a5095d22-04fd-3e4b-8544-ca6a18647602",
"type": "string",
"field": "materialNo",
"label": "物料编码-供应商侧",
"value": "{{FMaterialId_FName}}",
"describe": "物料编码-供应商侧",
"parent_id": null,
"is_required": false
},
{
"id": "33f69553-ee84-3dc9-9607-eedccc83f96e",
"type": "string",
"field": "materialName",
"label": "物料名称-供应商侧",
"value": "{{FMaterialId_FSpecification}}",
"describe": "物料名称-供应商侧",
"parent_id": null,
"is_required": false
},
{
"id": "ab10f330-f346-395a-90ff-2abc734fed53",
"type": "string",
"field": "materialSpecification",
"label": "物料规格-供应商侧",
"value": "{{FMaterialId_F_GZHQ_Text_DXGG}}",
"describe": "物料规格-供应商侧",
"parent_id": null,
"is_required": false
},
{
"id": "8e83d059-1c33-3db2-9658-0cf42e4b7ffa",
"type": "string",
"field": "stockNum",
"label": "库存现有量",
"value": "{{FBaseQty}}",
"describe": "采购订单物料数量",
"parent_id": null,
"is_required": false
},
{
"id": "b0c02c14-db78-3362-8fce-e99d5d396c8c",
"type": "string",
"field": "needSevenNum",
"label": "T±7需求库存量",
"value": null,
"describe": "入库数量",
"parent_id": null,
"is_required": false
},
{
"id": "163972d4-d6e9-34b3-a4f8-71dc49714036",
"type": "string",
"field": "needOneNum",
"label": "T+1需求库存量",
"value": null,
"describe": "入库时间",
"parent_id": null,
"is_required": false
},
{
"id": "0c1227d9-6b61-3738-a4d4-d6283b2eec16",
"type": "string",
"field": "updateTime",
"label": "更新时间",
"value": "{{FUpdateTime}}",
"describe": "更新时间",
"parent_id": null,
"is_required": false
},
{
"id": "bd4b5b16-6e2b-3074-bf51-97e3915ac162",
"type": "string",
"field": "bakOne",
"label": "备用字段1",
"value": null,
"describe": "备用字段1",
"parent_id": null,
"is_required": false
},
{
"id": "39662a1a-6e4d-3173-9bdf-553941dfccc9",
"type": "string",
"field": "bakTwo",
"label": "备用字段2",
"value": null,
"describe": "备用字段2",
"parent_id": null,
"is_required": false
},
{
"id": "7677161f-1369-3428-80c3-d8ca8b9524d3",
"type": "string",
"field": "bakThree",
"label": "备用字段3",
"value": null,
"describe": "备用字段3",
"parent_id": null,
"is_required": false
},
{
"id": "47a1f46e-0536-3911-90dc-4ae23ada1245",
"type": "string",
"field": "bakFour",
"label": "备用字段4",
"value": null,
"describe": "备用字段4",
"parent_id": null,
"is_required": false
}
]
}
],
"response": [],
"errorMsgKey": "msg",
"otherRequest": [],
"otherResponse": []
}