Reads /projectBasedServiceLines entries from the PurchaseOrders table.

Workday Resource Information

Retrieves a purchase order with the specified ID.

Secured by: Process: Purchase Order - View, Process: Supplier Invoice (OLD)+TG, 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.

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 /* A preview of the instance */
  id: Text /* Id of the instance */
  location: { /* The location as a worktag. */
      descriptor: Text /* A description 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 /* A preview of the instance */
      href: Text /* A link to the instance */
      id: Text /* Id of the instance */
      worktagType: { /* The worktag type. */
          descriptor: Text /* A description 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 /* A preview of the instance */
  id: Text /* Id of the instance */
  task: { /* Returns the \~Project\~ Plan Task associated with this \~Project\~ Subtask */
      descriptor: Text /* A preview 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 unique \~project plan phase\~ in a \~project\~. The \~project plan phase\~ is unique to the \~project\~ while the \~project phase\~ is globally unique in the tenant. */
          descriptor: Text /* A preview 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 /* A preview of the instance */
  href: Text /* A link to the instance */
  id: Text /* Id of the instance */
  worktagType: { /* The worktag type. */
      descriptor: Text /* A description of the instance */
      href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
}]

Columns

Name	Type	Description
Id [KEY]	String	Id of the instance
PurchaseOrders_Id [KEY]	String	The Workday ID of the PurchaseOrders that contains this.
AmountInvoiced_Currency	String	Supported for: SELECT. The total extended line amount of all invoice lines for the project based purchase order line. (Currency name)
AmountInvoiced_Value	Decimal	Supported for: SELECT. The total extended line amount of all invoice lines for the project based purchase order line. (Value)
AmountReceived_Currency	String	Supported for: SELECT. The total extended line amount of all receipt lines for the project based purchase order line. (Currency name)
AmountReceived_Value	Decimal	Supported for: SELECT. The total extended line amount of all receipt lines for the project based purchase order line. (Value)
Descriptor	String	Supported for: SELECT. A preview of the instance
ExtendedAmount_Currency	String	Supported for: SELECT. The extended amount for the purchase order line. Excludes the extended amounts on Tax Only Invoices. (Currency name)
ExtendedAmount_Value	Decimal	Supported for: SELECT. The extended amount for the purchase order line. Excludes the extended amounts on Tax Only Invoices. (Value)
Memo	String	Supported for: SELECT. The memo for the project based purchase order line.
Prepaid	Bool	Supported for: SELECT. If true, the purchase order line is prepaid.
Project_Descriptor	String	Supported for: SELECT. A preview of the instance
Project_EndDate	Datetime	Supported for: SELECT. The approved project end date.
Project_Id	String	Supported for: SELECT. Id of the instance
Project_Name	String	Supported for: SELECT. The approved project name.
Project_Reference	String	Supported for: SELECT. The reference ID of a project from an external or third-party system.
Project_StartDate	Datetime	Supported for: SELECT. The approved project start date.
Retention	Bool	Supported for: SELECT. If true, retention check box is selected.
SpendCategory_Descriptor	String	Supported for: SELECT. A description of the instance
SpendCategory_Href	String	Supported for: SELECT. A link to the instance
SpendCategory_Id	String	Supported for: SELECT. wid / id / reference id
Splits_Aggregate	String	Supported for: SELECT. A JSON aggregate. The line splits for the project based purchase order line. The field is empty if the line doesn't have splits.
Subtasks_Aggregate	String	Supported for: SELECT. A JSON aggregate. The project subtask for the project based purchase order line. Projects are always on project based service lines.
Worktags_Aggregate	String	Supported for: SELECT. A JSON aggregate. The worktags for the project based purchase order line.
Buyer_Prompt	String	Accepts multiple inputs. Filters the purchase orders by buyer. Specify the Workday ID of the worker assigned as buyer on the purchase order. You can specify multiple buyer query parameters.
Company_Prompt	String	Accepts multiple inputs. Filters the purchase orders by company. Specify the Workday ID of the company. You can specify multiple company query parameters.
ExcludeCanceled_Prompt	Bool	If true, this method excludes the purchase orders with Canceled status. The default is false.
ExcludeClosed_Prompt	Bool	If true, this method excludes the purchase orders with Closed status. The default is false.
FromDate_Prompt	Date	Filters the purchase orders with document date on or after the specified date. Use the yyyy-mm-dd format.
OrderFromConnection_Prompt	String	Accepts multiple inputs. Filters the purchase orders by supplier order-from connections. Specify the Workday ID of the order-from connection. You can specify multiple order-from connection query parameters.
Status_Prompt	String	Accepts multiple inputs. Filters the purchase orders by status. Specify the Workday ID of the status. You can specify multiple status query parameters.
SubmittedBy_Prompt	String	Accepts multiple inputs. Filters the purchase orders by the worker who submitted the purchase order. Specify the Workday ID of the worker. You can specify multiple submittedBy query parameters. You can use a returned id from GET /workers in the Staffing REST web service.
Supplier_Prompt	String	Accepts multiple inputs. Filters the purchase orders by supplier. Specify the Workday ID of the supplier. You can specify multiple supplier query parameters.
ToDate_Prompt	Date	Filters the purchase orders with document date on or before the specified date. Use the yyyy-mm-dd format.