ODBC Driver for Workday

Build 24.0.9060

RequisitionTemplatesServiceLines

Reads /serviceLines entries from the RequisitionTemplates table.

Workday Resource Information

Retrieves the goods and service line details of a requisition template with the specified ID. This operation returns only requisition templates that are authorized for use by the processing worker.

You can use the response data from this endpoint to:

* Create a new requisition using POST /requisitions.

* Add a requisition line to an existing requisition using POST /requisitions/{ID}/requisitionLines.

Secured by: REST API Public

Aggregate Fields

The driver 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 Requisition line split. This value displays in the same currency of the Requisition. */
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
  memo: Text /* The memo for a Requisition Line split on the requisition or purchase order. */
  percent: Numeric /* The Percentage specified for the Requisition Line distribution line split. */
  quantity: Numeric /* The Quantity specified for the Requisition Line distribution 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 */
      }
  }]
}]

Supplier_Aggregate


[{
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

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
RequisitionTemplates_Id [KEY] String The Workday ID of the RequisitionTemplates that contains this.
DeliverTo_Descriptor String Supported for: SELECT. A description of the instance
DeliverTo_Href String Supported for: SELECT. A link to the instance
DeliverTo_Id String Supported for: SELECT. wid / id / reference id
Descriptor String Supported for: SELECT. A preview of the instance
EndDate Datetime Supported for: SELECT. The requested end date of the service line on the requisition. Provided by the user who submits the requisition. Can determine the end of the service contract.
ExtendedAmount_Currency String Supported for: SELECT. The extended amount of the service line on the requisition. Doesn't include the extended amounts of tax-only invoices. (Currency name)
ExtendedAmount_Value Decimal Supported for: SELECT. The extended amount of the service line on the requisition. Doesn't include the extended amounts of tax-only invoices. (Value)
FulfillmentSource_Descriptor String Supported for: SELECT. A description of the instance
FulfillmentSource_Href String Supported for: SELECT. A link to the instance
FulfillmentSource_Id String Supported for: SELECT. wid / id / reference id
ItemDescription String Supported for: SELECT. The description for the item of the service line on the requisition.
ItemName_Descriptor String Supported for: SELECT. A description of the instance
ItemName_Href String Supported for: SELECT. A link to the instance
ItemName_Id String Supported for: SELECT. wid / id / reference id
Memo String Supported for: SELECT. The memo of the service line on the requisition.
OrderFromConnection_Descriptor String Supported for: SELECT. A description of the instance
OrderFromConnection_Href String Supported for: SELECT. A link to the instance
OrderFromConnection_Id String Supported for: SELECT. wid / id / reference id
ShipToAddress_Descriptor String Supported for: SELECT. A description of the instance
ShipToAddress_Href String Supported for: SELECT. A link to the instance
ShipToAddress_Id String Supported for: SELECT. wid / id / reference id
ShipToContact_Descriptor String Supported for: SELECT. A description of the instance
ShipToContact_Href String Supported for: SELECT. A link to the instance
ShipToContact_Id String Supported for: SELECT. wid / id / reference id
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 of the service line on the requisition.
StartDate Datetime Supported for: SELECT. The requested start date of the service line on the requisition. Provided by the user who submits the requisition. Can determine the start of a service contract.
Supplier_Aggregate String Supported for: SELECT. A JSON aggregate. The supplier or resource provider of the service line on the requisition. Helps determine the supplier for each line on a purchase order when your order includes multiple suppliers.
Worktags_Aggregate String Supported for: SELECT. A JSON aggregate. The accounting worktags that apply to the service line on the requisition.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060