purchase_po_items

采购单明细

所属应用: purchase

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_id	item_id	int(10) unsigned	Y		Y
po_id	po_id	mediumint(8) unsigned	Y		N
product_id	product_id	int(10) unsigned	Y		N
num	num	mediumint(8) unsigned	Y		N
in_num	in_num	mediumint(8) unsigned	Y	0	N
out_num	out_num	mediumint(8) unsigned	Y	0	N
price	price	decimal(20,3)	Y		N
purchasing_price	采购进价	decimal(20,3)	N	0.000	N
status	采购详情状态 1:待入库;2:部分入库;3:完成入库;	enum('1','2','3')	N		N
barcode	条形码	varchar(32)	N		N
bn	货号	varchar(30)	N		N
name	货品名称	varchar(200)	N		N
spec_info	货品描述	longtext	N		N
memo	memo	text	N		N
defective_num	不良品	mediumint(8) unsigned	Y	0	N

索引

Key name	Column names	Unique	Comment
primary	item_id	Y
ind_status	status	N
idx_c_po_id	po_id	N
idx_c_product_id	product_id	N