| main_params | 主表参数 | |
| main_params.amount | 商品总价 | {{amount}} |
| main_params.area_name | 收货地区 | {{area_name}} |
| main_params.cod | 是否货到付款 | {{cod}} |
| main_params.cod_fee | 货到付款服务费 | {{cod_fee}} |
| main_params.code | 单据编号 | {{code}} |
| main_params.create_date | 制单时间 | {{create_date}} |
| main_params.create_name | 制单人 | {{create_name}} |
| main_params.discount_fee | 让利金额 | {{discount_fee}} |
| main_params.express_code | 快递公司代码 | {{express_code}} |
| main_params.express_name | 快递公司名称 | {{express_name}} |
| main_params.express_no | 快递单号 | {{express_no}} |
| main_params.pay_time | 支付时间 | {{pay_time}} |
| main_params.payment | 已付金额 | {{payment}} |
| main_params.picture_bill | 是否多包裹 | {{picture_bill}} |
| main_params.platform_code | 平台单号 | {{platform_code}} |
| main_params.post_cost | 物流成本 | {{post_cost}} |
| main_params.post_fee | 物流费用 | {{post_fee}} |
| main_params.qty | 商品总数 | {{qty}} |
| main_params.receiver_address | 收货地址 | {{receiver_address}} |
| main_params.receiver_mobile | 收货人手机 | {{receiver_mobile}} |
| main_params.receiver_name | 收货人姓名 | {{receiver_name}} |
| main_params.platform_code | 平台单号 | {{platform_code}} |
| main_params.post_cost | 物流成本 | {{post_cost}} |
| main_params.post_fee | 物流费用 | {{post_fee}} |
| main_params.qty | 商品总数 | {{qty}} |
| main_params.receiver_address | 收货地址 | {{receiver_address}} |
| main_params.receiver_mobile | 收货人手机 | {{receiver_mobile}} |
| main_params.receiver_phone | 收货人电话 | {{receiver_phone}} |
| main_params.refund | 退款状态 | {{refund}} |
| main_params.shop_code | 店铺代码 | {{shop_code}} |
| main_params.shop_name | 店铺名称 | {{shop_name}} |
| main_params.sync_status | 数据同步状态 | {{sync_status}} |
| main_params.unpaid_amount | 未付金额 | {{unpaid_amount}} |
| main_params.vip_code | 会员代码 | {{vip_code}} |
| main_params.vip_name | 会员名称 | {{vip_name}} |
| main_params.warehouse_code | 仓库代码 | {{warehouse_code}} |
| main_params.warehouse_name | 仓库名称 | {{warehouse_name}} |
| main_params.extend_params_1 | 发货信息表参数 | |
| main_params.extend_params_1.eshop_id | 网店id | {{onlinePlatTypeCode}} |
| main_params.extend_params_1.number | 编码 | {{onlinePlatTypeCode}} |
| main_params.extend_params_1.name | 名称 | {{onlinePlatTypeName}} |
| main_params.extend_params_1.extend_params_2 | 物料明细表参数 | |
| main_params.extend_params_1.extend_params_2.eshop_id | 网店id | {{onlinePlatTypeCode}} |
| main_params.extend_params_1.extend_params_2.logisticsfilterbystockorg | 按库存组织匹配物流公司 | |
| main_params.extend_params_1.extend_params_2.logisticsfilterbyareascope | 按配送区域范围匹配物流公司 | |
| main_params.extend_params_1.extend_params_2.logisticsfilterbyfare | 按最小运费匹配物流公司 | |
| main_params.extend_params_1.extend_params_2.logisticsfilterbynetshop | 按网店匹配物流公司 | |
| main_params.extend_params_1.extend_params_2.logisticsfilterbymatscope | 按物流配送范围匹配物流公司 | |
| main_params.extend_params_1.extend_params_2.main_sql | 主表SQL语句 | INSERT INTO lehua.gy_deliverys (id, amount, area_name, cod, cod_fee, code, create_date, create_name, discount_fee, express_code, express_name, express_no, pay_time, payment, picture_bill, platform_code, post_cost, post_fee, qty, receiver_address, receiver_mobile, receiver_name, receiver_phone, refund, shop_code, shop_name, sync_status, unpaid_amount, vip_code, vip_name, warehouse_code, warehouse_name) VALUES (<{id: }>, <{amount: }>, <{area_name: }>, <{cod: }>, <{cod_fee: }>, <{code: }>, <{create_date: }>, <{create_name: }>, <{discount_fee: }>, <{express_code: }>, <{express_name: }>, <{express_no: }>, <{pay_time: }>, <{payment: }>, <{picture_bill: }>, <{platform_code: }>, <{post_cost: }>, <{post_fee: }>, <{qty: }>, <{receiver_address: }>, <{receiver_mobile: }>, <{receiver_name: }>, <{receiver_phone: }>, <{refund: }>, <{shop_code: }>, <{shop_name: }>, <{sync_status: }>, <{unpaid_amount: }>, <{vip_code: }>, <{vip_name: }>, <{warehouse_code: }>, <{warehouse_name: }>); |
| main_params.extend_params_1.extend_params_2.extend_sql_1 | 发货信息SQL语句 | INSERT INTO lehua.gy_deliverys_delivery_statusinfo (id, cancel, delivery, delivery_date, delivery_name, delivery_print_date, delivery_print_name, express_print_date, print_delivery, print_express, scan, scan_date, scan_name, thermal_print, thermal_print_status, weight, weight_date, weight_name, weight_qty, wms, wms_order) VALUES (<{id: }>, <{cancel: }>, <{delivery: }>, <{delivery_date: }>, <{delivery_name: }>, <{delivery_print_date: }>, <{delivery_print_name: }>, <{express_print_date: }>, <{print_delivery: }>, <{print_express: }>, <{scan: }>, <{scan_date: }>, <{scan_name: }>, <{thermal_print: }>, <{thermal_print_status: }>, <{weight: }>, <{weight_date: }>, <{weight_name: }>, <{weight_qty: }>, <{wms: }>, <{wms_order: }>); |
| main_params.extend_params_1.extend_params_2.extend_sql_2 | 物料明细SQL语句 | INSERT INTO main_eshop_parameter (eshop_id, logisticsfilterbystockorg, logisticsfilterbyareascope, logisticsfilterbyfare, logisticsfilterbynetshop, logisticsfilterbymatscope) VALUES (<{eshop_id: }>, <{logisticsfilterbystockorg: }>, <{logisticsfilterbyareascope: }>, <{logisticsfilterbyfare: }>, <{logisticsfilterbynetshop: }>, <{logisticsfilterbymatscope: }>); |
