Table: dbo.Bank_Transaction_Reconciliation_Detail
This table is primarily for Bank Rec use. Its purpose is for partial clearing of a bank transaction. The records in this table define the smallest granularity at which a bank transaction can be cleared. For some types of transactions, the system defines the contents of this table; for others, the user is allowed to enter what they wish.
Columns
Name | Type | Constraints | Description
bank_transaction_reconciliation_detail_KEY | int (4) | NOT NULL | Primary key
bank_transaction_KEY | int (4) | NOT NULL | The parent bank transaction
description | nvarchar (240) | NOT NULL | Description of the transaction detail
amount | decimal (9, 2) | NOT NULL | The amount of the transaction detail
bank_reconciliation_statement_KEY | int (4) |  | Links us to the bank reconciliation in which this item was cleared.
sequence_number | int (4) | NOT NULL | Sequence number that determines the order within the transaction details
source__direct_deposit_bank_transaction_allocation_KEY | int (4) |  | If the source of this detail record was a direct deposit allocation (either an allocation from the parent bank transaction or, in the case of funding, from another bank transaction), then this foreign key will be point to said allocation. Otherwise, this key will be set to NULL.
source__bank_transaction_KEY | int (4) |  | If the source of this detail record was another bank transaction (a funding deposit, a funding payment, the paper portion of a direct deposit check), then this foreign key will be point to said bank transaction. Otherwise, this key will be set to NULL.

Primary key
Name | Columns | Description
PK_Bank_Transaction_Reconciliation_Detail | bank_transaction_reconciliation_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Transaction_Reconciliation_Detail__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEY | bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |
FK_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__bank_transaction_KEY | source__bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Bank_Transaction_Reconciliation_Detail__Direct_Deposit_Bank_Transaction_Allocation__source__direct_deposit_bank_transaction_a | source__direct_deposit_bank_transaction_allocation_KEY | Direct_Deposit_Bank_Transaction_Allocation (direct_deposit_bank_transaction_allocation_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Reconciliation_Detail__bank_transaction_reconciliation_detail_KEY | bank_transaction_reconciliation_detail_KEY | Bank_Reconciliation_Statement_Detail |
FK_BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__Bank_Transaction_Reconciliation_Detail__bank_transactio | bank_transaction_reconciliation_detail_KEY | BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source |