console_dailyinventory
日盘单
所属应用: console
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | ID | int(10) unsigned | Y | Y | |
| dailyinventory_bn | 日盘单号 | varchar(32) | Y | N | |
| channel_id | channel_id | int(10) unsigned | Y | N | |
| channel_bn | channel_bn | varchar(100) | Y | N | |
| channel_type | 类型 wms:仓库;store:门店; | enum('wms','store') | N | wms | N |
| stock_date | 日期 | DATE | N | N | |
| oms_stock | 系统库存 | int(11) | N | 0 | N |
| outer_stock | 外部库存 | int(11) | N | 0 | N |
| diff_stock | 库存差异 | int(11) | N | 0 | N |
| is_diff | 存在差异 | enum('0','1') | N | 0 | N |
| at_time | 创建时间 | TIMESTAMP | N | CURRENT_TIMESTAMP | N |
| up_time | 更新时间 | TIMESTAMP | N | CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_dlyinv_bn | dailyinventory_bn | Y | |
| ind_uni | stock_date, channel_id, channel_type | Y |
