Tableau Connector for Workday

Build 20.0.7740

AdhocBankTransactions

Contains Ad hoc Bank Transaction Data

Columns

Name Type References Description
Ad_hoc_Bank_Transaction_ID String This is the unique identifier for the Ad hoc Bank Transaction. If you do not specify an ID, Workday generates one automatically.
Ad_Hoc_Bank_Transaction_Number String This is the unique identifier for the Ad Hoc Bank Transaction Number. You must set up sequence generation for Workday to generate and assign a number automatically. If not, the number remains blank.
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.
Cancel_Accounting_Date Date Cancel Accounting Date
Locked_in_Workday Bool Locked in Workday is a boolean flag controlling user ability to edit the transaction. If the flag is set the user can't edit, cancel or change the transaction inside the Workday application, however the user can submit a draft transaction. The transaction can only be updated from the web service.
Transaction_Date Date Ad hoc Bank Transaction Date
Transaction_Memo String Free form text field foran Ad hoc Bank Transaction memo
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.
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.
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.
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_Rate_Override Decimal Transaction to Bank Account Currency Conversion Rate
Transaction_Amount Decimal Transaction Amount
Ad_hoc_Bank_Transaction_Purpose_Reference_WID String Contains a unique identifier for an instance of an object.
Ad_hoc_Bank_Transaction_Purpose_Reference_Ad_hoc_Bank_Transaction_Purpose_ID String Contains a unique identifier for an instance of an object.
Transaction_ID String Free-form Text for any reference notes
External_Reference String External Reference for the Ad Hoc Bank Transaction
Include_in_IRS_1099 Bool As of w18, this functionality has been deprecated. Ad hoc Bank Transaction lines with a valid IRS 1099 Suppliers and a spend category mapped to a 1099 MISC category will automatically be included in 1099 MISC reporting.
Journal_Source_Reference_WID String Contains a unique identifier for an instance of an object.
Journal_Source_Reference_Journal_Source_ID String Contains a unique identifier for an instance of an object.
Remove_Bank_Account_Worktag_on_Offset String When this attribute is yes, it excludes the Bank Account worktag on Offset journal entries
Eliminate_FX_Gain_Loss String When this attribute is yes, the foreign exchange gain/loss is eliminated from the transaction
Transaction_Line_Replacement_Data String Ad hoc Bank Transaction Transaction Lines
Tax_Code_Data String Encapsulating element containing Tax Details data
Attachment_Data String Encapsulating element containing all Business Document Attachment 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.

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