RequisitionsRequisitionLines

Manages line items within requisitions, including requested quantities and pricing.

Workday Resource Information

Retrieves a requisition line with the specified ID for the specified requisition.

Secured by: Checkout (REST), Process: Requisition - Reporting, Process: Requisition - View, Self-Service: Requisition, Self-Service: Supplier Contact Tasks, View: Organization Requisition

Scope: Procurement

Contains attachment(s)

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.

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	ReadOnly	Description
Id [KEY]	String	False	Unique identifier for the requisition line.
Requisitions_Id [KEY]	String	False	The Workday ID of the requisition to which this line belongs.
CatalogItem	Bool	False	Indicates whether this requisition line is for a catalog item.
CommodityCode_Descriptor	String	False	Description of the commodity code associated with this requisition line.
CommodityCode_Href	String	False	A link to the commodity code instance.
CommodityCode_Id	String	False	The Workday ID or reference ID for the commodity code.
CreatedMoment	Datetime	False	Timestamp indicating when the requisition line was created.
CriticalCustomValidations	String	False	List of critical validation messages that failed, formatted as a single string with HTML line feed delimiters.
DeliverToLocation_Descriptor	String	False	Description of the deliver-to location for this requisition line.
DeliverToLocation_Id	String	False	The Workday ID of the deliver-to location.
Descriptor	String	False	A brief description of the requisition line.
EndDate	Datetime	False	The requested end date for service-based requisition lines. This can be configured as hidden in Workday.
ExtendedAmount_Currency	String	False	Currency of the extended amount for this requisition line.
ExtendedAmount_Value	Decimal	False	Total extended amount for the requisition line, excluding tax-only invoices.
FormattedExtendedAmount	String	False	Formatted total amount including currency symbol, adjusted for user locale settings.
FormattedShippingAddress	String	False	Full shipping address for this requisition line, formatted as a single string with HTML line feed delimiters.
FormattedUnitCost	String	False	Formatted unit cost including currency symbol, adjusted based on user locale settings.
Href	String	False	A link to the requisition line instance in Workday.
ItemDescription	String	False	Detailed description of the item in this requisition line.
ItemImage_Descriptor	String	False	Description of the associated item image.
ItemImage_Href	String	False	A link to the associated item image instance.
ItemImage_Id	String	False	The Workday ID of the associated item image.
ItemImage_InternalURL	String	False	Internal Workday UI Server URL for the item image.
ItemRanking	Decimal	False	Ranking assigned to the item in this requisition line.
ItemURL	String	False	Workday Instance View URL for the procurement item linked to this requisition line.
Item_Descriptor	String	False	A description of the procurement item for this requisition line.
Item_Href	String	False	A link to the procurement item instance.
Item_Id	String	False	The Workday ID or reference ID of the procurement item.
LineCompany_Descriptor	String	False	Description of the company associated with this requisition line.
LineCompany_Id	String	False	The Workday ID of the associated company.
LineDeliverToLocationChain	String	False	Full hierarchy of deliver-to locations for this requisition line.
LotSerialInformation_Descriptor	String	False	A preview of the lot/serial information for this requisition line.
LotSerialInformation_Id	String	False	The Workday ID of the lot/serial information.
LotSerialInformation_LotNumber	String	False	The lot number for the lot and serial transaction.
LotSerialInformation_SerialNumber	String	False	The lot serial number for the lot and serial transaction.
Memo	String	False	Memo field for additional details. Can be hidden using Workday configuration.
NoCharge	Bool	False	Indicates if this is a no-charge requisition line.
OrderFromConnection_Descriptor	String	False	Description of the ordering connection associated with this line.
OrderFromConnection_Id	String	False	The Workday ID of the ordering connection.
Quantity	Decimal	False	Quantity requested in this requisition line. Supports up to 20 integer places and 2 decimal precision.
RequestedDeliveryDate	Datetime	False	The requested delivery date for the item in this requisition line.
RfqRequired	Bool	False	Indicates if a Request for Quote (RFQ) is required.
SearchTerm	String	False	Search term used in Workday's catalog for this item.
ServiceRequisitionLine	Bool	False	Indicates whether this requisition line is for a service.
ShipToAddressReference_Descriptor	String	False	Description of the ship-to address reference.
ShipToAddressReference_Href	String	False	A link to the ship-to address reference instance.
ShipToAddressReference_Id	String	False	The Workday ID of the ship-to address reference.
ShipToAddress_Descriptor	String	False	Description of the ship-to address for this requisition line.
ShipToAddress_Href	String	False	A link to the ship-to address instance.
ShipToAddress_Id	String	False	The Workday ID of the ship-to address.
ShipToContact_Descriptor	String	False	Description of the ship-to contact.
ShipToContact_Href	String	False	A link to the ship-to contact instance.
ShipToContact_Id	String	False	The Workday ID of the ship-to contact.
SpendCategory_Descriptor	String	False	Description of the spend category.
SpendCategory_Href	String	False	A link to the spend category instance.
SpendCategory_Id	String	False	The Workday ID of the spend category.
StartDate	Datetime	False	Requested start date for service requisition lines.
SupplierContract_Descriptor	String	False	Description of the supplier contract associated with this requisition line.
SupplierContract_Href	String	False	A link to the supplier contract instance.
SupplierContract_Id	String	False	The Workday ID of the supplier contract.
SupplierItemIdentifier	String	False	Supplier-assigned identifier for the item in this requisition line.
Supplier_Descriptor	String	False	Description of the supplier for this requisition line.
Supplier_Href	String	False	A link to the supplier instance.
Supplier_Id	String	False	The Workday ID of the supplier.
UnitCost_Currency	String	False	Currency of the unit cost for this requisition line.
UnitCost_Value	Decimal	False	Unit cost for this requisition line.
UnitOfMeasure_Descriptor	String	False	Description of the unit of measure used in this requisition line.
UnitOfMeasure_Href	String	False	A link to the unit of measure instance.
UnitOfMeasure_Id	String	False	The Workday ID of the unit of measure.
WarningCustomValidations	String	False	List of warning messages for custom validations that failed, formatted as a single string with HTML line feed delimiters.
WebItem	Bool	False	Indicates whether this requisition line is for a web item.
WebItemImageURL	String	False	URL of the supplier’s web image for this item.
Worktags_Aggregate	String	False	All worktags assigned to this requisition line.
WriteInGoods	Bool	False	Indicates if this requisition line is a write-in goods line without a predefined purchase item or supplier item.
WriteInService	Bool	False	Indicates if this requisition line is a write-in service line without a predefined purchase item or supplier item.
ExternalSourceableId_Prompt	String	False	External system reference ID for this requisition line.
ExternalSystemId_Prompt	String	False	External system ID associated with this requisition line.
FromDate_Prompt	Date	False	Filters requisitions with a document date on or after the specified date (yyyy-mm-dd format).
Requester_Prompt	String	False	Filters requisitions by requester, using the Workday ID of the worker who created the requisition.
RequisitionType_Prompt	String	False	Filters requisitions by type, specifying the Workday ID of the requisition type (supports multiple values).
SubmittedByPerson_Prompt	String	False	Filters requisitions by the person who submitted them, using their Workday ID or reference ID.
SubmittedBySupplier_Prompt	String	False	Filters requisitions by the supplier who submitted them, using their Workday ID or reference ID (supports multiple values).
SubmittedBy_Prompt	String	False	Filters requisitions by the worker who submitted them, using their Workday ID or reference ID.
ToDate_Prompt	Date	False	Filters requisitions with a document date on or before the specified date (yyyy-mm-dd format).

ODBC Driver for Workday

RequisitionsRequisitionLines

Workday Resource Information

Aggregate Fields

Worktags_Aggregate

Columns