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 |