Table: dbo.Manual_Funding_Bank_Transaction
Holds manual funding transaction data - used to created bank transactions when manual funding is processed.
Columns
NameTypeConstraintsDescription
manual_funding_bank_transaction_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (200)NOT NULLThe transaction description or name of the payee, depending on transaction type
transaction_datesmalldatetime (4)Date of the transaction
amountdecimal (9, 2)NOT NULLThe amount of the transaction
checkbook_KEYint (4)NOT NULLThe checkbook/bank account the transaction is associated with
funded_transaction_type_KEYint (4)NOT NULLForeign key to the type of transactions that were funded by this funding transaction
impound__checkbook_KEYint (4)NOT NULLkey to impound bank account funding is associated with
funding_processed_status_KEYint (4)NOT NULLFunding electronic processing status - see CK_Funding_Bank_Transaction__funding_processed_status for details.
edited_ach_effective_datesmalldatetime (4)Effective date of the transaction if edited by the user - null otherwise
bank_transaction_KEYint (4)Bank transaction that paid this allocation.
client_expense__gl_account_KEYint (4)GL account key for client expense - firm vendor transactions only.
firm_revenue__gl_account_KEYint (4)GL account key for firm revenue - firm vendor transactions only.
notenvarchar (480)NOT NULLThis column will provide the freedom to describe the reason for adding manual funding transaction which will be processed later while creating ACH file and escalate to Gl_Transaction_Note table.
Primary key
NameColumnsDescription
PK_Manual_Funding_Bank_Transactionmanual_funding_bank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Manual_Funding_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Manual_Funding_Bank_Transaction__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Manual_Funding_Bank_Transaction__Checkbook__impound__checkbook_KEYimpound__checkbook_KEYCheckbook (checkbook_KEY)
FK_Manual_Funding_Bank_Transaction__Funded_Transaction_Type__funded_transaction_type_KEYfunded_transaction_type_KEYFunded_Transaction_Type (funded_transaction_type_KEY)
FK_Manual_Funding_Bank_Transaction__Funding_Processed_Status__funding_processed_status_KEYfunding_processed_status_KEYFunding_Processed_Status (funding_processed_status_KEY)
FK_Manual_Funding_Bank_Transaction__GL_Account__client_expense__gl_account_KEYclient_expense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Manual_Funding_Bank_Transaction__GL_Account__firm_revenue__gl_account_KEYfirm_revenue__gl_account_KEYGL_Account (gl_account_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record__Manual_Funding_Bank_Transaction__manual_funding_bank_transaction_Kmanual_funding_bank_transaction_KEYManual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record

Schema diagram