| main_params | 主参数 | object | |
| main_params.code | 订单编码 | string | {{tradeNo}} |
| main_params.settlement_status | 结算状态 | string | 3 |
| main_params.channel | 销售渠道 | string | {{departName}} |
| main_params.cust_id | 客户 | string | {{customerCode}} |
| main_params.sale_date | 销售时间 | string | {{gmtCreate}} |
| main_params.network_order_no | 网点订单号 | string | {{onlineTradeNo}} |
| main_params.order_type | 订单类型 | string | {{tradeType}} |
| main_params.receivable_amount | 应收合计 | string | {{payment}} |
| main_params.customer_account | 客户账号 | string | {{customerCode}} |
| main_params.consignee | 收货人 | string | {{customerName}} |
| main_params.mobile | 手机 | string | null |
| main_params.phone | 电话 | string | null |
| main_params.address | 收货地址 | string | {{country}}{{state}}{{city}}{{district}}{{town}} |
| main_params.delivery_way | 交货方式 | string | {{logisticType}} |
| main_params.group | 销售组织 | string | findCollection find textField_l2iazxw0 from a7cb0b9d-2aef-342a-bcb9-7d02e747f1d8 where textField_l2iazxvw={{shopCode}} |
| main_params.dept_id | 销售部门 | string | |
| main_params.group_id | 销售组 | string | |
| main_params.saler_id | 销售员 | string | |
| main_params.trade_time | 下单时间 | string | {{tradeTime}} |
| main_params.charge_id | 付款方 | string | |
| main_params.payment_date | 付款时间 | string | {{gmtModified}} |
| main_params.payer_name | 购方名称 | string | {{payerName}} |
| main_params.payer_reg_no | 购方税号 | string | |
| main_params.payer_bank_account | 购方开户行及帐号 | string | {{payerBankAccount}} |
| main_params.payer_phone | 购方电话 | string | {{payerPhone}} |
| main_params.invoice_no | 发票号码 | string | {{invoiceCode}} |
| main_params.invoice_code | 发票代码 | string | {{invoiceCode}} |
| main_params.invoice_status | 发票开具状态 | string | {{invoiceStatus}} |
| main_params.pay_type | 支付方式 | string | {{payType}} |
| main_params.first_payment | 付首款金额 | string | |
| main_params.first_paytime | 付首款时间 | string | {{gmtCreate}} |
| main_params.final_payment | 付尾款金额 | string | |
| main_params.final_paytime | 付尾款时间 | string | {{gmtCreate}} |
| main_params.check_amount | 对账金额 | string | |
| main_params.invoice_type | 发票类型 | string | {{invoiceType}} |
| main_params.changer_id | 变更人 | string | |
| main_params.change_date | 变更日期 | string | {{gmtModified}} |
| main_params.change_reason | 变更原因 | string | null |
| main_params.closer_id | 关闭人 | string | |
| main_params.close_date | 关闭日期 | string | {{gmtModified}} |
| main_params.cancel_status | 作废状态 | string | |
| main_params.canceller_id | 作废人 | string | |
| main_params.cancel_date | 作废日期 | string | {{gmtModified}} |
| main_params.order_status | 订单状态 | string | 3 |
| main_params.close_status | 关闭状态 | string | |
| main_params.date | date | string | {{tradeTime}} |
| main_params.extend_params_1 | 1:1扩展参数 | array | goodsDetail |
| main_params.extend_params_1.lastInsertId | order_id | string | :lastInsertId |
| main_params.extend_params_1.goods_id | 货品编码id | string | {{goodsDetail.goodsNo}} |
| main_params.extend_params_1.goods_name | 货品名称 | string | {{goodsDetail.goodsName}} |
| main_params.extend_params_1.goods_model | 规格型号 | string | {{goodsDetail.goodsName}} |
| main_params.extend_params_1.goods_type | 类别 | string | {{goodsDetail.goodsTypeCount}} |
| main_params.extend_params_1.tax_price | 销售含税单价 | string | {{goodsDetail.sellPrice}} |
| main_params.extend_params_1.price_unit_id | 计价单位 | string | {{goodsDetail.unit}} |
| main_params.extend_params_1.barcode | 条码 | string | {{goodsDetail.barcode}} |
| main_params.extend_params_1.product_num | 销售数量 | string | {{goodsDetail.sellCount}} |
| main_params.extend_params_1.price | 销售单价 | string | {{goodsDetail.sellPrice}} |
| main_params.extend_params_1.unit_id | 销售单位 | string | {{goodsDetail.unit}} |
| main_params.extend_params_1.sell_total | 总金额 | string | {{goodsDetail.sellTotal}} |
| main_params.extend_params_1.discount_total | 优惠金额 | float | {{goodsDetail.discountTotal}} |
| main_params.extend_params_1.discount_point | 抵扣积分 | string | {{goodsDetail.discountPoint}} |
| main_params.extend_params_1.tax_fee | 税额 | string | {{goodsDetail.taxFee}} |
| main_params.extend_params_1.share_fee | 分摊金额 | string | _function case when'{{goodsDetail.shareFavourableFee}}' ='' then '0' else '{{goodsDetail.shareFavourableFee}}' end |
| main_params.extend_params_1.estimate_weight | 预估重量 | string | {{goodsDetail.estimateWeight}} |
| main_params.extend_params_1.estimate_goods_volume | 预估体积 | string | {{goodsDetail.estimateGoodsVolume}} |
| main_params.extend_params_1.goods_memo | 货品备注 | string | {{goodsDetail.goodsmemo}} |
| main_params.extend_params_1.cate_name | 货品类别 | string | {{goodsDetail.catename}} |
| main_params.extend_params_1.brand | 品牌 | string | {{goodsDetail.brandName}} |
| main_params.extend_params_1.buyer_memo | 买家备注 | string | {{buyerMemo}} |
| main_params.extend_params_1.is_gift | 是否赠品 | string | {{goodsDetail.isGift}} |
| main_params.extend_params_1.product_digest | 货品摘要 | string | _function left('{{sellerMemo}}',200) |
| main_params.extend_params_1.remark | 备注 | string | null |
| main_params.extend_params_1.sale_discount_policy_id | 销售折扣政策id | string | |
| main_params.extend_params_1.original_order_code | 原始订单号 | string | null |
| main_params.extend_params_1.payment_information_id | 支付相关信息 | string | |
| main_params.extend_params_1.date | date | string | {{gmtCreate}} |
| main_params.extend_params_1.main_sql | 主语句 | string | INSERT INTO lehua.sale_order ( code, settlement_status, channel, cust_id, sale_date, network_order_no, order_type, receivable_amount, customer_account, consignee, mobile, address, phone, delivery_way, group, dept_id, group_id, saler_id, trade_time, charge_id, payment_date, payer_name, payer_reg_no, payer_bank_account, payer_phone, invoice_no, invoice_code, invoice_status, pay_type, first_payment, first_paytime, final_payment, final_paytime, check_amount, invoice_type, changer_id, change_date, change_reason, closer_id, close_date, cancel_status, canceller_id, cancel_date, order_status, close_status, date) VALUES ( <{code: }>, <{settlement_status: 0}>, <{channel: }>, <{cust_id: }>, <{sale_date: }>, <{network_order_no: }>, <{order_type: 0}>, <{receivable_amount: }>, <{customer_account: }>, <{consignee: }>, <{mobile: }>, <{address: }>, <{phone: }>, <{delivery_way: }>, <{group: }>, <{dept_id: }>, <{group_id: }>, <{saler_id: }>, <{trade_time: }>, <{charge_id: }>, <{payment_date: }>, <{payer_name: }>, <{payer_reg_no: }>, <{payer_bank_account: }>, <{payer_phone: }>, <{invoice_no: }>, <{invoice_code: }>, <{invoice_status: }>, <{pay_type: }>, <{first_payment: }>, <{first_paytime: }>, <{final_payment: }>, <{final_paytime: }>, <{check_amount: }>, <{invoice_type: }>, <{changer_id: }>, <{change_date: }>, <{change_reason: }>, <{closer_id: }>, <{close_date: }>, <{cancel_status: }>, <{canceller_id: }>, <{cancel_date: }>, <{order_status: }>, <{close_status: }>, <{date: }>); |
| main_params.extend_params_1.extend_sql_1 | 1:1扩展语句 | string | INSERT INTO lehua.sale_order_detail ( order_id, goods_id, goods_name, goods_model, goods_type, tax_price, price_unit_id, barcode, product_num, price, unit_id, sell_total, discount_total, discount_point, tax_fee, share_fee, estimate_weight, estimate_goods_volume, goods_memo, cate_name, brand, buyer_memo, is_gift, product_digest, remark, sale_discount_policy_id, original_order_code, payment_information_id, date) VALUES ( <{lastInsertId: }>, <{goods_id: }>, <{goods_name: }>, <{goods_model: }>, <{goods_type: }>, <{tax_price: }>, <{price_unit_id: }>, <{barcode: }>, <{product_num: }>, <{price: }>, <{unit_id: }>, <{sell_total: }>, <{discount_total: }>, <{discount_point: }>, <{tax_fee: }>, <{share_fee: }>, <{estimate_weight: }>, <{estimate_goods_volume: }>, <{goods_memo: }>, <{cate_name: }>, <{brand: }>, <{buyer_memo: }>, <{is_gift: }>, <{product_digest: }>, <{remark: }>, <{sale_discount_policy_id: }>, <{original_order_code: }>, <{payment_information_id: }>, <{date: }>); |
