Tableau Connector for Workday

Build 25.0.9434

SupplierInvoiceRequests

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 /* A preview 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 /* A description 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 /* A description 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 /* A description 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 /* A preview 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 /* A preview 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 /* A description of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  worktags: [{
      descriptor: Text /* A preview 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

A human-readable description of the company associated with the supplier invoice request.

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

A human-readable description of the currency used in the supplier invoice request.

Currency_Id String False

Unique identifier associated with the currency.

Descriptor String False

A brief, human-readable summary 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

A human-readable description of the handling code.

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

A human-readable description of the payment terms.

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

A human-readable description of the reference type.

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

A human-readable description of the remit-to connection.

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

A human-readable description of the requester.

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

A human-readable description of the shipping address.

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

A human-readable description of the supplier invoice request status.

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

A human-readable description of the statutory invoice type.

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

A human-readable description of the supplier.

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).

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