MES Stateless API

GetAvailSNOS Method

Save PDF

GetAvailSNOS Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAvailSNOS() method gets a list of serial numbers that are available for the item specified. If no item is specified, this method will get a list of all available serial numbers.

Syntax

'Declaration
 
Public Shared Function GetAvailSNOS( _
   ByVal itemId As String, _
   ByVal serialNo As String _
) As DataSet

'Usage
 
Dim itemId As String
Dim serialNo As String
Dim value As DataSet
 
value = Lot.GetAvailSNOS(itemId, serialNo)

public static DataSet GetAvailSNOS( 
   string itemId,
   string serialNo
)

Parameters

itemId: Optional. Holds the ID of the item to be retrieved.
serialNo: Optional. Holds the serial number of the item to be retrieved.

Return Value

Returns a DataSet that contains records for all the lots that satisfy the specified filters. The returned records include columns from the Item, Lot, and Inv_Lot_Attr tables. If no matching lots are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
item_id	A string that is ID of the item stored, from Lot table.
item_desc	A string that is the description of the item, from the Item table
lot_no	A string that is the lot number, from the Lot table.
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.
row_id	An integer that is the ID of the row.
inv_lot_item_id_h	A string that is the ID of the inventory lot item, from the Inv_Lot_Attr table.
inv_lot_lot_no_h	A string that is the inventory lot number, from the Inv_Lot_Attr table.
attr<attr_id>	A string that is the ID of the attribute associated with the lot, from the Inv_Lot_Attr table.
attr<attr_id>_d_h	A string that is the description of the attribute whose ID is the numeric part of the field name following “attr” and preceding “d_h”, from the Inv_Lot_Attr table.

MES Stateless API

GetAvailSNOS Method

Table of Contents

GetAvailSNOS Method

In This Topic

MES Stateless API

GetAvailSNOS Method

Syntax

Parameters

Return Value

See Also

Reference

In This Topic