GetAll Method (BomItemOperStepLink)
- Last UpdatedNov 06, 2025
- 2 minute read
The GetAll() method retrieves one or more BOM item/operation step link records from the Bom_Item_Oper_Step_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all BOM item/operation step link records from the table.
'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 stepNo As Nullable(Of Integer), _
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 stepNo As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = BomItemOperStepLink.GetAll(parentItemId, verId, bomPos, processId, operId, stepNo, lastEditBy, lastEditAt)
public static DataSet GetAll(
string parentItemId,
string verId,
Nullable<int> bomPos,
string processId,
string operId,
Nullable<int> stepNo,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- parentItemId
Optional filter parameter. Holds the ID of a parent item.
- verId
Optional filter parameter. Holds the ID of a BOM version.
- bomPos
- Optional filter parameter. Holds aBOM position.
- 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.
- stepNo
Optional filter parameter. Holds the number of an operation step number.
- lastEditBy
Optional filter parameter. Holds the ID of a user who added or last updated a BOM item operation step link record.
- lastEditAt
Optional filter parameter. Holds the date/time when a BOM item operation step link record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Bom_Item_Oper_Step_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.
|
Column Name |
Description |
|---|---|
|
parent_item_id |
A string that is the parent item ID. |
|
ver_id |
A string that is the BOM version ID. |
|
bom_pos |
An integer that is the BOM position. |
|
process_id |
A string that is the process ID. |
|
oper_id |
A string that is the operation ID. |
|
step_no |
An integer that is the step number. |
|
qty_per_parent_item |
A double-precision floating point number that is the nominal quantity of an item required per unit of the current parent item. For by-products, this value is less than zero. |
|
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. |