Table: dbo.Bank_Transaction_Template_Reconciliation_Detail
This table contains records that denote if the user wishes to clear the whole transaction amount in bank reconciliation, or whether it wants the option of partially clearing the bank transaction.
Columns
NameTypeConstraintsDescription
bank_transaction_template_reconciliation_detail_KEYint (4)NOT NULLPrimary key.
transaction_template_KEYint (4)NOT NULLKey of the bank transaction template parent.
descriptionnvarchar (240)NOT NULLThe description of the reconciliation detail record.
amountdecimal (9, 2)NOT NULLThe amount of the reconciliation detail record.
sequence_numberint (4)NOT NULLA value that orders the reconciliation detail records linked to a specific bank transaction template record.
Primary key
NameColumnsDescription
PK_Bank_Transaction_Template_Reconciliation_Detailbank_transaction_template_reconciliation_detail_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Transaction_Template_Reconciliation_Detail$transaction_template_KEY$sequence_numbertransaction_template_KEY, sequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Transaction_Template_Reconciliation_Detail__Bank_Transaction_Template__transaction_template_KEYtransaction_template_KEYBank_Transaction_Template (transaction_template_KEY)

Schema diagram