Tableau Connector for Workday

Build 20.0.7740

BankAccounts

Bank Account Data

Columns

Name Type References Description
Bank_Account_ID String Bank Account ID. This is the bank account unique identifier.
Account_Name String Bank Account Name
Financial_Institution_Reference_WID String Contains a unique identifier for an instance of an object.
Financial_Institution_Reference_Financial_Institution_ID String Contains a unique identifier for an instance of an object.
Financial_Institution_Reference_Financial_Institution_Reference_ID String Contains a unique identifier for an instance of an object.
Financial_Party_Reference_WID String Contains a unique identifier for an instance of an object.
Financial_Party_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Financial_Party_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Financial_Party_Reference_Custom_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Financial_Party_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Financial_Party_Reference_Region_Reference_ID String Contains a unique identifier for an instance of an object.
Default_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Default_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Accepted_Currencies_Reference String Accepted Currencies Reference. When no accepted currencies are passed in the web service, the bank account will accept all currencies.
Bank_Branch_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Branch_Reference_Bank_Branch_ID String Contains a unique identifier for an instance of an object.
Bank_Account_Open_Date Date Bank Account Open Date
Account_Closed Bool Boolean value indicating the Bank Account should be closed. The Bank Account will not longer be available for payments.
Bank_Account_Close_Date Date Bank Account Close Date
Country_Reference_WID String Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Routing_Transit_or_Institution_Number String Routing Transit or Institution Number
Financial_Account_Number String Financial Account Number
Bank_Identifier_Code String Bank Identifier Code
IBAN String IBAN
Bank_Account_Format_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Account_Format_Reference_Bank_Statement_Format_Reference_ID String Contains a unique identifier for an instance of an object.
Custom_Code_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Custom_Code_Set_Reference_Bank_Statement_Custom_Code_Set_ID String Contains a unique identifier for an instance of an object.
Branch_Name String Branch Name
Branch_Phonetic_Name String Branch Phonetic Name
Check_Digit String Collects the check digit when it is not part of the bank id number
Bank_Account_Name String Collects the bank account name
Bank_Account_Phonetic_Name String Bank Account Phonetic Name
Roll_Number String Collects the Roll number
Fraction String Collects the Bank Account Fraction that will be printed on checks.
Formatted_MICR String F = Floating On-US
Target_Balance Decimal Bank Account Target Balance
Payment_Type_Reference String Reference to an existing Payment Type
Default_Payment_Type_for_Ad_Hoc_Payments_Reference_WID String Contains a unique identifier for an instance of an object.
Default_Payment_Type_for_Ad_Hoc_Payments_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Bank_Account_Security_Segment_Reference String This is the bank account security segment for the bank account. If segmented security is set up for bank accounts, these segments indicate the security for the bank account.
Check_Print_Layout_Reference_WID String Contains a unique identifier for an instance of an object.
Check_Print_Layout_Reference_Check_Print_Layout_ID String Contains a unique identifier for an instance of an object.
Check_Print_Layout_Reference_Check_Print_Layout_with_Report_Design_ID String Contains a unique identifier for an instance of an object.
Use_Branch_Address Bool Use Branch Address
Advanced_Mode Bool Identifies whether the account performs simple based reconciliation or advanced rule based reconciliation.
Parsing_Rule_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Parsing_Rule_Set_Reference_Parsing_Rule_Set_ID String Contains a unique identifier for an instance of an object.
Perform_Automatic_Reconciliation_Reference_WID String Contains a unique identifier for an instance of an object.
Perform_Automatic_Reconciliation_Reference_Auto_Recon_Initiation_Type_ID String Contains a unique identifier for an instance of an object.
Reconciliation_Rule_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Reconciliation_Rule_Set_Reference_Reconciliation_Rule_Set String Contains a unique identifier for an instance of an object.
Inactive_for_Automatic_Bank_Reconciliation Bool Set the Reconciliation Rule Set to be inactive for this bank account.
Reconciliation_Matching_Rule_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Reconciliation_Matching_Rule_Set_Reference_Matching_Rule_Set String Contains a unique identifier for an instance of an object.
Perform_Automatic_First_Notice_Reconciliation_Reference_WID String Contains a unique identifier for an instance of an object.
Perform_Automatic_First_Notice_Reconciliation_Reference_Auto_Recon_Initiation_Type_ID String Contains a unique identifier for an instance of an object.
First_Notice_Rule_Set_Reference_WID String Contains a unique identifier for an instance of an object.
First_Notice_Rule_Set_Reference_Reconciliation_Rule_Set String Contains a unique identifier for an instance of an object.
Batch_Electronic_Payments Bool Identifies whether to consolidate electronic payments into a single batch for reconciliation.
Batch_Electronic_Customer_Payment_Deposits Bool Identifies whether to consolidate customer electronic payments into a single deposits for customer payments settled through a settlement run.
Group_Student_Electronic_Payment_into_a_Deposit Bool Identifies whether to consolidate Student electronic payments into a single deposits for Student Payments settled through a settlement run.
Submit_Reconciled_Statements_Automatically Bool Identifies whether to automatically submit fully reconciled statements.
Bank_Statement_Worktag_Rule_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Statement_Worktag_Rule_Set_Reference_Bank_Statement_Worktag_Rule_Set_ID String Contains a unique identifier for an instance of an object.
Used_by_Cash Bool Indicates that the account can be used for cash transactions
Used_by_Customer_Payments Bool Indicates that the account can be used for Customer Payments
Used_by_Customer_Refunds Bool Indicates that the account can be used for Customer Refunds
Used_by_Expense_Payments Bool Indicates that the account can be used for Expense Payments
Used_by_Payroll_On_Cycle Bool Indicates that the account can be used for Payroll on-cycle
Used_by_Supplier_Payments Bool Indicates that the account can be used for Supplier Payments
Used_by_Intercompany_Payments Bool Indicates that the account can be used for Inter-company Payments
Used_by_Ad_hoc_Payments Bool Indicates that the account can be used for Ad Hoc Payments
Used_by_Bank_Account_Transfers_for_Settlement Bool Indicates that the account can be used for Bank Account Transfer for Settlement
Used_By_Payroll_Off_Cycle Bool Indicates that the account can be used for Payroll Off-Cycle
Used_By_Prenote_Payments Bool Indicates that the account can be used for Prenote Payments
Used_By_Procurement_Card_Payments Bool Indicates that the account can be used for Procurement Card Payments.
Used_By_Tax_Payments Bool Indicates that the account may be used by Tax Payments.
Used_by_Cash_Advances Bool Indicates that the account can be used for Cash Advances.
Used_by_Expense_Credit_Card_Payments Bool Indicated that the account is used by Expense Credit Card Payments.
Used_by_Student_Refund Bool Refers if Student Refund Usage is a valid for the Bank Account.
Used_By_Student_Payment Bool Refers if Student Payment Usage is a valid for the Bank Account.
Used_by_Student_Sponsor_Refund Bool Refers if Student Sponsor Refund Usage is valid for the Bank Account.
Last_Check_Number_Used Decimal Numeric value of the last check number used. This value can be set to the next check number to use.
Enable_Positive_Pay Bool Boolean value indicating positive pay should be enabled.
Outsourced Bool Boolean value indicating if the bank account is outsourced
Account_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Account_Type_Reference_Bank_Account_Type_Code String Contains a unique identifier for an instance of an object.
Allow_Additional_Usage Bool Boolean indicating if the bank account can be used for additional usages
Default_Bank_Statement_Beginning_Balance Bool If selected, defaults this statement's beginning balance from the previous statement's balance (if no beginning balance is provided).
Outsourced_Bank_Provider_Reference_WID String Contains a unique identifier for an instance of an object.
Outsourced_Bank_Provider_Reference_Outsourced_Bank_Provider_ID String Contains a unique identifier for an instance of an object.
Payment_Integration_Data String Element containing payment integration data
Lockbox_Data String Element containing Lockbox Data
Check_Sorting_Setup_Reference_IID String Contains a unique identifier for an instance of an object.
Check_Sorting_Setup_Reference_WID String Contains a unique identifier for an instance of an object.
Check_Sorting_Setup_Line_Data String Sets 0 or more configuration rules for sorting checks.
Attachment_Data String Encapsulating element containing all Business Document Attachment data.

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