SSIS Components for Oracle Fusion Cloud Financials

Build 24.0.9062

ExternalBankAccounts

The external bank accounts resource is used to view, create, and modify an external bank account.

Columns

Name Type Description
BankAccountNumber String Account number of the external bank account.
CountryCode String Country code of the external bank account.
BankBranchIdentifier Long Identifier of the bank branch where the external bank account is present.
BankIdentifier Long Identifier of the bank where the external bank account is present.
BankAccountId [KEY] Long Identifier of the external bank account.
CurrencyCode String Currency code of the external bank account.
IBAN String International Bank Account Number (IBAN), which is an alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account number internationally. The standard IBAN carries all the routing information needed to get a payment from one bank to another.
CheckDigits String Number added to the external bank account number to derive a further number as a means of verifying the accuracy or validity of the external account number as it is printed or transmitted.
AccountType String Type of external bank account. Possible values are Savings and Checking.
AccountSuffix String Two or three digits added to the end of an external bank account number in some countries, such as New Zealand. This format allows customers to have a single account number with differing suffixes that represent different types of accounts.
AgencyLocationCode String Agency location code of the external bank account.
AllowInternationalPaymentIndicator String Indicates whether the external bank account can be used for foreign payments or only for domestic payments.
SecondaryAccountReference String Reference number of a secondary external bank account, such as the Building Society Roll Number used in the United Kingdom.
StartDate Date Date when the external bank account becomes active.
EndDate Date Date when the external bank account becomes inactive.
BankAccountName String Name of the external bank account.
AlternateAccountName String Alternate name of the external bank account.
BankBranchPartyIndicator String Indicates whether an external bank account is associated with any external bank and branch created in Trading Community Architecture (TCA). If the value is Yes or Null, external bank and branch information is stored in TCA and the external bank and branch identifiers are stored on the external bank account. If the value is No, external bank and branch attributes are stored on the external bank account.
BankName String Name of the bank where the customer has an external bank account.
BankNumber String Code or identifier issued to an external bank by a banking regulatory authority.
BankBranchName String Name of the bank branch where the customer or supplier has an external bank account.
BankBranchNumber String Number of a bank branch. This is known as a routing transit number in the United States and a sort code in the United Kingdom.
BIC String Bank Identifier Code (BIC), which is the identifier code used by SWIFT to identify an external bank or bank branch. The BIC is a universal method of identifying financial institutions to facilitate the automated processing of telecommunication messages in banking and related financial environments.
VendorId Long VendorId of ExternalBankAccounts
PersonId Long Person identifier when the account owner is an employee.
Intent String Purpose of the external bank account. The value is based on the payment function of the external payee or the external payer of the account owner. The following are the expected values: PAYABLES_DISB - Supplier, EMPLOYEE_EXP - Person, EMPLOYEE_EXP - Employee, AR_CUSTOMER_REFUNDS - Refund, CUSTOMER_PAYMENT - Customer, ONETIME_PAYMENT - Onetime, and ADHOC_PAYMENT - Adhoc.
PartyId Long Party identifier of the external bank account owner.
PayeeCreation String Indicates whether the external payee and instrument assignments should be created along with the bank account. Valid values are Y and N. For internal use only.
Finder String Finder of ExternalBankAccounts

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062