MES Stateless API

GetAll Method (PoLine)

Save PDF

GetAll Method (PoLine)

Save PDF

Last UpdatedNov 06, 2025
5 minute read

The GetAll() method retrieves one or more purchase order line item records from the PO_Line table and related tables, as specified by the filter parameters. Passing no filter parameters will retrieve all purchase order line item records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal poId As String, _
   ByVal poLineNo As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal vendorItemId As String, _
   ByVal uomId As Nullable(Of Integer), _
   ByVal requiredByUtc As Nullable(Of Date), _
   ByVal requiredByLocal As Nullable(Of Date), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim poId As String
Dim poLineNo As Nullable(Of Integer)
Dim itemId As String
Dim vendorItemId As String
Dim uomId As Nullable(Of Integer)
Dim requiredByUtc As Nullable(Of Date)
Dim requiredByLocal As Nullable(Of Date)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = PoLine.GetAll(poId, poLineNo, itemId, vendorItemId, uomId, requiredByUtc, requiredByLocal, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string poId,
   Nullable<int> poLineNo,
   string itemId,
   string vendorItemId,
   Nullable<int> uomId,
   Nullable<DateTime> requiredByUtc,
   Nullable<DateTime> requiredByLocal,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

poId: Optional filter parameter. Holds the ID of a purchase order.
poLineNo: Optional filter parameter. Holds a number that identifies a line item in a purchase order.
itemId: Optional filter parameter. Holds the ID of an item being ordered.
vendorItemId: Optional filter parameter. Holds the ID used by the vendor to identify an item being ordered.
uomId: Optional filter parameter. Holds the ID of the unit of measure for a line item. (The uomId for the PoLine class, if supplied by the Add(), Update(), or UpdateSpecific() method, will override the item's nominal unit of measure.)
requiredByUtc: Optional filter parameter. Holds the UTC date when the goods for a line item are required.
requiredByLocal: Optional filter parameter. Holds 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. If a ship-to entity is not specified, the default time zone will be used to determine the local time.
spare1: Optional filter parameter. Holds the contents of the user-defined spare1 field.
spare2: Optional filter parameter. Holds the contents of the user-defined spare2 field.
spare3: Optional filter parameter. Holds the contents of the user-defined spare3 field.
spare4: Optional filter parameter. Holds the contents of the user-defined spare4 field.
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.

Return Value

Returns a DataSet that contains records for all the purchase order line items that satisfy the specified filters. The returned records include columns from the PO_Line, Cust, Item, and UOM tables. If no matching purchase order line items are 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.
vend_id	A string that is the ID of the vendor, from the PO table.
item_id	A string that is the ID of the item being ordered, from the PO_Line table.
item_desc	A string that is the description of the item being ordered, from the Item table.
num_decimals	An integer that is the number of decimals allowed for the item being ordered, from the Item table.
item_uom_id	An integer that is the ID of the unit of measure for the item being ordered, from the Item table.
item_uom_description	A string that is the description of the unit of measure for the item being ordered, from the UOM 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 UOM that has been defined for the line item, from the PO_Line table. Will be null if a UOM has not been defined for the line item.
description	A string that is the description of the UOM that will be used for the line item, from the UOM table. Will be null if a UOM has not been defined for the line item.
po_line_uom_id	An integer that is the ID of the UOM that is being used for the line item's quantity in the purchase order. If the uom_id column has a value other than null, this value will be the line item UOM ID (that is, the value in the uom_id column). If the uom_id column value is null, this value will be the item UOM ID (that is, the value in the item_uom_id column).
po_line_uom_description	A string that is the description of the UOM that is being used for the line item's quantity in the purchase order. If the uom_id column has a value other than null, this value will be the line item UOM description (that is, the value in the description column). If the uom_id column value is null, this value will be the item UOM description (that is, the value in the item_uom_description column).
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 may 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.
reqd_by	A datetime that is the UTC date when the line item is required with the time zone bias added, from the PO_Line table.
spare1	A string that is the content of the user-defined spare1 field, from the PO_Line table.
spare2	A string that is the content of the user-defined spare2 field, from the PO_Line table.
spare3	A string that is the content of the user-defined spare3 field, from the PO_Line table.
spare4	A string that is the content of the user-defined spare4 field, 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