Table: dbo.Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail
This dictionary table associates a payroll bank transaction record with a client pay schedule detail record.
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLForeign key to Payroll_Bank_Transaction table. This is also the primary key for this table.
client_pay_schedule_detail_KEYint (4)NOT NULLForeign key to the Client_Pay_Schedule_Detail table.
Primary key
NameColumnsDescription
PK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYClient_Pay_Schedule_Detail (client_pay_schedule_detail_KEY)
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)

Schema diagram