---
title: "PurchaseOrders (Autotask)"
description: "itgen_autotask_purchaseorders_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.PurchaseOrders.PurchaseOrders
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.PurchaseOrders.PurchaseOrders
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/en/
---

# 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:

- [Autotask](/en/release-notes/drivers?driver=autotask)

