GetAll Method (PO)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal poId As String, _
ByVal vendId As String, _
ByVal sellerId As Nullable(Of Integer), _
ByVal shipTo As Nullable(Of Integer), _
ByVal dateIssuedUtc As Nullable(Of Date), _
ByVal dateIssuedLocal As Nullable(Of Date), _
ByVal stateCode As Nullable(Of PurchaseOrderState), _
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 vendId As String
Dim sellerId As Nullable(Of Integer)
Dim shipTo As Nullable(Of Integer)
Dim dateIssuedUtc As Nullable(Of Date)
Dim dateIssuedLocal As Nullable(Of Date)
Dim stateCode As Nullable(Of PurchaseOrderState)
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 = PO.GetAll(poId, vendId, sellerId, shipTo, dateIssuedUtc, dateIssuedLocal, stateCode, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string poId,
string vendId,
Nullable<int> sellerId,
Nullable<int> shipTo,
Nullable<DateTime> dateIssuedUtc,
Nullable<DateTime> dateIssuedLocal,
Nullable<PurchaseOrderState> stateCode,
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.
- vendId
- Optional filter parameter. Holds the ID of a vendor.
- sellerId
- Optional filter parameter. Holds the ID of the seller from whom the order was purchased.
- shipTo
- Optional filter parameter. Holds the ID of an entity at which purchased goods are to be received.
- dateIssuedUtc
- Optional filter parameter. Holds the UTC date when a purchase order was issued.
- dateIssuedLocal
- Optional filter parameter. Holds the date when a purchase order was issued in the local time of the entity specified by the shipTo parameter, if supplied. If a ship-to entity is not specified, the default time zone will be used to determine the local time.
- stateCode
Optional filter parameter. Holds the state of a purchase order.
0=Open (the default)
1=Partially Complete
2=Complete
3=Closed
- 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 orders that satisfy the specified filters. The returned records include columns from the PO table. If no matching purchase orders 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. |
|
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. |