源系统平台:旺店通·企业奇门
源系统接口: 查询销售出库单wdt.stockout.order.query.trade
目标系统平台: 用友BIP
目标系统接口: 销售订单单个保存/yonbip/sd/voucherorder/singleSave
源平台元数据配置:
{
"id": "stockout_id",
"api": "wdt.stockout.order.query.trade",
"type": "QUERY",
"method": "POST",
"number": "order_no",
"idCheck": true,
"request": [
{
"id": "4623d86a-46bc-303d-8f30-30945add6e62",
"type": "datetime",
"field": "start_time",
"label": "开始时间",
"value": "{{LAST_SYNC_TIME|datetime}}",
"describe": "增量获取数据,start_time作为开始时间,格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "189afb22-1012-3a81-9c16-e5ac86c0382b",
"type": "datetime",
"field": "end_time",
"label": "结束时间",
"value": "{{CURRENT_TIME|datetime}}",
"describe": "增量获取数据,end_time作为结束时间,格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "45e80aa6-ce3d-3739-8bc7-cf567845065e",
"type": "string",
"field": "status",
"label": "状态",
"value": "95",
"describe": "5已取消,55已审核,95已发货,105 部分打款,110已完成,113:异常发货",
"parent_id": null,
"is_required": false
},
{
"id": "735d357a-e800-3d5d-a7ba-ff782af54a6e",
"type": "string",
"field": "src_order_no",
"label": "系统订单编号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "49aa3e89-55f1-3240-9535-0236386f8e40",
"type": "string",
"field": "src_tid",
"label": "原始单号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "11f7679a-bd34-3826-b118-d52bd8d44e17",
"type": "string",
"field": "stockout_no",
"label": "出库单号",
"value": null,
"describe": null,
"parent_id": null,
"is_required": false
},
{
"id": "6aa284b1-a8c6-30df-97c9-23f69cd31b35",
"type": "string",
"field": "shop_no",
"label": "店铺编号",
"value": null,
"describe": "代表店铺所有属性的唯一编码,用于店铺区分,ERP内支持自定义(ERP店铺界面设置),用于获取指定店铺单据数据信息",
"parent_id": null,
"is_required": false
},
{
"id": "cdaa77d7-a089-377a-b1fa-0c872793ce89",
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": "代表仓库所有属性的唯一编码,用于仓库区分,ERP内支持自定义(ERP仓库界面设置),用于获取指定仓库单据数据信息(不支持一次推送多个仓库编号)",
"parent_id": null,
"is_required": false
}
],
"response": [
{
"id": "231781d6-50a9-3973-b6ab-8e4e4ae59a91",
"type": "string",
"field": "stockout_id",
"label": "出库单主键id",
"value": null,
"describe": "出库单主键id",
"parent_id": null,
"is_required": true
},
{
"id": "2281d912-34be-3510-8b07-33441ade10d9",
"type": "string",
"field": "order_no",
"label": "出库单号",
"value": null,
"describe": "出库单号,唯一单号",
"parent_id": null,
"is_required": true
},
{
"id": "27fbbbb0-caa8-3959-9f17-3461dd87f75e",
"type": "string",
"field": "src_order_no",
"label": "源单号",
"value": null,
"describe": "源单号,旺店通系统单号(多默认为JY开头)",
"parent_id": null,
"is_required": true
},
{
"id": "07230f22-2b0e-3f42-a302-ff14d751b9cf",
"type": "string",
"field": "warehouse_no",
"label": "仓库编号",
"value": null,
"describe": "仓库编号",
"parent_id": null,
"is_required": true
},
{
"id": "276d4e0c-4f41-3d29-a3fe-ac4ff3c9f423",
"type": "string",
"field": "consign_time",
"label": "发货时间",
"value": null,
"describe": "销售出库单发货时间 时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "501a4894-aa8c-3c30-88cd-b8442867b64c",
"type": "string",
"field": "order_type",
"label": "出库单类型",
"value": null,
"describe": "出库单类型",
"parent_id": null,
"is_required": true
},
{
"id": "0de6462d-232a-3738-9533-bbae9824dd4e",
"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异常发货",
"parent_id": null,
"is_required": true
},
{
"id": "81f67f22-b361-3432-bdf0-13fbc4a84625",
"type": "string",
"field": "order_type_name",
"label": "出库单类型名称",
"value": null,
"describe": "固定名称“销售出库”",
"parent_id": null,
"is_required": true
},
{
"id": "4d1684a2-7a16-3211-9eb4-afce7e3a75c6",
"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",
"parent_id": null,
"is_required": true
},
{
"id": "bf5eeec6-d90b-3c74-869a-b1e316a290b2",
"type": "string",
"field": "subtype",
"label": "出库子类型",
"value": null,
"describe": "出库子类型",
"parent_id": null,
"is_required": true
},
{
"id": "970ec1b4-82c2-3413-b695-a56f5c314d34",
"type": "string",
"field": "goods_count",
"label": "数量",
"value": null,
"describe": "货品数量",
"parent_id": null,
"is_required": true
},
{
"id": "137b27af-79c4-35bd-9c7e-92b176118631",
"type": "string",
"field": "goods_total_amount",
"label": "货品总售价",
"value": null,
"describe": "货品总售价",
"parent_id": null,
"is_required": true
},
{
"id": "64c4d013-52ba-3f6f-aa39-ea2cfe78d26c",
"type": "string",
"field": "goods_total_cost",
"label": "货品总成本",
"value": null,
"describe": "货品总成本",
"parent_id": null,
"is_required": true
},
{
"id": "3f47c7b6-bc2a-3009-86ef-4b05960e864c",
"type": "string",
"field": "post_fee",
"label": "邮资成本",
"value": null,
"describe": "邮资成本",
"parent_id": null,
"is_required": true
},
{
"id": "a493c182-eee0-3a5e-9f1a-8db4bc4cbd78",
"type": "string",
"field": "logistics_no",
"label": "物流单号",
"value": null,
"describe": "物流单号",
"parent_id": null,
"is_required": true
},
{
"id": "3c7a65d9-ebf3-35aa-a508-648914f704e8",
"type": "string",
"field": "package_fee",
"label": "包装费",
"value": null,
"describe": "包装费",
"parent_id": null,
"is_required": true
},
{
"id": "3884c953-ef57-3da9-8129-c35a7ef845c3",
"type": "string",
"field": "receiver_name",
"label": "收件人",
"value": null,
"describe": "收件人",
"parent_id": null,
"is_required": true
},
{
"id": "34c32df3-d845-32bf-945a-e2b173e2a90e",
"type": "string",
"field": "receiver_country",
"label": "国家",
"value": null,
"describe": "国家",
"parent_id": null,
"is_required": true
},
{
"id": "3ad51d2b-c127-36d4-b357-533e512533b6",
"type": "string",
"field": "receiver_province",
"label": "省份",
"value": null,
"describe": "省份",
"parent_id": null,
"is_required": true
},
{
"id": "6dbcec6d-8cd2-3602-b2aa-79e4060fc389",
"type": "string",
"field": "receiver_city",
"label": "城市",
"value": null,
"describe": "城市",
"parent_id": null,
"is_required": true
},
{
"id": "250fa5d0-0896-38b8-ad54-97d488c4b2b9",
"type": "string",
"field": "receiver_district",
"label": "地区",
"value": null,
"describe": "地区",
"parent_id": null,
"is_required": true
},
{
"id": "40e83f97-0088-3e27-b3a3-b801c5b7496e",
"type": "string",
"field": "receiver_address",
"label": "详细地址",
"value": null,
"describe": "详细地址",
"parent_id": null,
"is_required": true
},
{
"id": "878aafe3-c9fc-30b5-be9b-4bdf7b9266ce",
"type": "string",
"field": "receiver_mobile",
"label": "收件人移动电话",
"value": null,
"describe": "收件人移动电话",
"parent_id": null,
"is_required": true
},
{
"id": "3a45d636-5504-3cfe-a8f6-0d6626eb7322",
"type": "string",
"field": "receiver_telno",
"label": "收件人固定电话",
"value": null,
"describe": "收件人固定电话",
"parent_id": null,
"is_required": true
},
{
"id": "9090fc5f-42e4-378d-a48f-8af182ef4361",
"type": "string",
"field": "receiver_zip",
"label": "邮编",
"value": null,
"describe": "邮编",
"parent_id": null,
"is_required": true
},
{
"id": "97d0592c-cc1d-3fa1-b68c-dda02d0ab809",
"type": "string",
"field": "receiver_dtb",
"label": "大头笔",
"value": null,
"describe": "大头笔",
"parent_id": null,
"is_required": true
},
{
"id": "31b15d79-c32c-3f56-832d-df9b02d6f07a",
"type": "string",
"field": "weight",
"label": "实际重量",
"value": null,
"describe": "ERP系统称重功能记录的重量,如果没有使用称重功能默认使用货品档案维护的预估重量",
"parent_id": null,
"is_required": true
},
{
"id": "9712a2b5-0b72-3ff4-a118-5719eda38dfe",
"type": "string",
"field": "logistics_type",
"label": "物流公司类型",
"value": null,
"describe": "响应值为ERP定义的ID数值,数值对应的物流公司类型名称单击这里",
"parent_id": null,
"is_required": true
},
{
"id": "53a7f118-b937-31aa-85a2-b0b793928527",
"type": "string",
"field": "logistics_code",
"label": "物流公司编号",
"value": null,
"describe": "代表物流所有属性的唯一编码,用于物流区分,ERP内支持自定义(ERP物流界面设置)",
"parent_id": null,
"is_required": true
},
{
"id": "0d224ce4-3fcd-3a25-b745-1ebd9d30ae45",
"type": "string",
"field": "logistics_name",
"label": "物流公司名称",
"value": null,
"describe": "物流公司名称",
"parent_id": null,
"is_required": true
},
{
"id": "5ebc8fd7-bdc5-3533-bf5b-1b191a27f46d",
"type": "string",
"field": "print_remark",
"label": "打印备注",
"value": null,
"describe": "打印备注",
"parent_id": null,
"is_required": true
},
{
"id": "a33aa851-ed0a-3d3c-ac38-b426fddbb45b",
"type": "string",
"field": "paid",
"label": "已付金额",
"value": null,
"describe": "已付金额",
"parent_id": null,
"is_required": true
},
{
"id": "12b2b0f6-704e-39c8-8dbf-86ec1f281942",
"type": "string",
"field": "refund_status",
"label": "退款状态",
"value": null,
"describe": "退款状态: 0无退款,1取消退款,2已申请退款,3等待退货,4等待收货,5退款成功",
"parent_id": null,
"is_required": true
},
{
"id": "585a8a70-e222-3339-88b3-b2ff39d8f8bd",
"type": "string",
"field": "salesman_no",
"label": "业务员编号",
"value": null,
"describe": "业务员编号",
"parent_id": null,
"is_required": true
},
{
"id": "4bf979b4-fb20-38e6-8650-d063353fafc0",
"type": "string",
"field": "salesman_name",
"label": "业务员名称",
"value": null,
"describe": "业务员名称",
"parent_id": null,
"is_required": true
},
{
"id": "0b67ff22-90f8-37fd-a5d4-aa79682fd02e",
"type": "string",
"field": "fullname",
"label": "业务员名称",
"value": null,
"describe": "业务员名称",
"parent_id": null,
"is_required": true
},
{
"id": "a398210e-b72d-3470-94ef-5cb8e96a1536",
"type": "string",
"field": "warehouse_name",
"label": "仓库",
"value": null,
"describe": "仓库",
"parent_id": null,
"is_required": true
},
{
"id": "95e59788-1ea3-3bec-b332-58065655f888",
"type": "string",
"field": "created",
"label": "创建时间",
"value": null,
"describe": "创建时间 时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "3e44e4e4-21a2-31dc-a986-3c37a538960c",
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"describe": "备注",
"parent_id": null,
"is_required": true
},
{
"id": "2e2c10bd-84a0-394c-abd2-0807f7f1e3fe",
"type": "string",
"field": "stockout_reason",
"label": "出库原因",
"value": null,
"describe": "出库原因",
"parent_id": null,
"is_required": true
},
{
"id": "48ac210d-4446-32a1-a920-57a05b68d1a6",
"type": "string",
"field": "outer_no",
"label": "外部单号",
"value": null,
"describe": "外部单号",
"parent_id": null,
"is_required": true
},
{
"id": "bd8d22cd-0a24-3a16-b84c-9fb2335cf517",
"type": "string",
"field": "trade_no",
"label": "订单编号",
"value": null,
"describe": "系统订单编号,默认单号为JY开头,ERP内支持自定义(设置路径:设置——编码设置)",
"parent_id": null,
"is_required": true
},
{
"id": "a46761ec-f0ca-372c-a561-0a00c7ee7247",
"type": "string",
"field": "src_trade_no",
"label": "原始单号",
"value": null,
"describe": "商城或电商平台的订单编号,合并订单的多个订单编号有逗号隔开",
"parent_id": null,
"is_required": true
},
{
"id": "660c7f98-9d62-3a8f-b97b-2f9d74488e94",
"type": "string",
"field": "nick_name",
"label": "网名",
"value": null,
"describe": "网名",
"parent_id": null,
"is_required": true
},
{
"id": "ba869a56-07ee-3233-86e2-7ebe9d7359f4",
"type": "string",
"field": "customer_name",
"label": "客户名称",
"value": null,
"describe": "客户名称(客户真实姓名,取自receiver_name)",
"parent_id": null,
"is_required": true
},
{
"id": "1554a4b8-471c-30b8-8cef-d06c05754412",
"type": "string",
"field": "customer_no",
"label": "客户编号",
"value": null,
"describe": "客户编号",
"parent_id": null,
"is_required": true
},
{
"id": "7b20ef68-4033-3267-9798-bb81900653ce",
"type": "string",
"field": "trade_time",
"label": "交易时间",
"value": null,
"describe": "交易时间 时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "91d8bcc0-dc19-32a9-b249-50874ceb6d5d",
"type": "string",
"field": "pay_time",
"label": "付款时间",
"value": null,
"describe": "付款时间 时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "29eb7ab8-756f-3619-ba39-907e6a02cea7",
"type": "string",
"field": "status",
"label": "出库单状态",
"value": null,
"describe": "出库单状态 5 已取消 48未确认 50待审核 52待推送 53同步失败 55已审核 95 已发货 105部分打款 110已完成 113 异常发货 115回传失败 120回传成功",
"parent_id": null,
"is_required": true
},
{
"id": "3079041c-2f87-3820-8dc7-88b00276def4",
"type": "string",
"field": "shop_name",
"label": "店铺名称",
"value": null,
"describe": "店铺名称",
"parent_id": null,
"is_required": true
},
{
"id": "071391e2-e30b-3d4f-82b3-8243897d752e",
"type": "string",
"field": "shop_no",
"label": "店铺编号",
"value": null,
"describe": "代表店铺所有属性的唯一编码,用于店铺区分,ERP内支持自定义(ERP店铺界面设置)",
"parent_id": null,
"is_required": true
},
{
"id": "56907d15-adb4-3476-9d7e-8557f0d1f56c",
"type": "string",
"field": "buyer_message",
"label": "买家留言",
"value": null,
"describe": "买家留言",
"parent_id": null,
"is_required": true
},
{
"id": "88281ee1-ac75-39a3-9048-2e25c2e08a9c",
"type": "string",
"field": "cs_remark",
"label": "客服备注",
"value": null,
"describe": "客服备注",
"parent_id": null,
"is_required": true
},
{
"id": "105d3026-d3e5-3b5f-8886-5b572b65e7b1",
"type": "string",
"field": "flag_name",
"label": "订单标记",
"value": null,
"describe": "订单标记",
"parent_id": null,
"is_required": true
},
{
"id": "f949fc3b-808f-3b8b-b824-5b6c4f86f0cf",
"type": "string",
"field": "post_amount",
"label": "邮费",
"value": null,
"describe": "从平台获取的销售订单的邮费",
"parent_id": null,
"is_required": true
},
{
"id": "0938c9fd-2761-3e76-8ee2-8b533d0c1394",
"type": "string",
"field": "block_reason",
"label": "截停原因",
"value": null,
"describe": "截停原因:1申请退款2已退款4地址被修改8发票被修改16物流被修改32仓库变化64备注修改128更换货品256添加货品512放弃抢单1024其他 2048 拦截赠品 4096 拦截天猫换货 8192 买家留言变更 16384 该换货订单存在退货/退款",
"parent_id": null,
"is_required": true
},
{
"id": "37f03d9d-dfaa-3a63-8551-2b61b02c75c3",
"type": "string",
"field": "invoice_type",
"label": "发票类别",
"value": null,
"describe": "发票类别0 不需要,1普通发票,2普通增值税发票,3专用增值税发票",
"parent_id": null,
"is_required": true
},
{
"id": "15b460d6-1b4c-36e6-ace0-91afa2c996a8",
"type": "string",
"field": "invoice_title",
"label": "发票抬头",
"value": null,
"describe": "发票抬头",
"parent_id": null,
"is_required": true
},
{
"id": "b19cb71b-1c2f-33e9-904a-ef1987a5a7ec",
"type": "string",
"field": "invoice_content",
"label": "发票内容",
"value": null,
"describe": "发票内容",
"parent_id": null,
"is_required": true
},
{
"id": "4630abfc-92d4-36ea-953d-392fe780dcb3",
"type": "string",
"field": "invoice_id",
"label": "发票ID",
"value": null,
"describe": "发票ID,目前只设0-1,1表示已开发票",
"parent_id": null,
"is_required": true
},
{
"id": "1d45e9f0-14a5-3837-88ac-cdaf98756719",
"type": "string",
"field": "delivery_term",
"label": "发货条件",
"value": null,
"describe": "发货条件 1款到发货 2货到付款(包含部分货到付款) 3分期付款 4挂账单",
"parent_id": null,
"is_required": true
},
{
"id": "51015270-2c32-373e-b234-a3697bada54d",
"type": "string",
"field": "fenxiao_type",
"label": "分销类别",
"value": null,
"describe": "0 非分销订单 1 转供销 2 代销 3经销",
"parent_id": null,
"is_required": true
},
{
"id": "cc6b7fe1-d505-3886-a757-5fea598dfa9b",
"type": "string",
"field": "fenxiao_nick",
"label": "分销商ID",
"value": null,
"describe": "分销订单的分销商id,或转供销时供应商id",
"parent_id": null,
"is_required": true
},
{
"id": "73496e46-13f1-3c64-8432-6b08df6a3f70",
"type": "string",
"field": "cod_amount",
"label": "货到付款金额",
"value": null,
"describe": "货到付款金额",
"parent_id": null,
"is_required": true
},
{
"id": "634312eb-0cbc-349a-bec3-c8ed8c9d6a9c",
"type": "string",
"field": "id_card_type",
"label": "证件类别",
"value": null,
"describe": "1 身份证",
"parent_id": null,
"is_required": true
},
{
"id": "7393e257-5a40-36f0-80ec-36b6b38ee241",
"type": "string",
"field": "receiver_area",
"label": "收件人地址",
"value": null,
"describe": "省市区空格分隔",
"parent_id": null,
"is_required": true
},
{
"id": "09df483d-2770-3cde-9544-5233749e0da3",
"type": "string",
"field": "shop_remark",
"label": "店铺备注",
"value": null,
"describe": "店铺备注",
"parent_id": null,
"is_required": true
},
{
"id": "131ad094-0fb8-397b-9f31-9d132739e6eb",
"type": "string",
"field": "modified",
"label": "最后修改时间",
"value": null,
"describe": "最后修改时间 时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "d84c88ef-1a21-3e1a-ab22-976169018114",
"type": "string",
"field": "platform_id",
"label": "平台id",
"value": null,
"describe": "平台id",
"parent_id": null,
"is_required": true
},
{
"id": "38680676-8946-3725-8712-99ff2e328254",
"type": "string",
"field": "trade_id",
"label": "订单表主键",
"value": null,
"describe": "订单表主键",
"parent_id": null,
"is_required": true
},
{
"id": "2c0f91e1-c713-322f-8c73-cb22b20b17a7",
"type": "string",
"field": "checker_name",
"label": "审单员编号",
"value": null,
"describe": "审单员编号",
"parent_id": null,
"is_required": true
},
{
"id": "0d5999b1-47ae-3897-b92e-30e5b08710f3",
"type": "string",
"field": "employee_no",
"label": "审单员编号",
"value": null,
"describe": "审单员编号",
"parent_id": null,
"is_required": true
},
{
"id": "a043d1b6-6549-34f0-91de-df39071ff3df",
"type": "string",
"field": "operator_name",
"label": "审核员",
"value": null,
"describe": "审核员",
"parent_id": null,
"is_required": true
},
{
"id": "88b0eff8-e763-3599-a2ba-dfdf28dbb1ca",
"type": "string",
"field": "packager_no",
"label": "打包员编号",
"value": null,
"describe": "打包员编号",
"parent_id": null,
"is_required": true
},
{
"id": "37c8ef07-6d62-3b10-8ccd-77c61e8fdb40",
"type": "string",
"field": "packager_name",
"label": "打包员",
"value": null,
"describe": "打包员",
"parent_id": null,
"is_required": true
},
{
"id": "525b41e3-e6dc-361e-b39e-371cd65ea2fb",
"type": "string",
"field": "picker_no",
"label": "拣货员编号",
"value": null,
"describe": "拣货员编号",
"parent_id": null,
"is_required": true
},
{
"id": "5f584921-fb73-3fbb-a50c-5ce4600ca632",
"type": "string",
"field": "picker_name",
"label": "拣货员",
"value": null,
"describe": "拣货员",
"parent_id": null,
"is_required": true
},
{
"id": "121a7bea-93b7-31dd-b5cf-e1595ddaa6b4",
"type": "string",
"field": "printer_no",
"label": "打单员编号",
"value": null,
"describe": "打单员编号",
"parent_id": null,
"is_required": true
},
{
"id": "4c384817-94af-34c8-915a-a83646efc4a9",
"type": "string",
"field": "printer_name",
"label": "打单员",
"value": null,
"describe": "打单员",
"parent_id": null,
"is_required": true
},
{
"id": "5c8324cd-28e2-3e73-b66d-f1cf0413e896",
"type": "string",
"field": "examiner_no",
"label": "验货员编号",
"value": null,
"describe": "验货员编号",
"parent_id": null,
"is_required": true
},
{
"id": "85064039-4e70-3b41-bd9a-4eea054bf87f",
"type": "string",
"field": "examiner_name",
"label": "验货员",
"value": null,
"describe": "验货员",
"parent_id": null,
"is_required": true
},
{
"id": "d000bd67-156f-331e-8777-8d99cad00682",
"type": "string",
"field": "stockout_no",
"label": "出库单号",
"value": null,
"describe": "出库单号",
"parent_id": null,
"is_required": true
},
{
"id": "4b9267fd-6967-32dc-9bdb-d946f6e30ea6",
"type": "string",
"field": "src_order_type",
"label": "源单据类别",
"value": null,
"describe": "源单据类别,1 销售订单",
"parent_id": null,
"is_required": true
},
{
"id": "28bb183f-f860-3f84-ac53-aaaf9348a9c1",
"type": "string",
"field": "wms_status",
"label": "处理状态",
"value": null,
"describe": "处理状态 0 待处理 1 推送失败 2 推送成功 3 接口取消成功系统驳回失败 4 服务器正在处理 5 WMS返回发货信息 6 异步标记,推送申请成功'",
"parent_id": null,
"is_required": true
},
{
"id": "118c9512-caba-3205-a738-bd0a2445c36f",
"type": "string",
"field": "error_info",
"label": "接口处理错误信息",
"value": null,
"describe": "接口处理错误信息",
"parent_id": null,
"is_required": true
},
{
"id": "4f0d6e40-881e-36d8-a40c-846466978fd3",
"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其他",
"parent_id": null,
"is_required": true
},
{
"id": "f0d70228-6776-344a-8488-b378463d039b",
"type": "string",
"field": "warehouse_id",
"label": "出库仓库id",
"value": null,
"describe": "出库的仓库id",
"parent_id": null,
"is_required": true
},
{
"id": "161e67b2-ee25-3448-b360-e8177801a52d",
"type": "string",
"field": "customer_id",
"label": "客户id",
"value": null,
"describe": "客户id",
"parent_id": null,
"is_required": true
},
{
"id": "08d5d771-5c36-373d-9b91-0372b8eb72ea",
"type": "string",
"field": "freeze_reason",
"label": "冻结原因",
"value": null,
"describe": "冻结原因",
"parent_id": null,
"is_required": true
},
{
"id": "0f65f351-d9ff-3955-bbe8-3631fc98b8c9",
"type": "string",
"field": "is_allocated",
"label": "是否分配",
"value": null,
"describe": "是否分配stockout_order_detail_position",
"parent_id": null,
"is_required": true
},
{
"id": "2bcd66ce-ac93-31a6-8f45-a7581bb1be31",
"type": "string",
"field": "consign_status",
"label": "出库状态",
"value": null,
"describe": "出库状态 1验货 2称重 4出库 8物流同步 16分拣 32档口, 64拣货 1073741824原始单已完成",
"parent_id": null,
"is_required": true
},
{
"id": "a7f64dbe-7088-3aeb-8ba5-e2afb6c86fa7",
"type": "string",
"field": "ebill_status",
"label": "电子面单状态",
"value": null,
"describe": "电子面单,获取状态(0 还未获取单号或获取单号和打印信息完毕;1 手动获取物流单号中;100-105 获取打印数据中)",
"parent_id": null,
"is_required": true
},
{
"id": "6a790399-1a3d-3098-9030-b880030298ea",
"type": "string",
"field": "operator_id",
"label": "制单人",
"value": null,
"describe": "制单人",
"parent_id": null,
"is_required": true
},
{
"id": "14caddf6-e87f-354a-a9b5-42f410bfc5bb",
"type": "string",
"field": "goods_type_count",
"label": "货品种类数量",
"value": null,
"describe": "货品种类数量",
"parent_id": null,
"is_required": true
},
{
"id": "8fd7190a-5088-3b9f-b5e2-28ab22cf8dee",
"type": "string",
"field": "md5_str",
"label": "MD5字符串值",
"value": null,
"describe": "MD5字符串值,用于单据排序",
"parent_id": null,
"is_required": true
},
{
"id": "a144cfda-81ea-3a67-b893-31f89e44a769",
"type": "string",
"field": "custom_type",
"label": "其他出库自定义子类别",
"value": null,
"describe": "其他出库自定义子类别0,1,2,3,4",
"parent_id": null,
"is_required": true
},
{
"id": "9bd387e3-0c69-372e-9ede-f6d888c6f2c2",
"type": "string",
"field": "receiver_ring",
"label": "京东三环内",
"value": null,
"describe": "京东三环内",
"parent_id": null,
"is_required": true
},
{
"id": "612341c5-1ad5-30af-a2e8-c2f56b0e9ab0",
"type": "string",
"field": "to_deliver_time",
"label": "配送时间",
"value": null,
"describe": "配送时间,如周末",
"parent_id": null,
"is_required": true
},
{
"id": "25dd2391-f77e-352c-8cb2-c88c197e8a14",
"type": "string",
"field": "pre_charge_time",
"label": "配送中心",
"value": null,
"describe": "配送中心",
"parent_id": null,
"is_required": true
},
{
"id": "7c5d3614-3de2-3f94-a35c-f755bd878ced",
"type": "string",
"field": "logistics_id",
"label": "物流公司ID",
"value": null,
"describe": "物流公司ID",
"parent_id": null,
"is_required": true
},
{
"id": "11ca938d-aa0b-3d1a-bc3d-7ff84240f442",
"type": "string",
"field": "unknown_goods_amount",
"label": "未知成本销售总额",
"value": null,
"describe": "未知成本销售总额",
"parent_id": null,
"is_required": true
},
{
"id": "33e216da-5447-3892-9b81-a4c9b4d7e079",
"type": "string",
"field": "calc_post_cost",
"label": "预估邮费成本",
"value": null,
"describe": "预估邮费成本",
"parent_id": null,
"is_required": true
},
{
"id": "98700a1d-4100-3c53-b6db-5ee1f3bdeef3",
"type": "string",
"field": "post_cost",
"label": "邮费成本",
"value": null,
"describe": "邮费成本",
"parent_id": null,
"is_required": true
},
{
"id": "423ef680-9e3a-3f7f-a2ea-2682cf17cb2a",
"type": "string",
"field": "calc_weight",
"label": "预估重量",
"value": null,
"describe": "预估重量",
"parent_id": null,
"is_required": true
},
{
"id": "4ec62712-b987-3355-924d-f3ff546f630d",
"type": "string",
"field": "post_weight",
"label": "快递重量",
"value": null,
"describe": "快递给的重量",
"parent_id": null,
"is_required": true
},
{
"id": "7999e559-e51b-3188-8e76-01529304d2bb",
"type": "string",
"field": "package_id",
"label": "包装id",
"value": null,
"describe": "包装id",
"parent_id": null,
"is_required": true
},
{
"id": "58343b44-ff26-383a-aeb0-2b9b52ba88fa",
"type": "string",
"field": "package_cost",
"label": "包装成本",
"value": null,
"describe": "包装成本",
"parent_id": null,
"is_required": true
},
{
"id": "8781ce77-a450-3d89-8309-8a174137171c",
"type": "string",
"field": "has_invoice",
"label": "是否包含发票",
"value": null,
"describe": "是否包含发票",
"parent_id": null,
"is_required": true
},
{
"id": "1170211e-3571-3eaf-9491-92ecddeb928e",
"type": "string",
"field": "printer_id",
"label": "打单员",
"value": null,
"describe": "打单员",
"parent_id": null,
"is_required": true
},
{
"id": "bdc4f314-c1a8-3bc2-be16-737d039cf3a5",
"type": "string",
"field": "pick_error_count",
"label": "拣货出错次数",
"value": null,
"describe": "拣货出错次数",
"parent_id": null,
"is_required": true
},
{
"id": "ba1203cf-5e44-3e94-9986-799c1458d90a",
"type": "string",
"field": "picker_id",
"label": "拣货员id",
"value": null,
"describe": "拣货操作员ID",
"parent_id": null,
"is_required": true
},
{
"id": "c9b0b3ad-302d-3d2b-a31a-ae8c49d65afa",
"type": "string",
"field": "sorter_id",
"label": "分拣员id",
"value": null,
"describe": "包裹分拣员id",
"parent_id": null,
"is_required": true
},
{
"id": "846c46bb-66ab-3adb-9bcc-32459a672e9f",
"type": "string",
"field": "examiner_id",
"label": "验货员id",
"value": null,
"describe": "验货操作员id",
"parent_id": null,
"is_required": true
},
{
"id": "1307d5e1-c889-38b6-91b7-29c0fb9ad970",
"type": "string",
"field": "consigner_id",
"label": "发货人id",
"value": null,
"describe": "发货人id",
"parent_id": null,
"is_required": true
},
{
"id": "5b1c5582-497e-3e90-8506-51dd4d3c3597",
"type": "string",
"field": "packager_id",
"label": "打包员id",
"value": null,
"describe": "打包id",
"parent_id": null,
"is_required": true
},
{
"id": "255e9f18-bd7d-3ba8-b822-cccba66a0bf5",
"type": "string",
"field": "pack_score",
"label": "打包积分",
"value": null,
"describe": "打包积分",
"parent_id": null,
"is_required": true
},
{
"id": "a20951ab-d487-312c-a813-ad99caa6ee1a",
"type": "string",
"field": "pick_score",
"label": "拣货积分",
"value": null,
"describe": "拣货积分",
"parent_id": null,
"is_required": true
},
{
"id": "2ad73f73-0948-32a8-a524-d9cbed7bc7c4",
"type": "string",
"field": "checkouter_id",
"label": "签出员工id",
"value": null,
"describe": "签出员工id",
"parent_id": null,
"is_required": true
},
{
"id": "c0594f74-5e5a-37a1-a003-34940b7624a0",
"type": "string",
"field": "watcher_id",
"label": "监视员id",
"value": null,
"describe": "监视员",
"parent_id": null,
"is_required": true
},
{
"id": "630f7e9e-822f-3591-bdc8-029d3a9fbc56",
"type": "string",
"field": "picklist_no",
"label": "分拣单编号",
"value": null,
"describe": "分拣单编号",
"parent_id": null,
"is_required": true
},
{
"id": "1c549f65-d499-3ca9-b014-c30b02e73f6d",
"type": "string",
"field": "picklist_seq",
"label": "分拣序号",
"value": null,
"describe": "订单在分拣单中序号",
"parent_id": null,
"is_required": true
},
{
"id": "4cdd82b3-8869-3c76-8e39-bc483c5f5af4",
"type": "string",
"field": "invoice_print_status",
"label": "发票打印状态",
"value": null,
"describe": "发票打印状态",
"parent_id": null,
"is_required": true
},
{
"id": "47807e70-bf39-3e75-b49a-c955d0112e06",
"type": "string",
"field": "flag_id",
"label": "颜色",
"value": null,
"describe": "颜色",
"parent_id": null,
"is_required": true
},
{
"id": "60db7a0f-8f55-327c-9119-0a7ea417d15b",
"type": "string",
"field": "logistics_template_id",
"label": "物流单模板id",
"value": null,
"describe": "物流单模板id",
"parent_id": null,
"is_required": true
},
{
"id": "4730fd17-54eb-3d71-bb44-6a6e3fca5618",
"type": "string",
"field": "sendbill_template_id",
"label": "发货单模板id",
"value": null,
"describe": "发货单模板id",
"parent_id": null,
"is_required": true
},
{
"id": "0f23f666-923f-3820-b6b2-4fc4861b9a92",
"type": "string",
"field": "pos_allocate_mode",
"label": "货位分配方式",
"value": null,
"describe": "货位分配方式:0系统自动分配, 1手动指定货位分配 2手动指定有效期批次货位 3其它出库优化使用出库货位 4按批次出库",
"parent_id": null,
"is_required": true
},
{
"id": "19ee37be-0e59-3101-b1c4-0329e68d547e",
"type": "string",
"field": "note_count",
"label": "便签条数",
"value": null,
"describe": "便签条数",
"parent_id": null,
"is_required": true
},
{
"id": "1a15e66e-6ee1-383c-be8f-7170ec8f4b43",
"type": "string",
"field": "reason_id",
"label": "其他出库原因",
"value": null,
"describe": "其他出库原因",
"parent_id": null,
"is_required": true
},
{
"id": "9ae671ce-6997-31d1-b7ac-147288a68e6f",
"type": "string",
"field": "lock_id",
"label": "锁定策略id",
"value": null,
"describe": "锁定策略id",
"parent_id": null,
"is_required": true
},
{
"id": "734eb71b-cea6-3232-afd3-0e77fa4419d6",
"type": "string",
"field": "reserve",
"label": "保留",
"value": null,
"describe": "保留",
"parent_id": null,
"is_required": true
},
{
"id": "511a782f-2e18-3478-b4ff-345cc780378b",
"type": "string",
"field": "batch_no",
"label": "打印批次",
"value": null,
"describe": "打印批次",
"parent_id": null,
"is_required": true
},
{
"id": "430a9e0b-2f29-365d-87e4-602a83e45b1d",
"type": "string",
"field": "discount",
"label": "优惠金额",
"value": null,
"describe": "优惠金额",
"parent_id": null,
"is_required": true
},
{
"id": "db77ab84-1ec7-303f-b467-81bd71b1a86a",
"type": "string",
"field": "src_tids",
"label": "原始单号",
"value": null,
"describe": "原始单号,平台订单号",
"parent_id": null,
"is_required": true
},
{
"id": "855ee2c0-e2f4-39a4-bca0-22537461d295",
"type": "string",
"field": "tax",
"label": "税额",
"value": null,
"describe": "税额",
"parent_id": null,
"is_required": true
},
{
"id": "52673b2c-86b5-301b-a019-b14389c5a26d",
"type": "string",
"field": "tax_rate",
"label": "税率",
"value": null,
"describe": "税率",
"parent_id": null,
"is_required": true
},
{
"id": "5eecf75a-cb9c-373a-9531-c0f32f71a160",
"type": "string",
"field": "currency",
"label": "币种",
"value": null,
"describe": "币种",
"parent_id": null,
"is_required": true
},
{
"id": "bc943e5c-b3cc-3e38-aed0-93c4847fe12c",
"type": "string",
"field": "id_card",
"label": "证件号码",
"value": null,
"describe": "证件号码",
"parent_id": null,
"is_required": true
},
{
"id": "0dcbfc80-2cee-3326-8407-d1fe6cc8ee2f",
"type": "string",
"field": "stock_check_time",
"label": "出库单审核时间",
"value": null,
"describe": "出库单审核时间 时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": null,
"is_required": true
},
{
"id": "13ef39d0-f0ea-3579-a353-f464de6072d8",
"type": "string",
"field": "bad_reason",
"label": "异常状态",
"value": null,
"describe": "需要通过异或的方式判断,异常订单(bit位),1无库存记录 2地址发生变化 4发票变化 8仓库变化16备注变化32平台更换货品64退款…512抢单异常",
"parent_id": null,
"is_required": true
},
{
"id": "58698467-b40c-3b8f-9c23-70e2c3cc7fc8",
"type": "string",
"field": "print_batch_no",
"label": "打印批次",
"value": null,
"describe": "ERP中的单据的打印批次信息,如需该字段,请升级至2.4.0.8版本及以上",
"parent_id": null,
"is_required": true
},
{
"id": "6343899b-f247-3d7f-9961-fccd573d0519",
"type": "string",
"field": "sendbill_print_status",
"label": "发货单打印状态",
"value": null,
"describe": "0未打印 1打印中 2已打印 3无需打印",
"parent_id": null,
"is_required": true
},
{
"id": "0fd71548-b3d6-3d8d-8fc1-a78e71e4b35c",
"type": "string",
"field": "logistics_print_status",
"label": "物流单打印状态",
"value": null,
"describe": "0未打印 1打印中 2已打印 3无需打印",
"parent_id": null,
"is_required": true
},
{
"id": "501a3fa4-1d2d-3383-8e24-abe1fd2160c7",
"type": "string",
"field": "picklist_print_status",
"label": "分拣单打印状态",
"value": null,
"describe": "0未打印 1打印中 2已打印 3无需打印",
"parent_id": null,
"is_required": true
},
{
"id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"type": "array",
"field": "details_list",
"label": "货品列表节点",
"children": [
{
"id": "0eb4a3d9-1072-3215-b991-d6f8a3f994b6",
"type": "string",
"field": "rec_id",
"label": "出库明细主键",
"value": null,
"parent": "details_list",
"describe": "出库明细主键",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "33dbad08-26fb-3824-a4ea-28111061323d",
"type": "string",
"field": "stockout_id",
"label": "出库单主键id",
"value": null,
"parent": "details_list",
"describe": "出库单主键id",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "5fb77397-9caa-3785-ad5c-8a9c0ffe47dc",
"type": "string",
"field": "spec_no",
"label": "商家编码",
"value": null,
"parent": "details_list",
"describe": "代表单品(sku)所有属性的编码,SKU概念介绍,单击这里",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "c5d4d260-81aa-37ee-93ac-3564562cc845",
"type": "string",
"field": "goods_count",
"label": "货品数量",
"value": null,
"parent": "details_list",
"describe": "货品数量",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "00216fad-237a-3512-8465-26302d3f1603",
"type": "string",
"field": "sell_price",
"label": "销售价",
"value": null,
"parent": "details_list",
"describe": "销售价,最终交易价格,扣除优惠",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "794eb883-8b58-3e0a-8fbf-108d91520354",
"type": "string",
"field": "brand_no",
"label": "品牌编号",
"value": null,
"parent": "details_list",
"describe": "品牌编号",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "ee0a6856-8594-38f4-ae7c-04edaada8d41",
"type": "string",
"field": "brand_name",
"label": "品牌名称",
"value": null,
"parent": "details_list",
"describe": "品牌名称",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "104e1a10-944d-30d7-a8d6-109bff637c85",
"type": "string",
"field": "goods_type",
"label": "货品类型",
"value": null,
"parent": "details_list",
"describe": "货品类型: 1销售商品 2原材料 3包装 4周转材料5虚拟商品6固定资产 0其它",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "5389eaea-e593-3553-8ea4-9b3ec1a3e63f",
"type": "string",
"field": "gift_type",
"label": "是否是赠品",
"value": null,
"parent": "details_list",
"describe": "是否是赠品 0非赠品 1自动赠送 2手工赠送",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "1bc10633-1cb3-3a9e-8d80-ca6c3fa98771",
"type": "string",
"field": "goods_name",
"label": "货品名称",
"value": null,
"parent": "details_list",
"describe": "货品名称",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "d0e05a70-c428-3906-8475-38217dc1a85d",
"type": "string",
"field": "goods_no",
"label": "货品编号",
"value": null,
"parent": "details_list",
"describe": "代表货品(spu)所有属性的编号,SPU概念介绍,单击这里",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "35f1419b-7c07-3967-bad7-3da11da02dd2",
"type": "string",
"field": "spec_name",
"label": "规格名称",
"value": null,
"parent": "details_list",
"describe": "规格名称",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "37a97aa7-e6a3-3f74-8646-9cc3da49c97a",
"type": "string",
"field": "spec_code",
"label": "规格码",
"value": null,
"parent": "details_list",
"describe": "规格码",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "872c30f1-38dd-38a6-8014-5f85df24750c",
"type": "string",
"field": "suite_no",
"label": "来源组合装编码",
"value": null,
"parent": "details_list",
"describe": "来源组合装编码",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "518713a2-3d68-3a6f-b7f6-be5da281c547",
"type": "string",
"field": "cost_price",
"label": "成本价",
"value": null,
"parent": "details_list",
"describe": "成本价",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "1ccd59c8-e27c-3dd7-96d0-173e15dd463c",
"type": "string",
"field": "total_amount",
"label": "总货款",
"value": null,
"parent": "details_list",
"describe": "总货款,sell_price * goods_count=total_amount",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "08e02dd0-587a-3f26-8c2c-e74096d914ae",
"type": "string",
"field": "goods_id",
"label": "货品id",
"value": null,
"parent": "details_list",
"describe": "货品id",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "4086af47-6921-398c-881a-c866964d72e9",
"type": "string",
"field": "spec_id",
"label": "商品主键",
"value": null,
"parent": "details_list",
"describe": "商品主键",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "1f7fba60-b7c9-36a7-b656-aaf4dfaedc02",
"type": "string",
"field": "weight",
"label": "估重",
"value": null,
"parent": "details_list",
"describe": "估重",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "bdcc2453-4e59-3420-ba87-203c96bbfb45",
"type": "string",
"field": "remark",
"label": "备注",
"value": null,
"parent": "details_list",
"describe": "备注",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "9e5fe0d3-04f5-3d95-bbd6-5fb1a8d4b853",
"type": "string",
"field": "paid",
"label": "已支付金额",
"value": null,
"parent": "details_list",
"describe": "已支付金额",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "377d8781-8194-3028-82f0-82fe1e4a1b0c",
"type": "string",
"field": "refund_status",
"label": "退款状态",
"value": null,
"parent": "details_list",
"describe": "退款状态",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "46669505-22bc-307c-b3bd-c1f43e303140",
"type": "string",
"field": "market_price",
"label": "零售价",
"value": null,
"parent": "details_list",
"describe": "零售价",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "03449ab8-7263-366e-bdb9-06f02d1c31ca",
"type": "string",
"field": "discount",
"label": "总折扣金额",
"value": null,
"parent": "details_list",
"describe": "总折扣金额",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "7458825a-099c-3ca2-984e-16fc6a04cfa7",
"type": "string",
"field": "share_amount",
"label": "分摊后合计应收",
"value": null,
"parent": "details_list",
"describe": "分摊后合计应收",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "3b975457-15e3-34fa-bf09-5bd96f25e53d",
"type": "string",
"field": "tax_rate",
"label": "税率",
"value": null,
"parent": "details_list",
"describe": "税率",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "8fbd01d0-e05c-38ad-a19f-b746ee9b8423",
"type": "string",
"field": "barcode",
"label": "条码",
"value": null,
"parent": "details_list",
"describe": "条码",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "1ade11fa-bff9-3545-b029-1132e1501c29",
"type": "string",
"field": "unit_name",
"label": "基本单位",
"value": null,
"parent": "details_list",
"describe": "基本单位",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "26ed9395-4605-36ae-a99f-13083f4604bf",
"type": "string",
"field": "sale_order_id",
"label": "订单详情表主键",
"value": null,
"parent": "details_list",
"describe": "订单详情表主键",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "4958cd11-b0bb-3e16-b680-9cbce8cc610f",
"type": "string",
"field": "share_post",
"label": "邮费分摊",
"value": null,
"parent": "details_list",
"describe": "邮费分摊",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "4a1e3419-1dcf-32d0-9cae-c432f5328f42",
"type": "string",
"field": "src_oid",
"label": "原始子订单号",
"value": null,
"parent": "details_list",
"describe": "原始子订单号",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "3ee755bf-e603-3619-879a-90a3063cf7d8",
"type": "string",
"field": "src_tid",
"label": "原始订单号",
"value": null,
"parent": "details_list",
"describe": "原始订单号",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "8c9fdd80-c76c-3f5d-b6f2-9bd5c583600e",
"type": "string",
"field": "from_mask",
"label": "单据内部来源",
"value": null,
"parent": "details_list",
"describe": "1手机订单 2聚划算 4服务子订单 8家装 16二次付款 32开具电子发票 1024库存不足 2048当日达 4096次日达 8192预约时效",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "5606b1e0-04bb-3ec2-b77c-3d64c0ff8920",
"type": "string",
"field": "src_order_type",
"label": "源单据类别",
"value": null,
"parent": "details_list",
"describe": "源单据类别 以主单为准",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "1937246b-4016-3b52-8fc1-262a39b750bb",
"type": "string",
"field": "src_order_detail_id",
"label": "sales_trade_order表的主键",
"value": null,
"parent": "details_list",
"describe": "sales_trade_order表的主键",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "0ead437f-ed79-39b7-9ccf-e8114cad4dbb",
"type": "string",
"field": "base_unit_id",
"label": "基本单位",
"value": null,
"parent": "details_list",
"describe": "基本单位",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "006c5eba-610b-369e-8cfb-6ecec2955ea0",
"type": "string",
"field": "unit_id",
"label": "辅助单位",
"value": null,
"parent": "details_list",
"describe": "辅助单位",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "510ec66c-4fd6-3730-95c2-4f85d007bd0a",
"type": "string",
"field": "unit_ratio",
"label": "单位换算",
"value": null,
"parent": "details_list",
"describe": "单位换算",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "93162796-093e-3625-aeee-0795a427ca2b",
"type": "string",
"field": "num",
"label": "货品数量",
"value": null,
"parent": "details_list",
"describe": "货品数量",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "2cbcdd72-61ed-3c68-8865-a57e16280521",
"type": "string",
"field": "num2",
"label": "辅助数量",
"value": null,
"parent": "details_list",
"describe": "辅助数量",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "33e1f26d-0a9e-3461-90f2-e6b34adc2ac0",
"type": "string",
"field": "price",
"label": "最终价格",
"value": null,
"parent": "details_list",
"describe": "最终价格,share_price删掉,取代share_price",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "039f1bfb-7487-368e-b654-d5161640f222",
"type": "string",
"field": "batch_id",
"label": "指定出库批次",
"value": null,
"parent": "details_list",
"describe": "指定出库批次",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "038bcd79-6666-35b1-9096-72a9d4ab7aef",
"type": "string",
"field": "is_examined",
"label": "是否验货",
"value": null,
"parent": "details_list",
"describe": "是否验货,用于挂起,已标记为验货的不需要再验货",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "66df1480-88a4-3204-89dc-eb6131c3d651",
"type": "string",
"field": "is_package",
"label": "是否包装",
"value": null,
"parent": "details_list",
"describe": "是否包装",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "193425d1-6292-3ec8-98cc-02cde37db4dd",
"type": "string",
"field": "is_zero_cost",
"label": "是否允许0成本",
"value": null,
"parent": "details_list",
"describe": "是否允许0成本",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "34a292be-3b66-3018-8f5a-dbc7e17c9dff",
"type": "string",
"field": "scan_type",
"label": "扫描方式",
"value": null,
"parent": "details_list",
"describe": "0未验货,1扫描验货,2手工验货,3快速验货,4无需验货",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "2ca01c5a-3847-32f9-8e5f-1439184d39c1",
"type": "string",
"field": "good_prop1",
"label": "货品档案自定义属性1",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性1",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "1a469894-c257-38bd-adc3-86f92f1fb745",
"type": "string",
"field": "good_prop2",
"label": "货品档案自定义属性2",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性2",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "178a38a0-525c-33a4-a0f6-867cadd4b563",
"type": "string",
"field": "good_prop3",
"label": "货品档案自定义属性3",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性3",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "7ceb3c41-6f20-307c-b532-d5ea52cab985",
"type": "string",
"field": "good_prop4",
"label": "货品档案自定义属性4",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性4",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "74f16a34-bca7-323f-b250-81ad9ed49987",
"type": "string",
"field": "good_prop5",
"label": "货品档案自定义属性5",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性5",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "22641e8a-6162-31ee-832a-bcbed2321d51",
"type": "string",
"field": "good_prop6",
"label": "货品档案自定义属性6",
"value": null,
"parent": "details_list",
"describe": "货品档案自定义属性6",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "44ab5d1d-fd43-3a68-bc4e-eba2ffcce396",
"type": "string",
"field": "prop1",
"label": "单品列表自定义属性1",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性1",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "63f41361-e410-3b5e-898c-f1a978565f49",
"type": "string",
"field": "prop2",
"label": "单品列表自定义属性2",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性2",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "7fa2fd29-402f-3ab0-adff-dcd4a6db4bc8",
"type": "string",
"field": "prop3",
"label": "单品列表自定义属性3",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性3",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "3302102e-e9d5-3e3d-b538-619a56774874",
"type": "string",
"field": "prop4",
"label": "单品列表自定义属性4",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性4",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "18eebc09-14ef-3c98-a779-a8dc23f220a3",
"type": "string",
"field": "prop5",
"label": "单品列表自定义属性5",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性5",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "96369494-f3ba-34b3-ad9d-66f950b468c4",
"type": "string",
"field": "prop6",
"label": "单品列表自定义属性6",
"value": null,
"parent": "details_list",
"describe": "单品列表自定义属性6",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "09e9f338-ad45-3fd1-a9ab-a00b4c50d0db",
"type": "string",
"field": "batch_no",
"label": "批次号",
"value": null,
"parent": "details_list",
"describe": "批次号",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "6d2b832a-2dd5-3c6f-8167-27bbb875c4f5",
"type": "string",
"field": "batch_remark",
"label": "批次备注",
"value": null,
"parent": "details_list",
"describe": "批次备注",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "04d3b5a5-d7fc-3a3d-a5b0-db2eefc2f3ae",
"type": "string",
"field": "expire_date",
"label": "有效期",
"value": null,
"parent": "details_list",
"describe": "有效期,时间格式:yyyy-MM-dd HH:mm:ss",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
},
{
"id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"type": "array",
"field": "position_list",
"label": "货位节点列表",
"parent": "details_list",
"children": [
{
"id": "3857fae3-93ad-3d3d-ab7b-2c0573d82ba0",
"type": "string",
"field": "position_id",
"label": "货位ID",
"value": null,
"parent": "position_list",
"describe": "货位ID",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "42982a19-6175-3294-b080-b398b5a1e1d6",
"type": "string",
"field": "position_no",
"label": "货位编号",
"value": null,
"parent": "position_list",
"describe": "货位编号",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "1bed1900-7be2-30d1-af24-d6d46f8bf65b",
"type": "string",
"field": "stockout_order_detail_id",
"label": "出库单明细id",
"value": null,
"parent": "position_list",
"describe": "出库单明细id",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "3d62d298-5738-33b5-bbda-49469ae75464",
"type": "string",
"field": "rec_id",
"label": "货位主键id",
"value": null,
"parent": "position_list",
"describe": "货位主键id",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "2ffa4b8a-e2be-3caa-ad3a-bf11714475b9",
"type": "string",
"field": "stockin_detail_id",
"label": "入库单明细id",
"value": null,
"parent": "position_list",
"describe": "入库单明细id",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "481e91d2-bb72-33cb-b4f5-47c16bf58679",
"type": "string",
"field": "num",
"label": "货品数量",
"value": null,
"parent": "position_list",
"describe": "货品数量",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "21374237-a4de-37f0-9d49-649bb8f3292a",
"type": "string",
"field": "stock_spec_detail_id",
"label": "入库单号明细id",
"value": null,
"parent": "position_list",
"describe": "入库单号明细id",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "4f32e069-7c41-3b86-97bb-b8fa251fc343",
"type": "string",
"field": "batch_id",
"label": "批次id",
"value": null,
"parent": "position_list",
"describe": "批次id",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "594c2020-fa90-3c41-a22c-5693214ca091",
"type": "string",
"field": "batch_no",
"label": "批次号",
"value": null,
"parent": "position_list",
"describe": "批次号",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "23590768-72f4-3b42-bcb7-a1cfb7cbed08",
"type": "string",
"field": "modified",
"label": "最后更新时间",
"value": null,
"parent": "position_list",
"describe": "最后更新时间",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "9476adaf-3dd6-3083-bb8b-d4c28019f02d",
"type": "string",
"field": "cost_price",
"label": "成本价",
"value": null,
"parent": "position_list",
"describe": "成本价",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
},
{
"id": "64d0dd01-782f-31ba-b116-c865291d9491",
"type": "string",
"field": "position_goods_count",
"label": "货位出库数量",
"value": null,
"parent": "position_list",
"describe": "货位出库数量",
"parent_id": "5508c8d6-e030-347a-b906-7cf9c01fd8ac",
"is_required": true
}
],
"describe": "货位节点列表",
"parent_id": "0da470e9-863b-3a21-98eb-59a9b7059c5f",
"is_required": true
}
],
"describe": "货品列表节点",
"parent_id": null,
"is_required": true
}
],
"condition": [
[
{
"field": "platform_id",
"logic": "neq",
"value": 0
},
{
"field": "platform_id",
"logic": "neq",
"value": 127
}
]
],
"pagination": {
"pageSize": 100
},
"otherRequest": [
{
"id": "1575f0ef-50e6-3f45-9a41-662929be1f38",
"type": "string",
"field": "page_size",
"label": "分页大小",
"value": "{{PAGINATION_PAGE_SIZE}}",
"describe": "每页返回的数据条数,输入值范围1~100,不传本参数,输入值默认为40,使用举例单击这里",
"parent_id": null,
"is_required": false
},
{
"id": "40e2fad7-7588-3beb-a269-ee9f2e96d3d8",
"type": "string",
"field": "page_no",
"label": "页号",
"value": "{{PAGINATION_START_PAGE}}",
"describe": "不传值默认从0页开始",
"parent_id": null,
"is_required": true
}
],
"otherResponse": [],
"formatResponse": [
{
"new": "consign_time_new",
"old": "consign_time",
"format": "date"
}
]
}
目标平台元数据配置:
{
"id": null,
"api": "/yonbip/sd/voucherorder/singleSave",
"type": "EXECUTE",
"method": "POST",
"number": null,
"idCheck": true,
"request": [
{
"id": "ecf21249-a807-3ee5-b8c5-ca125b43394e",
"type": "string",
"field": "resubmitCheckKey",
"label": "保证请求的幂等性",
"value": "{{random}}",
"describe": "保证请求的幂等性,该值由客户端生成,并且必须是全局唯一的,长度不能超过32位。更多信息,请参见«MDD幂等性»",
"parent_id": null,
"is_required": true
},
{
"id": "214d7704-73b3-3d85-9d0f-87fc93ce3218",
"type": "string",
"field": "salesOrgId",
"label": "销售组织",
"value": "_findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}}",
"describe": "销售组织,传id或者code 示例:2282800216593664",
"parent_id": null,
"is_required": true
},
{
"id": "d14d82c1-f329-3a03-a30c-28c5878c25e8",
"type": "string",
"field": "transactionTypeId",
"label": "交易类型",
"value": "SO0210",
"describe": "交易类型,传id或者code 示例:2291507369660672",
"parent_id": null,
"is_required": true
},
{
"type": "string",
"field": "bizFlow",
"label": "bizFlow",
"value": "8925d809-dcc4-11ec-9896-6c92bf477043",
"describe": "流程ID",
"parent_id": null,
"is_required": true
},
{
"type": "string",
"field": "bizFlow_version",
"label": "bizFlow_version",
"value": "V1.0",
"parent_id": null,
"is_required": true
},
{
"id": "8d93a4ed-1894-3cb1-b93a-09e5bc115ef3",
"type": "string",
"field": "vouchdate",
"label": "单据日期",
"value": "{{consign_time_new}}",
"describe": "单据日期,格式为:yyyy-MM-dd HH:mm:ss 示例:2021-06-09 00:00:00",
"parent_id": null,
"is_required": true
},
{
"id": "4f550239-c386-3554-91b4-8bc12a92397c",
"type": "string",
"field": "code",
"label": "单据编码",
"value": null,
"describe": "单据编码,以系统编码规则配置为准:系统设置为手工编号时必输,系统设置为自动编号时非必输;修改时必传 示例:UO-366420210609000004",
"parent_id": null,
"is_required": false
},
{
"id": "399ecb36-920c-34e0-9582-3baafbabc2d5",
"type": "string",
"field": "agentId",
"label": "客户",
"value": "_findCollection find mapping_customer from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}}",
"describe": "客户,传id或者code 示例:2282507926999296",
"parent_id": null,
"is_required": true
},
{
"id": "202dc11d-fab4-3eb9-bea3-3783acb37ed6",
"type": "string",
"field": "settlementOrgId",
"label": "开票组织",
"value": "_findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}}",
"describe": "开票组织,传id或者code 示例:2282800216593664",
"parent_id": null,
"is_required": true
},
{
"id": "2dc4ac86-8896-37af-94a3-5f69514605d9",
"type": "string",
"field": "source",
"label": "单据来源",
"value": "4",
"describe": "单据来源, 0:PC、1:移动、2:导入、3:ERP、4:OPENAPI、 示例:0",
"parent_id": null,
"is_required": false
},
{
"id": "cf962128-9a3d-355e-9abe-274cbad816cc",
"type": "string",
"field": "orderPrices!currency",
"label": "币种",
"value": "CNY",
"describe": "币种,传id或者code 示例:2281153755730176",
"parent_id": null,
"is_required": true
},
{
"id": "ec80569d-30f5-3cad-a8aa-bbd169a93fcb",
"type": "string",
"field": "orderPrices!exchRate",
"label": "汇率 ",
"value": "1",
"describe": "汇率 示例:1",
"parent_id": null,
"is_required": true
},
{
"id": "b2596419-429e-3820-bd7d-2d86f1d2e101",
"type": "string",
"field": "orderPrices!exchangeRateType",
"label": "汇率类型",
"value": "01",
"describe": "汇率类型,传id或者code 示例:0000KPC165PABLPTS60000",
"parent_id": null,
"is_required": true
},
{
"id": "d90b0953-927a-3a2e-80f7-e9b5e5816477",
"type": "string",
"field": "orderPrices!natCurrency",
"label": "本币",
"value": "CNY",
"describe": "本币,传id或者code 示例:2281153755730176",
"parent_id": null,
"is_required": true
},
{
"id": "20c0fa04-8609-3663-9313-5d4e8d390f77",
"type": "string",
"field": "orderPrices!taxInclusive",
"label": "单价含税 ",
"value": "true",
"describe": "单价含税 示例:true",
"parent_id": null,
"is_required": true
},
{
"id": "eafa2398-7324-360d-a43f-6ef4184652f5",
"type": "string",
"field": "invoiceAgentId",
"label": "开票客户",
"value": "_findCollection find mapping_customer from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}}",
"describe": "开票客户,传id或者code 示例:2282507926999296",
"parent_id": null,
"is_required": true
},
{
"id": "296a9b08-96da-369c-9084-b4655d913bb2",
"type": "string",
"field": "invoiceUpcType",
"label": "发票类型",
"value": "1",
"describe": "发票类型, 0:收据、1:增值税专用发票、2:增值税普通发票、3:增值税电子普通发票、4:机动车销售销售统一发票、 示例:0",
"parent_id": null,
"is_required": true
},
{
"id": "f5d0cd9e-5a83-39c8-8ab0-e28d2953cbbc",
"type": "string",
"field": "payMoney",
"label": "合计含税金额",
"value": "{{details.batch_details_paid}}",
"describe": "合计含税金额。可精确到6位小数,需等于表体含税金额的合计。 示例:77.28",
"parent_id": null,
"is_required": true
},
{
"id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"type": "array",
"field": "orderDetails",
"label": "销售订单子表",
"value": "details",
"children": [
{
"id": "a2c2c8ba-719f-36b9-af75-ba7a8ba74ce7",
"type": "string",
"field": "stockId",
"label": "仓库",
"value": "{{details.warehouse_no}}",
"parent": "orderDetails",
"describe": "仓库,传id或者code 示例:aaa",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": false
},
{
"id": "b571c83c-28bc-393e-9304-e5a2156ae123",
"type": "string",
"field": "isExpiryDateManage",
"label": "是否有效期管理",
"value": "true",
"parent": "orderDetails",
"describe": "是否有效期管理, true:是、false:否、 示例:false",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": false
},
{
"id": "850433d0-a9ef-3749-bd85-f8350c3cd875",
"type": "string",
"field": "orderDetailPrices!natSum",
"label": "本币含税金额 ",
"value": "{{details.batch_details_share_amount}}",
"parent": "orderDetails",
"describe": "本币含税金额 示例:77.28",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "e59de1ef-db0a-3bd9-95bb-82c0d121cbca",
"type": "string",
"field": "orderDetailPrices!natMoney",
"label": "本币无税金额 ",
"value": "{{details.batch_details_share_amount}}",
"parent": "orderDetails",
"describe": "本币无税金额 示例:73.6",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "8d29d408-917c-37f5-93ad-b1c08b55a265",
"type": "string",
"field": "productId",
"label": "商品",
"value": "{{details.batch_details_spec_no}}",
"parent": "orderDetails",
"describe": "商品,传id或者code 示例:2293858192511232",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "d5999a7b-6409-3f51-90e5-88bc05c64dff",
"type": "string",
"field": "masterUnitId",
"label": "主计量单位",
"value": "_findCollection find code from f9eedcc9-f1ff-31c0-9081-6aee9cf21740 where name={{batch_details_unit_name}}",
"parent": "orderDetails",
"describe": "主计量单位,传id或者code 示例:2281391353483520",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "c68bc57b-7876-3e90-b8e3-3d473b8251a9",
"type": "string",
"field": "invExchRate",
"label": "销售换算率 ",
"value": "1",
"parent": "orderDetails",
"describe": "销售换算率 示例:4",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "252ddc65-336b-356d-ad16-a28b282f8eb9",
"type": "string",
"field": "unitExchangeTypePrice",
"label": "浮动(销售)",
"value": "0",
"parent": "orderDetails",
"describe": "浮动(销售) 示例:0",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "f0600ef4-cfbe-33ca-b8cd-19759a1f9c30",
"type": "string",
"field": "orderDetailPrices!oriTax",
"label": "税额 ",
"value": "{{details.tax}}",
"parent": "orderDetails",
"describe": "税额 示例:3.68",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "4ccad4c6-16ba-3b3a-979c-e10f969e3fb5",
"type": "string",
"field": "iProductAuxUnitId",
"label": "销售单位",
"value": "_findCollection find code from f9eedcc9-f1ff-31c0-9081-6aee9cf21740 where name={{batch_details_unit_name}}",
"parent": "orderDetails",
"describe": "销售单位,传id或者code 示例:2281391349666048",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "317593ff-a468-30ac-b2d7-e6276479a87b",
"type": "string",
"field": "orderDetailPrices!natUnitPrice",
"label": "本币无税单价 ",
"value": "{{details.batch_details_sell_price}}",
"parent": "orderDetails",
"describe": "本币无税单价 示例:3.2",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "be0d65fc-8671-3919-9566-5eeabc32147a",
"type": "string",
"field": "invPriceExchRate",
"label": "计价换算率",
"value": "1",
"parent": "orderDetails",
"describe": "计价换算率 示例:1",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "9903d20b-2b0a-322a-b6b2-557813d23d38",
"type": "string",
"field": "isBatchManage",
"label": "是否批次管理",
"value": "true",
"parent": "orderDetails",
"describe": "是否批次管理, true:是、false:否、 示例:false",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": false
},
{
"id": "6f466c90-496b-3ffd-b55f-1db46620dc7b",
"type": "string",
"field": "oriSum",
"label": "含税金额",
"value": "{{details.batch_details_paid}}",
"parent": "orderDetails",
"describe": "含税金额。可精确到6位小数。 示例:77.28",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "42b65c0d-bcf6-331a-860a-b944e9ccf807",
"type": "string",
"field": "orderDetailPrices!oriMoney",
"label": "无税金额 ",
"value": "{{details.batch_details_share_amount}}",
"parent": "orderDetails",
"describe": "无税金额 示例:73.6",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "1ddae965-bd4c-3394-ade2-a71aed714aae",
"type": "string",
"field": "priceQty",
"label": "计价数量 ",
"value": "{{details.batch_details_goods_count}}",
"parent": "orderDetails",
"describe": "计价数量 示例:23",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "cea21768-14df-3777-8391-7eeb79713efe",
"type": "string",
"field": "stockOrgId",
"label": "库存组织",
"value": "_findCollection find org_code from 4f73f755-1c4f-33e6-b5a1-7e3b8d894800 where code={{warehouse_no}}",
"parent": "orderDetails",
"describe": "库存组织id或库存组织code 示例:2282800216593664",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "f390597d-74d7-365e-8bc3-de1de034a4ad",
"type": "string",
"field": "iProductUnitId",
"label": "计价单位",
"value": "_findCollection find code from f9eedcc9-f1ff-31c0-9081-6aee9cf21740 where name={{batch_details_unit_name}}",
"parent": "orderDetails",
"describe": "计价单位,传id或者code 示例:2281391353483520",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "742a2208-de31-3008-ac8c-b10d3c062e40",
"type": "string",
"field": "orderDetailPrices!natTaxUnitPrice",
"label": "本币含税单价 ",
"value": "{{details.batch_details_sell_price}}",
"parent": "orderDetails",
"describe": "本币含税单价 示例:3.36",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": false
},
{
"id": "19fe4956-37ad-3684-bcbd-b5952e2d385f",
"type": "string",
"field": "orderProductType",
"label": "商品售卖类型",
"value": "SALE",
"parent": "orderDetails",
"describe": "商品售卖类型, SALE:销售品、GIFT:赠品、MARKUP:加价购、REBATE:返利商品、 示例:SALE",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "d77cec91-cb21-3cab-8f6f-ab8370bc2f73",
"type": "string",
"field": "subQty",
"label": "销售数量 ",
"value": "{{details.batch_details_goods_count}}",
"parent": "orderDetails",
"describe": "销售数量 示例:5.75",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "5418464d-2398-3244-bbe3-5d7e28c1e8f4",
"type": "string",
"field": "consignTime",
"label": "计划发货日期",
"value": "{{details.consign_time_new}}",
"parent": "orderDetails",
"describe": "计划发货日期,格式为:yyyy-MM-dd HH:mm:ss 示例:2021-06-23 00:00:00",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "54643a42-b58e-34fb-ac44-4dbc44b51567",
"type": "string",
"field": "skuId",
"label": "商品SKUid或SKUcode ",
"value": "{{details.batch_details_spec_no}}",
"parent": "orderDetails",
"describe": "商品SKUid或SKUcode 示例:2293858201112832",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "c9dc2200-e286-33f8-ab6f-ff055134e09f",
"type": "string",
"field": "taxId",
"label": "税目税率",
"value": "{{details.batch_details_tax_rate}}",
"parent": "orderDetails",
"describe": "税目税率,传id或者code 示例:2281153771049217",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "bba09169-7c92-3e49-8780-acdf26195bdd",
"type": "string",
"field": "qty",
"label": "数量 ",
"value": "{{details.batch_details_goods_count}}",
"parent": "orderDetails",
"describe": "数量 示例:23",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "a1985cdc-155a-3c2b-baae-14bb44c973f4",
"type": "string",
"field": "settlementOrgId",
"label": "开票组织",
"value": "_findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}}",
"parent": "orderDetails",
"describe": "开票组织,传id或者code 示例:2282800216593664",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "19d61270-6a61-3b4f-80b6-0f33ec1c6cbd",
"type": "string",
"field": "oriTaxUnitPrice",
"label": "含税成交价",
"value": "{{details.batch_details_share_amount}}",
"parent": "orderDetails",
"describe": "含税成交价,可精确到6位小数 示例:3.36",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "48f72bed-8f23-3f44-acb9-de7a33d3de72",
"type": "string",
"field": "orderDetailPrices!natTax",
"label": "本币税额 ",
"value": "{{details.tax}}",
"parent": "orderDetails",
"describe": "本币税额 示例:3.68",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "c7d57e34-5d08-3402-8b2d-671ecf19ae66",
"type": "string",
"field": "unitExchangeType",
"label": "浮动(计价) ",
"value": "0",
"parent": "orderDetails",
"describe": "浮动(计价) 示例:0",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "838e7305-bbc2-301d-85b3-7127e768e192",
"type": "string",
"field": "orderDetailPrices!oriUnitPrice",
"label": "无税成交价",
"value": "{{details.batch_details_share_amount}}",
"parent": "orderDetails",
"describe": "无税成交价 示例:3.2",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "d7fbe535-fb1b-30eb-9598-53dbbde6ff47",
"type": "string",
"field": "salesOrgId",
"label": "销售组织",
"value": "_findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}}",
"parent": "orderDetails",
"describe": "销售组织,传id或者code 示例:2282800216593664",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": false
},
{
"id": "6a4eb59a-d721-3401-bfb2-9d3c71ee8ff5",
"type": "string",
"field": "_status",
"label": "操作标识",
"value": "Insert",
"parent": "orderDetails",
"describe": "操作标识, Insert:新增、Update:更新 示例:Insert",
"parent_id": "819a8dab-8ec4-365e-9780-9231a57c0187",
"is_required": true
},
{
"id": "memo",
"type": "string",
"field": "memo",
"label": "备注",
"value": "{{details.batch_details_batch_no}}",
"parent": "orderDetails"
},
{
"type": "string",
"field": "batch_no",
"label": "batch_no",
"value": "{{details.batch_details_batch_no}}",
"parent": "orderDetails"
},
{
"id": "producedate",
"type": "string",
"field": "producedate",
"label": "producedate",
"value": "{{details.batch_details_created}}",
"parent": "orderDetails"
},
{
"id": "invaliddate",
"type": "string",
"field": "invaliddate",
"label": "invaliddate",
"value": "{{details.batch_details_expire_date}}",
"parent": "orderDetails"
}
],
"describe": "销售订单子表[voucher.order.OrderDetail]",
"parent_id": null,
"is_required": false
},
{
"id": "6b0d1377-c848-3272-aff7-7d36e364eed3",
"type": "string",
"field": "_status",
"label": "操作标识",
"value": "Insert",
"describe": "操作标识, Insert:新增、Update:更新 示例:Insert",
"parent_id": null,
"is_required": false
},
{
"id": "36f24b7f-fae6-3405-8cc1-1d6c1f36f71a",
"type": "string",
"field": "memo",
"label": "备注 ",
"value": "{{warehouse_no}}",
"describe": "备注 示例:222222",
"parent_id": null,
"is_required": false
},
{
"id": "headFreeItem!define1",
"type": "string",
"field": "headFreeItem!define1",
"label": "销售类型",
"value": "网店销售",
"parent": null
}
],
"BIPAudit": "/yonbip/sd/voucherorder/batchaudit",
"response": [],
"otherRequest": [],
"otherResponse": [],
"groupCalculate": {
"bodyName": "details",
"bodyGroup": [
"batch_details_spec_no",
"batch_details_batch_no",
"batch_details_expire_date",
"batch_details_created"
],
"calculate": {
"receivable": "$sum",
"batch_details_paid": "$sum",
"batch_details_goods_count": "$sum",
"batch_details_share_amount": "$sum"
},
"headerGroup": [
"consign_time_new",
"shop_no",
"warehouse_no"
]
}
}