源系统平台:用友BIP
源系统接口: 现存量查询/yonbip/scm/stock/QueryCurrentStocksByCondition
目标系统平台: 轻易云集成平台
目标系统接口: 写入空操作写入空操作
源平台元数据配置:
{
"id": "id",
"api": "/yonbip/digitalModel/orgunit/querytree",
"type": "QUERY",
"method": "POST",
"number": "code",
"idCheck": true,
"request": [
{
"type": "string",
"field": "code",
"label": "组织编码",
"value": null,
"describe": "组织id 示例:1136142391349504",
"is_required": false
},
{
"type": "string",
"field": "name",
"label": "组织名称",
"value": null,
"describe": "仓库id 示例:1136142391349504",
"is_required": false
},
{
"type": "string",
"field": "enable",
"label": "状态",
"value": "1",
"describe": "商品SKUid 示例:1136142803423490",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "org",
"label": "组织id",
"value": null,
"describe": "组织id",
"is_required": false
},
{
"type": "string",
"field": "warehouse",
"label": "仓库id",
"value": null,
"describe": "仓库id",
"is_required": false
},
{
"type": "string",
"field": "product",
"label": "物料id",
"value": null,
"describe": "物料id",
"is_required": false
},
{
"type": "string",
"field": "product_name",
"label": "物料name",
"value": null,
"describe": "物料name",
"is_required": false
},
{
"type": "string",
"field": "product_code",
"label": "物料编码",
"value": null,
"describe": "物料编码",
"is_required": false
},
{
"type": "string",
"field": "productsku",
"label": "物料skuid",
"value": null,
"describe": "物料skuid",
"is_required": false
},
{
"type": "string",
"field": "productsku_name",
"label": "物料sku名字",
"value": null,
"describe": "物料sku名字",
"is_required": false
},
{
"type": "string",
"field": "productsku_code",
"label": "物料sku编码",
"value": null,
"describe": "物料sku编码",
"is_required": false
},
{
"type": "string",
"field": "unit",
"label": "主计量",
"value": null,
"describe": "主计量",
"is_required": false
},
{
"type": "BigDecimal",
"field": "currentqty",
"label": "现存量",
"value": null,
"describe": "现存量",
"is_required": false
},
{
"type": "BigDecimal",
"field": "innoticeqty",
"label": "收货预计入库数量",
"value": null,
"describe": "收货预计入库数量",
"is_required": false
},
{
"type": "BigDecimal",
"field": "planavailableqty",
"label": "计划可用量",
"value": null,
"describe": "计划可用量",
"is_required": false
},
{
"type": "BigDecimal",
"field": "availableqty",
"label": "可用量",
"value": null,
"describe": "可用量",
"is_required": false
},
{
"type": "BigDecimal",
"field": "preretailqty",
"label": "订单预计出库数量",
"value": null,
"describe": "订单预计出库数量",
"is_required": false
}
],
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "写入空操作",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [],
"response": [],
"otherRequest": [],
"otherResponse": []
}