JDBC Driver for Workday

Build 25.0.9434

RequisitionTemplatesGoodsLines

Stores details of goods line items within requisition templates.

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. 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.

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 for the worktag. */
         -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 for the worktag. */
     -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 Unique identifier for this requisition template goods line instance.
RequisitionTemplates_Id [KEY] String Workday-generated unique ID linking this record to the associated requisition template.
DeliverTo_Descriptor String Human-readable description of the designated delivery location.
DeliverTo_Href String A URL or reference link to the designated delivery location instance.
DeliverTo_Id String Unique identifier associated with the designated delivery location.
Descriptor String A brief, human-readable summary of the instance.
ExtendedAmount_Currency String The currency of the extended amount for the goods line on the requisition, excluding tax-only invoices.
ExtendedAmount_Value Decimal The total extended cost for the goods line on the requisition, excluding tax-only invoices.
FulfillmentSource_Descriptor String Human-readable description of the fulfillment source.
FulfillmentSource_Href String A URL or reference link to the fulfillment source instance.
FulfillmentSource_Id String Unique identifier associated with the fulfillment source.
InventorySite_Descriptor String Human-readable description of the inventory site.
InventorySite_Href String A URL or reference link to the inventory site instance.
InventorySite_Id String Unique identifier associated with the inventory site.
ItemDescription String Text description of the item in the goods line on the requisition.
ItemIdentifiers_Aggregate String Alternative item identifiers associated with the inventory item in the requisition's goods line.
ItemName_Descriptor String Human-readable description of the item.
ItemName_Href String A URL or reference link to the item instance.
ItemName_Id String Unique identifier associated with the item.
ItemTags_Aggregate String Tags assigned to the item in the requisition's goods line, often used for categorization.
Memo String Additional notes or comments associated with the goods line in the requisition.
OrderFromConnection_Descriptor String Human-readable description of the ordering connection.
OrderFromConnection_Href String A URL or reference link to the ordering connection instance.
OrderFromConnection_Id String Unique identifier associated with the ordering connection.
Quantity Decimal The number of units requested for the item in the requisition's goods line.
ShipToAddress_Descriptor String Human-readable description of the shipping address.
ShipToAddress_Href String A URL or reference link to the shipping address instance.
ShipToAddress_Id String Unique identifier associated with the shipping address.
ShipToContact_Descriptor String Human-readable description of the shipping contact person.
ShipToContact_Href String A URL or reference link to the shipping contact instance.
ShipToContact_Id String Unique identifier associated with the shipping contact.
SpendCategory_Descriptor String Human-readable description of the spend category for this requisition.
SpendCategory_Href String A URL or reference link to the spend category instance.
SpendCategory_Id String Unique identifier associated with the spend category.
Splits_Aggregate String Line splits associated with the goods line in the requisition, used for cost allocation.
SupplierItemIdentifier String The unique identifier assigned to the item by the supplier, distinct from the manufacturer ID.
Supplier_Aggregate String The supplier or resource provider associated with the goods line in the requisition, determining the vendor for purchase orders.
UnitCost_Currency String The currency of the unit cost for the goods line in the requisition.
UnitCost_Value Decimal The per-unit cost of the item in the requisition's goods line.
UnitOfMeasure_Descriptor String Human-readable description of the unit of measure (e.g., Each, Box, Pack).
UnitOfMeasure_Href String A URL or reference link to the unit of measure instance.
UnitOfMeasure_Id String Unique identifier associated with the unit of measure.
Worktags_Aggregate String Accounting worktags associated with the goods line in the requisition for financial tracking and reporting.

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