ADO.NET Provider for Workday

Build 24.0.9175

PurchaseOrdersServiceLines

Reads /serviceLines 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 本製品 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 */
      }
  }]
}]

TaxRecoverability_Aggregate


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

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 The total extended line amount of all invoice lines for the purchase order line. This field works with Goods and Service lines. The currency is the currency of the purchase order.
AmountInvoiced_Value Decimal The total extended line amount of all invoice lines for the purchase order line. This field works with Goods and Service lines. The currency is the currency of the purchase order.
AmountOrdered_Currency String The extended amount for the purchase order line. Excludes extended amounts on Tax Only Invoices.
AmountOrdered_Value Decimal The extended amount for the purchase order line. Excludes extended amounts on Tax Only Invoices.
AmountReceived_Currency String The total extended line amount of all receipt lines for the purchase order line.
AmountReceived_Value Decimal The total extended line amount of all receipt lines for the purchase order line.
DeliverTo_Descriptor String A description of the instance
DeliverTo_Href String A link to the instance
DeliverTo_Id String wid / id / reference id
Descriptor String A preview of the instance
DueDate Datetime The date when the purchase order line is due for delivery. This value is based on the creation date of the purchase order and lead time for the item.
EndDate Datetime The end date for the simple service order line.
ExtendedAmount_Currency String The extended amount for the purchase order line. Excludes extended amounts on tax only invoices.
ExtendedAmount_Value Decimal The extended amount for the purchase order line. Excludes extended amounts on tax only invoices.
ItemDescription String The line item description for the purchase order line.
ItemName_Descriptor String A description of the instance
ItemName_Href String A link to the instance
ItemName_Id String wid / id / reference id
Location_Descriptor String A description of the instance
Location_Href String A link to the instance
Location_Id String wid / id / reference id
Memo String The line memo for the purchase order line.
Prepaid Bool If true, the purchase order line is prepaid.
Retention Bool If true, the purchase order line has retention.
ShipToAddress_Descriptor String A description of the instance
ShipToAddress_Href String A link to the instance
ShipToAddress_Id String wid / id / reference id
ShipToContact_Descriptor String A description of the instance
ShipToContact_Href String A link to the instance
ShipToContact_Id String wid / id / reference id
SpendCategory_Descriptor String A description of the instance
SpendCategory_Href String A link to the instance
SpendCategory_Id String wid / id / reference id
Splits_Aggregate String The line splits on the purchase order line. Empty when the purchase order line doesn't have splits.
StartDate Datetime The start date for the simple service order line.
TaxApplicability_Descriptor String A description of the instance
TaxApplicability_Href String A link to the instance
TaxApplicability_Id String wid / id / reference id
TaxCode_Descriptor String A preview of the instance
TaxCode_Id String Id of the instance
TaxRecoverability_Aggregate String The tax recoverability percentage on a taxable purchase order line.
Worktags_Aggregate String The Worktags for the purchase order line.
Buyer_Prompt String 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 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 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 Filters the purchase orders by status. Specify the Workday ID of the status. You can specify multiple status query parameters.
SubmittedBy_Prompt String 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 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175