Table: dbo.Bank_Reconciliation_Statement_Detail
Columns
NameTypeConstraintsDescription
bank_reconciliation_statement_KEYint (4)NOT NULLLinks us to a reconciliation (one bank account, one period).
bank_reconciliation_statement_detail_KEYint (4)NOT NULLThe primary key for this table.
bank_transaction_reconciliation_detail_KEYint (4)NOT NULLLinks us to the bank transaction detail related to this record.
bank_transaction__bank_transaction_type_KEYint (4)NOT NULLTells us what this is: check, deposit, or something else.
bank_reconciliation_clear_status_KEYint (4)NOT NULLTells us if this item is cleared or uncleared in the bank reconciliation to which this record is related.
bank_transaction__transaction_datesmalldatetime (4)NOT NULLBank transaction detail date.
bank_transaction__reference_numbernvarchar (32)NOT NULLBank transaction reference.
bank_transaction_detail__amountdecimal (9, 2)NOT NULLBank transaction detail amount.
bank_transaction_detail__descriptionnvarchar (240)NOT NULLBank transaction detail description.
cleared_amountdecimal (9, 2)NOT NULLAmount that this item was cleared for, but zero if no adjustment was made.
adjustment_amountdecimal (9, 2)NOT NULLamount of adjustment, if any.
adjustment__gl_account_KEYint (4)GL account used if an adjustment is made.
adjustment_reasonnvarchar (240)NOT NULLReason given for an adjustment.
adjustment__bank_transaction_KEYint (4)Links us to the transaction to which the adjustment was made.
bank_reconciliation_adjustment_type_KEYint (4)NOT NULLThe key of the adjustment type
bank_reconciliation_recurring_adjustment_template_KEYint (4)The key of the adjustment template, if any. This is only set non-null when the adjustment is a recurring adjustment, to provide linkage to the appropriate recurring adjustment template.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Statement_Detailbank_reconciliation_statement_detail_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Reconciliation_Statement_Detail$bank_reconciliation_statement_KEY$bank_transaction_reconciliation_detail_KEYbank_reconciliation_statement_KEY, bank_transaction_reconciliation_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Adjustment_Type__bank_reconciliation_adjustment_type_KEYbank_reconciliation_adjustment_type_KEYBank_Reconciliation_Adjustment_Type (bank_reconciliation_adjustment_type_KEY)
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Clear_Status__bank_reconciliation_clear_status_KEYbank_reconciliation_clear_status_KEYBank_Reconciliation_Clear_Status (bank_reconciliation_clear_status_KEY)
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Recurring_Adjustment_Template__bank_reconciliation_recurring_adjustbank_reconciliation_recurring_adjustment_template_KEYBank_Reconciliation_Recurring_Adjustment_Template (bank_reconciliation_recurring_adjustment_template_KEY)
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction__adjustment__bank_transaction_KEYadjustment__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Reconciliation_Detail__bank_transaction_reconciliation_detail_KEYbank_transaction_reconciliation_detail_KEYBank_Transaction_Reconciliation_Detail (bank_transaction_reconciliation_detail_KEY)
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Type__bank_transaction__bank_transaction_type_KEYbank_transaction__bank_transaction_type_KEYBank_Transaction_Type (bank_transaction_type_KEY)
FK_Bank_Reconciliation_Statement_Detail__GL_Account__adjustment__gl_account_KEYadjustment__gl_account_KEYGL_Account (gl_account_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Reconciliation_Statement_Import__Bank_Reconciliation_Statement_Detail__bank_reconciliation_statement_detail_KEYbank_reconciliation_statement_detail_KEYBank_Reconciliation_Statement_Import

Schema diagram