源系统平台:金蝶云星空
源系统接口: 物料查询executeBillQuery
目标系统平台: 聚水潭
目标系统接口: 商品上传(新)jushuitan.itemsku.upload
源平台元数据配置:
{
"id": "FMasterId",
"api": "executeBillQuery",
"type": "QUERY",
"method": "POST",
"number": "FNumber",
"idCheck": false,
"request": [
{
"type": "string",
"field": "FMasterId",
"label": "id",
"value": "FMasterId"
},
{
"type": "string",
"field": "F_XC_DECIMAL",
"label": "批发价",
"value": "F_XC_DECIMAL"
},
{
"type": "string",
"field": "F_XC_ASSISTANT",
"label": "品牌-自定义",
"value": "F_XC_ASSISTANT.FDATAVALUE"
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": "FNumber"
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": "FName"
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": "FSpecification"
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": "FMnemonicCode"
},
{
"type": "string",
"field": "F_XC_TEXT",
"label": "批准文号",
"value": "F_XC_TEXT"
},
{
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": "FBARCODE"
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": "FDescription"
},
{
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": "FMaterialGroup.FNumber"
},
{
"type": "string",
"field": "FMaterialGroup_Fname",
"label": "物料分组名称",
"value": "FMaterialGroup.Fname"
},
{
"type": "string",
"field": "F_XC_WLSCCJ",
"label": "生产厂家",
"value": "F_XC_WLSCCJ"
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "数据状态",
"value": "FDocumentStatus"
},
{
"type": "string",
"field": "FForbidStatus",
"label": "禁用状态",
"value": "FForbidStatus"
},
{
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": "FBaseUnitId.FNumber"
},
{
"type": "string",
"field": "FBaseUnitId_FName",
"label": "基本单位.名称",
"value": "FBaseUnitId.FName"
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "FCreateOrgId.FNumber"
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "FUseOrgId.FNumber"
},
{
"type": "string",
"field": "FIsInventory",
"label": "允许库存",
"value": "FIsInventory"
},
{
"type": "string",
"field": "FIsSale",
"label": "允许销售",
"value": "FIsSale"
},
{
"type": "string",
"field": "FIsAsset",
"label": "允许资产",
"value": "FIsAsset"
},
{
"type": "string",
"field": "FIsSubContract",
"label": "允许委外",
"value": "FIsSubContract"
},
{
"type": "string",
"field": "FIsProduce",
"label": "允许生产",
"value": "FIsProduce"
},
{
"type": "string",
"field": "FIsPurchase",
"label": "允许采购",
"value": "FIsPurchase"
},
{
"type": "string",
"field": "FTAXRATEID_FNumber",
"label": "默认税率",
"value": "FTAXRATEID.FNumber"
},
{
"type": "string",
"field": "FStockId_FNumber",
"label": "仓库",
"value": "FStockId.FNumber"
},
{
"type": "string",
"field": "FPurchaseOrgId_FNumber",
"label": "采购组织.编码",
"value": "FPurchaseOrgId.FNumber"
},
{
"type": "string",
"field": "FPurchaseOrgId_FName",
"label": "采购组织",
"value": "FPurchaseOrgId.FName"
},
{
"type": "string",
"field": "FIsBatchManage",
"label": "启用批号管理",
"value": "FIsBatchManage"
},
{
"type": "string",
"field": "FIsKFPeriod",
"label": "启用保质期管理",
"value": "FIsKFPeriod"
},
{
"type": "string",
"field": "FIsSNManage",
"label": "启用序列号管理",
"value": "FIsSNManage"
},
{
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": "FSafeStock"
},
{
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": "FCategoryID"
},
{
"type": "string",
"field": "FOrderQty",
"label": "起订量",
"value": "FOrderQty"
},
{
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": "FMinQty"
},
{
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": "FMaxQty"
},
{
"type": "string",
"field": "FDefaultVendor_FNumber",
"label": "默认供应商",
"value": "FDefaultVendor.FNumber"
},
{
"type": "string",
"field": "FMaxPOQty",
"label": "最大订货量",
"value": "FMaxPOQty"
},
{
"type": "string",
"field": "FMinPOQty",
"label": "最小订货量",
"value": "FMinPOQty"
},
{
"type": "string",
"field": "FIncreaseQty",
"label": "最小包装量",
"value": "FIncreaseQty"
},
{
"type": "string",
"field": "FFixLeadTime",
"label": "固定提前期",
"value": "FFixLeadTime"
},
{
"type": "string",
"field": "FVarLeadTime",
"label": "变动提前期",
"value": "FVarLeadTime"
},
{
"type": "string",
"field": "FPlanBatchSplitQty",
"label": "拆分批量",
"value": "FPlanBatchSplitQty"
},
{
"type": "string",
"field": "FProduceBillType_FNumber",
"label": "生产类型",
"value": "FProduceBillType.FNumber"
},
{
"type": "string",
"field": "FPOBillTypeId_FNumber",
"label": "采购类型",
"value": "FPOBillTypeId.FNumber"
},
{
"type": "string",
"field": "FSubBillType_FNumber",
"label": "委外类型",
"value": "FSubBillType.FNumber"
},
{
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": "FGROSSWEIGHT"
},
{
"type": "string",
"field": "FNETWEIGHT",
"label": "净重",
"value": "FNETWEIGHT"
},
{
"type": "string",
"field": "FWEIGHTUNITID_FNumber",
"label": "重量单位",
"value": "FWEIGHTUNITID.FNumber"
},
{
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": "FLENGTH"
},
{
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": "FWIDTH"
},
{
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": "FHEIGHT"
},
{
"type": "string",
"field": "FVOLUME",
"label": "体积",
"value": "FVOLUME"
},
{
"type": "string",
"field": "FWARRANTY",
"label": "保修期",
"value": "FWARRANTY"
},
{
"type": "string",
"field": "FSalePrice_CMK",
"label": "零售价",
"value": "FSalePrice_CMK"
},
{
"type": "string",
"field": "FVIPPrice_CMK",
"label": "会员价",
"value": "FVIPPrice_CMK"
},
{
"type": "string",
"field": "FEXPUNIT",
"label": "保质期单位",
"value": "FEXPUNIT"
},
{
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": "FExpPeriod"
},
{
"type": "string",
"field": "F_XC_Integer",
"label": "保质期(天数)",
"value": "F_XC_Integer"
}
],
"response": [
{
"type": "string",
"field": "FMasterId",
"label": "id",
"value": null
},
{
"type": "string",
"field": "F_XC_DECIMAL",
"label": "批发价",
"value": null
},
{
"type": "string",
"field": "F_XC_ASSISTANT",
"label": "品牌-自定义",
"value": null
},
{
"type": "string",
"field": "FNumber",
"label": "编码",
"value": null
},
{
"type": "string",
"field": "FName",
"label": "名称",
"value": null
},
{
"type": "string",
"field": "FSpecification",
"label": "规格型号",
"value": null
},
{
"type": "string",
"field": "FMnemonicCode",
"label": "助记码",
"value": null
},
{
"type": "string",
"field": "F_XC_TEXT",
"label": "批准文号",
"value": null
},
{
"type": "string",
"field": "FBARCODE",
"label": "条码",
"value": null
},
{
"type": "string",
"field": "FDescription",
"label": "描述",
"value": null
},
{
"type": "string",
"field": "FMaterialGroup_FNumber",
"label": "物料分组",
"value": null
},
{
"type": "string",
"field": "FMaterialGroup_Fname",
"label": "物料分组名称",
"value": null
},
{
"type": "string",
"field": "F_XC_WLSCCJ",
"label": "生产厂家",
"value": null
},
{
"type": "string",
"field": "FDocumentStatus",
"label": "数据状态",
"value": null
},
{
"type": "string",
"field": "FForbidStatus",
"label": "禁用状态",
"value": null
},
{
"type": "string",
"field": "FBaseUnitId_FNumber",
"label": "基本单位.编码",
"value": null
},
{
"type": "string",
"field": "FBaseUnitId_FName",
"label": "基本单位.名称",
"value": null
},
{
"type": "string",
"field": "FCreateOrgId_FNumber",
"label": "创建组织",
"value": "101"
},
{
"type": "string",
"field": "FUseOrgId_FNumber",
"label": "使用组织",
"value": "101"
},
{
"type": "string",
"field": "FIsInventory",
"label": "允许库存",
"value": null
},
{
"type": "string",
"field": "FIsSale",
"label": "允许销售",
"value": null
},
{
"type": "string",
"field": "FIsAsset",
"label": "允许资产",
"value": null
},
{
"type": "string",
"field": "FIsSubContract",
"label": "允许委外",
"value": null
},
{
"type": "string",
"field": "FIsProduce",
"label": "允许生产",
"value": null
},
{
"type": "string",
"field": "FIsPurchase",
"label": "允许采购",
"value": null
},
{
"type": "string",
"field": "FTAXRATEID_FNumber",
"label": "默认税率",
"value": null
},
{
"type": "string",
"field": "FStockId_FNumber",
"label": "仓库",
"value": null
},
{
"type": "string",
"field": "FPurchaseOrgId_FNumber",
"label": "采购组织.编码",
"value": null
},
{
"type": "string",
"field": "FPurchaseOrgId_FName",
"label": "采购组织",
"value": null
},
{
"type": "string",
"field": "FIsBatchManage",
"label": "启用批号管理",
"value": null
},
{
"type": "string",
"field": "FIsKFPeriod",
"label": "启用保质期管理",
"value": null
},
{
"type": "string",
"field": "FIsSNManage",
"label": "启用序列号管理",
"value": null
},
{
"type": "string",
"field": "FSafeStock",
"label": "安全库存",
"value": null
},
{
"type": "string",
"field": "FCategoryID",
"label": "存货类别",
"value": null
},
{
"type": "string",
"field": "FOrderQty",
"label": "起订量",
"value": null
},
{
"type": "string",
"field": "FMinQty",
"label": "最小批量",
"value": null
},
{
"type": "string",
"field": "FMaxQty",
"label": "最大批量",
"value": null
},
{
"type": "string",
"field": "FDefaultVendor_FNumber",
"label": "默认供应商",
"value": null
},
{
"type": "string",
"field": "FMaxPOQty",
"label": "最大订货量",
"value": null
},
{
"type": "string",
"field": "FMinPOQty",
"label": "最小订货量",
"value": null
},
{
"type": "string",
"field": "FIncreaseQty",
"label": "最小包装量",
"value": null
},
{
"type": "string",
"field": "FFixLeadTime",
"label": "固定提前期",
"value": null
},
{
"type": "string",
"field": "FVarLeadTime",
"label": "变动提前期",
"value": null
},
{
"type": "string",
"field": "FPlanBatchSplitQty",
"label": "拆分批量",
"value": null
},
{
"type": "string",
"field": "FProduceBillType_FNumber",
"label": "生产类型",
"value": null
},
{
"type": "string",
"field": "FPOBillTypeId_FNumber",
"label": "采购类型",
"value": null
},
{
"type": "string",
"field": "FSubBillType_FNumber",
"label": "委外类型",
"value": null
},
{
"type": "string",
"field": "FGROSSWEIGHT",
"label": "毛重",
"value": null
},
{
"type": "string",
"field": "FNETWEIGHT",
"label": "净重",
"value": null
},
{
"type": "string",
"field": "FWEIGHTUNITID_FNumber",
"label": "重量单位",
"value": null
},
{
"type": "string",
"field": "FLENGTH",
"label": "长",
"value": null
},
{
"type": "string",
"field": "FWIDTH",
"label": "宽",
"value": null
},
{
"type": "string",
"field": "FHEIGHT",
"label": "高",
"value": null
},
{
"type": "string",
"field": "FVOLUME",
"label": "体积",
"value": null
},
{
"type": "string",
"field": "FWARRANTY",
"label": "保修期",
"value": null
},
{
"type": "string",
"field": "FSalePrice_CMK",
"label": "零售价",
"value": null
},
{
"type": "string",
"field": "FVIPPrice_CMK",
"label": "会员价",
"value": null
},
{
"type": "string",
"field": "FEXPUNIT",
"label": "保质期单位",
"value": null
},
{
"type": "string",
"field": "FExpPeriod",
"label": "保质期",
"value": null
},
{
"type": "string",
"field": "F_XC_Integer",
"label": "保质期(天数)",
"value": null
}
],
"pagination": {
"pageSize": 500
},
"otherRequest": [
{
"type": "string",
"field": "Limit",
"label": "最大行数",
"value": "{{PAGINATION_PAGE_SIZE}}"
},
{
"type": "string",
"field": "StartRow",
"label": "开始行索引",
"value": "{{PAGINATION_START_ROW}}"
},
{
"type": "int",
"field": "TopRowCount",
"label": "返回总行数",
"value": "0"
},
{
"type": "string",
"field": "FilterString",
"label": "过滤条件",
"value": "FUseOrgId.fnumber='100' and F_XC_CHECKBOX =1 and FAPPROVEDATE>='{{LAST_SYNC_TIME|datetime}}'"
},
{
"type": "array",
"field": "FieldKeys",
"label": "需查询的字段key集合",
"parser": {
"name": "ArrayToString",
"params": ","
}
},
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "BD_MATERIAL"
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "jushuitan.itemsku.upload",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "sku_id",
"label": "商品编码",
"value": "{{FNumber}}",
"describe": "商品编码",
"is_required": true
},
{
"type": "string",
"field": "unit",
"label": "单位",
"value": "{{FBaseUnitId_FName}}",
"describe": "单位",
"is_required": true
},
{
"type": "string",
"field": "shelf_life",
"label": "保质期",
"value": "_function case when '{{F_XC_Integer}}'=0 then '' else '{{F_XC_Integer}}' end",
"describe": "保质期",
"is_required": true
},
{
"type": "string",
"field": "i_id",
"label": "款式编码",
"value": "{{FNumber}}",
"describe": "款式编码",
"is_required": true
},
{
"type": "string",
"field": "brand",
"label": "品牌,可更新",
"value": "{{F_XC_ASSISTANT}}",
"describe": "品牌,可更新",
"is_required": false
},
{
"type": "string",
"field": "vc_name",
"label": "虚拟分类,可更新",
"value": null,
"describe": "虚拟分类,可更新",
"is_required": false
},
{
"type": "string",
"field": "c_name",
"label": "商品分类,必须是[商品类目管理]中的叶子节点,可更新",
"value": null,
"describe": "商品分类,必须是[商品类目管理]中的叶子节点,可更新",
"is_required": false
},
{
"type": "string",
"field": "s_price",
"label": "基本售价,可更新",
"value": "{{F_XC_DECIMAL}}",
"describe": "基本售价,可更新",
"is_required": true
},
{
"type": "string",
"field": "item_type",
"label": "商品属性,可选值[\"成品\", \"半成品\", \"原材料\", \"包材\"],可更新",
"value": "成品",
"describe": "商品属性,可选值[\"成品\", \"半成品\", \"原材料\", \"包材\"],可更新",
"is_required": false
},
{
"type": "string",
"field": "l",
"label": "长,可更新",
"value": "{{FLENGTH}}",
"describe": "长,可更新",
"is_required": false
},
{
"type": "string",
"field": "w",
"label": "宽,可更新",
"value": "{{FWIDTH}}",
"describe": "宽,可更新",
"is_required": false
},
{
"type": "string",
"field": "h",
"label": "高,可更新",
"value": "{{FHEIGHT}}",
"describe": "高,可更新",
"is_required": false
},
{
"type": "string",
"field": "pic_big",
"label": "大图地址,可更新",
"value": null,
"describe": "大图地址,可更新",
"is_required": false
},
{
"type": "string",
"field": "name",
"label": "名称,可更新",
"value": "{{FName}}",
"describe": "名称,可更新",
"is_required": true
},
{
"type": "string",
"field": "remark",
"label": "备注,可更新",
"value": null,
"describe": "备注,可更新",
"is_required": false
},
{
"type": "string",
"field": "properties_value",
"label": "颜色及规格,可更新",
"value": "{{FSpecification}}",
"describe": "颜色及规格,可更新",
"is_required": false
},
{
"type": "string",
"field": "short_name",
"label": "简称,可更新",
"value": "{{FName}}",
"describe": "简称,可更新",
"is_required": false
},
{
"type": "string",
"field": "weight",
"label": "重量,可更新",
"value": null,
"describe": "重量,可更新",
"is_required": false
},
{
"type": "string",
"field": "enabled",
"label": "是否启用,默认值1, 可选值: -1=禁用, 0=备用, 1=启用,可更新",
"value": "1",
"describe": "是否启用,默认值1, 可选值: -1=禁用, 0=备用, 1=启用,可更新",
"is_required": false
},
{
"type": "string",
"field": "supplier_name",
"label": "供应商名称,可更新",
"value": null,
"describe": "供应商名称,可更新",
"is_required": false
},
{
"type": "string",
"field": "sku_code",
"label": "国际码,可更新",
"value": "{{FBARCODE}}",
"describe": "国际码,可更新",
"is_required": false
},
{
"type": "string",
"field": "supplier_sku_id",
"label": "供应商商品编码,可更新",
"value": null,
"describe": "供应商商品编码,可更新",
"is_required": false
},
{
"type": "string",
"field": "supplier_i_id",
"label": "供应商款式编码,可更新",
"value": null,
"describe": "供应商款式编码,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_price_1",
"label": "其它价格1,可更新",
"value": null,
"describe": "其它价格1,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_price_2",
"label": "其它价格2,可更新",
"value": null,
"describe": "其它价格2,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_price_3",
"label": "其它价格3,可更新",
"value": null,
"describe": "其它价格3,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_price_4",
"label": "其它价格4,可更新",
"value": null,
"describe": "其它价格4,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_price_5",
"label": "其它价格5,可更新",
"value": null,
"describe": "其它价格5,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_1",
"label": "其它属性1,可更新",
"value": "{{F_XC_TEXT}}",
"describe": "其它属性1,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_2",
"label": "其它属性2,可更新",
"value": "{{F_XC_WLSCCJ}}",
"describe": "其它属性2,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_3",
"label": "其它属性3,可更新",
"value": null,
"describe": "其它属性3,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_4",
"label": "其它属性4,可更新",
"value": null,
"describe": "其它属性4,可更新",
"is_required": false
},
{
"type": "string",
"field": "other_5",
"label": "其它属性5,可更新",
"value": null,
"describe": "其它属性5,可更新",
"is_required": false
},
{
"type": "string",
"field": "stock_disabled",
"label": "禁止同步,true=禁止,false=允许,可更新",
"value": "false",
"describe": "禁止同步,true=禁止,false=允许,可更新",
"is_required": false
},
{
"type": "string",
"field": "cost_price",
"label": "成本价,可更新",
"value": null,
"describe": "成本价,可更新",
"is_required": false
},
{
"type": "string",
"field": "market_price",
"label": "市场|吊牌价,可更新",
"value": null,
"describe": "市场|吊牌价,可更新",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "code",
"label": "错误码,0代表成功",
"value": null,
"describe": "错误码,0代表成功",
"is_required": false
},
{
"type": "string",
"field": "issuccess",
"label": "true代表成功",
"value": null,
"describe": "true代表成功",
"is_required": false
},
{
"type": "string",
"field": "msg",
"label": "执行描述",
"value": null,
"describe": "执行描述",
"is_required": false
}
],
"otherRequest": [
{
"id": "dataKey",
"type": "string",
"field": "dataKey",
"label": "dataKey",
"value": "items",
"parent": null
}
],
"otherResponse": []
}