purchase_pick_stockout_bill_item_boxs
出库单明细装箱信息
所属应用: purchase
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| box_id | box_id | int(10) unsigned | Y | Y | |
| stockout_id | 出库单ID | mediumint(8) unsigned | Y | 0 | N |
| stockout_item_id | 出库单明细ID | mediumint(8) unsigned | Y | 0 | N |
| po_id | 采购单ID | mediumint(8) unsigned | Y | 0 | N |
| bill_id | 拣货单ID | mediumint(8) unsigned | Y | 0 | N |
| box_no | 箱号 | varchar(50) | N | N | |
| num | 数量 | mediumint(8) unsigned | N | 0 | N |
| status | 出库状态 | tinyint(1) | N | 1 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | box_id | Y | |
| ind_stockout_item_id | stockout_item_id | N | |
| ind_stockout_id | stockout_id | N | |
| ind_po_id | po_id | N | |
| ind_bill_id | bill_id | N |