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