purchase_purchase_refunds

退款单

所属应用: purchase

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
refund_id	refund_id	mediumint(8) unsigned	Y		Y
refund_bn	退款单编号	varchar(32)	Y		N
rp_id	退货单ID	mediumint(8) unsigned	N		N
add_time	制单日期	int(10) unsigned	N		N
supplier_id	供应商	mediumint(8) unsigned	N		N
po_type	采购方式 cash:现购;credit:赊购;	enum('cash','credit')	N		N
type	退货方式 po:入库取消;eo:采购退货;iso:直接出库;	enum('po','eo','iso')	N		N
operator	经办人	varchar(50)	N		N
payment	payment	mediumint(8) unsigned	N		N
paymethod	paymethod	varchar(100)	N		N
refund	结算金额	decimal(20,3)	N		N
product_cost	商品总额	decimal(20,3)	N	0	N
delivery_cost	物流费用	decimal(20,3)	N	0	N
op_id	op_id	mediumint(8) unsigned	N		N
statement_time	结算日期	int(10) unsigned	N		N
bank_no	银行账号	varchar(50)	N		N
statement_status	结算状态 1:未结算;2:已结算;3:拒绝结算;	enum('1','2','3')	Y	1	N
memo	memo	longtext	N		N

索引

Key name	Column names	Unique	Comment
primary	refund_id	Y
ind_refund_bn	refund_bn	N
ind_po_type	po_type	N
ind_statement_status	statement_status	N
idx_c_rp_id	rp_id	N
idx_c_supplier_id	supplier_id	N
idx_c_payment	payment	N
idx_c_op_id	op_id	N