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