purchase_purchase_payments

付款单

所属应用: purchase

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
payment_id	payment_id	mediumint(8) unsigned	Y		Y
payment_bn	付款单编号	varchar(32)	Y		N
po_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
operator	经办人	varchar(50)	N		N
payable	应付金额	decimal(20,3)	N		N
product_cost	商品费用	decimal(20,3)	N	0	N
delivery_cost	物流费用	decimal(20,3)	N	0	N
deposit	预付金额	decimal(20,3)	N		N
paid	结算金额	decimal(20,3)	N		N
statement_time	结算日期	int(10) unsigned	N		N
balance	结算余额	decimal(20,3)	N		N
memo	memo	longtext	N		N
payment	payment	mediumint(8) unsigned	N		N
paymethod	paymethod	varchar(100)	N		N
op_id	op_id	mediumint(8) unsigned	N		N
statement_status	结算状态 1:未结算;2:已结算;3:拒绝结算;4:部分结算;	enum('1','2','3','4')	Y	1	N
tax_no	发票号	varchar(50)	N		N
bank_no	银行账号	varchar(50)	N		N
logi_no	物流运单号	varchar(50)	N		N
disabled	是否失效	enum('true','false')	N	false	N

索引

Key name	Column names	Unique	Comment
primary	payment_id	Y
ind_payment_bn	payment_bn	N
ind_statement_status	statement_status	N
idx_c_po_id	po_id	N
idx_c_supplier_id	supplier_id	N
idx_c_payment	payment	N
idx_c_op_id	op_id	N