MES Stateless API

GetByKey Method (PO)

Save PDF

TABLE OF CONTENTS

GetByKey Method (PO)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetByKey() method retrieves the specified purchase order record from the PO table.

The purchase order is uniquely identified by the purchase order ID in the purchase order record.

Syntax

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

'Usage
 
Dim poId As String
Dim value As DataSet
 
value = PO.GetByKey(poId)

public static DataSet GetByKey( 
   string poId
)

Parameters

poId: Required. Holds the ID of the purchase order.

Return Value

Returns a DataSet that contains the DataRow of the specified purchase order in the PO table. If no matching record for the specified purchase order 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.
vend_id	A string that is the vender ID.
seller_id	An integer that is the seller ID from whom this order was purchased
ship_to	An integer that is the ID of the entity at which purchased goods are to be received.
date_issued_utc	A datetime that is the UTC time when the purchase order was issued.
date_issued_local	A datetime that is the local time when the purchase order was issued in the local time of the entity specified by ship_to, if supplied. If a ship-to entity is not specified, the default time zone will be used to determine the local time.
date_issued	A datetime that is the time when the purchase order was issued in the local time of the client from which the method was called.
state_cd	An integer that indicates the state of the purchase order: 0=Open 1=Partial Complete 2=Complete 3=Closed
notes	A string that is the notes for the purchase order.
spare1 to spare4	A string that is the content of the spare1 to spare4 values.
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

GetByKey Method (PO)

Table of Contents

GetByKey Method (PO)

In This Topic

MES Stateless API

GetByKey Method (PO)

Syntax

Parameters

Return Value

See Also

Reference

In This Topic