External Bank Account

Stores the details of the external bank account.

QName: {http://xmlns.oracle.com/apps/financials/payments/shared/bankAccounts/bankAccountServiceV2/}ExternalBankAccount

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

External Bank Account Owner SDO

Contains

Intermediary Bank Account Owner SDO

Contains

External Bank Account SDO

Contained by

Bank Account Assignment

Handled by

External Payer

Handled by

External Bank Account

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountClassification

string

This column is no longer in use.

AccountSuffix

string

Suffix used for the bank account.

AgencyLocationCode

string

A code assigned by a company's Treasury Financial Management Service (FMS) that is used exclusively for Treasury reporting purposes. The agency location code identifies the source of financial transactions, such as an agency, bureau, or other reporting entity.

BAMaskSetting

string

Current bank account masking setting. Values taken from lookup IBY_INSTRUMENT_MASK_SETTING.

BAUnmaskLength

int

Number of digits to expose in the masking of the external bank account.

BankAccountName

string

Name of bank account.

BankAccountNameAlt

string

Internal alternate name of the supplier's bank account.

BankAccountNumber

string

Number of the bank account.

BankAccountNumberElectronic

string

This column is no longer in use.

BankAccountType

string

Type of bank account, such as savings or checking.

BankBranchName

string

Name of the bank branch.

BankId

long

Identifier of the bank to which the bank branch belongs.

BankName

string

Name of the bank.

BankNumber

string

Unique number that identifies a bank.

BankPartyId

long

Trading Community Hierarchy (TCA) party identifier of the bank associated with the bank account.

BranchId

long

Identifier of the bank branch to which this bank account belongs.

BranchNumber

string

The number assigned to the bank branch by the banking authority.

BranchPartyId

long

Trading Community Hierarchy (TCA) party identifier of the bank branch associated with the bank account.

CheckDigits

string

A single digit used to validate an identifier.

CountryCode

string

Country code of the bank account.

CreatedBy

string

User who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Date and time of the record creation.

CurrencyCode

string

The three-letter ISO code associated with a currency.

Description

string

Internal description of the supplier's bank account.

EFTSWIFTCode

string

An electronic fund transfer SWIFT (Society for Worldwide Interbank Financial Telecommunication) code.

EndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date when the bank account becomes inactive.

EndDateDisp

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date when the bank account becomes inactive

EndId

long

This column is no longer in use.

ExchangeRate

decimal

The ratio used to convert the principal unit of one currency into another currency.

ExchangeRateAgreementNumber

string

Identifier of the exchange rate agreement between the supplier and the supplier's bank.

ExchangeRateAgreementType

string

Type of agreement that specifies the exchange rate. Values are validated against the lookup IBY_XCHG_RATE_AGREEMENT.

ExtBankAcctDffVLA

External Bank Account

External bank account descriptive flexfield.

ExternalBankAccountId

long

Identifier of the external bank account.
  • Primary Key

ExternalBankAccountOwner

External Bank Account Owner

Owner of the external bank account.

ForeignPaymentUseFlag

boolean

Indicates whether this bank account can be used for foreign payments or domestic payments.

HedgingContractReference

string

Identifier of the agreement between supplier and supplier's bank that specifies the hedging details.

IBAN

string

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.

IntermediaryBankAccount

Intermediary Bank Account Owner

An intermediary account that is used to transfer funds between the originator's bank and the beneficiary's bank.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Date and time of the last record update.

LastUpdateLogin

string

The session login associated with the user who last updated the record.

LastUpdatedBy

string

User who last updated the record.

MaskedBankAccountNumber

string

Partially or completely concealed digits of a bank account number that are used for display purposes.

MaskedIBAN

string

Partially or completely concealed digits of an IBAN value that are used for display purposes.

Name

string

The name of the supplier bank account.

ObjectVersionNumber

int

Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

PaymentFactorFlag

boolean

Indicates whether this is a payment factor bank account.

SecondaryAccountReference

string

Additional account number reference information, such as a building society roll number.

ShortAccountName

string

Short account name of the supplier's bank account.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Date when the bank account becomes active.

StartId

long

This column is no longer in use.

TerritoryCode

string

This column is no longer in use.

TerritoryShortName

string

This column is no longer in use.