ome_delivery_items_detail

发货单明细详情,用于存储以订单行明细纬度数量.如:合单发货会以订单行明细平铺

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_detail_id	自增主键ID	int(10) unsigned	Y		Y
delivery_id	发货单ID,关联ome_delivery.delivery_id	int(10) unsigned	Y		N
delivery_item_id	发货单明细ID,关联ome_delivery_items.item_id	int(10) unsigned	Y		N
order_id	订单ID,关联ome_orders.order_id	int(10) unsigned	Y		N
order_item_id	订单明细ID,关联ome_order_items.item_id	int(10) unsigned	Y		N
order_obj_id	订单子单ID,关联ome_order_objects.obj_id	int(10) unsigned	Y		N
item_type	订单行明细类型,可选值:product(商品),pkg(捆绑商品),gift(赠品),giftpackage(礼包),lkb(福袋),pko(多选一)	varchar(50)	Y	product	N
product_id	基础物料ID,关联material_basic_material.bm_id	int(10) unsigned	Y		N
bn	基础物料编码	varchar(200)	N		N
number	需发货数	mediumint(8) unsigned	Y		N
price	订单行明细零售价	decimal(20,3)	Y	0	N
amount	订单行明细零售小计,公式: price * number	decimal(20,3)	Y	0	N
is_wms_gift	是否WMS赠品	enum('true','false')	N	false	N
oid	子订单号	varchar(50)	N	0	N
s_type	销售类型	varchar(50)	N	zx	N
divide_order_fee	实付金额	decimal(20,3)	N	0	N
divide_user_fee	用户实付	decimal(20,3)	N	0	N
retail_price	零售价	decimal(20,3)	N	0	N
origin_amount	货品单件价格	decimal(20,3)	N	0.00	N
total_price	行小计,公式: price * number	decimal(20,3)	N	0.00	N
total_promotion_amount	SKU商品优惠小计	decimal(20,3)	N	0.00	N

索引

Key name	Column names	Unique	Comment
primary	item_detail_id	Y
ind_delivery_item_id	delivery_item_id	N
ind_order_item_id	order_item_id	N
ind_order_obj_id	order_obj_id	N
ind_oid	oid	N
idx_c_delivery_id	delivery_id	N
idx_c_order_id	order_id	N
idx_c_product_id	product_id	N