order_id | 订单ID | | 订单ID |
order_no | 订单号 | | 订单号 |
name | 订单名称 | | 订单名称 |
exchange_rate | 汇率 | | 汇率 |
exchange_rate_usd | 汇率美元 | | 汇率美元 |
users | 业绩归属人 | | 业绩归属人 |
users.rate | 业绩归属人业绩占比 | | 业绩归属人业绩占比 |
users.user_id | 业绩归属人UserId | | 业绩归属人UserId |
users.users_info | 业绩归属人信息 | | 业绩归属人信息 |
users.users_info.rate | 业绩归属人业绩占比 | | 业绩归属人业绩占比 |
users.users_info.user_id | 业绩归属人UserId | | 业绩归属人UserId |
users.users_info.nickname | 业绩归属人昵称 | | 业绩归属人昵称 |
users.users_info.handler_info | 订单跟进人信息 | | 订单跟进人信息 |
users.users_info.handler_info.user_id | 订单跟进人UserId | | 订单跟进人UserId |
users.users_info.handler_info.nickname | 订单跟进人昵称| | 订单跟进人昵称| |
users.users_info.handler_info.company | 客户公司信息 | | 客户公司信息 |
users.users_info.handler_info.company.company_id | 客户ID | | 客户ID |
users.users_info.handler_info.company.name | 客户公司名称 | | 客户公司名称 |
users.users_info.handler_info.company.status_info | 订单状态信息 | | 订单状态信息 |
users.users_info.handler_info.company.status_info.id | 订单状态ID | | 订单状态ID |
users.users_info.handler_info.company.status_info.name | 订单状态名称 | | 订单状态名称 |
users.users_info.handler_info.company.status_info.currency | 货币 | | 货币 |
users.users_info.handler_info.company.status_info.amount | 订单金额 | | 订单金额 |
users.users_info.handler_info.company.status_info.amount_rmb | 订单金额(RMB) | | 订单金额(RMB) |
users.users_info.handler_info.company.status_info.amount_usd | 订单金额(美元) | | 订单金额(美元) |
users.users_info.handler_info.company.status_info.addition_cost_amount | 附加费用总金额 | | 附加费用总金额 |
users.users_info.handler_info.company.status_info.product_total_amount | 产品总金额 | | 产品总金额 |
users.users_info.handler_info.company.status_info.product_total_count | 产品总数量 | | 产品总数量 |
users.users_info.handler_info.company.status_info.price_contract | 价格条款 | | 价格条款 |
users.users_info.handler_info.company.status_info.receive_remittance_way | 收汇方式 | | 收汇方式 |
users.users_info.handler_info.company.status_info.price_contract_remark | 价格条款说明 | | 价格条款说明 |
users.users_info.handler_info.company.status_info.receive_remittance_remark | 收汇方式说明 | | 收汇方式说明 |
users.users_info.handler_info.company.status_info.insurance_remark | 保险说明 | | 保险说明 |
users.users_info.handler_info.company.status_info.bank_info | 银行信息 | | 银行信息 |
users.users_info.handler_info.company.status_info.order_contract | 订单条款 | | 订单条款 |
users.users_info.handler_info.company.status_info.company_name | 客户名称 | | 客户名称 |
users.users_info.handler_info.company.status_info.company_phone | 客户电话 | | 客户电话 |
users.users_info.handler_info.company.status_info.company_fax | 客户传真 | | 客户传真 |
users.users_info.handler_info.company.status_info.company_address | 客户地址 | | 客户地址 |
users.users_info.handler_info.company.status_info.customer_name | 联系人名称 | | 联系人名称 |
users.users_info.handler_info.company.status_info.customer_phone | 联系人电话 | | 联系人电话 |
users.users_info.handler_info.company.status_info.customer_email | 联系人邮箱 | | 联系人邮箱 |
users.users_info.handler_info.company.status_info.customer_address | 联系人地址 | | 联系人地址 |
users.users_info.handler_info.company.status_info.transport_mode | 运输方式 | | 运输方式 |
users.users_info.handler_info.company.status_info.shipment_deadline | 装运期限 | | 装运期限 |
users.users_info.handler_info.company.status_info.shipment_port | 装运港口 | | 装运港口 |
users.users_info.handler_info.company.status_info.target_port | 目的港口 | | 目的港口 |
users.users_info.handler_info.company.status_info.shipment_deadline_remark | 装运期限说明 | | 装运期限说明 |
users.users_info.handler_info.company.status_info.more_or_less | 溢短装 | | 溢短装 |
users.users_info.handler_info.company.status_info.package_remark | 包装说明 | | 包装说明 |
users.users_info.handler_info.company.status_info.marked | 唛头 | | 唛头 |
users.users_info.handler_info.company.status_info.account_date | 结单日期 | | 结单日期 |
users.users_info.handler_info.company.status_info.create_time | 创建日期 | | 创建日期 |
users.users_info.handler_info.company.status_info.update_time | 更新日期 | | 更新日期 |
users.users_info.handler_info.company.status_info.product_list | 产品明细数据 | | |
users.users_info.handler_info.company.status_info.product_list.unit | 单位 | | |
users.users_info.handler_info.company.status_info.product_list.count | 数量 | | |
users.users_info.handler_info.company.status_info.product_list.product_id | 产品id | | |
users.users_info.handler_info.company.status_info.product_list.product_no | 产品编码 | | |
users.users_info.handler_info.company.status_info.product_list.unit_price | 单价 | | |
users.users_info.handler_info.company.status_info.product_list.cost_amount | 金额 | | |
users.users_info.handler_info.company.status_info.product_list.description | 描述 | | |
users.users_info.handler_info.company.status_info.product_list.package_unit | 装箱单位 | | |
users.users_info.handler_info.company.status_info.product_list.product_name | 产品名称 | | |
users.users_info.handler_info.company.status_info.product_list.cost_with_tax | 税率 | | |