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. |