| 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 | ||