GetByKey Method (ShipmentLot)
- Last UpdatedNov 06, 2025
- 2 minute read
'Usage
Dim rowId As Integer
Dim value As DataSet
value = ShipmentLot.GetByKey(rowId)
Parameters
- rowId
- Required. Holds the row ID of the shipment lot record to be retrieved.
Return Value
Returns a DataSet that contains the DataRow of the specified shipment lot in the Shipment_Lot table. If no matching record is found, an empty DataSet is returned.
The columns of the returned row 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. |
|
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. |
|
trans_id |
An integer that is the transfer identifier for the goods shipped. |
|
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. |