数据表:ims_yz_package_deliver_bonus(自提点--自提点分红)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | - | - | |
uid | integer | - | - | |
pd_id | integer | - | - | package_deliver.id |
order_id | integer | - | - | yz_order.id |
order_goods_id | integer unsigned | - | - | 订单商品ID |
order_sn | string(100) | - | - | 订单编号 |
original_amount | decimal | 0.00 | - | 提成总金额 |
dividend_rate | decimal | 0.00 | - | 提成比率 |
amount | decimal | - | - | 实际提成金额 |
status | integer | - | - | 提成状态 |
create_month | string(255) | - | - | 创建时间用于分组 |
amount_info | string(255) | - | - | 商品有独立设置,提成算法记录 |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - | |
reward_type | boolean | 0 | 非空 | 奖励类型 -1未知 0收入 1可用爱心值 |
reward_detail | text(65535) | - | - | 奖励明细 |
