console_stock_account_items

盘点申请表

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
items_id	items_id	mediumint(8) unsigned	Y		Y
batch	批次号	varchar(64)	N		N
account_bn	商品货号	varchar(32)	Y		N
account_time	日期	int(10) unsigned	N		N
original_goods_stock	仓库良品数量	mediumint(9)	N	0	N
account_goods_stock	良品数量	mediumint(9)	N	0	N
goods_diff_nums	良品差异	mediumint(9)	N	0	N
original_rejects_stock	仓库不良品数量	mediumint(9)	N	0	N
account_rejects_stock	不良品数量	mediumint(9)	N	0	N
rejects_diff_nums	不良品差异	mediumint(9)	N	0	N
wms_id	WMS	varchar(32)	N		N
warehouse_code	WMS仓库编码	varchar(32)	Y		N

索引

Key name	Column names	Unique	Comment
primary	items_id	Y
ind_bacth_bn	batch, account_bn	N
ind_account_time	account_time	N