| 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 | |||
| Name | Type | Constraints | Description |
| direct_deposit_bank_transaction_allocation_KEY | int (4) | NOT NULL | The primary key, referencing the record that in turn references the FK that this table is tracking. |
| ach_company_batch_header_record_guid | uniqueidentifier (16) | NOT NULL | The referenced item, unique across all databases. |
| Primary key | |||
| Name | Columns | Description | |
| PK_BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record$direct_deposit_bank_transaction_allocation_KEY | direct_deposit_bank_transaction_allocation_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_BS_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record | direct_deposit_bank_transaction_allocation_KEY | Direct_Deposit_Bank_Transaction_Allocation (direct_deposit_bank_transaction_allocation_KEY) | |