resubmitCheckKey | 保证请求的幂等性 | {{order_no}} |
salesOrgId | 销售组织 | findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
transactionTypeId | 交易类型 | SO021 |
bizFlow | bizFlow | 4420f835-f5e0-11ec-9896-6c92bf477043 |
bizFlow_version | bizFlow_version | V1.0 |
vouchdate | 单据日期 | {{consign_time_new}} |
code | 单据编码 | {{order_no}} |
invoiceTitle | 发票抬头 | 1 |
taxNum | 纳税人识别号 | 1 |
invoiceTelephone | 营业电话 | 1 |
bankName | 开户银行 | 银行 |
subBankName | 银行支行 | 银行支行 |
bankAccount | 银行账号 | 1 |
invoiceAddress | 营业地址 | 地址 |
agentId | 客户 | _findCollection find mapping_customer from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
settlementOrgId | 开票组织 | findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
source | 单据来源 | 4 |
orderPrices!currency | 币种 | CNY |
orderPrices!exchRate | 汇率 | 1 |
orderPrices!exchangeRateType | 汇率类型 | 01 |
orderPrices!natCurrency | 本币 | CNY |
orderPrices!taxInclusive | 单价含税 | true |
invoiceAgentId | 开票客户 | _findCollection find mapping_customer from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
invoiceUpcType | 发票类型 | 1 |
payMoney | 合计含税金额 | {{details.details_list_paid}} |
orderDetails | 销售订单子表 | details_list |
orderDetails.stockId | 仓库 | {{details_list.warehouse_no}} |
orderDetails.isExpiryDateManage | 是否有效期管理 | false |
orderDetails.orderDetailPrices!natSum | 本币含税金额 | {{details_list.total_amount}} |
orderDetails.orderDetailPrices!natMoney | 本币无税金额 | function round({{details_list.total_amount}}/(1+{{details_list.tax_rate}}/100),2) |
orderDetails.productId | 商品 | {{details_list.spec_no}} |
orderDetails.masterUnitId | 主计量单位 | _findCollection find code from f9eedcc9-f1ff-31c0-9081-6aee9cf21740 where name={{details_list.unit_name}} |
orderDetails.invExchRate | 销售换算率 | 1 |
orderDetails.unitExchangeTypePrice | 浮动(销售) | |
orderDetails.orderDetailPrices!oriTax | 税额 | function round(({{details_list.total_amount}}{{details_list.tax_rate}}/100)/(1+{{details_list.tax_rate}}/100),2) |
orderDetails.iProductAuxUnitId | 销售单位 | _findCollection find code from f9eedcc9-f1ff-31c0-9081-6aee9cf21740 where name={{details_list.unit_name}} |
orderDetails.orderDetailPrices!natUnitPrice | 本币无税单价 | function {{details_list.details_list_total_amount}}/(1+{{details_list.details_list_tax_rate}}/100) |
orderDetails.invPriceExchRate | 计价换算率 | 1 |
orderDetails.isBatchManage | 是否批次管理 | false |
orderDetails.oriSum | 含税金额 | {{details_list.total_amount}} |
orderDetails.orderDetailPrices!oriMoney | 无税金额 | _function {{details_list.total_amount}}/(1+{{details_list.tax_rate}}/100) |
orderDetails.priceQty | 计价数量 | {{details_list.goods_count}} |
orderDetails.stockOrgId | 库存组织 | findCollection find org_code from 4f73f755-1c4f-33e6-b5a1-7e3b8d894800 where code={{warehouse_no}} |
orderDetails.iProductUnitId | 计价单位 | _findCollection find code from f9eedcc9-f1ff-31c0-9081-6aee9cf21740 where name={{details_list.unit_name}} |
orderDetails.orderDetailPrices!natTaxUnitPrice | 本币含税单价 | function round(({{details_list.total_amount}}/{{details_list.goods_count}}),6) |
orderDetails.orderProductType | 商品售卖类型 | SALE |
orderDetails.subQty | 销售数量 | {{details_list.goods_count}} |
orderDetails.consignTime | 计划发货日期 | {{details_list.consign_time_new}} |
orderDetails.skuId | 商品SKUid或SKUcode | {{details_list.spec_no}} |
orderDetails.taxId | 税目税率 | {{details_list.tax_rate}} |
orderDetails.qty | 数量 | {{details_list.goods_count}} |
orderDetails.settlementOrgId | 开票组织 | _findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
orderDetails.oriTaxUnitPrice | 含税成交价 | function round({{details_list.total_amount}}/{{details_list.goods_count}},2) |
orderDetails.orderDetailPrices!natTax | 本币税额 | _function round(({{details_list.total_amount}}*{{details_list.tax_rate}}/100)/(1+{{details_list.tax_rate}}/100),2) |
orderDetails.unitExchangeType | 浮动(计价) | |
orderDetails.orderDetailPrices!oriUnitPrice | 无税成交价 | function round(({{details_list.total_amount}}/{{details_list.goods_count}})/(1+{{details_list.tax_rate}}/100),2) |
orderDetails.salesOrgId | 销售组织 | _findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
orderDetails.status | 操作标识 | Insert |
orderDetails.memo | 备注 | {{details_list.batch_no}} |
orderDetails.batch_no | batch_no | |
orderDetails.producedate | producedate | |
orderDetails.invaliddate | invaliddate | |
orderDetails._status | 操作标识 | Insert |
orderDetails.memo | 备注 | {{warehouse_no}} |
orderDetails.headFreeItem!define1 | 销售类型 | 网店销售 |