MES Stateless API

GetAll Method (BomItemOperLink)

Save PDF

GetAll Method (BomItemOperLink)

Save PDF

Last UpdatedNov 06, 2025
4 minute read

The GetAll() method retrieves one or more BOM item/operation link records from the Bom_Item_Oper_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all BOM item/operation link records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal parentItemId As String, _
   ByVal verId As String, _
   ByVal bomPos As Nullable(Of Integer), _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim parentItemId As String
Dim verId As String
Dim bomPos As Nullable(Of Integer)
Dim processId As String
Dim operId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = BomItemOperLink.GetAll(parentItemId, verId, bomPos, processId, operId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string parentItemId,
   string verId,
   Nullable<int> bomPos,
   string processId,
   string operId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

parentItemId

Optional filter parameter. Holds the ID of a parent item that is being linked to an operation.

verId

Optional filter parameter. Holds the ID of a BOM version.

bomPos

Optional filter parameter. Holds a BOM position. The BOM position is not necessarily in a sequence.

processId

Optional filter parameter. Holds the ID of a process to which an operation belongs.

operId

Optional filter parameter. Holds the ID of an operation that is being linked to an item.

lastEditBy

Optional filter parameter. Holds the ID of a user who added or last updated a BOM item operation link record.

lastEditAt

Optional filter parameter. Holds the date/time when a BOM item/operation link record was added or last updated.

Return Value

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

The columns of the returned DataSet are described below.

ColumnName	Description
parent_item_id	A string that is the ID of a parent item.
ver_id	A string that is the ID of a BOM version.
bom_pos	An integer that is the BOM position.
process_id	A string that is the ID of a process used to make an item.
oper_id	A string that contains the ID of an operation within a process.
item_desc	A string that is the description of an item.
qty_per_parent_item	A floating point number that is the nominal quantity of the item required per unit of the current parent item.
reqd_start_pct	A floating point number that is the percentage of this component (or, if the BOM position is zero, of the input quantity of the item itself) that is required before the operation becomes Ready.
oper_desc	A string that is the description of an operation.
def_reas_cd	An integer that is the default consumption or production code for an item.
def_lot_no	A string that is the default lot number that specifies location from where items are consumed.
def_sublot_no	A string that is the default sublot number that specifies location from where items are consumed.
def_storage_ent_id	An integer that is the default storage entity to retrieve a component or store a product or by-product.
def_reject_ent_id	An integer that is the default storage entity for the rejected production items.
update_inv	A Boolean that is a flag that specifies whether the inventory table is updated with item consumption.
backflush	A Boolean that is a flag that specifies whether consumption is backflushed.
must_consume_from_inv	A Boolean that is a flag that specifies whether consumption must occur from inventory for this item.
may_choose_alt_inv_loc	A Boolean that is a flag that specifies whether a user can select alternate inventory locations when consuming or producing this item.
may_create_new_lots	A Boolean that is a flag that specifies whether a user can create new lots when consuming or producing this item.
must_consume_from_wip	A Boolean that is a flag that specifies whether the lots consumed during a job must be limited to those lots produced to the Item_Inv table for the same work order in an upstream job.
must_consume_before_prod	A Boolean that is a flag that specifies whether to prevent any production transactions until 'acceptable' quantities of BOM components are consumed, as specified in the maxQtyPerParentItem and minQtyPerParentItem parameters.
constant_qty	A Boolean that is a flag that specifies whether the quantity of a consumed item is independent of the quantity of a parent item that is produced.
last_edit_comment	A string that contains comments about why the record was 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.
mod_id	The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes.

MES Stateless API