Tableau Connector for Workday

Build 20.0.7740

SupplierInvoiceAdjustments

Supplier Invoice Adjustment Data

Columns

Name Type References Description
Supplier_Invoice_Adjustment_ID String Supplier Invoice Adjustment ID. This is the Supplier Invoice Adjustment 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 On Supplier Invoice Adjustment
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.
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.
Increase_Liability Bool Boolean flag for Increase Liability. In most cases, adjustments are used to decrease the liability to the supplier, in which case they are called credit memos. However, there are some circumstances where an adjustment is needed to increase the liability. In this case, set this value.
Adjustment_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Adjustment_Reason_Reference_Adjustment_Reason_ID String Contains a unique identifier for an instance of an object.
Adjustment_Date Date Invoice Adjustment Date
Adjustment_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.
Invoice_Accounting_Date Date Invoice Accounting Date for a Supplier Invoice Adjustment.
Cancel_Accounting_Date Date Cancel Accounting Date is populated only when a Supplier Invoice Adjustment is Cancelled.
Budget_Date Date Use this field to override the Budget Date on all supplier invoice lines and splits.
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.
Control_Total_Amount 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.
Original_Invoice_Reference_WID String Contains a unique identifier for an instance of an object.
Original_Invoice_Reference_Supplier_Invoice_Reference_ID String Contains a unique identifier for an instance of an object.
Original_Invoice_Supplier_Reference_Number String User can pass the Original Invoice Supplier Reference Number of a Supplier Invoice here to populate the Original Invoice Reference field with that Supplier Invoice.
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.
On_Hold Bool If this is set to 'TRUE' the invoice will be put on hold.
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's Invoice Number memo. The Supplier's Invoice Number 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
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.
Document_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.
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
Invoice_Line_Replacement_Data String Encapsulating element containing Supplier Invoice Line 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.
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.
Tax_Certificate_Number String Information Relating to Gapless Tax Certificate Numbers

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