Stores detailed line items for goods included in purchase orders, providing transparency into ordered products, quantities, and costs.

Workday Resource Information

Retrieves a purchase order with the specified ID.

Secured by: Process: Purchase Order - View, Process: Supplier Invoice (OLD), Process: Supplier Invoice - View, Self-Service: Purchase Order, Self-Service: Supplier Contact Tasks, View: Organization Purchase Order

Scope: Procurement, Supplier Accounts

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Splits_Aggregate

[{
  amount: Currency /* The amount on the purchase order transaction line split. */
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
  location: { /* The location worktag for a purchase order line split. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  memo: Text /* The memo for a purchase order line split. */
  percent: Numeric /* The percentage for a purchase order line split. */
  quantity: Numeric /* The quantity for the purchase order line split. */
  worktags: [{
      descriptor: Text /* The display name of the instance */
      href: Text /* A link to the instance */
      id: Text /* Id of the instance */
      worktagType: { /* The worktag type for the worktag. */
         -descriptor: Text /* The display name of the instance */
         -href: Text /* A link to the instance */
         *id: Text /* wid / id / reference id */
      }
  }]
}]

TaxRecoverability_Aggregate

[{
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
  percentRecoverable: Numeric /* The tax recoverable percentage for tax recoverability. */
}]

Worktags_Aggregate

[{
  descriptor: Text /* The display name of the instance */
  href: Text /* A link to the instance */
  id: Text /* Id of the instance */
  worktagType: { /* The worktag type for the worktag. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
}]

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier for the purchase order goods line. This ID is system-generated and used for reference across Workday.
PurchaseOrders_Id [KEY]	String	The unique Workday ID (WID) for the purchase order that contains this line item. This ID is used to link the goods line to its parent purchase order.
DeliverTo_Descriptor	String	The display name of the instance
DeliverTo_Href	String	A hyperlink reference pointing to the full Workday record of the delivery recipient, allowing direct navigation within the system.
DeliverTo_Id	String	The identifier (WID, ID, reference ID) uniquely associating this record with a delivery recipient.
DeliveryType_Descriptor	String	The display name of the instance
DeliveryType_Href	String	A hyperlink reference to the full Workday record of the delivery type, enabling direct access to additional details.
DeliveryType_Id	String	The identifier (WID, ID, reference ID) linking this purchase order line to a specific delivery type.
Descriptor	String	The display name of the instance
DueDate	Datetime	The expected delivery date for this purchase order line, calculated based on the purchase order creation date and item lead time. Ensures timely receipt of goods.
ExtendedAmount_Currency	String	The currency used for the extended amount value of this purchase order line. This indicates the monetary unit for cost calculations.
ExtendedAmount_Value	Decimal	The total cost of this purchase order line, excluding tax-only invoices. This value is calculated by multiplying the unit cost by the quantity ordered.
ItemDescription	String	A detailed description of the item purchased, including specifications, model numbers, or other key identifiers to ensure clarity for procurement and inventory.
ItemName_Descriptor	String	The display name of the instance
ItemName_Href	String	A hyperlink reference to the full Workday record of the item, allowing easy access to additional specifications and procurement details.
ItemName_Id	String	The identifier (WID, ID, reference ID) uniquely linking this purchase order line to an item record in the system.
LeadTime	Decimal	The number of days required for the item to be delivered from the time of purchase. This value helps in scheduling and inventory management.
Location_Descriptor	String	The display name of the instance
Location_Href	String	A hyperlink reference to the Workday record of the delivery location, providing additional details and context.
Location_Id	String	The identifier (WID, ID, reference ID) uniquely linking this record to a location in the system.
Memo	String	Internal notes or comments related to this purchase order line. Often used for justifications, special instructions, or tracking reference numbers.
Prepaid	Bool	Indicates whether this purchase order line was prepaid. If the value is 'true,' the payment was processed before goods were received.
QuantityInvoiced	Decimal	The total quantity of this item that has been invoiced across one or more supplier invoices. Helps track billing status and payment reconciliation.
QuantityOrdered	Decimal	The total number of units of this item ordered on the purchase order.
QuantityReceived	Decimal	The total quantity of this item received. If any returns exist, the returned quantity is subtracted from this value.
QuantityShipped	Decimal	The total quantity of this item shipped by the supplier, used to track delivery progress.
RequestedAsNoCharge	Bool	Indicates whether this item was requested as a no charge item, often used for internal transfers or promotional items.
Retention	Bool	Indicates whether this purchase order line has retention applied, meaning a portion of the payment is withheld until specific conditions are met.
ShipToAddress_Descriptor	String	The display name of the instance
ShipToAddress_Id	String	The identifier uniquely linking this purchase order line to a shipping address record.
ShipToContact_Descriptor	String	The display name of the instance
ShipToContact_Href	String	A hyperlink reference to the full Workday record of the ship-to contact, providing further details and contact information.
ShipToContact_Id	String	The identifier linking this record to the ship-to contact in the system.
SpendCategory_Descriptor	String	The display name of the instance
SpendCategory_Href	String	A hyperlink reference to the full Workday record of the spend category, enabling quick access to additional financial details.
SpendCategory_Id	String	The identifier linking this purchase order line to a spend category.
Splits_Aggregate	String	Detailed breakdown of line splits, showing how costs are allocated across multiple cost centers, departments, or funding sources. This field remains empty if no splits exist.
SupplierItemIdentifier	String	The unique identifier assigned to this item by the supplier. This value can differ for each supplier providing the same item. Helps in procurement tracking.
TaxApplicability_Descriptor	String	The display name of the instance
TaxApplicability_Href	String	A hyperlink reference to the full Workday record for tax applicability, providing additional compliance details.
TaxApplicability_Id	String	The identifier linking this purchase order line to tax applicability details.
TaxCode_Descriptor	String	The display name of the instance
TaxCode_Id	String	The identifier linking this purchase order line to a tax code record in the system.
TaxRecoverability_Aggregate	String	The percentage of tax that can be recovered for this taxable purchase order line, used for tax reporting and compliance.
UnitCost_Currency	String	The currency used for the unit cost of the item. Ensures accurate financial calculations and reporting.
UnitCost_Value	Decimal	The price per unit of this item in the specified currency, used for cost calculations and budgeting.
UnitOfMeasure_Descriptor	String	The display name of the instance
UnitOfMeasure_Href	String	A hyperlink reference to the Workday record for the unit of measure, allowing direct access to measurement details.
UnitOfMeasure_Id	String	The identifier linking this purchase order line to a unit of measure record.
Worktags_Aggregate	String	A collection of worktags associated with this purchase order line. Worktags are used for financial tracking and reporting.
Buyer_Prompt	String	Filters purchase orders by the buyer assigned in Workday. Accepts one or multiple WIDs of buyers.
Company_Prompt	String	Filters purchase orders by company. Accepts one or multiple WIDs of companies to refine results.
ExcludeCanceled_Prompt	Bool	If the value is 'true,' it excludes purchase orders with a Canceled status from the results. The default is 'false.'
ExcludeClosed_Prompt	Bool	If the value is 'true,' it excludes purchase orders with a Closed status from the results. The default is 'false.'
FromDate_Prompt	Date	Filters purchase orders with a document date on or after the specified date. Format: YYYY-MM-DD.
OrderFromConnection_Prompt	String	Filters purchase orders by supplier order-from connections. Accepts one or multiple WIDs.
Status_Prompt	String	Filters purchase orders by status. Accepts one or multiple WIDs for status.
SubmittedBy_Prompt	String	Filters purchase orders by submitter. Accepts one or multiple WIDs of workers who submitted the order.
Supplier_Prompt	String	Filters purchase orders by supplier. Accepts one or multiple WIDs of suppliers.
ToDate_Prompt	Date	Filters purchase orders with a document date on or before the specified date. Format: YYYY-MM-DD.