console_vopbill_amount

唯品会账单明细

所属应用: console

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	主键id	bigint(20) unsigned	Y		Y
bill_id	唯品会账单	int(10) unsigned	N		N
bill_number	唯品会账单	varchar(50)	N		N
barcode	itemNo	varchar(255)	N		N
product_name	itemDescription	varchar(255)	N		N
detail_line_type	行类型	varchar(255)	N		N
detail_line_name	行类型名称	varchar(255)	N		N
shop_id	店铺	varchar(32)	N		N
qty	数量	decimal(20,3)	N		N
amount	含税金额	decimal(20,2)	N	0	N
discount_amount	折扣金额	decimal(20,2)	N	0	N
total_amount	合计金额	decimal(20,2)	N	0	N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_bill_id	bill_id	N
ind_barcode	barcode	N
ind_detail_line_type_unique	detail_line_type, bill_id, barcode	Y
ind_detail_line_name	detail_line_name	N
idx_c_shop_id	shop_id	N