Excel Add-In for Workday

Build 25.0.9434

SupplierInvoiceRequestsLinesSplits

Manages cost distribution across split line items within supplier invoices.

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

Aggregate Fields

The add-in 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 */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
Id [KEY] String Unique identifier for this supplier invoice request line split instance.
SupplierInvoiceRequestsLines_Id [KEY] String Workday-generated unique ID linking this record to the supplier invoice request line.
SupplierInvoiceRequests_Id [KEY] String Workday-generated unique ID linking this record to the associated supplier invoice request.
Amount_Currency String The currency of the amount on the transaction line split. This value matches the business document currency.
Amount_Value Decimal The amount allocated to the transaction line split, displayed in the business document currency.
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.
Memo String A memo or additional note for the line split.
Percent Decimal The percentage allocated to this distribution line split of the business document.
Quantity Decimal The quantity allocated to this distribution line split of the business document.
Worktags_Aggregate String A list of worktags associated with the document line split.
Company_Prompt String Filter supplier invoice requests by company. Used internally for 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 the requester using the Workday ID.
Status_Prompt String Filter supplier invoice requests by status. Used internally for 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