ODBC Driver for Oracle Fusion Cloud Financials

Build 23.0.8839

ExternalBankAccountsaccountOwners

ExternalBankAccountsaccountOwners

Columns

Name Type Description
ExternalBankAccountsBankAccountId [KEY] Long ExternalBankAccountsBankAccountId of ExternalBankAccountsaccountOwners
AccountOwnerPartyIdentifier Long Party identifier of the external bank account owner.
AccountOwnerPartyNumber String Party number of the external bank account owner.
AccountOwnerPartyName String Party name of the external bank account owner.
PrimaryOwnerIndicator String Indicates whether an external bank account owner is primary.
StartDate Date Date when the external bank account owner becomes active.
EndDate Date Date when the external bank account owner becomes inactive.
AccountOwnerId [KEY] Long Application-generated identifier of the external bank account owner.
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.
PersonId Long Person identifier when the account owner is an employee.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
BankAccountId Long BankAccountId
BankAccountNumber String BankAccountNumber
BankBranchIdentifier Long BankBranchIdentifier
BankBranchName String BankBranchName
BankIdentifier Long BankIdentifier
BankName String BankName
CountryCode String CountryCode
CurrencyCode String CurrencyCode
IBAN String IBAN
Finder String finder

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