console_difference_items_freeze
盘点差异单明细冻结
所属应用: console
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | ID | mediumint(8) | Y | Y | |
| diff_id | 盘点差异单ID | mediumint(8) | N | N | |
| di_id | 盘点差异单明细ID | mediumint(8) | N | N | |
| branch_id | 盘点库存 | mediumint(8) unsigned | N | N | |
| bm_id | 基础物料ID | int(10) unsigned | N | N | |
| material_bn | 基础物料编码 | varchar(200) | N | N | |
| freeze_num | 冻结 | mediumint(9) | N | N | |
| out_status | 出库单 0:;1:生成失败; | enum('0','1') | N | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| idx_c_diff_id | diff_id | N | |
| idx_c_di_id | di_id | N | |
| idx_c_branch_id | branch_id | N |