Table: dbo.Shortfall_Transaction_N_Payroll_Check_Payroll_Item
Dictionary to associate a shortfall transaction to a payroll check payroll item
Columns
NameTypeConstraintsDescription
shortfall_transaction_KEYint (4)NOT NULLForeign key to associated shortfall transaction
payroll_check_payroll_item_KEYint (4)NOT NULLForeign key to associated payroll check payroll item
Primary key
NameColumnsDescription
PK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item$shortfall_transaction_KEYshortfall_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item__Payroll_Check_Payroll_Item__payroll_check_payroll_item_KEYpayroll_check_payroll_item_KEYPayroll_Check_Payroll_Item (payroll_check_payroll_item_KEY)
FK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYShortfall_Transaction (shortfall_transaction_KEY)

Schema diagram