Tableau Connector for Workday

Build 20.0.7740

AdhocPayments

Ad hoc Payment Data

Columns

Name Type References Description
Ad_hoc_Payment_ID String Ad hoc Payment ID
Submit Bool Save and Submit
Cancel_Accounting_Date Date Cancel Accounting Date
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.
Bank_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Account_Reference_Bank_Account_ID String Contains a unique identifier for an instance of an object.
Bank_Account_Reference_Petty_Cash_Account_ID String Contains a unique identifier for an instance of an object.
Ad_Hoc_Payee_Phonetic_Name String Ad Hoc Payee Phonetic Name
Single_Use Bool New Ad Hoc Payee is Single Use. Use this value to specify that the new ad hoc payee will be a single use payee.
Tax_Authority_Form_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Authority_Form_Type_Reference_Tax_Authority_Form_Type String Contains a unique identifier for an instance of an object.
IRS_1099_MISC_Payee Bool 1099 Payee Flag for Ad hoc Payment Payee
TIN_Type_Reference_WID String Contains a unique identifier for an instance of an object.
TIN_Type_Reference_Taxpayer_ID_Number_Type_ID String Contains a unique identifier for an instance of an object.
Tax_ID String Tax ID for Ad hoc Payment Payee
Tax_Payment Bool Use this value to specify whether the Ad Hoc Payment is a Tax Payment.
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.
Currency_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Currency_Conversion_Rate Decimal Overrides the Transaction to Bank Account Currency Conversion Rate. Added in web service v27.0.
Eliminate_Foreign_Exchange_Gain_or_Loss Bool Gives the user the option to eliminate the Foreign Exchange Gain or Loss. Added in web service v27.0.
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_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.
Payment_Date Date Payment Date
Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Memo String Memo
Document_Link String Document Link
Reference_Number String Reference Number
Control_Total_Amount Decimal Control Total Amount
Tax_Amount Decimal Tax Amount
Freight_Amount Decimal Freight Amount
Other_Charges Decimal Other Charges
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.
Addenda_Lines_as_Text String Addenda Lines as Text
External_Reference_as_Text String External Reference
Invoice_Line_Replacement_Data String 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.
Address_Data String Address Data
Bank_Data String Bank Data
Payee_Alternate_Name_Data String Payee Alternate Name Data
Attachment_Data String Attachment Data

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