Tableau Connector for Workday

Build 20.0.7740

SupplierInvoices

Supplier Invoice Data

Columns

Name Type References Description
Supplier_Invoice_ID String Supplier Invoice ID. This is the Supplier Invoice unique identifier
Submit Bool Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.
Locked_in_Workday Bool Set to True to disable editing and canceling the invoice inside the Workday application. Invoice can only be updated from the web service.
Invoice_Number String If adding a new invoice, then make the Invoice Number the same value as Reference ID. If updating an existing invoice, then make it the same value as the Reference ID of that invoice. If you do not make the Invoice Number the same as Reference ID, then duplicate Invoice Numbers for different invoices may be created. The Reference ID is the only value checked as a unique identifier. Note that the name of the Reference ID is different for each invoice type: e.g. Supplier Invoice ID, Supplier Invoice Adjustment ID, Customer Invoice Adjustment ID, and Customer Invoice ID.
Gapless_Document_Number String Gapless Document Number
Invoice_Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Invoice_Document_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
External_Supplier_Invoice_Source_Reference_WID String Contains a unique identifier for an instance of an object.
External_Supplier_Invoice_Source_Reference_External_Supplier_Invoice_Source_ID String Contains a unique identifier for an instance of an object.
External_Supplier_Invoice_Source_Reference_Workday_External_Supplier_Invoice_Source_ID String Contains a unique identifier for an instance of an object.
Cancel_Accounting_Date Date Cancel Accounting Date is only populated when a Supplier Invoice is Cancelled.
Invoice_Accounting_Date Date Invoice Accounting Date for a Supplier Invoice.
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.
Payment_Practices Bool Payment Practice field to flag a Supplier Invoice for Payment Practices Reporting
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.
Default_Tax_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Tax_Option_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
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.
Ship_To_Address_ID_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Address_ID_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Default_Withholding_Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Withholding_Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Default_Withholding_Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Invoice_Date Date If this is left blank, Workday will populate invoice date with the current date.
Invoice_Received_Date Date Field to store the Invoice Received Date value
Due_Date_Override Date If a date is provided, it will override the due date that Workday automatically determines based on the invoice date and payment terms.
Accounting_Date_Override Date Override date for Accounting.
Budget_Date Date Use this field to override the Budget Date on all supplier invoice lines and splits.
On_Hold Bool If this is set to 'TRUE' the invoice will be put on hold.
Control_Amount_Total Decimal This is the expected invoice total including tax. It is optional. An invoice cannot be submittted for approval if it has a non-zero control total that does not equal the sum of the extended amount for all invoice lines plus tax.
Tax_Amount Decimal Tax Amount
Withholding_Tax_Amount Decimal Withholding Tax Amount
Freight_Amount Decimal Freight Amount
Other_Charges Decimal Other Charges
Worktag_Split_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Worktag_Split_Template_Reference_Worktag_Allocation_Template_ID String Contains a unique identifier for an instance of an object.
Tax_Only Bool Tax Only Boolean to indicate if the Supplier Invoice is Tax Only
Referenced_Invoices_Reference String Tax Only invoice Workset for adding Referenced Invoices
Supplier_Document_Received Bool Boolean attribute indicating if the Supplier Paper Document was received (possibly through mail or fax) . If this is set then a Supplier Reference is required that will provide information for locating that document.
Suppliers_Invoice_Number String Free form text field to provide a Supplier Reference memo. The Supplier Reference is not a Workday Reference ID, but a text field for providing additional information about the Supplier Invoice.
External_PO_Number String Free form text field for providing addition information on the Purchase Order that the Supplier Invoice is for. This is not a Workday Purchase Order Reference ID.
Supplier_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Alternate_Supplier_Contract_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_Amendment_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_History_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Invoice_Contract_ID String Contains a unique identifier for an instance of an object.
Document_Link String Link to a scanned image of the paper invoice
Supplier_Invoice_Request_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Request_Reference_Supplier_Invoice_Request_Document_Number String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Request_Reference_Supplier_Invoice_Request_ID String Contains a unique identifier for an instance of an object.
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.
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.
Memo String This transaction header memo will print on the delivered transaction. It is optional freeform text
Approver_Reference_WID String Contains a unique identifier for an instance of an object.
Approver_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Approver_Reference_Employee_ID 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.
Override_Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Override_Payment_Type_Reference_Payment_Type_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.
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.
Prepaid Bool Set the Prepaid value to true for Prepaid Invoices where all lines are Prepaid. If set, the lines cannot be also set to Prepaid individually.
Prepayment_Release_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Prepayment_Release_Type_Reference_Prepayment_Release_Type_ID String Contains a unique identifier for an instance of an object.
Release_Date Date Prepaid Amortization Date
Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Frequency_Reference_Frequency_Behavior_ID String Contains a unique identifier for an instance of an object.
Number_of_Installments Decimal The Number of Installments to use when accounting for the Prepaid Amortization.
Use_Invoice_Date Bool Use the Invoice Date as the starting date for the first installment.
From_Date Date Use the Specified Date as the starting date for the first installment.
Gross_Invoice_Amount Decimal The Gross Invoice Amount includes the Invoice Line Extended Amount plus Tax, Retention, and Release Amount. This field only returns values.
Total_Amount_Retained Decimal The total amount retained for this invoice. This field only returns values.
Total_Amount_Released Decimal The total amount of retention released for this invoice. This field only returns values.
Retention_Memo String The retention memo.
Currency_Rate_Type_Override_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Override_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Currency_Rate_Date_Override Date For a foreign currency invoice, this allows you to override the date used to look up the currency conversion rate. The default date is normally the same as the invoice date.
Currency_Rate_Manual_Override Decimal For a foreign currency invoice, this allows you to directly override the currency conversion rate that will be used.
Document_Currency_Conversion_Rate Decimal This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Rate_Override Bool This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Currency_Rate_Lookup_Override Decimal This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Manual_Override_Percent Decimal This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Default_Rate_Type_Reference String This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Rate_Basis_Date Date This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Default_Currency_Rate Decimal This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Attachment_Data String Attachment Data
Tax_Code_Data String Tax Data by Tax Authority and Tax Code. For Customer Invoice Documents and Cash Sales tax data will always be calculated from the line data regardless of what is populated in Tax Rate Application Data. For Purchase Orders, Supplier Invoice Documents and Ad hoc Payments, if data is in Tax Rate Application Data, then that will be the tax information that is saved. Otherwise, the tax will be calculated from the lines.
Withholding_Tax_Code_Data String Withholding Tax Data by Tax Authority and Withholding Tax Code. For Customer Invoice Documents and Cash Sales tax data will always be calculated from the line data regardless of what is populated in Tax Rate Application Data. For Purchase Orders, Supplier Invoice Documents and Ad hoc Payments, if data is in Tax Rate Application Data, then that will be the tax information that is saved. Otherwise, the tax will be calculated from the lines.
Invoice_Line_Replacement_Data String Supplier Invoice Line Data. A Supplier Invoice may have multiple lines.
Retention_Release_Line_Data String Encapsulating element containing Supplier Invoice Retention Release Line data.
Comment String Free form comment regarding the business process.
Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Business_Process_Attachment_Data String Element for the attachments pertaining to a Event entered through a web service.
Supplier_Invoice_Prepaid_Amortization_Schedule String Supplier Invoice Prepaid Spend Amortization Schedule
Tax_Certificate_Number String Information Relating to Gapless Tax Certificate Numbers

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