Table: dbo.Payroll_Check_Sales_Amount_Distribution
Table to hold sales amount distributions for payroll checks.
Columns
NameTypeConstraintsDescription
payroll_check_sales_amount_distribution_KEYint (4)NOT NULLPrimary key
bank_transaction_KEYint (4)NOT NULLKey to associated bank transaction.
work_location_KEYint (4)NOT NULLKey to associated work location.
payroll_department_KEYint (4)Key to associated payroll department.
sales_amountdecimal (9, 2)NOT NULLSales amount for this distribution.
Primary key
NameColumnsDescription
PK_Payroll_Check_Sales_Amount_Distributionpayroll_check_sales_amount_distribution_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Sales_Amount_Distribution$bank_transaction_KEY$work_location_KEY$payroll_department_KEYbank_transaction_KEY, work_location_KEY, payroll_department_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Payroll_Check_Sales_Amount_Distribution__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)

Schema diagram