ODBC Driver for Workday

Build 24.0.9060

RequisitionTemplatesGoodsLines

Reads /goodsLines 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.

ItemIdentifiers_Aggregate


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

ItemTags_Aggregate


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

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
ExtendedAmount_Currency String Supported for: SELECT. The extended amount of the goods 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 goods 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 goods line on the requisition.
ItemIdentifiers_Aggregate String Supported for: SELECT. A JSON aggregate. The alternate item identifiers associated with the inventory item on the goods line of 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
ItemTags_Aggregate String Supported for: SELECT. A JSON aggregate. The item tags associated with a delivery run on a goods line.
Memo String Supported for: SELECT. The memo of the goods 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
Quantity Decimal Supported for: SELECT. The quantity of the item for the goods line on the requisition.
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 goods line on the requisition.
SupplierItemIdentifier String Supported for: SELECT. The alphanumeric identifier that a supplier assigns to an item. Each supplier can provide a unique identifier for the item. This identifier differs from the manufacturer identification number.
Supplier_Aggregate String Supported for: SELECT. A JSON aggregate. The supplier or resource provider of the goods line on the requisition. Helps determine the supplier for each line on a purchase order when your order includes multiple suppliers.
UnitCost_Currency String Supported for: SELECT. The unit cost of the goods line on the requisition. (Currency name)
UnitCost_Value Decimal Supported for: SELECT. The unit cost of the goods line on the requisition. (Value)
UnitOfMeasure_Descriptor String Supported for: SELECT. A description of the instance
UnitOfMeasure_Href String Supported for: SELECT. A link to the instance
UnitOfMeasure_Id String Supported for: SELECT. wid / id / reference id
Worktags_Aggregate String Supported for: SELECT. A JSON aggregate. The accounting worktags that apply to the goods line on the requisition.

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