Table: dbo.Shortfall_Transaction
Transactions to track tax and deduction shortfalls from checks and restitution payments.
Columns
NameTypeConstraintsDescription
shortfall_transaction_KEYint (4)NOT NULLPrimary key
shortfall_transaction_type_KEYint (4)NOT NULLType of transaction
employee_KEYint (4)NOT NULLForeign key to the associated employee
transaction_datesmalldatetime (4)NOT NULLDate of the transaction
amountdecimal (9, 2)NOT NULLDollar amount. Positive is a check shortfall, negative is a restitution or waiver
Primary key
NameColumnsDescription
PK_Shortfall_Transactionshortfall_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Shortfall_Transaction__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Shortfall_Transaction__Shortfall_Transaction_Type__shortfall_transaction_type_KEYshortfall_transaction_type_KEYShortfall_Transaction_Type (shortfall_transaction_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Shortfall_Transaction_N_Client_Payroll_Item__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYShortfall_Transaction_N_Client_Payroll_Item
FK_Shortfall_Transaction_N_Client_Tax_Item__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYShortfall_Transaction_N_Client_Tax_Item
FK_Shortfall_Transaction_N_Payroll_Check_Tax_Item__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYShortfall_Transaction_N_Payroll_Check_Tax_Item
FK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYShortfall_Transaction_N_Payroll_Check_Payroll_Item
FK_Payable_Transaction_N_Shortfall_Transaction__Shortfall_Transaction__shortfall_transaction_KEYshortfall_transaction_KEYPayable_Transaction_N_Shortfall_Transaction

Schema diagram