Tableau Connector for Workday

Build 20.0.7740

SupplierInvoiceRequests

Element that represents the contents of the entire Supplier Invoice Request, including Lines (with and without splits) and Attachments.

Columns

Name Type References Description
Supplier_Invoice_Request_ID String Reference ID
Invoice_Request_Number String A unique Workday system generated Supplier Invoice Request Number. This value cannot be updated, but it can be used to reference the instance of the Supplier Invoice Request.
Invoice_Request_Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Invoice_Request_Document_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Invoice_Date Date Invoice Date on the Supplier Invoice Request
Invoice_Received_Date Date Field to store the Invoice Received Date value
Canceled_On_Date Date Date the Supplier Invoice Request was Canceled. Will not show if the request is not canceled.
Requester_Reference_WID String Contains a unique identifier for an instance of an object.
Requester_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Requester_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Internal_Service_Provider_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Internal_Service_Provider_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Connection_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Connection_Reference_Supplier_Connection_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Control_Total_Amount Decimal Expected total amount for Supplier Invoice Request. It is optional.
Suppliers_Invoice_Number String Supplier Reference text field on the Supplier Invoice Request
Invoice_Request_Total_Amount Decimal Total Amount for the Supplier Invoice Request. Includes Tax Amount, Freight Amount and the sum of the Extended Amount of the Lines
Ship_To_Address_Reference_IID String Contains a unique identifier for an instance of an object.
Ship_To_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Additional_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Additional_Type_Reference_Additional_Reference_Type_ID String Contains a unique identifier for an instance of an object.
Additional_Reference_Number String The reference number that is encoded with key payment information on the invoice document.
Due_Date Date Due Date for the Supplier Invoice Request. Format is MM/DD/YYYY.
Tax_Amount Decimal Tax Amount
Handling_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Handling_Code_Reference_Handling_Code_ID String Contains a unique identifier for an instance of an object.
Statutory_Invoice_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Statutory_Invoice_Type_Reference_Invoice_Type_ID String Contains a unique identifier for an instance of an object.
Statutory_Invoice_Type_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Freight_Amount Decimal Freight Amount
Memo String This transaction header memo will print on the delivered transaction. It is optional freeform text
Supplier_Invoice_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Reference_Supplier_Invoice_Reference_ID String Contains a unique identifier for an instance of an object.
Attachment_Data String Attachment Data
Supplier_Invoice_Request_Line_Data String Supplier Invoice Request Line Data. A Supplier Invoice Request may have multiple lines.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740