|
id
|
int(10) unsigned
|
|
|
|
|
store_id
|
int(10) unsigned
|
|
|
|
|
ref_no
|
varchar(32)
|
|
|
|
|
status
|
enum
|
-- |
|
open
|
|
opened_by
|
int(10)
|
|
|
|
|
closed_by
|
int(10)
|
|
|
|
|
opened_at
|
datetime
|
|
|
2026-06-10 10:01:42.000000
|
|
closed_at
|
datetime
|
|
|
|
|
opening_cash
|
decimal(25,4)
|
|
|
0.0000
|
|
opening_note
|
text
|
|
|
|
|
expected_cash
|
decimal(25,4)
|
|
|
|
|
expected_total
|
decimal(25,4)
|
|
|
|
|
counted_cash
|
decimal(25,4)
|
|
|
|
|
counted_total
|
decimal(25,4)
|
|
|
|
|
difference_amount
|
decimal(25,4)
|
|
|
|
|
closing_note
|
text
|
|
|
|
|
summary_snapshot
|
longtext
|
|
|
|
|
created_at
|
datetime
|
|
|
2026-06-10 10:01:42.000000
|
|
updated_at
|
datetime
|
|
|
|