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
Name | Type | Constraints | Description
bank_transaction_reconciliation_detail_KEY | int (4) | NOT NULL | The primary key, referencing the record that in turn references the FK that this table is tracking.
bank_transaction_guid | uniqueidentifier (16) | NOT NULL | The referenced item, the bank transaction guid.

Primary key
Name | Columns | Description
PK_BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source$bank_transaction_reconciliation_detail_KEY | bank_transaction_reconciliation_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_BS_Bank_Transaction_Reconciliation_Detail__Bank_Transaction__source__Bank_Transaction_Reconciliation_Detail__bank_transactio | bank_transaction_reconciliation_detail_KEY | Bank_Transaction_Reconciliation_Detail (bank_transaction_reconciliation_detail_KEY) |