Returns the list of purchase orders.

View-Specific Information

Select

The driver will use the ShipStation API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

• Id, OrderNumber, Status and ReferenceNumber support the following operator: =.
• CreateDate supports the following operators: >,>=.

For example, the following queries are processed server side:

SELECT * FROM PurchaseOrders WHERE Id = 'se-4567'

SELECT * FROM PurchaseOrders WHERE OrderNumber = 'se-2345'

SELECT * FROM PurchaseOrders WHERE Status = 'open'

SELECT * FROM PurchaseOrders WHERE ReferenceNumber = '1234'

SELECT * FROM PurchaseOrders WHERE CreateDate > '2024-11-13T23:47:25.293-05:00'

SELECT * FROM PurchaseOrders WHERE CreateDate >= '2024-11-13T23:47:25.293-05:00'

Columns

Name	Type	References	Description
Id [KEY]	String		A string that uniquely identifies the purchase order.
OrderNumber	String		The purchase order number.
SupplierId	String	Suppliers.Id	A string that uniquely identifies the supplier.
SupplierName	String		The name of the supplier.
Status	String		The status of the purchase order. The allowed values are draft, open, receiving, received, cancelled, closed.
OrderDate	Datetime		The date the purchase order was placed.
ExpectedDeliveryDate	Datetime		The expected delivery date of the purchase order.
CreateDate	Datetime		The date and time the purchase order was created.
ModifyDate	Datetime		The date and time the purchase order was last modified.
ReferenceNumber	String		An optional reference number for the purchase order.
WarehouseId	String	Warehouses.Id	A string that uniquely identifies the destination warehouse.
PaymentTerms	String		The payment terms for the purchase order.
PaymentStatus	String		The payment status of the purchase order.
CurrencyCode	String		The currency code for the purchase order.
ShippingCarrier	String		The shipping carrier for the purchase order.
TrackingNumber	String		The tracking number for the purchase order shipment.
NoteToSupplier	String		An optional note to the supplier for the purchase order.