console_cpfr_items
配货单明细表
所属应用: console
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| item_id | item_id | mediumint(8) unsigned | Y | Y | |
| cpfr_id | cpfr_id | int(10) unsigned | Y | N | |
| store_bn | 门店编码 | varchar(20) | N | N | |
| to_branch_id | 调入仓库 | mediumint(8) unsigned | N | N | |
| bn | 货号 | varchar(30) | N | N | |
| product_id | product_id | int(10) unsigned | Y | N | |
| num | 实际补货数量 | mediumint(8) unsigned | Y | 0 | N |
| original_num | 申请补货数量 | mediumint(8) unsigned | Y | 0 | N |
| reple_nums | 建议补货数量 | mediumint(8) unsigned | N | 0 | N |
| from_branch_store | 调出仓库存 | mediumint(8) unsigned | N | 0 | N |
| to_branch_store | 调入仓库存 | mediumint(8) unsigned | N | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | item_id | Y | |
| idx_to_branch_id | to_branch_id | N | |
| idx_cpfr_store_bn | cpfr_id, store_bn | N | |
| idx_c_cpfr_id | cpfr_id | N |