Table: dbo.Bank_Transaction
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Bank_Transaction | bank_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Transaction$bank_transaction_guid | bank_transaction_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Transaction__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Accounting_Application (accounting_application_KEY) |
FK_Bank_Transaction__Bank_Transaction_Type__bank_transaction_type_KEY | bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |
FK_Bank_Transaction__Check_Output_Type__check_output_type_KEY | check_output_type_KEY | Check_Output_Type (check_output_type_KEY) |
FK_Bank_Transaction__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Bank_Transaction__Data_Origin__data_origin_KEY | data_origin_KEY | Data_Origin (data_origin_KEY) |
FK_Bank_Transaction__Export_Journal_Entry_To_Csa_Status__export_journal_entry_to_csa_status_KEY | export_journal_entry_to_csa_status_KEY | Export_Journal_Entry_To_Csa_Status (export_journal_entry_to_csa_status_KEY) |
FK_Bank_Transaction__Funding_Processed_Status__funding_processed_status_KEY | funding_processed_status_KEY | Funding_Processed_Status (funding_processed_status_KEY) |
FK_Bank_Transaction__Transaction_Status__transaction_status_KEY | transaction_status_KEY | Transaction_Status (transaction_status_KEY) |
FK_Bank_Transaction__Transaction_Template__generated_by__transaction_template_KEY | generated_by__transaction_template_KEY | Transaction_Template (transaction_template_KEY) |
FK_Bank_Transaction__Bank_Reconciliation_Clear_Status__bank_reconciliation_clear_status_KEY | bank_reconciliation_clear_status_KEY | Bank_Reconciliation_Clear_Status (bank_reconciliation_clear_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Feeds_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Feeds_Bank_Transaction |
FK_Web_Employee_Check_Stub_Queue__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Web_Employee_Check_Stub_Queue |
FK_Initial_Open_Item_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Initial_Open_Item_Bank_Transaction |
FK_Quick_Books_Online_Exported_Journal_Entry__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Quick_Books_Online_Exported_Journal_Entry |
FK_GL_Transaction_N_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | GL_Transaction_N_Bank_Transaction |
FK_Direct_Deposit_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Direct_Deposit_Bank_Transaction |
FK_Transfer_Bank_Transaction__Bank_Transaction__client__bank_transaction_KEY | client__bank_transaction_KEY | Transfer_Bank_Transaction |
FK_Transfer_Bank_Transaction__Bank_Transaction__impound__bank_transaction_KEY | impound__bank_transaction_KEY | Transfer_Bank_Transaction |
FK_Positive_Pay_File_Detail__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Positive_Pay_File_Detail |
FK_Reprintable_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Reprintable_Bank_Transaction |
FK_Workforce_Hub_Check_Stub_Queue__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Workforce_Hub_Check_Stub_Queue |
FK_GL_Balancing_Entry_N_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | GL_Balancing_Entry_N_Bank_Transaction |
FK_Check_Print_Run_N_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Check_Print_Run_N_Bank_Transaction |
FK_Manual_Funding_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Manual_Funding_Bank_Transaction |
FK_Funding_Withdrawal_Bank_Transaction_Detail__Bank_Transaction__detail__bank_transaction_KEY | detail__bank_transaction_KEY | Funding_Withdrawal_Bank_Transaction_Detail |
FK_Funding_Withdrawal_Bank_Transaction_Detail__Bank_Transaction__funding_withdrawal__bank_transaction_KEY | funding_withdrawal__bank_transaction_KEY | Funding_Withdrawal_Bank_Transaction_Detail |
FK_Bank_Transaction_Reversal__Bank_Transaction__reversal__bank_transaction_KEY | reversal__bank_transaction_KEY | Bank_Transaction_Reversal |
FK_Bank_Transaction_Reversal__Bank_Transaction__reversed__bank_transaction_KEY | reversed__bank_transaction_KEY | Bank_Transaction_Reversal |
FK_Impound_Payment_Client_Bank_Transaction_Detail__Bank_Transaction__client__bank_transaction_KEY | client__bank_transaction_KEY | Impound_Payment_Client_Bank_Transaction_Detail |
FK_Impound_Payment_Client_Bank_Transaction_Detail__Bank_Transaction__impound__bank_transaction_KEY | impound__bank_transaction_KEY | Impound_Payment_Client_Bank_Transaction_Detail |
FK_Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution |
FK_Form_1099_Print_Threshold_Override__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Form_1099_Print_Threshold_Override |
FK_Bank_Transaction_Event__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction_Event |
FK_Bank_Reconciliation_Adjustment_Order__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Reconciliation_Adjustment_Order |
FK_AR_Payment__Bank_Transaction__ar_deposit__bank_transaction_KEY | ar_deposit__bank_transaction_KEY | AR_Payment |
FK_Ach_Entry_Detail_Record__Bank_Transaction__bank_rec_funded_deposit_detail__bank_transaction_KEY | bank_rec_funded_deposit_detail__bank_transaction_KEY | Ach_Entry_Detail_Record |
FK_Bank_Transaction_Distribution__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction_Distribution |
FK_Bank_Transaction_Address__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction_Address |
FK_Form_1099__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Form_1099 |
FK_Bank_Transaction_Accounting_Source_Override_Bank_Transaction_Distribution__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction_Accounting_Source_Override_Bank_Transaction_Distribution |
FK_Payroll_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction |
FK_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction_Reconciliation_Detail |
FK_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__bank_transaction_KEY | source__bank_transaction_KEY | Bank_Transaction_Reconciliation_Detail |
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction__adjustment__bank_transaction_KEY | adjustment__bank_transaction_KEY | Bank_Reconciliation_Statement_Detail |
FK_Vendor_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Vendor_Bank_Transaction |
FK_Print_Payable_Transaction_Selection__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Print_Payable_Transaction_Selection |
FK_Funding_Withdrawal_Liability_Detail__Bank_Transaction__funding_withdrawal__bank_transaction_KEY | funding_withdrawal__bank_transaction_KEY | Funding_Withdrawal_Liability_Detail |
FK_Print_Check_Selection__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Print_Check_Selection |