Tableau Connector for Oracle Fusion Cloud Financials

Build 25.0.9434

ExternalBankAccountsaccountOwners

Tracks the owners associated with an external bank account, defining authorization and responsibility for transactions.

Columns

Name Type Description
ExternalBankAccountsBankAccountId [KEY] Long Unique identifier for the external bank account in the ExternalBankAccountsaccountOwners table, linking the account to its owner.
AccountOwnerPartyIdentifier Long Unique identifier for the party associated with the external bank account, representing the owner of the account.
AccountOwnerPartyNumber String Party number assigned to the external bank account owner, used to track and identify the party within the system.
AccountOwnerPartyName String Name of the party (individual or entity) that owns the external bank account, helping to identify the account holder.
PrimaryOwnerIndicator String Indicates whether the external bank account owner is the primary owner. Typically marked as 'Y' for yes and 'N' for no.
StartDate Date Date when the external bank account owner became active, marking the start of their association with the account.
EndDate Date Date when the external bank account owner becomes inactive, indicating the end of their association with the account.
AccountOwnerId [KEY] Long Application-generated identifier for the external bank account owner, used for internal tracking and management.
Intent String Purpose of the external bank account, indicating the payment function of the account. Values include PAYABLES_DISB (Supplier), EMPLOYEE_EXP (Person/Employee), CUSTOMER_PAYMENT (Customer), and others.
PersonId Long Unique identifier for the person associated with the account when the account owner is an employee, linking the bank account to a specific person.
AddJointAccountOwner String Indicates whether a joint account owner should be created if the bank account already exists. Valid values are 'Y' (Yes) and 'N' (No).
BankAccountId Long Unique identifier for the bank account linked to the account owner, referencing the external bank account associated with the party.
BankAccountNumber String Account number associated with the external bank account, used for transactions and identifying the account within the banking system.
BankBranchIdentifier Long Unique identifier for the bank branch where the external bank account is maintained, used to reference the specific branch location.
BankBranchName String Name of the bank branch where the external bank account is held, providing further identification of the account's location.
BankIdentifier Long Unique identifier for the bank where the external bank account is held, used for routing and bank identification purposes.
BankName String Name of the bank where the external bank account is maintained, identifying the financial institution.
CountryCode String Country code of the external bank account, indicating the country in which the bank account is located.
CurrencyCode String Currency code of the external bank account, specifying the currency in which the account operates.
Finder String Search term or identifier used to locate and filter specific external bank account owner records, aiding in efficient data retrieval.
IBAN String International Bank Account Number (IBAN) associated with the external bank account owner, providing a standardized way to identify the account internationally.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434