源系统平台:旺店通·企业奇门
源系统接口: 查询销售出库单wdt.stockout.order.query.trade
目标系统平台: 金蝶云星空
目标系统接口: 销售出库新增batchSave
源平台元数据配置:
{
"id": "stockout_id",
"api": "wdt.stockout.order.query.trade",
"type": "QUERY",
"method": "POST",
"number": "order_no",
"idCheck": true,
"request": [
{
"type": "datetime",
"field": "start_time",
"label": "开始时间",
"value": "2022-03-18 00:00:00",
"describe": "增量获取数据,start_time作为开始时间,格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "datetime",
"field": "end_time",
"label": "结束时间",
"value": "2022-03-18 23:59:59",
"describe": "增量获取数据,end_time作为结束时间,格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "string",
"field": "status",
"label": "状态",
"value": null,
"describe": "5已取消,55已审核,95已发货,105 部分打款,110已完成,113:异常发货",
"is_required": false
},
{
"type": "string",
"field": "src_order_no",
"label": "系统订单编号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "src_tid",
"label": "原始单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "stockout_no",
"label": "出库单号",
"value": null,
"describe": null,
"is_required": false
},
{
"type": "string",
"field": "shop_no",
"label": "店铺编号",
"value": null,
"describe": "代表店铺所有属性的唯一编码,用于店铺区分,ERP内支持自定义(ERP店铺界面设置),用于获取指定店铺单据数据信息",
"is_required": false
},
{
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": "代表仓库所有属性的唯一编码,用于仓库区分,ERP内支持自定义(ERP仓库界面设置),用于获取指定仓库单据数据信息(不支持一次推送多个仓库编号)",
"is_required": false
}
],
"response": [
{
"type": "string",
"field": "order_no",
"label": "出库单号",
"value": null,
"describe": "出库单号,唯一单号",
"is_required": true
},
{
"type": "string",
"field": "src_order_no",
"label": "源单号",
"value": null,
"describe": "源单号,旺店通系统单号(多默认为JY开头)",
"is_required": true
},
{
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": "仓库编号",
"is_required": true
},
{
"type": "string",
"field": "consign_time",
"label": "发货时间",
"value": null,
"describe": "销售出库单发货时间 时间格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "string",
"field": "order_type",
"label": "出库单类型",
"value": null,
"describe": "出库单类型",
"is_required": true
},
{
"type": "string",
"field": "trade_status",
"label": "订单状态",
"value": null,
"describe": "订单状态 5已取消 10待付款 12待尾款 13待选仓 15等未付16延时审核 19预订单前处理 20前处理(赠品,合并,拆分)21委外前处理22抢单前处理 25预订单 27待抢单 30待客审 35待财审 40待递交仓库 45递交仓库中 50已递交仓库 53未确认 55已确认 95已发货 105部分打款 110已完成 113异常发货",
"is_required": true
},
{
"type": "string",
"field": "order_type_name",
"label": "出库单类型名称",
"value": null,
"describe": "固定名称“销售出库”",
"is_required": true
},
{
"type": "string",
"field": "trade_type",
"label": "订单类型",
"value": null,
"describe": "1网店销售 2线下零售 3售后换货 4批发业务 5保修换新 6保修完成 7订单补发 .. 101自定义类型1 102自定义类型2 103自定义类型3 104自定义类型4 105自定义类型5 106自定义类型6",
"is_required": true
},
{
"type": "string",
"field": "subtype",
"label": "出库子类型",
"value": null,
"describe": "出库子类型",
"is_required": true
},
{
"type": "string",
"field": "goods_total_amount",
"label": "货品总售价",
"value": null,
"describe": "货品总售价",
"is_required": true
},
{
"type": "string",
"field": "goods_total_cost",
"label": "货品总成本",
"value": null,
"describe": "货品总成本",
"is_required": true
},
{
"type": "string",
"field": "post_fee",
"label": "邮资成本",
"value": null,
"describe": "邮资成本",
"is_required": true
},
{
"type": "string",
"field": "logistics_no",
"label": "物流单号",
"value": null,
"describe": "物流单号",
"is_required": true
},
{
"type": "string",
"field": "package_fee",
"label": "包装费",
"value": null,
"describe": "包装费",
"is_required": true
},
{
"type": "string",
"field": "receiver_name",
"label": "收件人",
"value": null,
"describe": "收件人",
"is_required": true
},
{
"type": "string",
"field": "receiver_country",
"label": "国家",
"value": null,
"describe": "国家",
"is_required": true
},
{
"type": "string",
"field": "receiver_province",
"label": "省份",
"value": null,
"describe": "省份",
"is_required": true
},
{
"type": "string",
"field": "receiver_city",
"label": "城市",
"value": null,
"describe": "城市",
"is_required": true
},
{
"type": "string",
"field": "receiver_district",
"label": "地区",
"value": null,
"describe": "地区",
"is_required": true
},
{
"type": "string",
"field": "receiver_address",
"label": "详细地址",
"value": null,
"describe": "详细地址",
"is_required": true
},
{
"type": "string",
"field": "receiver_mobile",
"label": "收件人移动电话",
"value": null,
"describe": "收件人移动电话",
"is_required": true
},
{
"type": "string",
"field": "receiver_telno",
"label": "收件人固定电话",
"value": null,
"describe": "收件人固定电话",
"is_required": true
},
{
"type": "string",
"field": "receiver_zip",
"label": "邮编",
"value": null,
"describe": "邮编",
"is_required": true
},
{
"type": "string",
"field": "receiver_dtb",
"label": "大头笔",
"value": null,
"describe": "大头笔",
"is_required": true
},
{
"type": "string",
"field": "logistics_type",
"label": "物流公司类型",
"value": null,
"describe": "响应值为ERP定义的ID数值,数值对应的物流公司类型名称单击这里",
"is_required": true
},
{
"type": "string",
"field": "logistics_code",
"label": "物流公司编号",
"value": null,
"describe": "代表物流所有属性的唯一编码,用于物流区分,ERP内支持自定义(ERP物流界面设置)",
"is_required": true
},
{
"type": "string",
"field": "logistics_name",
"label": "物流公司名称",
"value": null,
"describe": "物流公司名称",
"is_required": true
},
{
"type": "string",
"field": "print_remark",
"label": "打印备注",
"value": null,
"describe": "打印备注",
"is_required": true
},
{
"type": "string",
"field": "salesman_no",
"label": "业务员编号",
"value": null,
"describe": "业务员编号",
"is_required": true
},
{
"type": "string",
"field": "salesman_name",
"label": "业务员名称",
"value": null,
"describe": "业务员名称",
"is_required": true
},
{
"type": "string",
"field": "fullname",
"label": "业务员名称",
"value": null,
"describe": "业务员名称",
"is_required": true
},
{
"type": "string",
"field": "warehouse_name",
"label": "仓库",
"value": null,
"describe": "仓库",
"is_required": true
},
{
"type": "string",
"field": "created",
"label": "创建时间",
"value": null,
"describe": "创建时间 时间格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "string",
"field": "stockout_reason",
"label": "出库原因",
"value": null,
"describe": "出库原因",
"is_required": true
},
{
"type": "string",
"field": "outer_no",
"label": "外部单号",
"value": null,
"describe": "外部单号",
"is_required": true
},
{
"type": "string",
"field": "trade_no",
"label": "订单编号",
"value": null,
"describe": "系统订单编号,默认单号为JY开头,ERP内支持自定义(设置路径:设置——编码设置)",
"is_required": true
},
{
"type": "string",
"field": "src_trade_no",
"label": "原始单号",
"value": null,
"describe": "商城或电商平台的订单编号,合并订单的多个订单编号有逗号隔开",
"is_required": true
},
{
"type": "string",
"field": "nick_name",
"label": "网名",
"value": null,
"describe": "网名",
"is_required": true
},
{
"type": "string",
"field": "customer_name",
"label": "客户名称",
"value": null,
"describe": "客户名称(客户真实姓名,取自receiver_name)",
"is_required": true
},
{
"type": "string",
"field": "customer_no",
"label": "客户编号",
"value": null,
"describe": "客户编号",
"is_required": true
},
{
"type": "string",
"field": "trade_time",
"label": "交易时间",
"value": null,
"describe": "交易时间 时间格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "string",
"field": "pay_time",
"label": "付款时间",
"value": null,
"describe": "付款时间 时间格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "string",
"field": "status",
"label": "出库单状态",
"value": null,
"describe": "出库单状态 5 已取消 48未确认 50待审核 52待推送 53同步失败 55已审核 95 已发货 105部分打款 110已完成 113 异常发货 115回传失败 120回传成功",
"is_required": true
},
{
"type": "string",
"field": "shop_name",
"label": "店铺名称",
"value": null,
"describe": "店铺名称",
"is_required": true
},
{
"type": "string",
"field": "shop_no",
"label": "店铺编号",
"value": null,
"describe": "代表店铺所有属性的唯一编码,用于店铺区分,ERP内支持自定义(ERP店铺界面设置)",
"is_required": true
},
{
"type": "string",
"field": "buyer_message",
"label": "买家留言",
"value": null,
"describe": "买家留言",
"is_required": true
},
{
"type": "string",
"field": "cs_remark",
"label": "客服备注",
"value": null,
"describe": "客服备注",
"is_required": true
},
{
"type": "string",
"field": "flag_name",
"label": "订单标记",
"value": null,
"describe": "订单标记",
"is_required": true
},
{
"type": "string",
"field": "post_amount",
"label": "邮费",
"value": null,
"describe": "从平台获取的销售订单的邮费",
"is_required": true
},
{
"type": "string",
"field": "block_reason",
"label": "截停原因",
"value": null,
"describe": "截停原因:1申请退款2已退款4地址被修改8发票被修改16物流被修改32仓库变化64备注修改128更换货品256添加货品512放弃抢单1024其他 2048 拦截赠品 4096 拦截天猫换货 8192 买家留言变更 16384 该换货订单存在退货/退款",
"is_required": true
},
{
"type": "string",
"field": "invoice_type",
"label": "发票类别",
"value": null,
"describe": "发票类别0 不需要,1普通发票,2普通增值税发票,3专用增值税发票",
"is_required": true
},
{
"type": "string",
"field": "invoice_title",
"label": "发票抬头",
"value": null,
"describe": "发票抬头",
"is_required": true
},
{
"type": "string",
"field": "invoice_content",
"label": "发票内容",
"value": null,
"describe": "发票内容",
"is_required": true
},
{
"type": "string",
"field": "invoice_id",
"label": "发票ID",
"value": null,
"describe": "发票ID,目前只设0-1,1表示已开发票",
"is_required": true
},
{
"type": "string",
"field": "delivery_term",
"label": "发货条件",
"value": null,
"describe": "发货条件 1款到发货 2货到付款(包含部分货到付款) 3分期付款 4挂账单",
"is_required": true
},
{
"type": "string",
"field": "fenxiao_type",
"label": "分销类别",
"value": null,
"describe": "0 非分销订单 1 转供销 2 代销 3经销",
"is_required": true
},
{
"type": "string",
"field": "fenxiao_nick",
"label": "分销商ID",
"value": null,
"describe": "分销订单的分销商id,或转供销时供应商id",
"is_required": true
},
{
"type": "string",
"field": "cod_amount",
"label": "货到付款金额",
"value": null,
"describe": "货到付款金额",
"is_required": true
},
{
"type": "string",
"field": "id_card_type",
"label": "证件类别",
"value": null,
"describe": "1 身份证",
"is_required": true
},
{
"type": "string",
"field": "receiver_area",
"label": "收件人地址",
"value": null,
"describe": "省市区空格分隔",
"is_required": true
},
{
"type": "string",
"field": "shop_remark",
"label": "店铺备注",
"value": null,
"describe": "店铺备注",
"is_required": true
},
{
"type": "string",
"field": "platform_id",
"label": "平台id",
"value": null,
"describe": "平台id",
"is_required": true
},
{
"type": "string",
"field": "trade_id",
"label": "订单表主键",
"value": null,
"describe": "订单表主键",
"is_required": true
},
{
"type": "string",
"field": "checker_name",
"label": "审单员编号",
"value": null,
"describe": "审单员编号",
"is_required": true
},
{
"type": "string",
"field": "employee_no",
"label": "审单员编号",
"value": null,
"describe": "审单员编号",
"is_required": true
},
{
"type": "string",
"field": "operator_name",
"label": "审核员",
"value": null,
"describe": "审核员",
"is_required": true
},
{
"type": "string",
"field": "packager_no",
"label": "打包员编号",
"value": null,
"describe": "打包员编号",
"is_required": true
},
{
"type": "string",
"field": "packager_name",
"label": "打包员",
"value": null,
"describe": "打包员",
"is_required": true
},
{
"type": "string",
"field": "picker_no",
"label": "拣货员编号",
"value": null,
"describe": "拣货员编号",
"is_required": true
},
{
"type": "string",
"field": "picker_name",
"label": "拣货员",
"value": null,
"describe": "拣货员",
"is_required": true
},
{
"type": "string",
"field": "printer_no",
"label": "打单员编号",
"value": null,
"describe": "打单员编号",
"is_required": true
},
{
"type": "string",
"field": "printer_name",
"label": "打单员",
"value": null,
"describe": "打单员",
"is_required": true
},
{
"type": "string",
"field": "examiner_no",
"label": "验货员编号",
"value": null,
"describe": "验货员编号",
"is_required": true
},
{
"type": "string",
"field": "examiner_name",
"label": "验货员",
"value": null,
"describe": "验货员",
"is_required": true
},
{
"type": "string",
"field": "stockout_no",
"label": "出库单号",
"value": null,
"describe": "出库单号",
"is_required": true
},
{
"type": "string",
"field": "wms_status",
"label": "处理状态",
"value": null,
"describe": "处理状态 0 待处理 1 推送失败 2 推送成功 3 接口取消成功系统驳回失败 4 服务器正在处理 5 WMS返回发货信息 6 异步标记,推送申请成功'",
"is_required": true
},
{
"type": "string",
"field": "error_info",
"label": "接口处理错误信息",
"value": null,
"describe": "接口处理错误信息",
"is_required": true
},
{
"type": "string",
"field": "warehouse_type",
"label": "仓库类别",
"value": null,
"describe": "仓库类别 0不限 1普通仓库 2自动流转外部 3京东仓储 4科捷 5百世物流 6 SKU360 7通天晓 8中联网仓 9顺丰仓储 10网仓2号 11奇门仓储 12旺店通仓储 13心怡仓储 14力威仓储 15京东沧海 16云集仓储 127其他",
"is_required": true
},
{
"type": "string",
"field": "warehouse_id",
"label": "出库仓库id",
"value": null,
"describe": "出库的仓库id",
"is_required": true
},
{
"type": "string",
"field": "customer_id",
"label": "客户id",
"value": null,
"describe": "客户id",
"is_required": true
},
{
"type": "string",
"field": "freeze_reason",
"label": "冻结原因",
"value": null,
"describe": "冻结原因",
"is_required": true
},
{
"type": "string",
"field": "is_allocated",
"label": "是否分配",
"value": null,
"describe": "是否分配stockout_order_detail_position",
"is_required": true
},
{
"type": "string",
"field": "consign_status",
"label": "出库状态",
"value": null,
"describe": "出库状态 1验货 2称重 4出库 8物流同步 16分拣 32档口, 64拣货 1073741824原始单已完成",
"is_required": true
},
{
"type": "string",
"field": "ebill_status",
"label": "电子面单状态",
"value": null,
"describe": "电子面单,获取状态(0 还未获取单号或获取单号和打印信息完毕;1 手动获取物流单号中;100-105 获取打印数据中)",
"is_required": true
},
{
"type": "string",
"field": "operator_id",
"label": "制单人",
"value": null,
"describe": "制单人",
"is_required": true
},
{
"type": "string",
"field": "goods_type_count",
"label": "货品种类数量",
"value": null,
"describe": "货品种类数量",
"is_required": true
},
{
"type": "string",
"field": "md5_str",
"label": "MD5字符串值",
"value": null,
"describe": "MD5字符串值,用于单据排序",
"is_required": true
},
{
"type": "string",
"field": "custom_type",
"label": "其他出库自定义子类别",
"value": null,
"describe": "其他出库自定义子类别0,1,2,3,4",
"is_required": true
},
{
"type": "string",
"field": "receiver_ring",
"label": "京东三环内",
"value": null,
"describe": "京东三环内",
"is_required": true
},
{
"type": "string",
"field": "to_deliver_time",
"label": "配送时间",
"value": null,
"describe": "配送时间,如周末",
"is_required": true
},
{
"type": "string",
"field": "pre_charge_time",
"label": "配送中心",
"value": null,
"describe": "配送中心",
"is_required": true
},
{
"type": "string",
"field": "logistics_id",
"label": "物流公司ID",
"value": null,
"describe": "物流公司ID",
"is_required": true
},
{
"type": "string",
"field": "unknown_goods_amount",
"label": "未知成本销售总额",
"value": null,
"describe": "未知成本销售总额",
"is_required": true
},
{
"type": "string",
"field": "calc_post_cost",
"label": "预估邮费成本",
"value": null,
"describe": "预估邮费成本",
"is_required": true
},
{
"type": "string",
"field": "post_cost",
"label": "邮费成本",
"value": null,
"describe": "邮费成本",
"is_required": true
},
{
"type": "string",
"field": "calc_weight",
"label": "预估重量",
"value": null,
"describe": "预估重量",
"is_required": true
},
{
"type": "string",
"field": "post_weight",
"label": "快递重量",
"value": null,
"describe": "快递给的重量",
"is_required": true
},
{
"type": "string",
"field": "package_id",
"label": "包装id",
"value": null,
"describe": "包装id",
"is_required": true
},
{
"type": "string",
"field": "package_cost",
"label": "包装成本",
"value": null,
"describe": "包装成本",
"is_required": true
},
{
"type": "string",
"field": "has_invoice",
"label": "是否包含发票",
"value": null,
"describe": "是否包含发票",
"is_required": true
},
{
"type": "string",
"field": "printer_id",
"label": "打单员",
"value": null,
"describe": "打单员",
"is_required": true
},
{
"type": "string",
"field": "pick_error_count",
"label": "拣货出错次数",
"value": null,
"describe": "拣货出错次数",
"is_required": true
},
{
"type": "string",
"field": "picker_id",
"label": "拣货员id",
"value": null,
"describe": "拣货操作员ID",
"is_required": true
},
{
"type": "string",
"field": "sorter_id",
"label": "分拣员id",
"value": null,
"describe": "包裹分拣员id",
"is_required": true
},
{
"type": "string",
"field": "examiner_id",
"label": "验货员id",
"value": null,
"describe": "验货操作员id",
"is_required": true
},
{
"type": "string",
"field": "consigner_id",
"label": "发货人id",
"value": null,
"describe": "发货人id",
"is_required": true
},
{
"type": "string",
"field": "packager_id",
"label": "打包员id",
"value": null,
"describe": "打包id",
"is_required": true
},
{
"type": "string",
"field": "pack_score",
"label": "打包积分",
"value": null,
"describe": "打包积分",
"is_required": true
},
{
"type": "string",
"field": "pick_score",
"label": "拣货积分",
"value": null,
"describe": "拣货积分",
"is_required": true
},
{
"type": "string",
"field": "checkouter_id",
"label": "签出员工id",
"value": null,
"describe": "签出员工id",
"is_required": true
},
{
"type": "string",
"field": "watcher_id",
"label": "监视员id",
"value": null,
"describe": "监视员",
"is_required": true
},
{
"type": "string",
"field": "picklist_no",
"label": "分拣单编号",
"value": null,
"describe": "分拣单编号",
"is_required": true
},
{
"type": "string",
"field": "picklist_seq",
"label": "分拣序号",
"value": null,
"describe": "订单在分拣单中序号",
"is_required": true
},
{
"type": "string",
"field": "invoice_print_status",
"label": "发票打印状态",
"value": null,
"describe": "发票打印状态",
"is_required": true
},
{
"type": "string",
"field": "flag_id",
"label": "颜色",
"value": null,
"describe": "颜色",
"is_required": true
},
{
"type": "string",
"field": "logistics_template_id",
"label": "物流单模板id",
"value": null,
"describe": "物流单模板id",
"is_required": true
},
{
"type": "string",
"field": "sendbill_template_id",
"label": "发货单模板id",
"value": null,
"describe": "发货单模板id",
"is_required": true
},
{
"type": "string",
"field": "pos_allocate_mode",
"label": "货位分配方式",
"value": null,
"describe": "货位分配方式:0系统自动分配, 1手动指定货位分配 2手动指定有效期批次货位 3其它出库优化使用出库货位 4按批次出库",
"is_required": true
},
{
"type": "string",
"field": "note_count",
"label": "便签条数",
"value": null,
"describe": "便签条数",
"is_required": true
},
{
"type": "string",
"field": "reason_id",
"label": "其他出库原因",
"value": null,
"describe": "其他出库原因",
"is_required": true
},
{
"type": "string",
"field": "lock_id",
"label": "锁定策略id",
"value": null,
"describe": "锁定策略id",
"is_required": true
},
{
"type": "string",
"field": "reserve",
"label": "保留",
"value": null,
"describe": "保留",
"is_required": true
},
{
"type": "string",
"field": "src_tids",
"label": "原始单号",
"value": null,
"describe": "原始单号,平台订单号",
"is_required": true
},
{
"type": "string",
"field": "tax",
"label": "税额",
"value": null,
"describe": "税额",
"is_required": true
},
{
"type": "string",
"field": "currency",
"label": "币种",
"value": null,
"describe": "币种",
"is_required": true
},
{
"type": "string",
"field": "id_card",
"label": "证件号码",
"value": null,
"describe": "证件号码",
"is_required": true
},
{
"type": "string",
"field": "stock_check_time",
"label": "出库单审核时间",
"value": null,
"describe": "出库单审核时间 时间格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "string",
"field": "bad_reason",
"label": "异常状态",
"value": null,
"describe": "需要通过异或的方式判断,异常订单(bit位),1无库存记录 2地址发生变化 4发票变化 8仓库变化16备注变化32平台更换货品64退款…512抢单异常",
"is_required": true
},
{
"type": "string",
"field": "print_batch_no",
"label": "打印批次",
"value": null,
"describe": "ERP中的单据的打印批次信息,如需该字段,请升级至2.4.0.8版本及以上",
"is_required": true
},
{
"type": "string",
"field": "sendbill_print_status",
"label": "发货单打印状态",
"value": null,
"describe": "0未打印 1打印中 2已打印 3无需打印",
"is_required": true
},
{
"type": "string",
"field": "logistics_print_status",
"label": "物流单打印状态",
"value": null,
"describe": "0未打印 1打印中 2已打印 3无需打印",
"is_required": true
},
{
"type": "string",
"field": "picklist_print_status",
"label": "分拣单打印状态",
"value": null,
"describe": "0未打印 1打印中 2已打印 3无需打印",
"is_required": true
},
{
"type": "array",
"field": "details_list",
"label": "货品列表节点",
"children": [
{
"type": "string",
"field": "stockout_id",
"label": "出库单主键id",
"value": null,
"parent": "details_list",
"describe": "出库单主键id",
"is_required": true
},
{
"type": "string",
"field": "goods_count",
"label": "货品数量",
"value": null,
"parent": "details_list",
"describe": "货品数量",
"is_required": true
},
{
"type": "string",
"field": "weight",
"label": "估重",
"value": null,
"parent": "details_list",
"describe": "估重",
"is_required": true
},
{
"type": "string",
"field": "paid",
"label": "已支付金额",
"value": null,
"parent": "details_list",
"describe": "已支付金额",
"is_required": true
},
{
"type": "string",
"field": "refund_status",
"label": "退款状态",
"value": null,
"parent": "details_list",
"describe": "退款状态",
"is_required": true
},
{
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"parent": "details_list",
"describe": "备注",
"is_required": true
},
{
"type": "string",
"field": "src_order_type",
"label": "源单据类别",
"value": null,
"parent": "details_list",
"describe": "源单据类别 以主单为准",
"is_required": true
},
{
"type": "string",
"field": "discount",
"label": "总折扣金额",
"value": null,
"parent": "details_list",
"describe": "总折扣金额",
"is_required": true
},
{
"type": "string",
"field": "tax_rate",
"label": "税率",
"value": null,
"parent": "details_list",
"describe": "税率",
"is_required": true
},
{
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": null,
"parent": "details_list",
"describe": "代表单品(sku)所有属性的编码,SKU概念介绍,单击这里",
"is_required": true
},
{
"type": "string",
"field": "sell_price",
"label": "销售价",
"value": null,
"parent": "details_list",
"describe": "销售价,最终交易价格,扣除优惠",
"is_required": true
},
{
"type": "string",
"field": "brand_no",
"label": "品牌编号",
"value": null,
"parent": "details_list",
"describe": "品牌编号",
"is_required": true
},
{
"type": "string",
"field": "brand_name",
"label": "品牌名称",
"value": null,
"parent": "details_list",
"describe": "品牌名称",
"is_required": true
},
{
"type": "string",
"field": "goods_type",
"label": "货品类型",
"value": null,
"parent": "details_list",
"describe": "货品类型: 1销售商品 2原材料 3包装 4周转材料5虚拟商品6固定资产 0其它",
"is_required": true
},
{
"type": "string",
"field": "gift_type",
"label": "是否是赠品",
"value": null,
"parent": "details_list",
"describe": "是否是赠品 0非赠品 1自动赠送 2手工赠送",
"is_required": true
},
{
"type": "string",
"field": "goods_name",
"label": "货品名称",
"value": null,
"parent": "details_list",
"describe": "货品名称",
"is_required": true
},
{
"type": "string",
"field": "goods_no",
"label": "货品编号",
"value": null,
"parent": "details_list",
"describe": "代表货品(spu)所有属性的编号,SPU概念介绍,单击这里",
"is_required": true
},
{
"type": "string",
"field": "spec_name",
"label": "规格名称",
"value": null,
"parent": "details_list",
"describe": "规格名称",
"is_required": true
},
{
"type": "string",
"field": "spec_code",
"label": "规格码",
"value": null,
"parent": "details_list",
"describe": "规格码",
"is_required": true
},
{
"type": "string",
"field": "suite_no",
"label": "来源组合装编码",
"value": null,
"parent": "details_list",
"describe": "来源组合装编码",
"is_required": true
},
{
"type": "string",
"field": "total_amount",
"label": "总货款",
"value": null,
"parent": "details_list",
"describe": "总货款,sell_price * goods_count=total_amount",
"is_required": true
},
{
"type": "string",
"field": "goods_id",
"label": "货品id",
"value": null,
"parent": "details_list",
"describe": "货品id",
"is_required": true
},
{
"type": "string",
"field": "spec_id",
"label": "商品主键",
"value": null,
"parent": "details_list",
"describe": "商品主键",
"is_required": true
},
{
"type": "string",
"field": "market_price",
"label": "零售价",
"value": null,
"parent": "details_list",
"describe": "零售价",
"is_required": true
},
{
"type": "string",
"field": "share_amount",
"label": "分摊后合计应收",
"value": null,
"parent": "details_list",
"describe": "分摊后合计应收",
"is_required": true
},
{
"type": "string",
"field": "barcode",
"label": "条码",
"value": null,
"parent": "details_list",
"describe": "条码",
"is_required": true
},
{
"type": "string",
"field": "unit_name",
"label": "基本单位",
"value": null,
"parent": "details_list",
"describe": "基本单位",
"is_required": true
},
{
"type": "string",
"field": "sale_order_id",
"label": "订单详情表主键",
"value": null,
"parent": "details_list",
"describe": "订单详情表主键",
"is_required": true
},
{
"type": "string",
"field": "share_post",
"label": "邮费分摊",
"value": null,
"parent": "details_list",
"describe": "邮费分摊",
"is_required": true
},
{
"type": "string",
"field": "src_oid",
"label": "原始子订单号",
"value": null,
"parent": "details_list",
"describe": "原始子订单号",
"is_required": true
},
{
"type": "string",
"field": "src_tid",
"label": "原始订单号",
"value": null,
"parent": "details_list",
"describe": "原始订单号",
"is_required": true
},
{
"type": "string",
"field": "from_mask",
"label": "单据内部来源",
"value": null,
"parent": "details_list",
"describe": "1手机订单 2聚划算 4服务子订单 8家装 16二次付款 32开具电子发票 1024库存不足 2048当日达 4096次日达 8192预约时效",
"is_required": true
},
{
"type": "string",
"field": "src_order_detail_id",
"label": "sales_trade_order表的主键",
"value": null,
"parent": "details_list",
"describe": "sales_trade_order表的主键",
"is_required": true
},
{
"type": "string",
"field": "base_unit_id",
"label": "基本单位",
"value": null,
"parent": "details_list",
"describe": "基本单位",
"is_required": true
},
{
"type": "string",
"field": "unit_id",
"label": "辅助单位",
"value": null,
"parent": "details_list",
"describe": "辅助单位",
"is_required": true
},
{
"type": "string",
"field": "unit_ratio",
"label": "单位换算",
"value": null,
"parent": "details_list",
"describe": "单位换算",
"is_required": true
},
{
"type": "string",
"field": "num2",
"label": "辅助数量",
"value": null,
"parent": "details_list",
"describe": "辅助数量",
"is_required": true
},
{
"type": "string",
"field": "price",
"label": "最终价格",
"value": null,
"parent": "details_list",
"describe": "最终价格,share_price删掉,取代share_price",
"is_required": true
},
{
"type": "string",
"field": "is_examined",
"label": "是否验货",
"value": null,
"parent": "details_list",
"describe": "是否验货,用于挂起,已标记为验货的不需要再验货",
"is_required": true
},
{
"type": "string",
"field": "is_package",
"label": "是否包装",
"value": null,
"parent": "details_list",
"describe": "是否包装",
"is_required": true
},
{
"type": "string",
"field": "is_zero_cost",
"label": "是否允许0成本",
"value": null,
"parent": "details_list",
"describe": "是否允许0成本",
"is_required": true
},
{
"type": "string",
"field": "scan_type",
"label": "扫描方式",
"value": null,
"parent": "details_list",
"describe": "0未验货,1扫描验货,2手工验货,3快速验货,4无需验货",
"is_required": true
},
{
"type": "string",
"field": "good_prop1",
"label": "货品档案自定义属性1",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性1",
"is_required": true
},
{
"type": "string",
"field": "good_prop2",
"label": "货品档案自定义属性2",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性2",
"is_required": true
},
{
"type": "string",
"field": "good_prop3",
"label": "货品档案自定义属性3",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性3",
"is_required": true
},
{
"type": "string",
"field": "good_prop4",
"label": "货品档案自定义属性4",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性4",
"is_required": true
},
{
"type": "string",
"field": "good_prop5",
"label": "货品档案自定义属性5",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性5",
"is_required": true
},
{
"type": "string",
"field": "good_prop6",
"label": "货品档案自定义属性6",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性6",
"is_required": true
},
{
"type": "string",
"field": "prop1",
"label": "单品列表自定义属性1",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性1",
"is_required": true
},
{
"type": "string",
"field": "prop2",
"label": "单品列表自定义属性2",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性2",
"is_required": true
},
{
"type": "string",
"field": "prop3",
"label": "单品列表自定义属性3",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性3",
"is_required": true
},
{
"type": "string",
"field": "prop4",
"label": "单品列表自定义属性4",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性4",
"is_required": true
},
{
"type": "string",
"field": "prop5",
"label": "单品列表自定义属性5",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性5",
"is_required": true
},
{
"type": "string",
"field": "prop6",
"label": "单品列表自定义属性6",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性6",
"is_required": true
},
{
"type": "string",
"field": "batch_remark",
"label": "批次备注",
"value": null,
"parent": "details_list",
"describe": "批次备注",
"is_required": true
},
{
"type": "string",
"field": "expire_date",
"label": "有效期",
"value": null,
"parent": "details_list",
"describe": "有效期,时间格式:yyyy-MM-dd HH:mm:ss",
"is_required": true
},
{
"type": "array",
"field": "position_list",
"label": "货位节点列表",
"parent": "details_list",
"children": [
{
"type": "string",
"field": "modified",
"label": "最后更新时间",
"value": null,
"parent": "position_list",
"describe": "最后更新时间",
"is_required": true
},
{
"type": "string",
"field": "batch_no",
"label": "批次号",
"value": null,
"parent": "position_list",
"describe": "批次号",
"is_required": true
},
{
"type": "string",
"field": "rec_id",
"label": "货位主键id",
"value": null,
"parent": "position_list",
"describe": "货位主键id",
"is_required": true
},
{
"type": "string",
"field": "cost_price",
"label": "成本价",
"value": null,
"parent": "position_list",
"describe": "成本价",
"is_required": true
},
{
"type": "string",
"field": "num",
"label": "货品数量",
"value": null,
"parent": "position_list",
"describe": "货品数量",
"is_required": true
},
{
"type": "string",
"field": "batch_id",
"label": "批次id",
"value": null,
"parent": "position_list",
"describe": "批次id",
"is_required": true
},
{
"type": "string",
"field": "position_id",
"label": "货位ID",
"value": null,
"parent": "position_list",
"describe": "货位ID",
"is_required": true
},
{
"type": "string",
"field": "position_no",
"label": "货位编号",
"value": null,
"parent": "position_list",
"describe": "货位编号",
"is_required": true
},
{
"type": "string",
"field": "stockout_order_detail_id",
"label": "出库单明细id",
"value": null,
"parent": "position_list",
"describe": "出库单明细id",
"is_required": true
},
{
"type": "string",
"field": "stockin_detail_id",
"label": "入库单明细id",
"value": null,
"parent": "position_list",
"describe": "入库单明细id",
"is_required": true
},
{
"type": "string",
"field": "stock_spec_detail_id",
"label": "入库单号明细id",
"value": null,
"parent": "position_list",
"describe": "入库单号明细id",
"is_required": true
},
{
"type": "string",
"field": "position_goods_count",
"label": "货位出库数量",
"value": null,
"parent": "position_list",
"describe": "货位出库数量",
"is_required": true
}
],
"describe": "货位节点列表",
"is_required": true
}
],
"describe": "货品列表节点",
"is_required": true
}
],
"condition": [
[
{
"field": "shop_no",
"logic": "between",
"value": "3450,3499"
}
]
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "每页返回的数据条数,输入值范围1~100,不传本参数,输入值默认为40,使用举例单击这里",
"is_required": false
},
{
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}",
"describe": "不传值默认从0页开始",
"is_required": true
}
],
"otherResponse": []
}
目标平台元数据配置:
{
"id": null,
"api": "batchSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"type": "string",
"field": "FBillTypeID",
"label": "单据类型",
"value": "XSCKD07_SYS",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "单据类型",
"is_required": true
},
{
"type": "string",
"field": "FBillNo",
"label": "单据编号",
"value": "{{order_no}}test1",
"describe": "单据编号",
"is_required": true
},
{
"type": "string",
"field": "FDate",
"label": "日期",
"value": "{{consign_time}}",
"describe": "日期",
"is_required": true
},
{
"type": "string",
"field": "FStockOrgId",
"label": "发货组织",
"value": "_findCollection find email from 4cf40fbb-7205-39f0-98f2-b2d1cd4e15cf where shop_no={{shop_no}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FSaleOrgId",
"label": "销售组织",
"value": "_findCollection find email from 4cf40fbb-7205-39f0-98f2-b2d1cd4e15cf where shop_no={{shop_no}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": true
},
{
"type": "string",
"field": "FOwnerTypeIdHead",
"label": "货主类型",
"value": "BD_OwnerOrg"
},
{
"type": "string",
"field": "FOwnerIdHead",
"label": "货主",
"value": "_findCollection find email from 4cf40fbb-7205-39f0-98f2-b2d1cd4e15cf where shop_no={{shop_no}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FCustomerID",
"label": "客户",
"value": "{{shop_no}}",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FCarriageNO",
"label": "运输单号",
"value": "{{logistics_no}}",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FLinkPhone",
"label": "联系电话",
"value": "{{receiver_mobile}}",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FLinkMan",
"label": "收货人姓名",
"value": "{{receiver_name}}",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FNote",
"label": "备注",
"value": "{{cs_remark}}原始订单号:{{src_trade_no}}",
"describe": "多行文本",
"is_required": false
},
{
"type": "object",
"field": "SubHeadEntity",
"label": "财务信息",
"children": [
{
"type": "string",
"field": "FSettleOrgID",
"label": "结算组织",
"value": "_findCollection find email from 4cf40fbb-7205-39f0-98f2-b2d1cd4e15cf where shop_no={{shop_no}}",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "组织",
"is_required": false
},
{
"type": "string",
"field": "FSETTLECURRID",
"label": "结算币别",
"value": "PRE001",
"parent": "SubHeadEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "文本",
"is_required": false
}
],
"describe": null,
"is_required": false
},
{
"type": "array",
"field": "FEntity",
"label": "明细信息",
"value": "details_list",
"children": [
{
"type": "string",
"field": "FMaterialID",
"label": "物料编码",
"value": "_findCollection find FNumber from cdb4b806-7ece-3e84-b575-0d30a831abd4 where FOldNumber={{details_list.goods_no}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": true
},
{
"type": "string",
"field": "FRealQty",
"label": "实发数量",
"value": "{{details_list.goods_count}}",
"parent": "FEntity",
"describe": "数量",
"is_required": true
},
{
"type": "string",
"field": "FTaxPrice",
"label": "含税单价",
"value": "{{details_list.price}}",
"parent": "FEntity",
"describe": "单价",
"is_required": false
},
{
"type": "string",
"field": "FEntryTaxRate",
"label": "税率%",
"value": null,
"parent": "FEntity",
"describe": "小数",
"is_required": false
},
{
"type": "string",
"field": "FAllAmount",
"label": "价税合计",
"value": null,
"parent": "FEntity",
"describe": "金额",
"is_required": false
},
{
"type": "string",
"field": "FOwnerTypeId",
"label": "货主类型",
"value": "BD_OwnerOrg",
"parent": "FEntity"
},
{
"type": "string",
"field": "FOwnerId",
"label": "货主",
"value": "_findCollection find email from 4cf40fbb-7205-39f0-98f2-b2d1cd4e15cf where shop_no={{shop_no}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
}
},
{
"type": "string",
"field": "FStockID",
"label": "仓库",
"value": "{{warehouse_no}}",
"parent": "FEntity",
"parser": {
"name": "ConvertObjectParser",
"params": "FNumber"
},
"describe": "基础资料",
"is_required": false
},
{
"type": "string",
"field": "FIsFree",
"label": "是否赠品",
"value": "_function case '{{details_list.price}}' when '0.0000' then true else false end",
"parent": "FEntity"
},
{
"type": "string",
"field": "FEntrynote",
"label": "备注",
"value": "{{details_list.remark}}",
"parent": "FEntity",
"describe": "文本",
"is_required": false
},
{
"type": "string",
"field": "FSELLERNOTE",
"label": "卖家备注",
"value": "{{cs_remark}}",
"parent": "FEntity",
"describe": "文本",
"is_required": false
}
],
"describe": null,
"is_required": true
}
],
"response": [],
"operation": {
"rows": 10,
"method": "batchArraySave",
"rowsKey": "array"
},
"otherRequest": [
{
"type": "string",
"field": "FormId",
"label": "业务对象表单Id",
"value": "SAL_OUTSTOCK",
"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
},
{
"id": "InterationFlags",
"type": "string",
"field": "InterationFlags",
"label": "允许负库存",
"value": "STK_InvCheckResult",
"parent": null
}
],
"otherResponse": []
}