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
Name | Type | Constraints | Description
bank_transaction_template_reconciliation_detail_KEY | int (4) | NOT NULL | Primary key.
transaction_template_KEY | int (4) | NOT NULL | Key of the bank transaction template parent.
description | nvarchar (240) | NOT NULL | The description of the reconciliation detail record.
amount | decimal (9, 2) | NOT NULL | The amount of the reconciliation detail record.
sequence_number | int (4) | NOT NULL | A value that orders the reconciliation detail records linked to a specific bank transaction template record.

Primary key
Name | Columns | Description
PK_Bank_Transaction_Template_Reconciliation_Detail | bank_transaction_template_reconciliation_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Transaction_Template_Reconciliation_Detail$transaction_template_KEY$sequence_number | transaction_template_KEY, sequence_number |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Transaction_Template_Reconciliation_Detail__Bank_Transaction_Template__transaction_template_KEY | transaction_template_KEY | Bank_Transaction_Template (transaction_template_KEY) |