ODBC Driver for Workday

Build 24.0.9060

SupplierInvoiceRequestsLinesSplits

Reads /splits entries from the SupplierInvoiceRequestsLines table.

Workday Resource Information

Retrieves a supplier invoice line with the specified subresource ID for the specified supplier invoice ID.

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

Scope: Supplier Accounts

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.

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 Id of the instance
SupplierInvoiceRequestsLines_Id [KEY] String The Workday ID of the SupplierInvoiceRequestsLines that contains this.
SupplierInvoiceRequests_Id [KEY] String The Workday ID of the SupplierInvoiceRequests that owns this.
Amount_Currency String Supported for: SELECT. The amount on the transaction line split. This value displays in the same currency as the business document. (Currency name)
Amount_Value Decimal Supported for: SELECT. The amount on the transaction line split. This value displays in the same currency as the business document. (Value)
Billable Bool Supported for: SELECT. True if the supplier invoice request line or line split are billable.
Descriptor String Supported for: SELECT. A preview of the instance
Memo String Supported for: SELECT. The memo for a line split
Percent Decimal Supported for: SELECT. The percentage specified for the Business Document Line distribution line split.
Quantity Decimal Supported for: SELECT. The quantity specified for the Business Document Line distribution line split.
Worktags_Aggregate String Supported for: SELECT. A JSON aggregate. The worktags for the document line split.
Company_Prompt String Only used when a SupplierInvoiceRequests_Id filter is not provided. Accepts multiple inputs. The company for the Common Financial Dimensions. This is for internal use only on a REST API.
FromDueDate_Prompt Date Only used when a SupplierInvoiceRequests_Id filter is not provided. The beginning date of the payment due period for this supplier invoice request. Use the MM/DD/YYYY format. Example: When the payment term is Net 30, the due date value is the day from this invoice date.
FromInvoiceDate_Prompt Date Only used when a SupplierInvoiceRequests_Id filter is not provided. The date on or after which the supplier invoice is created using the MM/DD/YYYY format.
Requester_Prompt String Only used when a SupplierInvoiceRequests_Id filter is not provided. Accepts multiple inputs. The ID of the worker generating the supplier invoice request.
Status_Prompt String Only used when a SupplierInvoiceRequests_Id filter is not provided. Accepts multiple inputs. The status of the supplier invoice request. This is for internal use only on a REST API.
Supplier_Prompt String Only used when a SupplierInvoiceRequests_Id filter is not provided. Accepts multiple inputs. The supplier on the business documents.
ToDueDate_Prompt Date Only used when a SupplierInvoiceRequests_Id filter is not provided. The end date of the payment due period for this supplier invoice request. Use the MM/DD/YYYY format. Example: When the payment term is Net 30, the due date value is 30 days from the invoice date.
ToInvoiceDate_Prompt Date Only used when a SupplierInvoiceRequests_Id filter is not provided. The date on or before which the supplier invoice is created using the MM/DD/YYYY format.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060