MES Stateless API

GetConsItems Method

Save PDF

GetConsItems Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetConsItems() method retrieves a list of consumable items for this job.

Syntax

'Declaration
 
Public Shared Function GetConsItems( _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Integer _
) As DataSet

'Usage
 
Dim woId As String
Dim operId As String
Dim seqNo As Integer
Dim value As DataSet
 
value = JobExec.GetConsItems(woId, operId, seqNo)

public static DataSet GetConsItems( 
   string woId,
   string operId,
   int seqNo
)

Parameters

woId: Required. Holds the work order ID of the job whose consumable list is being retrieved.
operId: Required. Holds the operation ID of the job.
seqNo: Required. Holds the job sequence number.

Return Value

Returns a DataSet that contains records from a list of consumable items for this job (whose job BOM position > 0), all consumable substitute items for this job (whose job BOM substitute position is > 0), and the item produced by this job if and only if this item is the same item that was produced by any of the job that is immediately upstream to this job. If there are no consumable items, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
item_class_id	A string that is the item class ID from the Item_Class table linked to this consumable item for this job.
item_class_desc	A string that is the description of the item class, from the Item_Class table linked to this consumable item for this job.
item_id	A string that is the item ID, from the job/job_bom for this job.
item_desc	A string that is the description of the item, from the Item table linking this item for this job.
num_decimals	An integer that is the number of decimals allowed for this item, from the Item table linked to this item for this job.
uom_id	An integer that identifies the unit of measurement for this item, from the Item table linked to this item for this job.
description	A string that is the description of the unit of measurement for this item, from the Uom table linked to this item for this job.

MES Stateless API