| id | pkey | false | true | | | 1.81.18 | a unique identifier for the transaction |
| time | time | false | false | | | 1.0a100 | the time the transaction occured |
| account | string | false | false | bank_accounts.name | | 1.81.18 | the account the transaction is for |
| processor | string | true | false | credit_card_processors.provider_id | | 1.29 | the credit card processor used by this transaction |
| administrator | username | false | false | master_users.username | | 1.0a100 | the business_administrator who made this transaction |
| type | string | false | false | bank_transaction_types.name | | 1.0a100 | the type of transaction |
| expenseCategory | string | true | false | expense_categories.name | | 1.81.18 | the category in which this expense belongs |
| description | string | false | false | | | 1.0a100 | a description of the transaction |
| checkNo | string | true | false | | | 1.81.18 | the check number (if available) |
| amount | decimal_2 | false | false | | | 1.0a100 | the amount (negative for withdrawal) |
| confirmed | boolean | false | false | | | 1.0a100 | the confirmation status with bank |
