biweeklybudget.models.ofx_statement module

class biweeklybudget.models.ofx_statement.OFXStatement(**kwargs)

Bases: sqlalchemy.ext.declarative.api.Base, biweeklybudget.models.base.ModelAsDict

_sa_class_manager = {'account': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300150>, 'account_id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300258>, 'acct_type': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e13006d0>, 'acctid': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300830>, 'as_of': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300990>, 'avail_bal': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300ba0>, 'avail_bal_as_of': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300c50>, 'bankid': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300570>, 'brokerid': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300780>, 'currency': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e13004c0>, 'file_mtime': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300410>, 'filename': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300360>, 'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300200>, 'ledger_bal': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300a40>, 'ledger_bal_as_of': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300af0>, 'ofx_trans': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4df12e200>, 'routing_number': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e1300620>, 'type': <sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x7fb4e13008e0>}

account

Relationship to the Account this statement is for

account_id

Foreign key - Account.id - ID of the account this statement is for

acct_type

Textual account type, from the bank (i.e. “Checking”)

acctid

Institution’s account ID

as_of

Last OFX statement datetime

avail_bal

Available balance

avail_bal_as_of

as-of date for the available balance

bankid

FID of the Institution

brokerid

BrokerID, for investment accounts

currency

Currency definition (“USD”)

file_mtime

File mtime

filename

Filename parsed from

id

Unique ID

ledger_bal

Ledger balance, or investment account value

ledger_bal_as_of

as-of date for the ledger balance

ofx_trans

routing_number

Routing Number

type

Account Type, string corresponding to ofxparser.ofxparser.AccountType