MES Stateless API

GetByKey Method (PoLine)

Save PDF

GetByKey Method (PoLine)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetByKey() method retrieves the specified purchase order line item record from the PO_Line table.

The purchase order line item is uniquely identified by the combination of the purchase order ID and purchase order line item number.

Syntax

'Declaration
 
Public Shared Function GetByKey( _
   ByVal poId As String, _
   ByVal poLineNo As Integer _
) As DataSet

'Usage
 
Dim poId As String
Dim poLineNo As Integer
Dim value As DataSet
 
value = PoLine.GetByKey(poId, poLineNo)

public static DataSet GetByKey( 
   string poId,
   int poLineNo
)

Parameters

poId: Required. Holds the ID of the purchase order.
poLineNo: Required. Holds a number that identifies the line item in the purchase order.

Return Value

Returns a DataSet that contains the DataRow of the specified purchase order line item in the PO_Line table. If no matching record for the specified purchase order line is found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
po_id	A string that is the purchase order ID, from the PO_Line table.
po_line_no	An integer that is the line number in the purchase order, from the PO_Line table.
item_id	A string that is the ID of the item being ordered, from the PO_Line table.
vendor_item_id	A string that is the ID that the vendor uses to refer to the item being ordered, from the PO_Line table.
quantity	A double that is the amount of the item being ordered, from the PO_Line table.
uom_id	An integer that is the ID of the unit of measure for the item being ordered, from the PO_Line table. This unit of measure ID, if supplied by the Add(), Update(), or UpdateSpecific() method of the PoLine class, will override the item's nominal unit of measure from the Item table.
min_qty	A double that is the minimum quantity that, once shipped, will allow the order to be completed, from the PO_Line table.
max_qty	A double that is the maximum quantity that can be shipped against this line item, from the PO_Line table. A null value indicates no limit.
line_price	A double that is the total price for this line item, from the PO_Line table.
reqd_by_utc	A datetime that is the UTC date when the line item is required, from the PO_Line table.
reqd_by_local	A datetime that is the date when the goods for this line are required in the local time of the entity to which the goods are shipped, specified by the ship_to column in the PO's record, from the PO_Line table. If a ship-to entity is not specified, the default time zone will be used to determine the local time.
spare1 to spare4	A string that is the content of the user-defined spare1 to spare4 values, from the PO_Line 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.

MES Stateless API