|
id
|
int(11)
|
|
|
|
|
account_code
|
varchar(20)
|
|
|
|
|
period_month
|
tinyint(4)
|
|
|
|
|
period_year
|
smallint(6)
|
|
|
|
|
statement_date
|
date
|
|
|
|
|
statement_balance
|
decimal(14,2)
|
|
|
0.00
|
|
book_balance
|
decimal(14,2)
|
|
|
0.00
|
|
status
|
enum
|
-- |
|
draft
|
|
notes
|
text
|
|
|
|
|
reconciled_by
|
int(11)
|
|
|
|
|
reconciled_at
|
timestamp
|
|
|
|
|
journal_entry_id
|
int(11)
|
|
|
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|