| Holds manual funding transaction data - used to created bank transactions when manual funding is processed. |
| 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. |