ODBC Driver for Workday

Build 24.0.9060

SupplierInvoiceRequestsLines

Retrieves a collection of supplier invoice lines.

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

Columns

Name Type Description
Id [KEY] String Id of the instance
SupplierInvoiceRequests_Id [KEY] String The Workday ID of the SupplierInvoiceRequests that owns this.
Billable Bool Supported for: SELECT. True if a supplier invoice request line or line split is billable.
Descriptor String Supported for: SELECT. A preview of the instance
ExtendedAmount_Currency String Supported for: SELECT. The extended amount for the document line. Excludes Extended Amounts on Tax Only Invoices. (Currency name)
ExtendedAmount_Value Decimal Supported for: SELECT. The extended amount for the document line. Excludes Extended Amounts on Tax Only Invoices. (Value)
InternalMemo String Supported for: SELECT. The internal line memo for the supplier invoice request line.
ItemDescription String Supported for: SELECT. The description of the item on the document line. This is a text-only value.
Item_Descriptor String Supported for: SELECT. A description of the instance
Item_Href String Supported for: SELECT. A link to the instance
Item_Id String Supported for: SELECT. wid / id / reference id
Memo String Supported for: SELECT. The memo on the document line.
Quantity Decimal Supported for: SELECT. The quantity on the transaction line. This value can have 20 integer places, is precise to 2 decimal places, and can be negative.
SpendCategory_Descriptor String Supported for: SELECT. A description of the instance
SpendCategory_Href String Supported for: SELECT. A link to the instance
SpendCategory_Id String Supported for: SELECT. wid / id / reference id
SplitBy_Descriptor String Supported for: SELECT. A description of the instance
SplitBy_Href String Supported for: SELECT. A link to the instance
SplitBy_Id String Supported for: SELECT. wid / id / reference id
Type String Supported for: SELECT. The line type of the supplier invoice request.
UnitCost_Currency String Supported for: SELECT. The unit cost for the document line. (Currency name)
UnitCost_Value Decimal Supported for: SELECT. The unit cost for the document line. (Value)
UnitOfMeasure_Descriptor String Supported for: SELECT. A description of the instance
UnitOfMeasure_Href String Supported for: SELECT. A link to the instance
UnitOfMeasure_Id String Supported for: SELECT. wid / id / reference id
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