| This table's purpose is to allow the direct deposit funding UI to use the standard filtering mechanism.["BR"] WARNING - if this table is modified, use-defined table type dbo.Direct_Deposit_Fundable_Transactions and stored procedure["BR"] dbo.pb_Insert_Direct_Deposit_Fundable_Transactions also needs to be updated to maintain identical structure. |
| direct_deposit_fundable_transaction_KEY | int (4) | NOT NULL | The primary key. |
| user_session_guid | uniqueidentifier (16) | NOT NULL | Guid which ties a particular user session to a table row. |
| client_id | nvarchar (22) | NOT NULL | Client ID. |
| client_name | nvarchar (100) | NOT NULL | Client name. |
| funding_type__description | nvarchar (40) | NOT NULL | Funding type description |
| transaction_date | smalldatetime (4) | | Date the direct deposit transaction was created. |
| impound_bank_account__description | nvarchar (100) | NOT NULL | Name of the impound bank account |
| client_bank_account__description | nvarchar (100) | NOT NULL | Name of the client bank account. |
| transaction_reference | nvarchar (80) | NOT NULL | Reference number associated with the transaction, usually a check number. |
| transaction_amount | decimal (9, 2) | NOT NULL | Amount being transferred between accounts. |
| payee_id_number | nvarchar (30) | NOT NULL | Identifier associated with the payee (EIN, TIN, etc.) |
| payee_name | nvarchar (200) | NOT NULL | Name of the payee. |
| effective_date | smalldatetime (4) | | Date of the direct deposit transaction. |