|
id
|
int(11)
|
|
|
|
|
payment_number
|
varchar(30)
|
|
|
|
|
supplier_id
|
int(11)
|
|
|
浏览不相关的值
|
|
invoice_id
|
int(11)
|
|
|
|
|
payment_date
|
date
|
|
|
|
|
amount
|
decimal(14,2)
|
|
|
|
|
payment_method
|
enum
|
-- |
|
bank_transfer
|
|
bank_account
|
varchar(100)
|
|
|
|
|
reference_number
|
varchar(100)
|
|
|
|
|
journal_entry_id
|
int(11)
|
|
|
|
|
notes
|
text
|
|
|
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|