Table: dbo.Payroll_Check_Sales_Amount_Import
This table will hold imported sales amounts prior to check creation.
Columns
Name | Type | Constraints | Description
payroll_check_sales_amount_import_KEY | int (4) | NOT NULL | Primary key for the Payroll_Check_Sales_Amount_Import table.
client_pay_schedule_detail_KEY | int (4) | NOT NULL | Pay schedule detail this sales amount applies to
employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Employee work location payroll department this sales amount applies to.
sales_amount | decimal (9, 2) | NOT NULL | Sales amount
provisional_marker | nvarchar (200) |  | If set, indicates the record is not ready for processing into a check. Records with the same value belong to the same batch of provisional items.

Primary key
Name | Columns | Description
PK_Payroll_Check_Sales_Amount_Import | payroll_check_sales_amount_import_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_Sales_Amount_Import$client_pay_schedule_detail_KEY$employee_work_location_payroll_department_KEY | client_pay_schedule_detail_KEY, employee_work_location_payroll_department_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Sales_Amount_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEY | client_pay_schedule_detail_KEY | Client_Pay_Schedule_Detail (client_pay_schedule_detail_KEY) |
FK_Payroll_Check_Sales_Amount_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEY | employee_work_location_payroll_department_KEY | Employee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY) |