Table: dbo.BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record
Tracks an outgoing reference to ACH data in FK_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEY. Backup and restore uses this to link a restored client to ACH data.
Columns
NameTypeConstraintsDescription
direct_deposit_bank_transaction_allocation_KEYint (4)NOT NULLThe primary key, referencing the record that in turn references the FK that this table is tracking.
ach_company_batch_header_record_guiduniqueidentifier (16)NOT NULLThe referenced item, unique across all databases.
Primary key
NameColumnsDescription
PK_BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record$direct_deposit_bank_transaction_allocation_KEYdirect_deposit_bank_transaction_allocation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Recorddirect_deposit_bank_transaction_allocation_KEYDirect_Deposit_Bank_Transaction_Allocation (direct_deposit_bank_transaction_allocation_KEY)

Schema diagram