Tracks service lines within project-based purchase orders, detailing services procured in connection with specific projects.

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 */
      }
  }]
}]

Subtasks_Aggregate

[{
  amount: Currency /* The amount for the project subtask. The value can be negative and will be precise up to 6 decimal places. */
  description: Text /* The description of a project subtask on the document line. The project subtasks are always on the 
project based service lines for procurement transactions. */
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
  task: { /* The project plan task associated with the project subtask. */
      descriptor: Text /* The display name of the instance */
      endDate: Date /* The project plan task end date. */
      id: Text /* Id of the instance */
      name: Text /* The project plan task name. */
      phase: { /* The project plan phase for a project. The project plan phase is unique to the project and the project phase is unique to the tenant. */
          descriptor: Text /* The display name of the instance */
          id: Text /* Id of the instance */
          name: Text /* The name of the phrase associated with a project plan. */
      }
      startDate: Date /* The project plan task start date. */
  }
}]

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 each instance of a project-based service line in the Purchase Orders module. This ID is used to track and reference specific service line entries within the system.
PurchaseOrders_Id [KEY]	String	The Workday system-generated unique identifier of the Purchase Order that this project-based service line is associated with.
AmountInvoiced_Currency	String	The currency in which the total amount invoiced for this project-based purchase order line is recorded. This includes all invoice lines linked to the purchase order line.
AmountInvoiced_Value	Decimal	The total monetary amount invoiced for this project-based purchase order line, represented in the specified currency. Includes the sum of all related invoice lines.
AmountReceived_Currency	String	The currency in which the total amount received for this project-based purchase order line is recorded. This includes all receipt lines associated with the purchase order line.
AmountReceived_Value	Decimal	The total monetary amount received for this project-based purchase order line, represented in the specified currency. Includes the sum of all related receipt lines.
Descriptor	String	The display name of the instance
ExtendedAmount_Currency	String	The currency in which the extended amount for this purchase order line is recorded. The extended amount reflects the full value of the purchase order line, excluding tax-only invoices.
ExtendedAmount_Value	Decimal	The total extended amount for this purchase order line, representing the agreed price before taxes and adjustments, excluding amounts specific to tax-only invoices.
Memo	String	Additional notes or comments recorded for this project-based purchase order line, typically entered by users for reference purposes.
Prepaid	Bool	Indicates whether the purchase order line has been prepaid. If the value is 'true,' the cost has been paid in advance rather than upon receipt of goods or services.
Project_Descriptor	String	The display name of the instance
Project_EndDate	Datetime	The officially approved end date for the project, marking the conclusion of its planned activities and commitments.
Project_Id	String	A unique identifier assigned to the project instance, ensuring distinct tracking and reference within the system.
Project_Name	String	The officially designated name of the project, approved for use in records, reports, and project-related documentation.
Project_Reference	String	An external or third-party reference identifier for the associated project, which can be used for integration with other systems.
Project_StartDate	Datetime	The scheduled or approved start date of the project associated with this purchase order line.
Retention	Bool	Indicates whether the retention checkbox is selected for this purchase order line. If the value is 'true,' retention can be applied, typically meaning a portion of the payment is withheld until project completion.
SpendCategory_Descriptor	String	The display name of the instance
SpendCategory_Href	String	A URL link to the spend category instance, which provides additional details or navigation to the relevant Workday object.
SpendCategory_Id	String	The Workday unique identifier (WID), system ID, or reference ID for the spend category associated with this purchase order line.
Splits_Aggregate	String	A detailed breakdown of the line item splits for this project-based purchase order line. If the line has no splits, this field remains empty.
Subtasks_Aggregate	String	A collection of project-related subtasks associated with this purchase order line. Subtasks indicate task-level granularity within the project.
Worktags_Aggregate	String	The worktags assigned to this purchase order line, which help categorize and track financial transactions within Workday.
Buyer_Prompt	String	Filters purchase orders by the assigned buyer. Specify the Workday ID of the worker designated as the buyer on the purchase order. Multiple buyer IDs can be used.
Company_Prompt	String	Filters purchase orders based on the company they are associated with. Provide the Workday ID of the company. Multiple company IDs can be used.
ExcludeCanceled_Prompt	Bool	If the value is 'true,' this query excludes purchase orders that have been canceled. The default value is 'false,' meaning canceled orders are included.
ExcludeClosed_Prompt	Bool	If the value is 'true,' this query excludes purchase orders that have been closed. The default value is 'false,' meaning closed orders are included.
FromDate_Prompt	Date	Filters purchase orders to include only those with a document date on or after the specified date. Expected format: YYYY-MM-DD.
OrderFromConnection_Prompt	String	Filters purchase orders based on supplier order-from connections. Provide the Workday ID of the order-from connection. Multiple connection IDs can be used.
Status_Prompt	String	Filters purchase orders based on their status. Specify the Workday ID corresponding to the status. Multiple status IDs can be used.
SubmittedBy_Prompt	String	Filters purchase orders by the worker who submitted them. Provide the Workday ID of the submitting worker. Multiple worker IDs can be used.
Supplier_Prompt	String	Filters purchase orders by supplier. Provide the Workday ID of the supplier. Multiple supplier IDs can be used.
ToDate_Prompt	Date	Filters purchase orders to include only those with a document date on or before the specified date. Expected format: YYYY-MM-DD.