Table: dbo.Impound_Payment_Client_Bank_Transaction_Detail
Columns
NameTypeConstraintsDescription
impound_payment_client_bank_transaction_detail_KEYint (4)NOT NULLPrimary key.
impound__bank_transaction_KEYint (4)NOT NULLForeign key to the Impound payee check whose detail is being tracked in this table.
client__bank_transaction_KEYint (4)NOT NULLForeign key to a client payroll or vendor bank transaction (check) that is part of the source detail for this Impound payee check.
Primary key
NameColumnsDescription
PK_Impound_Payment_Client_Bank_Transaction_Detailimpound_payment_client_bank_transaction_detail_KEY
Unique constraints
NameColumnsDescription
UK_Impound_Payment_Client_Bank_Transaction_Detail$client__bank_transaction_KEYclient__bank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Impound_Payment_Client_Bank_Transaction_Detail__Bank_Transaction__client__bank_transaction_KEYclient__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Impound_Payment_Client_Bank_Transaction_Detail__Bank_Transaction__impound__bank_transaction_KEYimpound__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram