CData Python Connector for Workday

Build 25.0.9454

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 connector 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 /* The display name 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 /* The display name 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

The display name of the instance

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

The display name of the instance

DeliverToLocation_Id String False

The Workday ID of the deliver-to location.

Descriptor String False

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

The display name of the instance

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

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