| order_no | 订单号 | {{FBillNo}}-test |
| name | 订单名称 | 销售订单 |
| company_id | 客户ID | {{FCustId_FNumber}}11084411386 |
| customer_id | 客户联系人ID | findCollection find customers.0.customer_id from c75f1ee7-ed96-39ea-a1df-cc682ecc91b2 where serial_id={{customerid_number}} |
| currency | 货币 | {{FSettleCurrId}} |
| users | 业绩归属人 | |
| users.user_id | 用户id | 55262069 |
| users.rate | 业绩占比 | 100 |
| users.product_list | 产品子列表 | reftables |
| users.product_list.product_id | 产品ID | _findCollection find product_id from b6fff4b7-68fb-3316-b03c-ae6633c3824c where product_no={{reftables.FMaterialId_Fnumber}} |
| users.product_list.count | 产品数量 | {{reftables.FPriceUnitQty}} |
| users.product_list.unit_price | 产品单价 | {{reftables.FTaxPrice}} |
| users.product_list.cost_amount | 产品金额 | |
| users.product_list.sku_id | 产品SKU ID | |
| users.product_list.物流费 | 物流费 | {{reftables.物流费}} |
| users.product_list.Q1返利 | Q1返利 | {{reftables.Q1返利}} |
| users.product_list.Q2返利 | Q2返利 | {{reftables.Q2返利}} |
| users.product_list.Q3返利 | Q3返利 | {{reftables.Q3返利}} |
| users.product_list.Q4返利 | Q4返利 | {{reftables.Q4返利}} |
| users.product_list.售后费 | 售后费 | {{reftables.售后费}} |
| users.product_list.customer_name | 联系人名称 | {{contact_linkman}} |
| users.product_list.customer_phone | 联系人电话 | {{contact_phone}} |
| users.product_list.exchange_rate | 折现人民币汇率 | function {{FExchangeRate}}100 |
| users.product_list.exchange_rate_usd | 汇率美元 | _function CASE LOCATE('USD','{{currencyid_number}}') WHEN 0 THEN '{{new_exchange_rate}}' ELSE '100' END |
| users.product_list.remark | 备注 | {{remark}} |
| users.product_list.account_date | 订单日期，YYYY-mm-dd | {{billdate date}} |
| users.product_list.cost_list | 费用列表 | |
| users.product_list.cost_list.cost_name | 费用名称 | {{物流费}} |
| users.product_list.cost_list.percent_type | 计算规则0（加（+）绝对值、1加（+）占产品总金额百分比、2减（-）绝对值、3减（-）占产品总金额百分比） | |
| users.product_list.cost_list.percent_amount | 计算金额值，比如1%，那就是产品金额*1% | {{物流费}} |
| users.product_list.cost_list.cost | 金额，根据计算金额计算出来后的费用 | {{物流费}} |
| users.product_list.cost_list.users_info | 业绩归属人信息列表 | |
| users.product_list.cost_list.users_info.user_id | 业绩归属人id | 55262069 |
| users.product_list.cost_list.users_info.rate | 业绩占比 | 100 |
| users.product_list.cost_list.users_info.nickname | 业绩归属人昵称 | {{empid_name}} |
| users.product_list.cost_list.users_info.handler_info | handler_info | |
| users.product_list.cost_list.users_info.handler_info.user_id | 业绩归属人id | 55262069 |
| users.product_list.cost_list.users_info.handler_info.rate | 业绩占比 | 100 |
| users.product_list.cost_list.users_info.handler_info.nickname | 业绩归属人昵称 | {{empid_name}} |
| users.product_list.cost_list.users_info.handler_info.departments | 业绩归属部门信息列表 | |
| users.product_list.cost_list.users_info.handler_info.departments.department_id | 业绩归属部门id | 21928 |
| users.product_list.cost_list.users_info.handler_info.departments.rate | 业绩占比 | 100 |
| users.product_list.cost_list.users_info.handler_info.departments.name | 业绩归属部门名称 | |
| users.product_list.cost_list.users_info.handler_info.departments.handler | 处理人 | 55262069 |
| users.product_list.cost_list.users_info.handler_info.departments.产品折扣费 | 产品折扣费 | {{F_hesh_Discount}} |
