console_replenish_suggest_items

补货建议单据表

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_id	ID	int(10) unsigned	Y		Y
sug_id	sug_id	int(10) unsigned	N		N
bm_id	bm_id	int(10) unsigned	Y		N
material_bn	基础物料编码	varchar(30)	Y		N
store_num	门店可用库存	mediumint(8) unsigned	N	0	N
apply_nums	申请补货数量	mediumint(8) unsigned	N	0	N
reple_nums	实际补货数量	mediumint(8) unsigned	N	0	N
price	price	decimal(20,3)	N		N

索引

Key name	Column names	Unique	Comment
primary	item_id	Y
in_material_bn	material_bn	N