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