app.models.bank_statement module

BankStatement and BankTransaction ORM models.

class app.models.bank_statement.BankStatement(**kwargs)

Bases: UUIDPrimaryKeyMixin, Base

Statement-level metadata extracted from a CSV bank statement.

account_holder: Mapped[str | None]

account_number: Mapped[str | None]

bank_name: Mapped[str | None]

closing_balance: Mapped[Decimal | None]

currency: Mapped[str | None]

detected_delimiter: Mapped[str | None]

detected_encoding: Mapped[str | None]

detected_format: Mapped[str | None]

document: Mapped[Document]

document_id: Mapped[UUID]

extracted_at: Mapped[datetime]

id

opening_balance: Mapped[Decimal | None]

processing_job: Mapped[ProcessingJob]

processing_job_id: Mapped[UUID]

raw_headers: Mapped[dict[str, Any] | None]

statement_from: Mapped[date | None]

statement_to: Mapped[date | None]

total_rows_parsed: Mapped[int | None]

total_rows_skipped: Mapped[int | None]

transactions: Mapped[list[BankTransaction]]

updated_at: Mapped[datetime]

class app.models.bank_statement.BankTransaction(**kwargs)

Bases: UUIDPrimaryKeyMixin, Base

Individual transaction row from a bank statement CSV.

amount: Mapped[Decimal]

balance_after: Mapped[Decimal | None]

bank_statement: Mapped[BankStatement]

bank_statement_id: Mapped[UUID]

created_at: Mapped[datetime]

currency: Mapped[str | None]

description: Mapped[str | None]

direction: Mapped[str]

id: Mapped[UUID]

parse_warnings: Mapped[list[str] | None]

raw_description: Mapped[str | None]

reference_number: Mapped[str | None]

row_index: Mapped[int]

transaction_date: Mapped[date]

transaction_type: Mapped[TransactionType]

value_date: Mapped[date | None]