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 |