invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseOrders: Autotask itgen_autotask_purchaseorders_plural

read only REST

  • Catalog: Autotask
  • Schema: PurchaseOrders
  • Label: itgen_autotask_purchaseorders_plural

Can only retrieve data.

API Source

  • Endpoint: /V1.0/PurchaseOrders/query
  • Operation: get /V1.0/PurchaseOrders/query

Table Columns

The columns of the table PurchaseOrders are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
cancelDateTime datetime Cancel Date/Time
createDateTime datetime Created
creatorResourceID int32 Creator Resource ID
externalPONumber varchar2 External PO Number
fax varchar2 Fax
freight double Freight
generalMemo varchar2 General Memo
id int64 ID
impersonatorCreatorResourceID int32 Imperonsator Creator Resource ID
internalCurrencyFreight double Internal Currency Freight
latestEstimatedArrivalDate datetime Latest Estimated Arrival Date
paymentTerm int32 Payment Term
phone varchar2 Phone
purchaseForCompanyID int32 Purchase for Company ID
purchaseOrderNumber varchar2 Purchase Order Number
purchaseOrderTemplateID int32 Purchase Order Template ID
shippingDate datetime Shipping Date
shippingType int32 Shipping Type
shipToAddress1 varchar2 Ship-to Address 1
shipToAddress2 varchar2 Ship-to Address 2
shipToCity varchar2 Ship-to City
shipToName varchar2 Ship-to Name
shipToPostalCode varchar2 Ship-to Postal Code
shipToState varchar2 Ship-to State
showEachTaxInGroup char Show Each Tax in Group
showTaxCategory char Show Tax Category
status int32 Status
submitDateTime datetime Submit Date/Time
taxRegionID int32 Tax Region ID
useItemDescriptionsFrom int32 Use Item Descriptions from
vendorID int32 Vendor ID
vendorInvoiceNumber varchar2 Vendor Invoice Number

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: