taoguanallocate_appropriation_items

库存调拨单明细

所属应用: taoguanallocate

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_id	item_id	mediumint(8) unsigned	Y		Y
appropriation_id	appropriation_id	mediumint(8) unsigned	Y		N
product_id	product_id	int(10) unsigned	Y		N
bn	bn	varchar(30)	N		N
product_name	product_name	varchar(200)	N		N
from_branch_id	from_branch_id	mediumint(8) unsigned	N		N
from_pos_id	from_pos_id	mediumint(8) unsigned	N		N
to_branch_id	to_branch_id	mediumint(8) unsigned	Y		N
to_pos_id	to_pos_id	mediumint(8) unsigned	Y		N
num	num	mediumint(8) unsigned	N		N
from_branch_num	调出库库存	mediumint(8) unsigned	Y	0	N
to_branch_num	调入库库存	mediumint(8) unsigned	Y	0	N
package_code	箱单号	varchar(200)	N		N

索引

Key name	Column names	Unique	Comment
primary	item_id	Y
idx_c_appropriation_id	appropriation_id	N
idx_c_product_id	product_id	N
idx_c_from_branch_id	from_branch_id	N
idx_c_from_pos_id	from_pos_id	N
idx_c_to_branch_id	to_branch_id	N
idx_c_to_pos_id	to_pos_id	N