Table: dbo.Bank_Transaction_Reconciliation_Detail
This table is primarily for Bank Rec use. Its purpose is for partial clearing of a bank transaction. The records in this table define the smallest granularity at which a bank transaction can be cleared. For some types of transactions, the system defines the contents of this table; for others, the user is allowed to enter what they wish.
Columns
NameTypeConstraintsDescription
bank_transaction_reconciliation_detail_KEYint (4)NOT NULLPrimary key
bank_transaction_KEYint (4)NOT NULLThe parent bank transaction
descriptionnvarchar (240)NOT NULLDescription of the transaction detail
amountdecimal (9, 2)NOT NULLThe amount of the transaction detail
bank_reconciliation_statement_KEYint (4)Links us to the bank reconciliation in which this item was cleared.
sequence_numberint (4)NOT NULLSequence number that determines the order within the transaction details
source__direct_deposit_bank_transaction_allocation_KEYint (4)If the source of this detail record was a direct deposit allocation (either an allocation from the parent bank transaction or, in the case of funding, from another bank transaction), then this foreign key will be point to said allocation. Otherwise, this key will be set to NULL.
source__bank_transaction_KEYint (4)If the source of this detail record was another bank transaction (a funding deposit, a funding payment, the paper portion of a direct deposit check), then this foreign key will be point to said bank transaction. Otherwise, this key will be set to NULL.
Primary key
NameColumnsDescription
PK_Bank_Transaction_Reconciliation_Detailbank_transaction_reconciliation_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Transaction_Reconciliation_Detail__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
FK_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__bank_transaction_KEYsource__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Bank_Transaction_Reconciliation_Detail__Direct_Deposit_Bank_Transaction_Allocation__source__direct_deposit_bank_transaction_asource__direct_deposit_bank_transaction_allocation_KEYDirect_Deposit_Bank_Transaction_Allocation (direct_deposit_bank_transaction_allocation_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Reconciliation_Detail__bank_transaction_reconciliation_detail_KEYbank_transaction_reconciliation_detail_KEYBank_Reconciliation_Statement_Detail
FK_BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__Bank_Transaction_Reconciliation_Detail__bank_transactiobank_transaction_reconciliation_detail_KEYBS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source

Schema diagram