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) |