purchase_inventory

盘点表

所属应用: purchase

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
inventory_id	inventory_id	mediumint(8) unsigned	Y		Y
inventory_name	盘点名称	varchar(100)	Y		N
inventory_bn	盘点单编号	varchar(32)	Y		N
inventory_date	盘点日期	int(10) unsigned	N		N
inventory_checker	盘点人	varchar(20)	N		N
second_checker	复核人	varchar(20)	N		N
finance_dept	财务负责人	varchar(20)	N		N
warehousing_dept	仓库负责人	varchar(20)	N		N
difference	差异金额	decimal(20,3)	N		N
op_id	操作工号	mediumint(8) unsigned	N		N
op_name	工号姓名	varchar(20)	N		N
branch_id	盘点仓库ID	mediumint(8) unsigned	N		N
branch_name	盘点仓库	varchar(60)	N		N
inventory_type	盘点类别 1:自定义;2:全盘;3:在线盘点;	enum('1','2','3')	Y	1	N
confirm_status	确认状态 1:未确认;2:已确认;	enum('1','2')	Y	1	N
confirm_op	确认工号	mediumint(8) unsigned	N		N
confirm_time	确认时间	int(10) unsigned	N		N
import_status	导入状态 0:正在导入;1:失败;2:成功;	enum('0','1','2')	Y	0	N
update_status	库存更新 0:更新中;1:失败;2:成功;	enum('0','1','2')	Y	0	N
is_create	盘点表 1:未生成;2:已生成;	enum('1','2')	Y	2	N
inventory_overview	盘点概况	text	N		N
memo	memo	longtext	N		N

索引

Key name	Column names	Unique	Comment
primary	inventory_id	Y
ind_inventory_bn	inventory_bn	N
ind_inventory_date	inventory_date	N
ind_inventory_checker	inventory_checker	N
ind_inventory_type	inventory_type	N
ind_confirm_status	confirm_status	N
ind_import_status	import_status	N
ind_update_status	update_status	N
ind_branch_name	branch_name	N
idx_c_op_id	op_id	N
idx_c_branch_id	branch_id	N
idx_c_confirm_op	confirm_op	N