Table: dbo.Manual_Funding_Bank_Transaction
Holds manual funding transaction data - used to created bank transactions when manual funding is processed.
Columns
Name | Type | Constraints | Description
manual_funding_bank_transaction_KEY | int (4) | NOT NULL | Primary Key
description | nvarchar (200) | NOT NULL | The transaction description or name of the payee, depending on transaction type
transaction_date | smalldatetime (4) |  | Date of the transaction
amount | decimal (9, 2) | NOT NULL | The amount of the transaction
checkbook_KEY | int (4) | NOT NULL | The checkbook/bank account the transaction is associated with
funded_transaction_type_KEY | int (4) | NOT NULL | Foreign key to the type of transactions that were funded by this funding transaction
impound__checkbook_KEY | int (4) | NOT NULL | key to impound bank account funding is associated with
funding_processed_status_KEY | int (4) | NOT NULL | Funding electronic processing status - see CK_Funding_Bank_Transaction__funding_processed_status for details.
edited_ach_effective_date | smalldatetime (4) |  | Effective date of the transaction if edited by the user - null otherwise
bank_transaction_KEY | int (4) |  | Bank transaction that paid this allocation.
client_expense__gl_account_KEY | int (4) |  | GL account key for client expense - firm vendor transactions only.
firm_revenue__gl_account_KEY | int (4) |  | GL account key for firm revenue - firm vendor transactions only.
note | nvarchar (480) | NOT NULL | This 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
Name | Columns | Description
PK_Manual_Funding_Bank_Transaction | manual_funding_bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Manual_Funding_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Manual_Funding_Bank_Transaction__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Manual_Funding_Bank_Transaction__Checkbook__impound__checkbook_KEY | impound__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Manual_Funding_Bank_Transaction__Funded_Transaction_Type__funded_transaction_type_KEY | funded_transaction_type_KEY | Funded_Transaction_Type (funded_transaction_type_KEY) |
FK_Manual_Funding_Bank_Transaction__Funding_Processed_Status__funding_processed_status_KEY | funding_processed_status_KEY | Funding_Processed_Status (funding_processed_status_KEY) |
FK_Manual_Funding_Bank_Transaction__GL_Account__client_expense__gl_account_KEY | client_expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Manual_Funding_Bank_Transaction__GL_Account__firm_revenue__gl_account_KEY | firm_revenue__gl_account_KEY | GL_Account (gl_account_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record__Manual_Funding_Bank_Transaction__manual_funding_bank_transaction_K | manual_funding_bank_transaction_KEY | Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record |