
Bank Transactions table
id
transaction_date
reference
amount
type
description
reconciled
created_at
updated_at
linked_sales_batch_id
linked_expense_id
linked_payment_id
reconciliation_status
linked_financial_transaction_id


Financial Transactions
id
transaction_date
account_id
type
amount
payment_method
account
description
reference_id
store_id
created_by
status
created_at
updated_at
reconciliation_status
linked_bank_transaction_id
debit
credit
linked_sale_id
linked_bank_txn_id


sales items
id
transaction_id
product_id
quantity
unit_price
discount
vat_rate
total_price
created_at


sales transactions
id
store_id
sold_by
customer_name
receipt_number
total_amount
discount_total
vat_total
payment_method
created_at
transaction_type
status
customer_id
amount_paid