Table: dbo.Payroll_Check_Sales_Amount_Distribution
Table to hold sales amount distributions for payroll checks.
Columns
Name | Type | Constraints | Description
payroll_check_sales_amount_distribution_KEY | int (4) | NOT NULL | Primary key
bank_transaction_KEY | int (4) | NOT NULL | Key to associated bank transaction.
work_location_KEY | int (4) | NOT NULL | Key to associated work location.
payroll_department_KEY | int (4) |  | Key to associated payroll department.
sales_amount | decimal (9, 2) | NOT NULL | Sales amount for this distribution.

Primary key
Name | Columns | Description
PK_Payroll_Check_Sales_Amount_Distribution | payroll_check_sales_amount_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_Sales_Amount_Distribution$bank_transaction_KEY$work_location_KEY$payroll_department_KEY | bank_transaction_KEY, work_location_KEY, payroll_department_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Department (payroll_department_KEY) |
FK_Payroll_Check_Sales_Amount_Distribution__Work_Location__work_location_KEY | work_location_KEY | Work_Location (work_location_KEY) |