Table: dbo.Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction
This table will hold all the pending unmatched keyed-in data in the Rapid Clear dialog for a given bank reconciliation. This data will be deleted for finalized bank reconciliations.
Columns
Name | Type | Constraints | Description
bank_reconciliation_rapid_clear_unmatched_transaction_KEY | int (4) | NOT NULL | Primary key
bank_reconciliation_statement_KEY | int (4) | NOT NULL | Foreign key to the associated bank reconciliation statement.
impound__client_KEY | int (4) |  | Client key for IBAR, null for BAR.
gl_balance_effect_KEY | int (4) | NOT NULL | Foreign key to the GL_Balance_Effect table. 1 if the transaction is a debit, 2 if it is a credit.
reference_number | nvarchar (32) | NOT NULL | Reference number for debits, empty string for credits.
amount | decimal (9, 2) | NOT NULL | Amount keyed-in by the user.

Primary key
Name | Columns | Description
PK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction | bank_reconciliation_rapid_clear_unmatched_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEY | bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__Client__impound__client_KEY | impound__client_KEY | Client (client_KEY) |
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__GL_Balance_Effect__gl_balance_effect_KEY | gl_balance_effect_KEY | GL_Balance_Effect (gl_balance_effect_KEY) |