MES Stateless API

GetAll Method (ShipmentLot)

Save PDF

GetAll Method (ShipmentLot)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal custId As String, _
   ByVal poId As String, _
   ByVal soLineNumber As Nullable(Of Integer), _
   ByVal shipDateUtc As Nullable(Of Date), _
   ByVal lotNo As String, _
   ByVal sublotNo As String, _
   ByVal uomId As Nullable(Of Integer), _
   ByVal transId As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date), _
   ByVal rowId As Nullable(Of Integer) _
) As DataSet

'Usage
 
Dim custId As String
Dim poId As String
Dim soLineNumber As Nullable(Of Integer)
Dim shipDateUtc As Nullable(Of Date)
Dim lotNo As String
Dim sublotNo As String
Dim uomId As Nullable(Of Integer)
Dim transId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
 
value = ShipmentLot.GetAll(custId, poId, soLineNumber, shipDateUtc, lotNo, sublotNo, uomId, transId, lastEditBy, lastEditAt, rowId)

public static DataSet GetAll( 
   string custId,
   string poId,
   Nullable<int> soLineNumber,
   Nullable<DateTime> shipDateUtc,
   string lotNo,
   string sublotNo,
   Nullable<int> uomId,
   Nullable<int> transId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt,
   Nullable<int> rowId
)

Parameters

custId: Optional filter parameter. Holds the customer ID.
poId: Optional filter parameter. Holds the purchase order ID.
soLineNumber: Optional filter parameter. Holds the sales order line number of the goods shipped.
shipDateUtc: Optional filter parameter. Holds the date and time when the goods were shipped, in UTC.
lotNo: Optional filter parameter. Holds the lot number of the goods shipped.
sublotNo: Optional filter parameter. Holds the sublot number of the goods shipped.
uomId: Optional filter parameter. Holds the identifier of the unit of measure for the goods shipped.
transId: Optional filter parameter. Holds the transfer identifier for the goods shipped.
lastEditBy: Optional filter parameter. Holds the user who created or last updated the record.
lastEditAt: Optional filter parameter. Holds the date and time that the record was added or last updated.
rowId: Optional filter parameter. Holds the unique row identifier of the shipment lot record in the Shipment_Lot table.

Return Value

Returns a DataSet that contains records that satisfy the specified filters. The returned records include columns from the Shipment_Lot table and linked tables. If no matching records found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
cust_id	A string that is the customer ID.
po_id	A string that is the ID of the customer's purchase order with which the goods shipped are associated.
so_line_no	An integer that is the sales order line number of the goods shipped.
ship_date_utc	A datetime that indicates when the goods were shipped, in UTC.
ship_date_local	A datetime that indicates when the goods were shipped, in the local time of the entity from which the goods were shipped.
ship_date	A datetime that indicates when the goods were shipped, in the local time of of the client from which the method was called.
lot_no	A string that is the lot number.
sublot_no	A string that is the sublot number.
qty_shipped	A double that is the quantity of goods shipped.
uom_id	An integer that is the identifier of the unit of measure for the goods shipped.
description	A string that is the description of item's unit of measure, from the UOM table.
trans_id	An integer that is the transfer identifier for the goods shipped.
cust_name	A string that is the customer name, from the Cust table.
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 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.
row_id	An integer that is the record's unique row ID.

MES Stateless API