console_replenish_diff

补货差异单据表

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
diff_id	ID	int(10) unsigned	Y		Y
task_bn	补货任务号	varchar(30)	Y		N
cpfr_bn	配货单编码	varchar(30)	Y		N
store_bn	门店编码	varchar(20)	Y		N
out_branch_id	调出仓库	mediumint(8) unsigned	Y		N
to_branch_id	调入仓库	mediumint(8) unsigned	N		N
product_id	product_id	int(10) unsigned	Y		N
material_bn	基础物料编码	varchar(30)	Y		N
apply_nums	申请补货数量	mediumint(8) unsigned	N	0	N
finish_nums	最终补货数量	mediumint(8) unsigned	N	0	N
not_nums	未补货数量	mediumint(8) unsigned	N	0	N
create_time	创建时间	int(10) unsigned	N	0	N

索引

Key name	Column names	Unique	Comment
primary	diff_id	Y
in_cpfr_bn	cpfr_bn	N
in_task_bn	task_bn	N
in_store_bn	store_bn	N
in_material_bn	material_bn	N
in_create_time	create_time	N
idx_c_out_branch_id	out_branch_id	N
idx_c_to_branch_id	to_branch_id	N