|
id
|
int(11)
|
|
|
|
|
account_id
|
int(11)
|
|
|
|
|
transfer_account_id
|
int(11)
|
|
|
|
|
type
|
varchar(255)
|
|
|
|
|
number
|
varchar(255)
|
|
|
|
|
date
|
date
|
|
|
|
|
payee
|
varchar(255)
|
|
|
|
|
amount
|
decimal(10,2)
|
|
|
|
|
amount2
|
decimal(10,2)
|
|
|
|
|
exchange_rate
|
decimal(10,2)
|
|
|
1.00
|
|
category_id
|
int(11)
|
|
|
|
|
sub_category_id
|
int(11)
|
|
|
|
|
sub_sub_category_id
|
int(11)
|
|
|
|
|
info
|
mediumtext
|
|
|
|
|
document
|
varchar(155)
|
|
|
|
|
document_file
|
longblob
|
|
|
Binary - do not edit (0 B)
(Max: 4,096MiB)
|
|
status
|
int(11)
|
|
|
1
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
2026-02-10 11:42:41.000000
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|
|
TransactionID
|
int(11)
|
|
|
|