ODBC Driver for Workday

Build 25.0.9434

SupplierInvoiceRequestsLines

Tracks individual line items within supplier invoice requests.

Workday Resource Information

Retrieves all supplier invoice lines for the specified supplier invoice.

Secured by: Process: Supplier Invoice - Request, View: Supplier Invoice Request

Scope: Supplier Accounts

Columns

Name Type Description
Id [KEY] String Unique identifier for this supplier invoice request line instance.
SupplierInvoiceRequests_Id [KEY] String Workday-generated unique ID linking this record to the associated supplier invoice request.
Billable Bool Indicates whether the supplier invoice request line or line split is billable (true/false).
Descriptor String A brief, human-readable summary of the instance.
ExtendedAmount_Currency String The currency of the extended amount for the document line, excluding tax-only invoices.
ExtendedAmount_Value Decimal The extended amount for the document line, excluding tax-only invoices.
InternalMemo String The internal memo associated with the supplier invoice request line.
ItemDescription String The text-only description of the item on the document line.
Item_Descriptor String A human-readable description of the item associated with the document line.
Item_Href String A URL or reference link to the item instance.
Item_Id String Unique identifier associated with the item.
Memo String The memo associated with the document line.
Quantity Decimal The quantity of items on the transaction line, precise to two decimal places. Can be a negative value.
SpendCategory_Descriptor String A human-readable description of the spend category.
SpendCategory_Href String A URL or reference link to the spend category instance.
SpendCategory_Id String Unique identifier associated with the spend category.
SplitBy_Descriptor String A human-readable description of how the supplier invoice request line is split.
SplitBy_Href String A URL or reference link to the split method instance.
SplitBy_Id String Unique identifier associated with the split method.
Type String The type of the supplier invoice request line (for example, item, service, charge).
UnitCost_Currency String The currency of the unit cost for the document line.
UnitCost_Value Decimal The unit cost for the document line.
UnitOfMeasure_Descriptor String A human-readable description of the unit of measure.
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.
Company_Prompt String Filter supplier invoice requests by company. Used for internal REST API purposes.
FromDueDate_Prompt Date Filter supplier invoice requests with a payment due date on or after this date (MM/DD/YYYY format). Example: If payment terms are Net 30, the due date is based on the invoice date.
FromInvoiceDate_Prompt Date Filter supplier invoice requests created on or after this date (MM/DD/YYYY format).
Requester_Prompt String Filter supplier invoice requests by requester using the Workday ID.
Status_Prompt String Filter supplier invoice requests by status. Used for internal REST API purposes.
Supplier_Prompt String Filter supplier invoice requests by supplier using the Workday ID.
ToDueDate_Prompt Date Filter supplier invoice requests with a payment due date on or before this date (MM/DD/YYYY format). Example: If payment terms are Net 30, the due date is 30 days from the invoice date.
ToInvoiceDate_Prompt Date Filter supplier invoice requests created on or before this date (MM/DD/YYYY format).

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