源系统平台:金蝶云星空
源系统接口: 物料查询executeBillQuery
目标系统平台: 旺店通·企业奇门
目标系统接口: 创建货品档案wdt.goods.push
源平台元数据配置:
{
"id": "FMasterId",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FNumber",
"idCheck": true,
"request": [
{
"type": "string",
"field": "FMasterId",
"label": "id",
"value": "FMasterId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "FName",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": "FSpecification",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": "FMnemonicCode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": "FBARCODE",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "FDescription",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": "FMaterialGroup.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": "FBaseUnitId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "FCreateOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "FUseOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": "FGROSSWEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": "FLENGTH",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": "FWIDTH",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": "FHEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Text1",
"label": "简称",
"value": "F_PAEZ_Text1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Text5",
"label": "商家编码",
"value": "F_PAEZ_Text5",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant4",
"label": "品牌名称",
"value": "F_PAEZ_Assistant4",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Decimal",
"label": "零售价",
"value": "F_PAEZ_Decimal",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant7",
"label": "有效期",
"value": "F_PAEZ_Assistant7",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Integer",
"label": "销售积分",
"value": "F_PAEZ_Integer",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Integer1",
"label": "拣货积分",
"value": "F_PAEZ_Integer1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo2",
"label": "允许负库存",
"value": "F_PAEZ_Combo2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo3",
"label": "出货不验货",
"value": "F_PAEZ_Combo3",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo4",
"label": "允许零成本",
"value": "F_PAEZ_Combo4",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo5",
"label": "允许低于成本价",
"value": "F_PAEZ_Combo5",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo8",
"label": "补货类型",
"value": "F_PAEZ_Combo8",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo9",
"label": "大件类别",
"value": "F_PAEZ_Combo9",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant10",
"label": "辅助单位",
"value": "F_PAEZ_Assistant10",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant",
"label": "责任部门",
"value": "F_PAEZ_Assistant",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant1",
"label": "责任开发",
"value": "F_PAEZ_Assistant1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant2",
"label": "开发类型",
"value": "F_PAEZ_Assistant2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant3",
"label": "责任计划",
"value": "F_PAEZ_Assistant3",
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "FMasterId",
"label": "id",
"value": "FMasterId",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "FName",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": "FSpecification",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": "FMnemonicCode",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": "FBARCODE",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "FDescription",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": "FMaterialGroup.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": "FBaseUnitId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "FCreateOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "FUseOrgId.FNumber",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": "FGROSSWEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": "FLENGTH",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": "FWIDTH",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": "FHEIGHT",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Text1",
"label": "简称",
"value": "FComBrandId_CMK.FNumber",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Text5",
"label": "商家编码",
"value": "F_PAEZ_Text5",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant4",
"label": "品牌名称",
"value": "F_PAEZ_Assistant4",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Decimal",
"label": "零售价",
"value": "F_PAEZ_Decimal",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant7",
"label": "有效期",
"value": "F_PAEZ_Assistant7",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Integer",
"label": "销售积分",
"value": "F_PAEZ_Integer",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Integer1",
"label": "拣货积分",
"value": "F_PAEZ_Integer1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo2",
"label": "允许负库存",
"value": "F_PAEZ_Combo2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo3",
"label": "出货不验货",
"value": "F_PAEZ_Combo3",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo4",
"label": "允许零成本",
"value": "F_PAEZ_Combo4",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo5",
"label": "允许低于成本价",
"value": "F_PAEZ_Combo5",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo8",
"label": "补货类型",
"value": "F_PAEZ_Combo8",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Combo9",
"label": "大件类别",
"value": "F_PAEZ_Combo9",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant10",
"label": "辅助单位",
"value": "F_PAEZ_Assistant10",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant",
"label": "责任部门",
"value": "F_PAEZ_Assistant",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant1",
"label": "责任开发",
"value": "F_PAEZ_Assistant1",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant2",
"label": "开发类型",
"value": "F_PAEZ_Assistant2",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "F_PAEZ_Assistant3",
"label": "责任计划",
"value": "F_PAEZ_Assistant3",
"describe": null,
"is_required": false
}
],
"pagination": {
"pageSize": 100
},
"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": null,
"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": "BD_MATERIAL",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "wdt.goods.push",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "array",
"field": "goods_list",
"label": "货品节点",
"children": [
{
"type": "string",
"field": "goods_no",
"label": "货品编号",
"value": "{{FNumber}}",
"parent": "goods_list",
"describe": "代表货品(spu)所有属性的唯一编号,用于系统货品区分,,SPU概念介绍,单击这里",
"is_required": true
},
{
"type": "string",
"field": "goods_type",
"label": "货品类别",
"value": "1",
"parent": "goods_list",
"describe": "货品类别 1销售商品 2原材料 3包装 4周转材料5虚拟商品6固定资产 0其它",
"is_required": true
},
{
"type": "string",
"field": "goods_name",
"label": "货品名称",
"value": "{{FName}}",
"parent": "goods_list",
"describe": "货品名称",
"is_required": true
},
{
"type": "string",
"field": "short_name",
"label": "货品简称",
"value": null,
"parent": "goods_list",
"describe": "货品简称",
"is_required": false
},
{
"type": "string",
"field": "alias",
"label": "货品别名",
"value": null,
"parent": "goods_list",
"describe": "别名",
"is_required": false
},
{
"type": "string",
"field": "pinyin",
"label": "拼音名称",
"value": null,
"parent": "goods_list",
"describe": "拼音名称",
"is_required": false
},
{
"type": "string",
"field": "origin",
"label": "产地",
"value": null,
"parent": "goods_list",
"describe": "产地",
"is_required": false
},
{
"type": "string",
"field": "class_name",
"label": "分类",
"value": null,
"parent": "goods_list",
"describe": "类别名称",
"is_required": false
},
{
"type": "string",
"field": "brand_name",
"label": "品牌",
"value": null,
"parent": "goods_list",
"describe": "品牌名称",
"is_required": false
},
{
"type": "string",
"field": "unit_name",
"label": "基本单位",
"value": null,
"parent": "goods_list",
"describe": "基本单位",
"is_required": false
},
{
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"parent": "goods_list",
"describe": "备注",
"is_required": false
},
{
"type": "string",
"field": "props1",
"label": "自定义属性1",
"value": null,
"parent": "goods_list",
"describe": "自定义属性1",
"is_required": false
},
{
"type": "string",
"field": "props2",
"label": "自定义属性2",
"value": null,
"parent": "goods_list",
"describe": "自定义属性2",
"is_required": false
},
{
"type": "string",
"field": "props3",
"label": "自定义属性3",
"value": null,
"parent": "goods_list",
"describe": "自定义属性3",
"is_required": false
},
{
"type": "string",
"field": "props4",
"label": "自定义属性4",
"value": null,
"parent": "goods_list",
"describe": "自定义属性4",
"is_required": false
},
{
"type": "string",
"field": "props5",
"label": "自定义属性5",
"value": null,
"parent": "goods_list",
"describe": "自定义属性5",
"is_required": false
},
{
"type": "string",
"field": "props6",
"label": "自定义属性6",
"value": null,
"parent": "goods_list",
"describe": "自定义属性6",
"is_required": false
},
{
"type": "string",
"field": "aux_unit_name",
"label": "辅助单位名称",
"value": null,
"parent": "goods_list",
"describe": "辅助单位名称",
"is_required": false
},
{
"type": "string",
"field": "flag_name",
"label": "标记名称",
"value": null,
"parent": "goods_list",
"describe": "标记名称",
"is_required": false
},
{
"type": "array",
"field": "spec_list",
"label": "单品节点",
"parent": "goods_list",
"children": [
{
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": "{{FNumber}}",
"parent": "spec_list",
"describe": "代表单品(sku)所有属性的唯一编码,用于系统单品区分,SKU概念介绍单击这里",
"is_required": true
},
{
"type": "string",
"field": "spec_code",
"label": "规格码",
"value": null,
"parent": "spec_list",
"describe": "规格编码",
"is_required": false
},
{
"type": "string",
"field": "barcode",
"label": "主条码",
"value": "{{FBARCODE}}",
"parent": "spec_list",
"describe": "主条码",
"is_required": false
},
{
"type": "string",
"field": "spec_name",
"label": "规格名称",
"value": "{{FSpecification}}",
"parent": "spec_list",
"describe": "规格名称",
"is_required": false
},
{
"type": "string",
"field": "is_allow_neg_stock",
"label": "允许负库存",
"value": "1",
"parent": "spec_list",
"describe": "是否允许负库存1允许,0不允许(默认为1)",
"is_required": false
},
{
"type": "string",
"field": "is_sn_enable",
"label": "是否启用序列号",
"value": "0",
"parent": "spec_list",
"describe": "是否启用序列号,默认不启用,0不启用序列号 1强序列号 2弱序列",
"is_required": false
},
{
"type": "string",
"field": "is_single_batch",
"label": "是否启用同一批次出库",
"value": "1",
"parent": "spec_list",
"describe": "是否启用同一批次出库,默认不启用,0不启用1启用",
"is_required": false
},
{
"type": "string",
"field": "is_not_need_examine",
"label": "是否出库不用验货",
"value": null,
"parent": "spec_list",
"describe": "是否出库不用验货,默认不开启该配置,0出库不验货未开启 1出库不验货开启",
"is_required": false
},
{
"type": "string",
"field": "is_zero_cost",
"label": "是否允许0成本",
"value": null,
"parent": "spec_list",
"describe": "是否允许0成本,默认允许,0不允许1允许",
"is_required": false
},
{
"type": "string",
"field": "is_lower_cost",
"label": "是否允许低于成本价",
"value": null,
"parent": "spec_list",
"describe": "是否允许低于成本价,默认不允许,0不允许1允许",
"is_required": false
},
{
"type": "string",
"field": "is_not_use_air",
"label": "是否航空禁运",
"value": null,
"parent": "spec_list",
"describe": "是否航空禁运,默认不开启,0不开启1开启",
"is_required": false
},
{
"type": "string",
"field": "is_popular",
"label": "是否畅销品",
"value": null,
"parent": "spec_list",
"describe": "是否畅销品,默认非畅销,0非畅销 1畅销",
"is_required": false
},
{
"type": "string",
"field": "replenish_type",
"label": "补货",
"value": null,
"parent": "spec_list",
"describe": "补货,默认低于警戒库存补货,0持续补货1不补货2低于警戒库存补货",
"is_required": false
},
{
"type": "string",
"field": "large_type",
"label": "拆分",
"value": null,
"parent": "spec_list",
"describe": "默认普通件,-1非单发件(需和其他类型货品一起发) 0普通件 1普通大件(可与非大件一起发) 2独立大件(必须单独发)",
"is_required": false
},
{
"type": "string",
"field": "spec_unit_name",
"label": "基本单位",
"value": null,
"parent": "spec_list",
"describe": "基本单位名称",
"is_required": false
},
{
"type": "string",
"field": "lowest_price",
"label": "最低价",
"value": null,
"parent": "spec_list",
"describe": "最低价",
"is_required": false
},
{
"type": "string",
"field": "img_url",
"label": "图片url地址",
"value": null,
"parent": "spec_list",
"describe": "图片url地址",
"is_required": false
},
{
"type": "string",
"field": "retail_price",
"label": "零售价",
"value": null,
"parent": "spec_list",
"describe": "商品标价,系统内手工建单时使用,传值时需谨慎",
"is_required": false
},
{
"type": "string",
"field": "wholesale_price",
"label": "批发价",
"value": null,
"parent": "spec_list",
"describe": "批发价",
"is_required": false
},
{
"type": "string",
"field": "member_price",
"label": "会员价",
"value": null,
"parent": "spec_list",
"describe": "会员价",
"is_required": false
},
{
"type": "string",
"field": "market_price",
"label": "市场价",
"value": null,
"parent": "spec_list",
"describe": "市场价",
"is_required": false
},
{
"type": "string",
"field": "sale_score",
"label": "销售积分",
"value": null,
"parent": "spec_list",
"describe": "销售积分",
"is_required": false
},
{
"type": "string",
"field": "pack_score",
"label": "打包积分",
"value": null,
"parent": "spec_list",
"describe": "打包积分",
"is_required": false
},
{
"type": "string",
"field": "pick_score",
"label": "拣货积分",
"value": null,
"parent": "spec_list",
"describe": "拣货积分",
"is_required": false
},
{
"type": "string",
"field": "validity_days",
"label": "有效期天数",
"value": null,
"parent": "spec_list",
"describe": "保质期,天数",
"is_required": false
},
{
"type": "string",
"field": "weight",
"label": "重量",
"value": null,
"parent": "spec_list",
"describe": "ERP默认重量单位:kg",
"is_required": false
},
{
"type": "string",
"field": "length",
"label": "长",
"value": null,
"parent": "spec_list",
"describe": "长(CM)",
"is_required": false
},
{
"type": "string",
"field": "width",
"label": "宽",
"value": null,
"parent": "spec_list",
"describe": "宽(CM)",
"is_required": false
},
{
"type": "string",
"field": "height",
"label": "高",
"value": null,
"parent": "spec_list",
"describe": "高(CM)",
"is_required": false
},
{
"type": "string",
"field": "tax_rate",
"label": "税率",
"value": null,
"parent": "spec_list",
"describe": "税率",
"is_required": false
},
{
"type": "string",
"field": "prop1",
"label": "自定义1",
"value": null,
"parent": "spec_list",
"describe": "自定义属性1",
"is_required": false
},
{
"type": "string",
"field": "prop2",
"label": "自定义2",
"value": null,
"parent": "spec_list",
"describe": "自定义属性2",
"is_required": false
},
{
"type": "string",
"field": "prop3",
"label": "自定义3",
"value": null,
"parent": "spec_list",
"describe": "自定义属性3",
"is_required": false
},
{
"type": "string",
"field": "prop4",
"label": "自定义4",
"value": null,
"parent": "spec_list",
"describe": "自定义属性4",
"is_required": false
},
{
"type": "string",
"field": "prop5",
"label": "自定义5",
"value": null,
"parent": "spec_list",
"describe": "自定义属性5",
"is_required": false
},
{
"type": "string",
"field": "prop6",
"label": "自定义6",
"value": null,
"parent": "spec_list",
"describe": "自定义属性6",
"is_required": false
},
{
"type": "string",
"field": "custom_price1",
"label": "自定义价格1",
"value": null,
"parent": "spec_list",
"describe": "自定义价格1",
"is_required": false
},
{
"type": "string",
"field": "custom_price2",
"label": "自定义价格2",
"value": null,
"parent": "spec_list",
"describe": "自定义价格2",
"is_required": false
},
{
"type": "string",
"field": "spec_aux_unit_name",
"label": "单品辅助单位名称",
"value": null,
"parent": "spec_list",
"describe": "单品辅助单位名称",
"is_required": false
},
{
"type": "string",
"field": "tax_code",
"label": "税务编码",
"value": null,
"parent": "spec_list",
"describe": "自定义价格2",
"is_required": false
},
{
"type": "string",
"field": "spec_remark",
"label": "备注",
"value": null,
"parent": "spec_list",
"describe": "备注",
"is_required": false
}
],
"describe": "请求参数的2级数据节点,包含sku所有属性信息的数据节点,节点下数据字段详见下述\"spec_list\"",
"is_required": false
}
],
"describe": "货品表主键",
"is_required": false
}
],
"response": [],
"operation": {
"rows": 1,
"method": "batchArraySave",
"rowsKey": "goods_list"
},
"otherRequest": [],
"otherResponse": []
}