源系统平台：旺店通·企业奇门
源系统接口： 查询仓库wdt.warehouse.query
目标系统平台： 金蝶云星空
目标系统接口： 仓库新增batchSave
源平台元数据配置：
{
"id": "warehouse_no",
"api": "wdt.warehouse.query",
"type": "QUERY",
"method": "POST",
"number": "warehouse_no",
"idCheck": true,
"request": [
{
"id": "390fa579-fa06-3720-ad72-15a432dd42ed",
"type": "string",
"field": "type",
"label": "仓库类型",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
}
],
"response": [
{
"id": "199977e5-9368-35de-8c22-eb994d584021",
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": "代表仓库所有属性的唯一编码，用于仓库区分，ERP内支持自定义（ERP仓库界面设置），用于获取指定仓库数据信息",
"parent_id": null,
"is_required": false
},
{
"id": "1f9c376c-d0ff-3e10-a3cf-c25438205035",
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": "代表仓库所有属性的唯一编码，用于仓库区分，ERP内支持自定义（ERP仓库界面设置），用于获取指定仓库数据信息",
"parent_id": null,
"is_required": false
},
{
"id": "15fae71f-c7bd-342b-9e9f-628a91aec882",
"type": "string",
"field": "name",
"label": "仓库名称",
"value": null,
"describe": "ERP仓库界面的仓库名称",
"parent_id": null,
"is_required": false
},
{
"id": "34b72b40-1937-3985-b7c7-d5b050582fcf",
"type": "string",
"field": "warehouse_type",
"label": "仓库类型",
"value": null,
"describe": "（0不限1普通仓库2自动流传外部3京东仓储4科捷5百世物流6SKU3607通天晓8中联网仓9顺丰仓储10网仓2号11奇门仓储12旺店通仓储13心怡仓储14力威仓储20外部链路型127其它）",
"parent_id": null,
"is_required": false
},
{
"id": "0769d87a-df39-3f88-8700-020c08ec8ff9",
"type": "string",
"field": "ext_warehouse_no",
"label": "外部仓库编号",
"value": null,
"describe": "外部仓库编号",
"parent_id": null,
"is_required": false
},
{
"id": "0b232d3b-0ec0-3df0-bb86-d1467a1b570c",
"type": "string",
"field": "province",
"label": "省",
"value": null,
"describe": "仓库设置的省份信息",
"parent_id": null,
"is_required": false
},
{
"id": "661577b9-bc55-36f3-bcfe-6ac4529463cb",
"type": "string",
"field": "city",
"label": "市",
"value": null,
"describe": "仓库设置的城市信息",
"parent_id": null,
"is_required": false
},
{
"id": "31b94e2e-9c59-3ce2-8bb2-f9eed0d6f0a4",
"type": "string",
"field": "district",
"label": "区/县",
"value": null,
"describe": "仓库设置的区县信息",
"parent_id": null,
"is_required": false
},
{
"id": "6cc0f355-8817-3028-9ade-f46d1dda424f",
"type": "string",
"field": "address",
"label": "仓库地址",
"value": null,
"describe": "仓库地址",
"parent_id": null,
"is_required": false
},
{
"id": "ac17e867-20d0-311a-900f-311001b59c99",
"type": "string",
"field": "contact",
"label": "联系人",
"value": null,
"describe": "仓库设置中的联系人",
"parent_id": null,
"is_required": false
},
{
"id": "763be961-7ce8-328b-aeaa-bad643417f90",
"type": "string",
"field": "telno",
"label": "电话",
"value": null,
"describe": "仓库设置中的固话信息",
"parent_id": null,
"is_required": false
},
{
"id": "1d41b62e-4e07-3c39-82dc-0f6da1da7989",
"type": "string",
"field": "zip",
"label": "邮编",
"value": null,
"describe": "邮编",
"parent_id": null,
"is_required": false
},
{
"id": "4acdc1c5-7ca3-3690-a59b-33c43b2d30be",
"type": "string",
"field": "mobile",
"label": "移动电话",
"value": null,
"describe": "仓库设置中的手机信息",
"parent_id": null,
"is_required": false
},
{
"id": "b61ca02c-2899-39dd-b10b-593bbe45cad7",
"type": "string",
"field": "is_defect",
"label": "是否是残次仓",
"value": null,
"describe": "是否是残次仓（0不是，1是）",
"parent_id": null,
"is_required": false
},
{
"id": "162de5cb-055c-35a3-ad1d-453efd01b7e7",
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"describe": "仓库设置中的备注信息",
"parent_id": null,
"is_required": false
},
{
"id": "b107812c-0714-35be-8e2f-7a589a5daf4b",
"type": "string",
"field": "prop1",
"label": "自定义",
"value": null,
"describe": "自定义1(ERP内不显示该字段)",
"parent_id": null,
"is_required": false
},
{
"id": "284bccb8-b172-3103-97dd-425c2814b9aa",
"type": "string",
"field": "prop2",
"label": "自定义",
"value": null,
"describe": "自定义2(ERP内不显示该字段)",
"parent_id": null,
"is_required": false
},
{
"id": "5278c132-459e-3720-a53f-3606e287f7d1",
"type": "string",
"field": "warehouse_id",
"label": "仓库id",
"value": null,
"describe": "仓库id",
"parent_id": null,
"is_required": false
},
{
"id": "653160ba-87ff-3f5e-8a8b-858edc10ceb8",
"type": "string",
"field": "type",
"label": "仓库类型",
"value": null,
"describe": "仓库类型",
"parent_id": null,
"is_required": false
},
{
"id": "2a784961-3a34-3d96-8d13-9d82fcdf0769",
"type": "string",
"field": "sub_type",
"label": "仓库子类型",
"value": null,
"describe": "仓库子类型",
"parent_id": null,
"is_required": false
},
{
"id": "84836a9a-c70d-326d-bd8c-54e782f3211a",
"type": "string",
"field": "api_key",
"label": "API中商家的唯一标识",
"value": null,
"describe": "API中商家的唯一标识",
"parent_id": null,
"is_required": false
},
{
"id": "436c45e7-8bbc-397d-b312-819b2c526e8e",
"type": "string",
"field": "api_object_id",
"label": "和ext_warehouse_no一起保证唯一",
"value": null,
"describe": "和ext_warehouse_no一起保证唯一",
"parent_id": null,
"is_required": false
},
{
"id": "2d3cfbe1-97d6-37fa-b092-9979b8782beb",
"type": "string",
"field": "tag",
"label": "标签",
"value": null,
"describe": "委外仓禁止使用",
"parent_id": null,
"is_required": false
},
{
"id": "01195981-8097-3315-9907-e9c5ef378179",
"type": "string",
"field": "division_id",
"label": "区编号",
"value": null,
"describe": "区编号,云栈热敏用",
"parent_id": null,
"is_required": false
},
{
"id": "d41d333b-004d-3491-8459-d36cbc906f87",
"type": "string",
"field": "flag",
"label": "标记",
"value": null,
"describe": "用于下载标记",
"parent_id": null,
"is_required": false
},
{
"id": "6dd7401c-57e4-3ff4-b986-d986bfff9aa4",
"type": "string",
"field": "shop_id",
"label": "店铺ID",
"value": null,
"describe": "实体店仓库店铺id,米氏抢单用",
"parent_id": null,
"is_required": false
},
{
"id": "8484f645-bff2-3fa9-a46c-b2bc5390ab8c",
"type": "string",
"field": "is_outer_stock",
"label": "是否使用外部库存",
"value": null,
"describe": "使用外部库存",
"parent_id": null,
"is_required": false
},
{
"id": "4a1b1130-2623-33df-bb10-39800b4c5dc4",
"type": "string",
"field": "is_outer_goods",
"label": "是否是外部货品",
"value": null,
"describe": "代销仓库,货品没有所有权",
"parent_id": null,
"is_required": false
},
{
"id": "453c02f3-3a2c-3f6f-93f2-2abbd51c7e13",
"type": "string",
"field": "picker_num",
"label": "拣货员数量",
"value": null,
"describe": "仓库拣货员数量--智选批次使用",
"parent_id": null,
"is_required": false
},
{
"id": "4de6329d-d78a-3fe0-8905-97d05a0f6018",
"type": "string",
"field": "coordinates_x",
"label": "地理坐标_x",
"value": null,
"describe": "地理坐标_x",
"parent_id": null,
"is_required": false
},
{
"id": "106256d0-b52d-3fb5-8543-81d72db79e0c",
"type": "string",
"field": "coordinates_y",
"label": "地理坐标_y",
"value": null,
"describe": "地理坐标_y",
"parent_id": null,
"is_required": false
},
{
"id": "49fda5e6-4d8a-3c63-8ccb-be79c2b16d21",
"type": "string",
"field": "match_warehouse_id",
"label": "残次品/正品仓id",
"value": null,
"describe": "对应的残次品/正品仓id",
"parent_id": null,
"is_required": false
},
{
"id": "837fe354-2ce6-3871-bf7f-34010d9a0cb6",
"type": "string",
"field": "cod_logistics_id",
"label": "货到付款物流公司",
"value": null,
"describe": "货到付款物流公司",
"parent_id": null,
"is_required": false
},
{
"id": "2267300a-f5dd-3dd5-9380-17f9f49d9c51",
"type": "string",
"field": "is_disabled",
"label": "是否停用",
"value": null,
"describe": "是否停用",
"parent_id": null,
"is_required": false
},
{
"id": "23f05154-ff0a-34f0-8e11-58e5d02235c8",
"type": "string",
"field": "priority",
"label": "仓库优先级",
"value": null,
"describe": "仓库的优先级",
"parent_id": null,
"is_required": false
},
{
"id": "6c12d646-fa2a-3562-9746-c211b17c446a",
"type": "string",
"field": "created",
"label": "创建时间",
"value": null,
"describe": "创建时间， 格式：yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": false
},
{
"id": "1f05cc6c-2e5f-3fe9-95cc-8478fa248617",
"type": "string",
"field": "modified",
"label": "最后修改时间",
"value": null,
"describe": "最后修改时间， 格式：yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": false
}
],
"buildModel": false,
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"id": "1f467d08-316e-3529-bbc2-6ba282bcd9ed",
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "50",
"describe": "每页返回的数据条数，输入值范围1~100，不传本参数，输入值默认为40，使用举例单击这里",
"parent_id": null,
"is_required": false
},
{
"id": "157ccbbc-c23a-3070-b911-57a8db8bfcb7",
"type": "string",
"field": "page_no",
"label": "页号",
"value": "0",
"describe": "不传值默认从0页开始",
"parent_id": null,
"is_required": true
}
],
"otherResponse": [],
"autoFillResponse": false
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "a43360a8-d431-3832-aa45-82c7a75e0966",
"type": "string",
"field": "FName",
"label": "名称",
"value": "{{name}}",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "014a42d9-36ae-3ade-befb-f8ccf15e3cd7",
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "{{warehouse_no}}",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "25872f5c-1583-37e8-8880-c52129318d8c",
"type": "string",
"field": "FUseOrgId",
"label": "使用组织",
"value": "100.02.01",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "100",
"parent_id": null,
"is_required": true
},
{
"id": "a1fc6964-4a6a-3c11-964c-84c5d7a58f2d",
"type": "string",
"field": "FCreateOrgId",
"label": "创建组织",
"value": "100.02.01",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "100",
"parent_id": null,
"is_required": true
},
{
"id": "baec617a-d5e2-3b4c-bbae-cdb77897bfd2",
"type": "string",
"field": "FDescription",
"label": "描述",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "de41a51c-782d-369d-add1-9c519ea767de",
"type": "string",
"field": "FStockStatusType",
"label": "仓库类型",
"value": "0,1,2,3,4,5,6,7,8",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "de6e29c2-b4c7-3a53-9804-360e1115dca4",
"type": "string",
"field": "FAddress",
"label": "地址",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "ed4b0e7d-d93e-3b74-8fb3-8914e8b1f947",
"type": "string",
"field": "FStockProperty",
"label": "仓库属性",
"value": "5",
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "FALLOWMINUSQTY",
"type": "string",
"field": "FALLOWMINUSQTY",
"label": "是否允许负库存",
"value": "1",
"parent": null
},
{
"id": "FGROUP",
"type": "string",
"field": "FGROUP",
"label": "分组",
"value": "02",
"parent": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
}
],
"response": [],
"operation": {
"rows": 50,
"method": "batchArraySave",
"rowsKey": "array"
},
"pagination": {
"pageSize": 500
},
"otherRequest": [
{
"id": "f972c1cc-653a-3d9a-8128-431385d293ee",
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_STOCK",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"parent_id": null,
"is_required": true
},
{
"id": "5872c303-1fb8-3342-ab7e-1e26440ae690",
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
"parent_id": null,
"is_required": false
},
{
"id": "8e90d482-c207-3bf8-872e-a474fd8cba35",
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "BatchSave",
"describe": null,
"parent_id": null,
"is_required": true
},
{
"id": "8f5e0f1a-193f-303a-8ef7-45a0d0f4b86a",
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"parent_id": null,
"is_required": true
}
],
"otherResponse": []
}
