console_difference_items

盘点差异单明细

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	ID	mediumint(8)	Y		Y
diff_id	盘点差异单ID	int(10) unsigned	Y		N
bm_id	基础物料ID	int(10) unsigned	N		N
material_bn	基础物料编码	varchar(200)	N		N
wms_stores	WMS库存	mediumint(9)	N		N
oms_stores	系统库存	mediumint(9)	N		N
diff_stores	wms实物差异	mediumint(9)	N		N
oms_diff_stores	oms实物差异	mediumint(9)	N		N
number	数量	mediumint(9)	N		N
pos_accounts_num	POS账面数	mediumint(8)	N		N
batch	batch	text	N		N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_diff_id	diff_id	N
ind_bm_id	bm_id	N
ind_material_bn	material_bn	N