The response body is of type object.

Returns a JSON array that contains the information for each item production that matches the filter parameters. If no matching production records are found, an empty array is returned.

The following properties are returned.

row_id (integer)

The row ID of the item production record in the Item_Prod table.

wo_id (string)

The work order ID.

oper_id (string)

The operation ID.

seq_no (integer)

The sequence number, which indicates the Job table row.

shift_start_utc (datetime)

The start date and time of the shift during which the production occurred in UTC.

shift_start_local (datetime)

The start date and time of the shift during which the production occurred in the local time of the entity at which the shift was run.

shift_start (datetime)

The start date and time of the shift during which the production occurred in the local time of the time zone that was specified in the tz_id parameter in the call header or URL. If the tz_id parameter was not provided or was not valid, then the time is in UTC.

hour_start_utc (datetime)

The hour in which production occurred in UTC. The minutes portion will not be 0 if the time zone is not an integer number of hours from UTC. The seconds portion will always be 0.

hour_start_local (datetime)

The hour in which production occurred in the local time of the entity at which the production occurred. The minutes and seconds portion will always be 0.

hour_start (datetime)

The hour in which production occurred in the local time of the time zone that was specified in the tz_id parameter in the call header or URL. If the tz_id parameter was not provided or was not valid, then the time is in UTC. The minutes and seconds portion will always be 0.

item_id (string)

The item ID.

item_desc (string)

The item description.

uom_id (integer)

The ID of the unit of measure (UOM).

num_decimals (integer)

The number of decimal places that is used for quantities of this item.

serial_no_lvl_h (integer)

The number that indicates the level being used, lot or sublot, to indicate individual serial numbers.

0: The lot number is the serial number.

> 0: A particular sublot level is the serial number.

-1: There are no serial numbers.

description (string)

The unique description of the UOM.

abbreviation (string)

The abbreviation to append to quantities.

lifetime (integer)

The lifetime of the item before it expires, in days.

lot_no (string)

The lot number.

rm_lot_no (string)

The lot number of raw material from which this lot/sublot was produced.

sublot_no (string)

The sublot number

rm_sublot_no (string)

The sublot number of raw material from which this lot/sublot was produced.

reas_cd (integer)

The reason code that uniquely identifies grade + status of goods produced.

reas_desc (string)

The description of the reason.

user_id (string)

The ID of the user who is making this production entry.

user_desc (string)

The user description.

ent_id (integer)

The entity ID.

ent_name (string)

The entity name.

shift_id (integer)

The shift ID.

shift_desc (string)

The shift description.

grade_cd (integer)

The grade code of produced goods.

item_grade_desc (string)

The grade description,.

item_grade_color (string)

The name or hex value of the HTML color that is the background color of the item grade.

status_cd (integer)

The status code of produced goods.

item_status_desc (string)

The status description.

item_state_color (string)

The name or hex value of the HTML color that is the background color of the item state.

to_ent_id (integer)

The ID of the storage entity for produced goods.

to_ent_name (string)

The name of the storage entity for produced goods.

good_prod (Boolean)

The indication whether this production is good.

qty_prod (double)

The quantity produced.

qty_prod_erp (double)

The quantity produced value that was transferred to an ERP system.

processed_flag (integer)

The processed flag for this lot.

byproduct (Boolean)

The indication whether the produced item is a by-product.

ext_ref (string)

The reference to an external system for defect tracking or any other purpose.

move_status (integer)

An integer value that acts a a flag to indicate whether this lot has been moved to the next operation.

genealogy_id (string)

The genealogy ID.

event_id (string)

The event ID.

segment_requirement_id (string)

The segment requirement ID.

segment_response_id (string)

The segment response ID.

comments (string)

Comments about the item production.

spare1 (string)

The contents of the spare1 field.

spare2 (string)

The contents of the spare2 field.

spare3 (string)

The contents of the spare3 field.

spare4 (string)

The contents of the spare4 field.

item_spare1 (string)

The contents of the item_spare1 field.

item_spare2 (string)

The contents of the item_spare2 field.

item_spare3 (string)

The contents of the item_spare3 field.

item_spare4 (string)

The contents of the item_spare4 field.

last_edit_comment (string)

Comments about why the item production record was added or updated.

last_edit_by (string)

The ID of the user who added or last updated the item production record.

last_edit_at (datetime)

The date and time, in UTC, when the item production record was added or last updated.

created_at_utc (datetime)

The date and time when the item production record was created in UTC.

created_at_local (datetime)

The date and time when the item production record was created in the local time of the entity at which the production occurred.

created_at (datetime)

The date and time when the item production record was created in the local time of the time zone that was specified in the tz_id parameter in the call header or URL. If the tz_id parameter was not provided or was not valid, then the time is in UTC.

serial_no_lvl (integer)

A number that indicates whether the serial number is based on the item's lot number or not.

If the serial number is based on the lot number, a 0 is returned. Otherwise, a -1 is returned.

To get the production for the job for work order WO20171213.2445, operation Roast, and sequence number 2:

api/Production?woId=WO20171213.2445&opId=Roast&seqId=2

To get the production for the same job but for the item peanuts for the last 4 hours:

api/Production?woId=WO20171213.2445&opId=Roast&seqId=2&lastNHours=4&itemId=peanuts

To get the production for the same job during the morning shift that starts at 8 am:

api/Production?woId=WO20171213.2445&opId=Roast&seqId=2&shiftStart=8:00 AM

Examples: Work Tasks Lookups

To get the production for a job:

api/Production?woId={woId}&opId={opId}&seqId={seqId}

To get the production for a job for a specific item and filtered by a number of previous hours:

api/Production?woId={woId}&opId={opId}&seqId={seqId}&lastNHours={lastNHours}&itemId={itemId}

To get the production for a job during a shift:

api/Production?woId={woId}&opId={opId}&seqId={seqId}&shiftStart={shiftStart}

All Operations Resource Group | MES Web API V1 Web Service