console_stockdump

库存出入库单列表

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
stockdump_id	stockdump_id	mediumint(8) unsigned	Y		Y
stockdump_bn	编号	varchar(20)	Y		N
create_time	生成日期	int(10) unsigned	N		N
operator_name	操作人员	varchar(50)	N		N
in_status	单据状态 0:未入库;1:已入库;2:失败;	enum('0','1','2')	N	0	N
self_status	取消状态 0:取消;1:生效;2:关闭;	enum('0','1','2')	N	1	N
from_branch_id	from_branch_id	mediumint(8) unsigned	N		N
to_branch_id	to_branch_id	mediumint(8) unsigned	N		N
from_branch_name	调出仓库	varchar(30)	N		N
to_branch_name	调入仓库	varchar(30)	N		N
from_physics_id	调出方门店	int(10) unsigned	N		N
to_physics_id	调入方门店	int(10) unsigned	N		N
transfer_channel	移库单类型,branch_yk:仓库，store_yk:门店	varchar(25)	N	branch_yk	N
source_from	单据来源 pc:PC发起;store:门店;	enum('pc','store')	N	pc	N
confirm_type	确认状态 0:无需确认;1:未确认;2:已确认;	enum('0','1','2')	N	1	N
confirm_name	确认人	varchar(30)	N		N
confirm_time	确认日期	int(10) unsigned	N		N
response_time	出入库响应时间	int(10) unsigned	N		N
memo	memo	longtext	N		N
branch_memo	branch_memo	longtext	N		N
sync_status	同步状态 nosync:未同步;running:运行中;fail:失败;success:成功;	enum('nosync','running','fail','success')	N	nosync	N
up_time	更新时间	TIMESTAMP	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	stockdump_id	Y
ind_stockdump_bn	stockdump_bn	Y
ind_create_time	create_time	N
ind_confirm_type	confirm_type	N
ind_confirm_time	confirm_time	N
idx_c_from_branch_id	from_branch_id	N
idx_c_to_branch_id	to_branch_id	N
idx_c_from_physics_id	from_physics_id	N
idx_c_to_physics_id	to_physics_id	N