purchase_statement

结算单

所属应用: purchase

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
statement_id	ID	mediumint(8) unsigned	Y		Y
supplier_id	供应商ID	mediumint(8) unsigned	Y		N
supplier_bn	供应商编号	varchar(32)	N		N
object_bn	单据号	varchar(32)	N		N
statement_time	结算时间	int(10) unsigned	N		N
object_type	业务类型 1:赊购入库;2:现款结算;3:采购退货;	enum('1','2','3')	Y	1	N
object_id	object_id	mediumint(8) unsigned	N		N
initial_pay	期初应付	decimal(20,3)	N		N
pay_add	本期增加应付	decimal(20,3)	N		N
paid	本期已付	decimal(20,3)	N		N
final_pay	期末应付	decimal(20,3)	N		N
initial_receive	期初应收	decimal(20,3)	N		N
receive_add	本期增加应收	decimal(20,3)	N		N
received	本期已收	decimal(20,3)	N		N
final_receive	期末应收	decimal(20,3)	N		N
difference	差额	decimal(20,3)	N		N

索引

Key name	Column names	Unique	Comment
primary	statement_id	Y
ind_object_id	object_id	N
ind_object_type	object_type	N
idx_c_supplier_id	supplier_id	N