bank_transaction_KEY | int (4) | NOT NULL | Primary key |
transaction_date | smalldatetime (4) | | Date of the transaction |
bank_transaction_type_KEY | int (4) | NOT NULL | The type of bank transaction |
checkbook_KEY | int (4) | NOT NULL | The checkbook/bank account the transaction is associated with |
transaction_status_KEY | int (4) | NOT NULL | The current status of the bank transaction |
amount | decimal (9, 2) | NOT NULL | The amount of the transaction |
reference_number | nvarchar (32) | NOT NULL | Either a reference or check number depending on transaction type |
memo | nvarchar (480) | NOT NULL | A memo associated with the transaction |
description | nvarchar (240) | NOT NULL | The transaction description or name of the payee, depending on transaction type |
is_handwritten_check | bit (1) | NOT NULL | Indicates whether or not a withdrawal is a handwritten check |
edited_ach_effective_date | smalldatetime (4) | | Effective date of the transaction if edited by the user - null otherwise |
funding_processed_status_KEY | int (4) | NOT NULL | Funding electronic processing status values: 0 - tx has not been processed, 1 - tx has been funded but not processed, 2 - tx has been processed, 3 - do not ever process this tx cuz it was created before funding was set up. |
export_journal_entry_to_csa_status_KEY | int (4) | NOT NULL | The export status of the bank transaction. |
bank_transaction_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
are_bank_reconciliation_details_overridden_by_user | bit (1) | NOT NULL | Did the user override the system generated bank reconciliation detail for this bank transaction? This flag is set to false (0) if the bank transaction's bank reconciliation detail has been automatically generated by the system; it is set to true (1) if the detail was entered by the user. If set to true, then it is up the developer to make sure the bank reconciliation detail stays in sync with the bank transaction; the system will not automatically make adustments as the bank transaction's amount or description changes. |
data_origin_KEY | int (4) | NOT NULL | The origin of each bank transaction. For example, Data Entry or CSA Conversion. |
sent_check_stub_to_employee_self_service | bit (1) | NOT NULL | This flag is set to 1 (true) for pay checks that have been transmitted to Employee Self Service. It is set to 0 (false) for pay checks that haven't been sent yet and for all other transaction types. |
reference_number_sortable | nvarchar (160) | NOT NULL | A representation of the reference_number column that sorts in natural order. A trigger keeps this field synchronized with the content of reference_number. |
origin__accounting_application_KEY | int (4) | | The application that was running when the bank transaction was created. |
generated_by__transaction_template_KEY | int (4) | | If we created the bank transaction from a template, and the template has not been deleted, then this is the key of the template we used. Otherwise, it will be null. |
auto_clear_in_bank_rec | bit (1) | NOT NULL | This flag determines how the transaction is treated by the Bank Reconciliation process. If true, the transaction is automatically marked cleared during the next Bank Reconciliation session; if false, the transaction is left uncleared and the user will have to manually clear it. |
exported_to_quick_books | bit (1) | NOT NULL | This flag should be true if the transaction has been exported to quickbooks. It should be false otherwise. |
check_output_type_KEY | int (4) | | Specifies the printed mode of the transactions having type as Payroll/Vendor checks (Paper/Remote). If null then the transactions are of some other types. |
is_proxy_for_a_distribution | bit (1) | NOT NULL | True when the only purpose of the transaction is to affect checkbook balance, but not account balances. Otherwise, false. |
bank_reconciliation_clear_status_KEY | int (4) | NOT NULL | Used to track if the aggregate clear status of matching Bank_Transaction_Reconciliation_Detail rows. |
skip_negative_funding | bit (1) | NOT NULL | A bool flag to indicate whether or not to create negative funding when reversing a check. |