源系统平台：旺店通·旗舰奇门
源系统接口： 销售退货单查询wdt.wms.stockin.refund.querywithdetail
目标系统平台： 金蝶云星空
目标系统接口： 销售退货新增batchSave
源平台元数据配置：
{
"id": "order_no",
"api": "wdt.wms.stockin.refund.querywithdetail",
"type": "QUERY",
"method": "POST",
"number": "order_no",
"idCheck": true,
"request": [
{
"type": "object",
"field": "pager",
"label": "分页参数",
"children": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "50",
"parent": "pager",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "1",
"parent": "pager",
"describe": null,
"is_required": true
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "params",
"label": "业务参数",
"children": [
{
"type": "string",
"field": "start_time",
"label": "开始时间",
"value": "{{LAST_SYNC_TIME|datetime}}",
"parent": "params",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "end_time",
"label": "结束时间",
"value": "{{CURRENT_TIME|datetime}}",
"parent": "params",
"describe": null,
"is_required": true
},
{
"type": "string",
"field": "status",
"label": "入库单状态",
"value": null,
"parent": "params",
"describe": "英文逗号拼接的状态值:10=已取消；20=编辑中；30=待审核；37=待质检；40=质检确认；\r\n60=待结算；70=暂估结算；80=已完成",
"is_required": false
},
{
"type": "string",
"field": "time_type",
"label": "时间条件类型",
"value": "1",
"parent": "params",
"describe": "查询的时间条件类型, 0:修改时间; 1:入库时间 不传默认为0",
"is_required": false
},
{
"type": "string",
"field": "warehouse_no",
"label": "仓库编码",
"value": null,
"parent": "params",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shop_nos",
"label": "店铺编号",
"value": null,
"parent": "params",
"describe": "多个店铺编号使用英文逗号分隔",
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "order_no",
"label": "入库单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "status",
"label": "入库单状态",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "warehouse_name",
"label": "仓库名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "created_time",
"label": "入库单创建时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "remark",
"label": "入库单备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "fenxiao_nick",
"label": "分销商昵称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "operator_name",
"label": "退换建单人",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "logistics_type",
"label": "物流方式",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "check_time",
"label": "审核时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "refund_no",
"label": "退换单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_count",
"label": "货品总数",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "actual_refund_amount",
"label": "退换单实际退款金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "customer_no",
"label": "客户编码",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "customer_name",
"label": "退货人姓名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "nick_name",
"label": "客户网名",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shop_name",
"label": "店铺名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shop_no",
"label": "店铺编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shop_remark",
"label": "店铺备注",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "flag_name",
"label": "标记名称",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "trade_no_list",
"label": "订单编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "total_price",
"label": "入库单总金额",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "modified",
"label": "最后修改时间",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "details_list",
"label": "入库单明细",
"children": [
{
"type": "string",
"field": "rec_id",
"label": "明细id(主键)",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "stockin_id",
"label": "入库单id",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "num",
"label": "数量",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "total_cost",
"label": "总成本",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "remark",
"label": "明细备注",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "right_num",
"label": "调整后数量",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_name",
"label": "货品名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_no",
"label": "货品编码",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "defect",
"label": "是否残次品",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "prop2",
"label": "自定义属性2",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "spec_name",
"label": "规格名",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "spec_code",
"label": "规格码",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "brand_no",
"label": "品牌编号",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "brand_name",
"label": "品牌名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "goods_unit",
"label": "入库单位名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "basic_unit_name",
"label": "基本单位名称",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "batch_no",
"label": "批次号",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "expire_date",
"label": "有效期",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "position_no",
"label": "货位",
"value": null,
"parent": "details_list",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"otherRequest": [],
"otherResponse": []
}
目标平台元数据配置：
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "XSTHD01_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": null,
"describe": "单据编号",
"is_required": true
},
{
"type": "string",
"field": "FSaleOrgId",
"label": "销售组织",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": null,
"describe": "日期",
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId",
"label": "库存组织",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": true
},
{
"type": "string",
"field": "FRetcustId",
"label": "退货客户",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FSaledeptid",
"label": "销售部门",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FSettleCurrId",
"label": "结算币别",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "F_JHKJ_Text",
"label": "原始退款单号",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "F_JHKJ_Text1",
"label": "退货原因",
"value": null,
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "F_JHKJ_Text11",
"label": "退货成功时间",
"value": null,
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "F_JHKJ_Text111",
"label": "退货时间",
"value": null,
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FHeadNote",
"label": "备注",
"value": null,
"describe": "多行文本",
"is_required": false
},
{
"type": "string",
"field": "FPayCustId",
"label": "付款方",
"value": null,
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"children": [
{
"type": "string",
"field": "FMaterialId",
"label": "物料编码",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FBarcode",
"label": "零售条形码",
"value": null,
"parent": "FEntity",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FRealQty",
"label": "实退数量",
"value": null,
"parent": "FEntity",
"describe": "数量",
"is_required": true
},
{
"type": "string",
"field": "FPrice",
"label": "单价",
"value": null,
"parent": "FEntity",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": null,
"parent": "FEntity",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FIsFree",
"label": "是否赠品",
"value": null,
"parent": "FEntity",
"describe": "复选框",
"is_required": false
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率%",
"value": null,
"parent": "FEntity",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FReturnType",
"label": "退货类型",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单选辅助资料列表",
"is_required": false
},
{
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型",
"value": null,
"parent": "FEntity",
"describe": "多类别基础资料列表",
"is_required": false
},
{
"type": "string",
"field": "FOwnerId",
"label": "货主",
"value": null,
"parent": "FEntity",
"describe": "多类别基础资料",
"is_required": false
},
{
"type": "string",
"field": "FStockId",
"label": "仓库",
"value": null,
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FLot",
"label": "批号",
"value": null,
"parent": "FEntity",
"describe": "批次",
"is_required": false
},
{
"type": "string",
"field": "FDeliveryDate",
"label": "退货日期",
"value": null,
"parent": "FEntity",
"describe": "长日期",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": null,
"parent": "FEntity",
"describe": "文本",
"is_required": false
},
{
"type": "array",
"field": "FEntity_Link",
"label": "关联关系表",
"parent": "FEntity",
"describe": null,
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "object",
"field": "SubHeadEntity",
"label": "财务信息",
"children": [
{
"type": "string",
"field": "FSettleOrgId",
"label": "结算组织",
"value": null,
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FSettleTypeId",
"label": "结算方式",
"value": null,
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
}
],
"describe": null,
"is_required": false
}
],
"response": [],
"operation": {
"rows": 20,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "SAL_RETURNSTOCK",
"describe": "必须填写金蝶的表单ID如:PUR_PurchaseOrder",
"is_required": true
},
{
"type": "string",
"field": "Operation",
"label": "执行的操作",
"value": "Save",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsAutoSubmitAndAudit",
"label": "提交并审核",
"value": "true",
"describe": null,
"is_required": true
},
{
"type": "bool",
"field": "IsVerifyBaseDataField",
"label": "验证基础资料",
"value": "false",
"describe": "是否验证所有的基础资料有效性，布尔类，默认false（非必录）",
"is_required": false
},
{
"type": "string",
"field": "SubSystemId",
"label": "系统模块",
"value": "21",
"describe": "默认仓库模块",
"is_required": false
}
],
"otherResponse": []
}
