MES Stateless API

GetItemsProdByDstrmJob Method

Save PDF

GetItemsProdByDstrmJob Method

Save PDF

Last UpdatedNov 06, 2025
4 minute read

The GetItemsProdByDstrmJob() method retrieves a list of items produced by the jobs that are immediately downstream to the specified job.

Syntax

'Declaration
 
Public Shared Function GetItemsProdByDstrmJob( _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Integer, _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal subLotNo As String _
) As DataSet

'Usage
 
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim itemId As String
Dim lotNo As String
Dim subLotNo As String
Dim value As DataSet
 
value = JobExec.GetItemsProdByDstrmJob(woId, operId, seqNo, itemId, lotNo, subLotNo)

public static DataSet GetItemsProdByDstrmJob( 
   string woId,
   string operId,
   int seqNo,
   string itemId,
   string lotNo,
   string subLotNo
)

Parameters

woId: Required. Holds the work order ID of the job.
operId: Required. Holds the operation ID of the job.
seqNo: Required. Holds the job sequence number.
itemId: Optional filter parameter. Holds an item that is produced by the job.
lotNo: Optional filter parameter. Holds the number of the lot to which an item is produced.
subLotNo: Optional filter parameter. Holds the number of the sublot to which an item is produced.

Return Value

Returns a DataSet that contains all the records in the Item_Prod table that satisfy the specified job and optional filters. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
wo_id	A string that is the ID of the work order.
oper_id	A string that is the ID of the operation for this work order.
seq_no	An integer that is the job sequence number.
shift_start_utc	A datetime that is the shift start time when this item was produced, in UTC.
shift_start_local	A datetime that is the shift start time, in the local time of the entity.
shift_start	A datetime that is the shift start time, in the local time of the client application that is making the call.
item_id	A string that is the ID of the item that was produced.
lot_no	A string that is the lot number to which this item was stored.
rm_lot_no	A string that is the raw material lot number to which this lot was produced.
sublot_no	A string that is the sublot number to which this item was stored.
rm_sublot_no	A string that is the raw material sublot number to which this sublot was produced.
reas_cd	An integer that is the unique reason grade + status of goods produced.
user_id	A string that is the ID of the user who added this production.
ent_id	An integer that is the ID of the entity on which this job ran.
shift_id	An integer that is the ID of the shift.
grade_cd	An integer that is the grade code for this item.
status_cd	An integer that is the status code for this item.
to_ent_id	An integer that is the ID of the storage entity where this item was stored.
good_prod	A Boolean that is a flag that indicates whether this production is a good production. True, if good production; false, if rejects.
qty_prod	A double floating point that is the amount of quantity produced for this item
qty_prod_erp	A double floating point that is the amount of quantity transferred to ERP.
processed_flag	An integer that is a flag that indicates whether this lot is processed. 0, if not processed; otherwise, 1.
byproduct	A Boolean that is a flag that indicates whether this item is a byproduct. True, if it is a by-product; false, if it is a main production item.
ext_ref	A string that is a reference to an external system for defect tracking or any other purposes.
move_status	An integer that is a flag that indicates whether this lot bas been moved to next operation or not.
spare1	A string that is the contents of the user-defined spare1 field.
spare2	A string that is the contents of the user-defined spare2 field.
spare3	A string that is the contents of the user-defined spare3 field.
spare4	A string that is the contents of the user-defined spare4 field.
last_edit_comment	A string that contains comments about why the record was added or updated.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A datetime that indicates when the record was added or last updated.
created_at_utc	A datetime that is when this record was created, in UTC.
created_at_local	A datetime that is when this record was created, in the local time of the entity.
created_at	A datetime that is when this record was created, in the local time of the client application that is making the call.
row_id	An integer that is the unique row ID for the record.

MES Stateless API

GetItemsProdByDstrmJob Method

Table of Contents

GetItemsProdByDstrmJob Method

In This Topic

MES Stateless API

GetItemsProdByDstrmJob Method

Syntax

Parameters

Return Value

Remarks

See Also

Reference

In This Topic