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
NameTypeConstraintsDescription
bank_reconciliation_rapid_clear_unmatched_transaction_KEYint (4)NOT NULLPrimary key
bank_reconciliation_statement_KEYint (4)NOT NULLForeign key to the associated bank reconciliation statement.
impound__client_KEYint (4)Client key for IBAR, null for BAR.
gl_balance_effect_KEYint (4)NOT NULLForeign key to the GL_Balance_Effect table. 1 if the transaction is a debit, 2 if it is a credit.
reference_numbernvarchar (32)NOT NULLReference number for debits, empty string for credits.
amountdecimal (9, 2)NOT NULLAmount keyed-in by the user.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transactionbank_reconciliation_rapid_clear_unmatched_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__Client__impound__client_KEYimpound__client_KEYClient (client_KEY)
FK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction__GL_Balance_Effect__gl_balance_effect_KEYgl_balance_effect_KEYGL_Balance_Effect (gl_balance_effect_KEY)

Schema diagram