Table: dbo.Bank_Reconciliation_Statement_Detail
Columns
Name | Type | Constraints | Description
bank_reconciliation_statement_KEY | int (4) | NOT NULL | Links us to a reconciliation (one bank account, one period).
bank_reconciliation_statement_detail_KEY | int (4) | NOT NULL | The primary key for this table.
bank_transaction_reconciliation_detail_KEY | int (4) | NOT NULL | Links us to the bank transaction detail related to this record.
bank_transaction__bank_transaction_type_KEY | int (4) | NOT NULL | Tells us what this is: check, deposit, or something else.
bank_reconciliation_clear_status_KEY | int (4) | NOT NULL | Tells us if this item is cleared or uncleared in the bank reconciliation to which this record is related.
bank_transaction__transaction_date | smalldatetime (4) | NOT NULL | Bank transaction detail date.
bank_transaction__reference_number | nvarchar (32) | NOT NULL | Bank transaction reference.
bank_transaction_detail__amount | decimal (9, 2) | NOT NULL | Bank transaction detail amount.
bank_transaction_detail__description | nvarchar (240) | NOT NULL | Bank transaction detail description.
cleared_amount | decimal (9, 2) | NOT NULL | Amount that this item was cleared for, but zero if no adjustment was made.
adjustment_amount | decimal (9, 2) | NOT NULL | amount of adjustment, if any.
adjustment__gl_account_KEY | int (4) |  | GL account used if an adjustment is made.
adjustment_reason | nvarchar (240) | NOT NULL | Reason given for an adjustment.
adjustment__bank_transaction_KEY | int (4) |  | Links us to the transaction to which the adjustment was made.
bank_reconciliation_adjustment_type_KEY | int (4) | NOT NULL | The key of the adjustment type
bank_reconciliation_recurring_adjustment_template_KEY | int (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
Name | Columns | Description
PK_Bank_Reconciliation_Statement_Detail | bank_reconciliation_statement_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Reconciliation_Statement_Detail$bank_reconciliation_statement_KEY$bank_transaction_reconciliation_detail_KEY | bank_reconciliation_statement_KEY, bank_transaction_reconciliation_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Adjustment_Type__bank_reconciliation_adjustment_type_KEY | bank_reconciliation_adjustment_type_KEY | Bank_Reconciliation_Adjustment_Type (bank_reconciliation_adjustment_type_KEY) |
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Clear_Status__bank_reconciliation_clear_status_KEY | bank_reconciliation_clear_status_KEY | Bank_Reconciliation_Clear_Status (bank_reconciliation_clear_status_KEY) |
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Recurring_Adjustment_Template__bank_reconciliation_recurring_adjust | bank_reconciliation_recurring_adjustment_template_KEY | Bank_Reconciliation_Recurring_Adjustment_Template (bank_reconciliation_recurring_adjustment_template_KEY) |
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEY | bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction__adjustment__bank_transaction_KEY | adjustment__bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Reconciliation_Detail__bank_transaction_reconciliation_detail_KEY | bank_transaction_reconciliation_detail_KEY | Bank_Transaction_Reconciliation_Detail (bank_transaction_reconciliation_detail_KEY) |
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Type__bank_transaction__bank_transaction_type_KEY | bank_transaction__bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |
FK_Bank_Reconciliation_Statement_Detail__GL_Account__adjustment__gl_account_KEY | adjustment__gl_account_KEY | GL_Account (gl_account_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Reconciliation_Statement_Import__Bank_Reconciliation_Statement_Detail__bank_reconciliation_statement_detail_KEY | bank_reconciliation_statement_detail_KEY | Bank_Reconciliation_Statement_Import |