MES Stateless API

GetAll(Nullable<Int32>,Nullable<Int32>,String,String,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,String,String,Nullable<Int32>,String,Nullable<DateTime>) Method

Save PDF

GetAll(Nullable<Int32>,Nullable<Int32>,String,String,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,String,String,Nullable<Int32>,String,Nullable<DateTime>) Method

Save PDF

Last UpdatedNov 06, 2025
6 minute read

The GetAll() method retrieves one or more item inventory records from the Item_Inv table, as specified by the filter parameters. Passing no filter parameters will retrieve all item inventory records from the table.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal rowId As Nullable(Of Integer), _
   ByVal entId As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal subLotNo As String, _
   ByVal gradeCd As Nullable(Of Integer), _
   ByVal statusCd As Nullable(Of Integer), _
   ByVal uomId As Nullable(Of Integer), _
   ByVal dateInUtc As Nullable(Of Date), _
   ByVal dateInLocal As Nullable(Of Date), _
   ByVal dateOutUtc As Nullable(Of Date), _
   ByVal dateOutLocal As Nullable(Of Date), _
   ByVal expiryDate As Nullable(Of Date), _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim rowId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim itemId As String
Dim lotNo As String
Dim subLotNo As String
Dim gradeCd As Nullable(Of Integer)
Dim statusCd As Nullable(Of Integer)
Dim uomId As Nullable(Of Integer)
Dim dateInUtc As Nullable(Of Date)
Dim dateInLocal As Nullable(Of Date)
Dim dateOutUtc As Nullable(Of Date)
Dim dateOutLocal As Nullable(Of Date)
Dim expiryDate As Nullable(Of Date)
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = ItemInv.GetAll(rowId, entId, itemId, lotNo, subLotNo, gradeCd, statusCd, uomId, dateInUtc, dateInLocal, dateOutUtc, dateOutLocal, expiryDate, woId, operId, seqNo, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> rowId,
   Nullable<int> entId,
   string itemId,
   string lotNo,
   string subLotNo,
   Nullable<int> gradeCd,
   Nullable<int> statusCd,
   Nullable<int> uomId,
   Nullable<DateTime> dateInUtc,
   Nullable<DateTime> dateInLocal,
   Nullable<DateTime> dateOutUtc,
   Nullable<DateTime> dateOutLocal,
   Nullable<DateTime> expiryDate,
   string woId,
   string operId,
   Nullable<int> seqNo,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

rowId: Optional filter parameter. Holds the row ID of an item inventory record to be retrieved.
entId: Optional filter parameter. Holds the ID of an entity.
itemId: Optional filter parameter. Holds the ID of an item.
lotNo: Optional filter parameter. Holds the lot number of an item.
subLotNo: Optional filter parameter. Holds the sublot number of an item.
gradeCd: Optional filter parameter. Holds the grade code of an item.
statusCd: Optional filter parameter. Holds the status code of an item.
uomId: Optional filter parameter. Holds the ID of the unit of measure that is used for the item in the inventory record. This UOM can be different than the item's native UOM.
dateInUtc: Optional filter parameter. Holds the date when items were last received to a lot or location in UTC.
dateInLocal: Optional filter parameter. Holds the date when items were last received to a lot or location in the local time of the storage entity.
dateOutUtc: Optional filter parameter. Holds the date when items were last sent from a lot or location in UTC.
dateOutLocal: Optional filter parameter. Holds the date when items were last sent from a lot or location in the local time of the storage entity.
expiryDate: Optional filter parameter. Holds an item's expiry date and time in the local time of the storage entity.
woId: Optional filter parameter. Holds the ID of the work order for a last job that produced these goods.
operId: Optional filter parameter. Holds the ID of the operation for a last job that produced these goods.
seqNo: Optional filter parameter. Holds the operation sequence number for a last job that produced these goods.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated an item inventory record.
lastEditAt: Optional filter parameter. Holds the date and time when an item inventory record was added or last updated.

Return Value

Returns a DataSet that contains records for all the inventory items that satisfy the specified filters. The returned records include columns from the Ent, Item_Inv, Item, Item_Grade, Item_State, and UOM tables. If no matching inventory items are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
row_id	An integer that is the ID of the row.
ent_id	An integer that is the ID of the entity.
item_id	A string that is the ID of the item.
lot_no	A string that is the lot number of the item.
sublot_no	A string that is the sublot number of the item.
grade_cd	An integer that is the grade code of the item. Set to null if it should default to the grade code of the lot or sublot.
status_cd	An integer that is the status code of the item. Set to null if it should default to the status code of the lot or sublot.
ent_name	A string that is the name of the entity.
item_desc	A string that is the description of the item.
item_uom_id	An integer that is the ID of the unit of measure for the item.
inv_unique_by_job	A Boolean that is a flag that specifies whether the item can include the wo_id, oper_id, and seq_no parameters in their effective primary key.
item_grade_desc	A string that is the description of the item grade.
grade_color	An integer that is the RGB background color for the item grade.
item_status_desc	A string that is the description of the item status.
state_color	An integer that is the RGB background color for the item status.
qty_left	A floating point number that is the quantity remaining in the entity.
qty_left_erp	A floating point number that is the quantity remaining in the entity, as last transmitted to an ERP system. The default is 0.
uom_id	An integer that is the ID of the unit of measure for the inventory. This UOM can be different than the item's native UOM (item_uom_id).
date_in_utc	The date when the items are last received to this lot or location in UTC.
date_in_local	The date when the items are last received to this lot or location in the local time of the storage entity.
date_in	The date when the items are last received to this lot or location in the local time of the client application that is making the call, converted from the date_in_utc value.
date_out_utc	The date when the items are last sent from this lot or location in UTC.
date_out_local	The date when the items are last sent from this lot or location in the local time of the storage entity.
date_out	The date when the items are last sent from this lot or location in the local time of the client application that is making the call, converted from the date_out_utc value.
expiry_date_utc	A datetime that is the expiry date and time for the item in UTC, from the Item_Inv table.
expiry_date_local	A datetime that is the expiry date and time for the item in the local time of the storage entity, from the Item_Inv table.
expiry_date	A datetime that is the expiry date and time for the item in the local time of the client application that is making the call, converted from the expiry_date_utc value.
wo_id	A string that is ID of the work order for the last job that produced these goods.
oper_id	A string that is the ID of the operation for the last job that produced these goods.
seq_no	An integer that is the sequence number for the last job that produced these goods.
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.
spare5	A string that is the contents of the user-defined spare5 field.
spare6	A string that is the contents of the user-defined spare6 field.
num_decimals	An integer that is the number of decimal places for quantity values.
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 date/time that indicates when the record was added or last updated.
uom_desc	A string that is the description of the unit of measure for the item.
shippable_grade_h	An integer that is the minimum acceptable grade required to allow the item to be shipped.
shippable_state_h	An integer that is the minimum acceptable state required to allow the item to be shipped.

MES Stateless API