Table: dbo.Payroll_Check_Sales_Amount_Import
This table will hold imported sales amounts prior to check creation.
Columns
NameTypeConstraintsDescription
payroll_check_sales_amount_import_KEYint (4)NOT NULLPrimary key for the Payroll_Check_Sales_Amount_Import table.
client_pay_schedule_detail_KEYint (4)NOT NULLPay schedule detail this sales amount applies to
employee_work_location_payroll_department_KEYint (4)NOT NULLEmployee work location payroll department this sales amount applies to.
sales_amountdecimal (9, 2)NOT NULLSales amount
provisional_markernvarchar (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
NameColumnsDescription
PK_Payroll_Check_Sales_Amount_Importpayroll_check_sales_amount_import_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Sales_Amount_Import$client_pay_schedule_detail_KEY$employee_work_location_payroll_department_KEYclient_pay_schedule_detail_KEY, employee_work_location_payroll_department_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Sales_Amount_Import__Client_Pay_Schedule_Detail__client_pay_schedule_detail_KEYclient_pay_schedule_detail_KEYClient_Pay_Schedule_Detail (client_pay_schedule_detail_KEY)
FK_Payroll_Check_Sales_Amount_Import__Employee_Work_Location_Payroll_Department__employee_work_location_payroll_department_KEYemployee_work_location_payroll_department_KEYEmployee_Work_Location_Payroll_Department (employee_work_location_payroll_department_KEY)

Schema diagram