Stores supplier invoice requests, including approval and payment details.

Workday Resource Information

Retrieves all supplier invoices.

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

Scope: Supplier Accounts

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.

Lines_Aggregate

[{
  billable: Boolean /* True if the supplier invoice request line or line split are billable. */
  descriptor: Text /* The display name of the instance */
  extendedAmount: Currency /* The extended amount for the document line.  Excludes extended amount on tax only invoices. */
  id: Text /* Id of the instance */
  internalMemo: Text /* The internal line memo for the supplier invoice request line. */
  item: { /* The item for the document line. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  itemDescription: Text /* The description of the item on the document line. This is a text-only value. */
  memo: Text /* The memo on the document line. */
  order: Text /* The order of the lines on a transaction. You can use this field to compare other transactions, such as supplier invoice matching events. */
  quantity: Numeric /* The quantity on the transaction line. This value can have 20 integer places, is precise to 2 decimal places, and can be negative. */
  serviceLine: Boolean /* The line type for supplier invoice request line. */
  spendCategory: { /* Retrieves the spend category defined on the line for the Business Document Line Distribution. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  splitBy: { /* The distribution method for supplier invoice request line. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  splits: [{
      amount: Currency /* The amount on the transaction line split. This value displays in the same currency as the business document. */
      billable: Boolean /* True if the supplier invoice request line or line split are billable. */
      descriptor: Text /* The display name of the instance */
      id: Text /* Id of the instance */
      memo: Text /* The memo for a line split */
      percent: Numeric /* The percentage specified for the Business Document Line distribution line split. */
      quantity: Numeric /* The quantity specified for the Business Document Line distribution line split. */
      worktags: [{
          descriptor: Text /* The display name of the instance */
          id: Text /* Id of the instance */
      }]
  }]
  unitCost: Currency /* The unit cost for the document line. */
  unitOfMeasure: { /* The unit of measure for the document line. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  worktags: [{
      descriptor: Text /* The display name of the instance */
      id: Text /* Id of the instance */
  }]
}]

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier for this supplier invoice request instance.
Company_Descriptor	String	False	The display name of the instance
Company_Href	String	False	A URL or reference link to the company instance.
Company_Id	String	False	Unique identifier associated with the company.
ControlTotalAmount_Currency	String	False	The currency of the total control amount, which should match the sum of the line amounts.
ControlTotalAmount_Value	Decimal	False	The total control amount that should match the sum of the line amounts.
Currency_CurrencyID	String	False	The reference ID for currency lookups within Workday Web Services. For supervisory organizations, this is also the 'Organization ID.'
Currency_Descriptor	String	False	The display name of the instance
Currency_Id	String	False	Unique identifier associated with the currency.
Descriptor	String	False	The display name of the instance
DueDate	Datetime	False	The due date for payment of the supplier invoice request. Example: If payment terms are Net 30, the due date is 30 days after the invoice date.
FreightAmount_Currency	String	False	The currency of the freight amount for the supplier invoice request.
FreightAmount_Value	Decimal	False	The freight amount for the supplier invoice request.
HandlingCode_Descriptor	String	False	The display name of the instance
HandlingCode_Href	String	False	A URL or reference link to the handling code instance.
HandlingCode_Id	String	False	Unique identifier associated with the handling code.
InvoiceDate	Datetime	False	The date when the supplier invoice request was created.
InvoiceReceivedDate	Datetime	False	The date when the supplier invoice was received.
Lines_Aggregate	String	False	A list of supplier invoice request lines associated with the supplier invoice request.
Memo	String	False	The memo or additional notes for the supplier invoice request.
PaymentTerms_Descriptor	String	False	The display name of the instance
PaymentTerms_Href	String	False	A URL or reference link to the payment terms instance.
PaymentTerms_Id	String	False	Unique identifier associated with the payment terms.
ReferenceNumber	String	False	The reference number containing key payment details for the invoice request document.
ReferenceType_Descriptor	String	False	The display name of the instance
ReferenceType_Href	String	False	A URL or reference link to the reference type instance.
ReferenceType_Id	String	False	Unique identifier associated with the reference type.
RemitToConnection_Descriptor	String	False	The display name of the instance
RemitToConnection_Href	String	False	A URL or reference link to the remit-to connection instance.
RemitToConnection_Id	String	False	Unique identifier associated with the remit-to connection.
RequestNumber	String	False	The unique number assigned to the supplier invoice request at the time of creation.
Requester_Descriptor	String	False	The display name of the instance
Requester_Href	String	False	A URL or reference link to the requester instance.
Requester_Id	String	False	Unique identifier associated with the requester.
ShipToAddress_Descriptor	String	False	The display name of the instance
ShipToAddress_Href	String	False	A URL or reference link to the shipping address instance.
ShipToAddress_Id	String	False	Unique identifier associated with the shipping address.
Status_Descriptor	String	False	The display name of the instance
Status_Href	String	False	A URL or reference link to the status instance.
Status_Id	String	False	Unique identifier associated with the supplier invoice request status.
StatutoryInvoiceType_Descriptor	String	False	The display name of the instance
StatutoryInvoiceType_Href	String	False	A URL or reference link to the statutory invoice type instance.
StatutoryInvoiceType_Id	String	False	Unique identifier associated with the statutory invoice type.
Supplier_Descriptor	String	False	The display name of the instance
Supplier_Href	String	False	A URL or reference link to the supplier instance.
Supplier_Id	String	False	Unique identifier associated with the supplier.
SuppliersInvoiceNumber	String	False	The reference number provided by the supplier for the supplier invoice request.
TaxAmount_Currency	String	False	The currency of the tax amount for the supplier invoice request.
TaxAmount_Value	Decimal	False	The tax amount for the supplier invoice request.
Company_Prompt	String	False	Filter supplier invoice requests by company. Used for internal REST API purposes.
FromDueDate_Prompt	Date	False	Filter supplier invoice requests with a payment due date on or after this date (MM/DD/YYYY format).
FromInvoiceDate_Prompt	Date	False	Filter supplier invoice requests created on or after this date (MM/DD/YYYY format).
Requester_Prompt	String	False	Filter supplier invoice requests by requester using the Workday ID.
Status_Prompt	String	False	Filter supplier invoice requests by status. Used for internal REST API purposes.
Supplier_Prompt	String	False	Filter supplier invoice requests by supplier using the Workday ID.
ToDueDate_Prompt	Date	False	Filter supplier invoice requests with a payment due date on or before this date (MM/DD/YYYY format).
ToInvoiceDate_Prompt	Date	False	Filter supplier invoice requests created on or before this date (MM/DD/YYYY format).