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 |