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
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | Foreign key to Payroll_Bank_Transaction table. This is also the primary key for this table.
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Foreign key to the Client_Pay_Schedule_Detail table.

Primary key
Name | Columns | Description
PK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Client_Pay_Schedule_Detail (client_pay_schedule_detail_KEY) |
FK_Payroll_Bank_Transaction_N_Client_Pay_Schedule_Detail__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |