|
id
|
int(11)
|
|
|
|
|
user_id
|
int(11)
|
|
|
|
|
opening_balance
|
decimal(10,2)
|
|
|
|
|
opening_time
|
timestamp
|
|
|
current_timestamp()
|
|
closing_time
|
timestamp
|
|
|
|
|
status
|
enum
|
-- |
|
open
|
|
expected_closing_balance
|
decimal(10,2)
|
|
|
0.00
|
|
actual_closing_balance
|
decimal(10,2)
|
|
|
0.00
|
|
difference
|
decimal(10,2)
|
|
|
0.00
|
|
note
|
text
|
|
|
|
|
base_amount
|
decimal(10,2)
|
|
|
0.00
|
|
closing_amount
|
decimal(10,2)
|
|
|
|
|
notes
|
text
|
|
|
|
|
opened_by
|
int(11)
|
|
|
|
|
closed_by
|
int(11)
|
|
|
|