resubmitCheckKey | 保证请求的幂等性 | {{refund_no}} |
code | 单据编码 | {{refund_no}} |
salesOrgId | 销售组织 | findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
transactionTypeId | 交易类型 | 1480261131563434158 |
agentId | 客户 | _findCollection find mapping_customer from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
retailInvestors | 是否散户 | |
headFreeItem!define2 | 销售类型 | {{remark}} |
saleDepartmentId | 销售部门 | |
vouchdate | 单据日期 | {{modified}} |
corpContact | 销售业务员 | |
settlementOrgId | 开票组织 | findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
currency | 币种 | CNY |
exchangeRateType | 汇率类型 | 01 |
natCurrency | 本币 | CNY |
retailAgentName | 散户名称 | _findCollection find shop_name from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
saleReturnMemo | 备注 | |
saleReturnMemo.remark | 备注 | |
saleReturnMemo.refundStatus | 退货单退款状态 | NONE |
saleReturnMemo.refundAmount | 退款金额 | |
saleReturnMemo.isWfControlled | 是否受审批流控制 | false |
saleReturnMemo.exchRate | 汇率 | 1 |
saleReturnMemo.taxInclusive | 单价含税 | true |
saleReturnMemo.saleReturnSourceType | 退货类型 | NONE |
saleReturnMemo.bizFlow_name | 流程名称 | 销售退货 |
saleReturnMemo.bizFlow_version | 版本信息 | V1.0 |
saleReturnMemo.logisticWayId | 物流公司id | |
saleReturnMemo.invoiceAgentId | 开票客户 | findCollection find mapping_customer from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
saleReturnMemo.realMoney | 应付金额 | |
saleReturnMemo.modifyInvoiceType | 发票类型是否可改 | |
saleReturnMemo.logisticsBillNo | 物流单号 | |
saleReturnMemo.logisticsUserName | 司机姓名 | |
saleReturnMemo.logisticsUserPhone | 司机电话 | |
saleReturnMemo.logisticsCarNum | 车牌号 | |
saleReturnMemo.receiver | 收货人 | |
saleReturnMemo.receiveMobile | 收货人移动电话 | |
saleReturnMemo.receiveTelePhone | 收货人固定电话 | |
saleReturnMemo.receiveAddress | 收货地址 | |
saleReturnMemo.receiveZipCode | 收货人邮编 | |
saleReturnMemo.bdInvoiceTypeId | 发票类型 | |
saleReturnMemo.invoiceUpcType | 发票类型 | |
saleReturnMemo.invoiceTitleType | 抬头类型 | |
saleReturnMemo.invoiceTitle | 发票抬头 | 1 |
saleReturnMemo.taxNum | 纳税识别号 | 1 |
saleReturnMemo.bankName | 开户银行 | 银行 |
saleReturnMemo.subBankName | 开户支行 | 银行支行 |
saleReturnMemo.bankAccount | 账号 | 1 |
saleReturnMemo.invoiceTelephone | 营业电话 | 1 |
saleReturnMemo.invoiceAddress | 营业地址 | 地址 |
saleReturnMemo.totalMoney | 总金额 | |
saleReturnMemo.payMoney | 退货金额 | {{actual_refund_amount}} |
saleReturnMemo.totalMoneyOrigTaxfree | 无税总金额 | |
saleReturnMemo.payMoneyOrigTaxfree | 无税退货金额 | |
saleReturnMemo.totalOriTax | 税额 | |
saleReturnMemo.totalMoneyDomestic | 本币总金额 | |
saleReturnMemo.payMoneyDomestic | 本币退货金额 | |
saleReturnMemo.totalMoneyDomesticTaxfree | 本币无税总金额 | |
saleReturnMemo.payMoneyDomesticTaxfree | 本币无税退货金额 | |
saleReturnMemo.totalNatTax | 本币税额 | |
saleReturnMemo.bizFlow | 流程ID | e88e9d81-f134-11ec-9896-6c92bf477043 |
saleReturnMemo.isFlowCoreBill | 是否流程核心单据 | |
saleReturnMemo.headFreeItem!define5 | 原始单号 | {{tid}} |
saleReturnMemo._status | 操作标识 | Insert |
saleReturnMemo.saleReturnDetails | 退货单详情 | refund_order_list |
saleReturnMemo.saleReturnDetails.id | 表体行ID | |
saleReturnMemo.saleReturnDetails.orderDetailId | 订单行id | |
saleReturnMemo.saleReturnDetails.orderDetailIdKey | 订单行idkey | |
saleReturnMemo.saleReturnDetails.sourceid | 来源单据ID | |
saleReturnMemo.saleReturnDetails.sourceautoid | 来源单据子表ID | |
saleReturnMemo.saleReturnDetails.source | 来源单据类型 | |
saleReturnMemo.saleReturnDetails.makeRuleCode | 生单类型编码 | |
saleReturnMemo.saleReturnDetails.productId | 商品 | {{refund_order_list.refund_order_list_spec_no}} |
saleReturnMemo.saleReturnDetails.skuId | 商品sku | {{refund_order_list.refund_order_list_spec_no}} |
saleReturnMemo.saleReturnDetails.projectId | 项目 | |
saleReturnMemo.saleReturnDetails.unitExchangeType | 浮动换算率(销售) | |
saleReturnMemo.saleReturnDetails.unitExchangeTypePrice | 浮动换算率(计价) | |
saleReturnMemo.saleReturnDetails.taxId | 税目税率 | VAT13 |
saleReturnMemo.saleReturnDetails.stockId | 仓库 | {{warehouse_no}} |
saleReturnMemo.saleReturnDetails.stockOrgId | 库存组织 | findCollection find org_code from 4f73f755-1c4f-33e6-b5a1-7e3b8d894800 where code={{warehouse_no}} |
saleReturnMemo.saleReturnDetails.saleReturnDepartmentId | 退货部门id | |
saleReturnMemo.saleReturnDetails.iProductAuxUnitId | 销售单位 | 1483333416136474627 |
saleReturnMemo.saleReturnDetails.iProductUnitId | 计价单位 | 1483333416136474627 |
saleReturnMemo.saleReturnDetails.masterUnitId | 主计量单位 | 1483333416136474627 |
saleReturnMemo.saleReturnDetails.orderProductType | 商品类型 | SALE |
saleReturnMemo.saleReturnDetails.bizProductId | 商家商品id | |
saleReturnMemo.saleReturnDetails.salesOrgId | 销售组织 | _findCollection find mapping_sale_org from 4769a428-14c4-33b8-91fd-e8da3b39d5cb where shop_no={{shop_no}} |
saleReturnMemo.saleReturnDetails.enable | 是否有效状态 | |
saleReturnMemo.saleReturnDetails.orderNo | 源头订单号 | |
saleReturnMemo.saleReturnDetails.upcode | 来源单据号 | |
saleReturnMemo.saleReturnDetails.modelDescription | 规格 | |
saleReturnMemo.saleReturnDetails.model | 型号 | |
saleReturnMemo.saleReturnDetails.specDescription | 规格描述 | |
saleReturnMemo.saleReturnDetails.invExchRate | 销售换算率 | 1 |
saleReturnMemo.saleReturnDetails.subQty | 退货销售数量 | {{refund_order_list.refund_order_list_refund_num}} |
saleReturnMemo.saleReturnDetails.invPriceExchRate | 计价换算率 | 1 |
saleReturnMemo.saleReturnDetails.priceQty | 退货计价数量 | {{refund_order_list.refund_order_list_refund_num}} |
saleReturnMemo.saleReturnDetails.qty | 退货数量 | {{refund_order_list.refund_order_list_refund_num}} |
saleReturnMemo.saleReturnDetails.batchNo | 批次 | |
saleReturnMemo.saleReturnDetails.isExpiryDateManage | 是否有效期管理 | |
saleReturnMemo.saleReturnDetails.productDate | 生产日期 | |
saleReturnMemo.saleReturnDetails.expireDateNo | 保质期 | |
saleReturnMemo.saleReturnDetails.expireDateUnit | 保质期单位 | |
saleReturnMemo.saleReturnDetails.invalidDate | 有效期至 | |
saleReturnMemo.saleReturnDetails.oriTaxUnitPrice | 含税成交价 | function round((round({{refund_order_list.refund_order_list_refund_order_amount}},2)/{{refund_order_list.refund_order_list_refund_num}}),2) |
saleReturnMemo.saleReturnDetails.oriUnitPrice | 无税单价 | _function round((round({{refund_order_list.refund_order_list_refund_order_amount}},2)/{{refund_order_list.refund_order_list_refund_num}})/1.13,2) |
saleReturnMemo.saleReturnDetails.oriSum | 含税金额 | function round({{refund_order_list.refund_order_list_refund_order_amount}},2) |
saleReturnMemo.saleReturnDetails.oriMoney | 无税金额 | _function round(round({{refund_order_list.refund_order_list_refund_order_amount}},2)/1.13,2) |
saleReturnMemo.saleReturnDetails.oriTax | 税额 | function abs(round(round({{refund_order_list.refund_order_list_refund_order_amount}},2)/1.13,2)-round({{refund_order_list.refund_order_list_refund_order_amount}},2)) |
saleReturnMemo.saleReturnDetails.natTaxUnitPrice | 本币含税单价 | _function round((round({{refund_order_list.refund_order_list_refund_order_amount}},2)/{{refund_order_list.refund_order_list_refund_num}}),2) |
saleReturnMemo.saleReturnDetails.natUnitPrice | 本币无税单价 | function round((round({{refund_order_list.refund_order_list_refund_order_amount}},2)/{{refund_order_list.refund_order_list_refund_num}})/1.13,2) |
saleReturnMemo.saleReturnDetails.natSum | 本币含税金额 | _function round({{refund_order_list.refund_order_list_refund_order_amount}},2) |
saleReturnMemo.saleReturnDetails.natMoney | 本币无税金额 | function round(round({{refund_order_list.refund_order_list_refund_order_amount}},2)/1.13,2) |
saleReturnMemo.saleReturnDetails.natTax | 本币税额 | _function round(round({{refund_order_list.refund_order_list_refund_order_amount}},2)/1.13*0.13,2) |
saleReturnMemo.saleReturnDetails.retNotNeedInvoiceQty | 退货不开票数量 | |
saleReturnMemo.saleReturnDetails.firstsourceid | 源头单据id | |
saleReturnMemo.saleReturnDetails.firstsourceautoid | 源头单据子表id | |
saleReturnMemo.saleReturnDetails.firstsource | 源头单据类型 | |
saleReturnMemo.saleReturnDetails.firstupcode | 源头单据号 | {{refund_no}} |
saleReturnMemo.saleReturnDetails.orderId | 销售订单id | |
saleReturnMemo.saleReturnDetails.bodyFreeItem!define1 | 表体备注 | {{refund_order_list.refund_order_list_remark}} |
saleReturnMemo.saleReturnDetails.bodyFreeItem!define3 | 子订单号 | {{refund_order_list.refund_order_list_oid}} |
saleReturnMemo.saleReturnDetails.bodyFreeItem!define4 | 原始订单 | {{refund_order_list.refund_order_list_tid}} |
saleReturnMemo.saleReturnDetails.bodyFreeItem!define5 | 旺店通行内码 | {{refund_order_list.refund_order_list_order_id}} |
saleReturnMemo.saleReturnDetails._status | 操作标识, Insert:新增、Update:更新 示例:Insert | Insert |