The work_orders Data Model
The work_orders data model creates a relationship between the area and line of a site, the start time, and the work order ID. The start time and work order ID are associated with the end time, products per bag, bags per case, cases per pallet, and other product details.
The data model uses the following primary key and rest APIs:
- Primary key: ((tenant_id, enterprise_id, site_id, area, line), start_time, work_order_id)
- REST APIs: workOrderReports, workOrderReports{id}
- tenant_id
- enterprise_id
- site_id
- area
- line
- start_time
- work_order_id
- actual_cases
- actual_rate
- adjusted_cases
- adjusted_units
- bags_per_case
- bom_name
- cases_per_pallet
- comment
- constraint_sched_time
- constraints_running
- crew
- duration
- end_time
- end_time_utc
- enterprise
- forecast_end_time
- forecast_quantity
- forecast_start_time
- good_quantity
- initiated_by
- ins_ts
- line_substate
- num_constraints
- path_id
- pl_id
- pp_status_desc
- prod_code
- prod_desc
- prod_per_bag
- prod_per_stat
- product_family_desc
- product_grp_desc
- production_status
- production_status_reason
- pu_id
- replica_ins_ts
- replica_upd_ts
- route
- run_time
- running_scrap
- sched_time
- scrap_quantity
- shift
- site
- start_time_utc
- stat_case_conv
- stat_units
- stop_scrap
- target_rate
- tenant
- total_quantity
- unit
- units_per_case
- upd_ts
- work_order_name