API Data Provider - Online Help

PurchaseOrders

Returns a summary of all Purchase Orders.

Columns

Name Type References
Id [KEY] Integer
Name String
State String

The allowed values are Draft, Pending Approval, Approved, Rejected, Received.

Number Integer
Notes String
TotalCost String
Currency String
Tax Double
ShippingHandling Double
BillingAddress String
ShippingAddress String
PaymentTerms String
TermsConditions String
DueDate Datetime
OrderDate Datetime
CreatedAt Datetime
UpdatedAt Datetime
RequesterId Integer

Users.Id

RequesterName String
RequesterHref String
BuyerId Integer

Users.Id

BuyerName String
BuyerHref String
VendorId Integer

Vendors.Id

VendorName String
VendorHref String
PurchaseOrderItems String
Approvers String
Tags String
Tasks String
Incidents String
OtherAssets String
CustomFieldsValues String
Href String

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0