MES Stateless API

GetByKey Method (ItemInv)

Save PDF

GetByKey Method (ItemInv)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetByKey() method retrieves the specified item inventory record from the Item_Inv table.

Syntax

'Declaration
 
Public Shared Function GetByKey( _
   ByVal rowId As Integer _
) As DataSet

'Usage
 
Dim rowId As Integer
Dim value As DataSet
 
value = ItemInv.GetByKey(rowId)

public static DataSet GetByKey( 
   int rowId
)

Parameters

rowId: Required. Holds the ID of the row that identifies the record to be retrieved.

Return Value

Returns a DataSet that contains the record for the specified inventory item. If no matching inventory item is found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
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.
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.
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.
row_id	An integer that is the ID of the row.

MES Stateless API

GetByKey Method (ItemInv)

Table of Contents

GetByKey Method (ItemInv)

In This Topic

MES Stateless API

GetByKey Method (ItemInv)

Syntax

Parameters

Return Value

See Also

Reference

In This Topic