MES Stateless API

GetItemEntSpecs Method

Save PDF

GetItemEntSpecs Method

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetItemEntSpecs() method returns one or more item specification and entity specification records from the Oper_Ent_Spec and Bom_Item_Oper_Spec tables.

Syntax

'Declaration
 
Public Shared Function GetItemEntSpecs( _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal entId As Integer, _
   ByVal ItemId As String _
) As DataSet

'Usage
 
Dim processId As String
Dim operId As String
Dim entId As Integer
Dim ItemId As String
Dim value As DataSet
 
value = OperEntSpec.GetItemEntSpecs(processId, operId, entId, ItemId)

public static DataSet GetItemEntSpecs( 
   string processId,
   string operId,
   int entId,
   string ItemId
)

Parameters

processId: Required. Holds the ID of the process.
operId: Required. Holds the ID of the operation.
entId: Required. Holds the ID of the entity.
ItemId: Required. Holds the ID of the item.

Return Value

Returns a DataSet that contains records for all the item specification and entity specification that satisfy the specified filters. The returned records include columns from the Oper_Ent_Spec, Item, Bom_Ver, Oper_Spec_Ver, and Bom_Item_Oper_Spec tables. If no matching item specification and entity specification records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
process_id	A string that is the ID of the process.
oper_id	A string that is the ID of the operation.
step_no	An integer that is the step number. The default is -1, which means that the specification is not associated with a step.
ent_id	An integer that is the ID of the entity.
item_id	A string that is the ID of the item, from the Item table.
item_desc	A string that is the description of the item, from the Item table.
bom_ver_id	A string that is the ID of the BOM version. If entity_specs = 1, this value is from the Bom_Ver table. If entity_specs = 0, this value is from the Bom_Item_Oper_Spec table.
bom_pos	An integer that is the BOM position, from the Bom_Item_Oper_Spec table.
spec_ver_id	A string that is the ID of the specification version, from the Oper_Spec_Ver table.
spec_id	A string that is the ID of the specification.
spec_value	A string that is the value for this specification.
assoc_file	A string that is the path and filen name of the file associated with this specification.
assoc_file_type	A string that is the file type of the file that is associated with this specification.
comments	A string that contains the comments or instructions to an operator regarding this specification.
min_value	A string that is the minimum acceptable value for the specification. The default is null, which means no minimum value is defined.
max_value	A string that is the maximum acceptable value for the specification. The default is null, which means no maximum value is defined.
access_level	An integer that is the security access level for modifying this specification. The default is null, which means no extra security is defined.
entity_specs	An integer that indicates from what table the spec comes. 0 indicates that the spec is from the Bom_Item_Oper_Spec table. 1 indicates that the spec is from the Oper_Ent_Spec table.
grp_id	A string value that is the ID of the specification group of which this specification is a member, from the Spec table.
spec_desc	A string that is the description of the specification.
units	A string that is the unit of measure for the specification value, from the Spec table.

MES Stateless API