The Sales and Prime Cost Labor Report shows labor cost and labor budget by labor category. It contains one row for each location, business date, and labor category, with the net sales, sales budget, and overtime hours for the same location and date.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| location_id | VARCHAR | Location identifier |
| business_date | DATE | Business date of the activity |
| operational_year | NUMBER(4,0) | Fiscal year from the 4-4-5 calendar |
| operational_period | NUMBER(2,0) | Fiscal period number (1-12) from the 4-4-5 calendar. Blank for the extra week at the end of a 53-week year. |
| operational_week | NUMBER(17,0) | Fiscal week number from the 4-4-5 calendar |
| labor_category_number | NUMBER(38,0) | Labor category number (GL special categories 800-830). Blank when the location and date has net sales, sales budget, or overtime hours but no labor category line. |
| labor_category_name | VARCHAR | Labor category name |
| labor_cost | NUMBER(38,4) | Labor cost for the category: debits minus credits |
| labor_budget | NUMBER(38,4) | Budgeted labor cost for the category |
| net_sales | NUMBER(38,2) | Net sales for the location and date. The value repeats on each category row, so do not total it across categories. |
| sales_budget | NUMBER(38,2) | Budgeted net sales for the location and date. The value repeats on each category row, so do not total it across categories. |
| overtime_hours | NUMBER(38,4) | Overtime hours for the location and date. The value repeats on each category row, so do not total it across categories. |