Table: dbo.BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source
This table will only have rows in a CDMU Backup Database. Tracks an outgoing reference to bank transaction data from Bank_Transaction_Reconciliation_Detail. If there is a reconciled firm client transaction from a funded paper net check with source__bank_transaction_KEY pointing to a standard client and it is then reversed we get into a state where a standard client row is referencing firm data through source__bank_transaction_KEY. Backup and restore uses this to link a restored client to data in the firm.
Columns
NameTypeConstraintsDescription
bank_transaction_reconciliation_detail_KEYint (4)NOT NULLThe primary key, referencing the record that in turn references the FK that this table is tracking.
bank_transaction_guiduniqueidentifier (16)NOT NULLThe referenced item, the bank transaction guid.
Primary key
NameColumnsDescription
PK_BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source$bank_transaction_reconciliation_detail_KEYbank_transaction_reconciliation_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__Bank_Transaction_Reconciliation_Detail__bank_transactiobank_transaction_reconciliation_detail_KEYBank_Transaction_Reconciliation_Detail (bank_transaction_reconciliation_detail_KEY)

Schema diagram