Tableau Connector for Workday

Build 20.0.7740

Suppliers_Settlement_Account_Data

Bank Account Type becomes required when using v30.1 of the web service.

Columns

Name Type References Description
Supplier_Supplier_Reference_WID String

Suppliers.Supplier_Reference_WID

The unique identifier type. Each
Settlement_Bank_Account_ID String Settlement Bank Account ID is a unique ID to the Settlement Bank Account
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.
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_Nickname String Bank Account Nickname
Bank_Account_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Account_Type_Reference_Bank_Account_Type_Code String Contains a unique identifier for an instance of an object.
Bank_Name String Bank Name
Routing_Transit_Number String Routing Transit Number must adhere to bank routing account standards.
Branch_ID String Branch ID
Branch_Name String Branch Name
Bank_Account_Number String Bank Account Number
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
Roll_Number String Collects the Roll number
IBAN String International Bank Account Number (IBAN)
SWIFT_Bank_Identification_Code String Society for Worldwide Interbank Financial Telecommunication (SWIFT) Bank Identification Code (BIC)
Accepts_Payment_Types_Reference String Accepts Payment Types Reference is a reference to accepts payment types for a supplier.
Payment_Types_Reference String Only applicable for Suppliers. Reference to the Payment Types this Settlement Bank Account is intended for. Leave blank to designate this Settlement Bank Account as the default for all Payment Types.
For_Supplier_Connections_Only Bool Designates this Settlement Bank Account to be used for Supplier Connections only.
Requires_Prenote Bool Requires Prenote Reference
Payment_Type_Prenote_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Type_Prenote_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Inactive Bool Indicates whether the Settlement Bank Account is inactive or active. A true value indicates the account is Inactive.
Bank_Instructions String Bank Instructions for FFC (For Further Credit).
Intermediary_Bank_Data String Intermediary Bank Account information including Order, Bank Account Type, Currency, Routing Transit Number, etc.

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