Bank Account

The bank account view object contains legal entity level bank account information such as account name, account number, currency, bank account usage by functions, the cash and cash clearing account combinations and so on.

Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO

Primary Keys : BankAccountReportPEOBankAccountId

Initial Extract Date : BankAccountReportPEOCreationDate

Incremental Extract Date : BankAccountReportPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
BankAccountReportPEOAccountClassification	Indicates whether the bank account is internal or external. A list of accepted values is defined in the lookup type ACCOUNT_CLASSIFICATION.
BankAccountReportPEOAccountHolderId	The identifier of the account holder of the bank account.
BankAccountReportPEOAccountHolderName	The name of account holder of the bank account.
BankAccountReportPEOAccountHolderNameAlt	The alternate name of account holder of the bank account.
BankAccountReportPEOAccountOwnerOrgId	The identifier of the legal entity owning the bank account. This is a foreign key to the XLE_ENTITY_PROFILES table.
BankAccountReportPEOAccountOwnerPartyId	The identifier of the party associated to the account owner. This is a foreign key to the HZ_PARTIES table.
BankAccountReportPEOAccountSuffix	The account suffix for the bank account.
BankAccountReportPEOAgencyLocationCode	The agency location code used by federal agencies.
BankAccountReportPEOApUseAllowedFlag	Indicates whether the bank account is enabled for payables function. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEOArUseAllowedFlag	Indicates whether the bank account is enabled for receivables function. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEOAssetCodeCombinationId	The unique identifier of the cash account code combination. This is a foreign key to the GL_CODE_COMBINATIONS table.
BankAccountReportPEOAttribute1	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute10	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute11	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute12	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute13	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute14	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute15	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute2	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute3	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute4	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute5	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute6	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute7	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute8	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttribute9	A segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeCategory	The descriptive flexfield context name for the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeDate1	A date segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeDate2	A date segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeDate3	A date segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeDate4	A date segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeDate5	A date segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeNumber1	A number segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeNumber2	A number segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeNumber3	A number segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeNumber4	A number segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOAttributeNumber5	A number segment of the Bank Accounts descriptive flexfield.
BankAccountReportPEOBankAccountId	The unique identifier of the bank account. This is the primary key of the Bank Account view object.
BankAccountReportPEOBankAccountName	The name used to refer the bank account.
BankAccountReportPEOBankAccountNameAlt	The alternate name of the bank account. This is useful for businesses in Japan.
BankAccountReportPEOBankAccountNum	The identification number of the bank account.
BankAccountReportPEOBankAccountNumElectronic	The electronic bank account number used for electronic transfer of funds.
BankAccountReportPEOBankAccountType	Indicates whether the account is savings, checking or others. A list of accepted values is defined in the lookup type BANK_ACCOUNT_TYPE.
BankAccountReportPEOBankBranchId	The unique identifier of the bank branch associated to the bank account. This is a foreign key to the CE_BANK_BRANCHES_V view.
BankAccountReportPEOBankExchangeRateType	The conversion rate type used for bank statement reconciliation for multi-currency bank accounts.
BankAccountReportPEOBankId	The unique identifier of the bank associated to the bank account. This is a foreign key to the CE_BANKS_V view.
BankAccountReportPEOCashCcidFixedSegments	This is a list of segments that represent the general ledger cash account and are used to retrieve multiple cash account combinations for journal reconciliation.
BankAccountReportPEOCashClearingCcid	The unique identifier of the cash clearing account code combination. This is a foreign key to the GL_CODE_COMBINATIONS table.
BankAccountReportPEOCheckDigits	The check digits used for validation of the bank account number.
BankAccountReportPEOCreatedBy	The user who created the bank account.
BankAccountReportPEOCreationDate	The date and time when the bank account was created.
BankAccountReportPEOCurrencyCode	The currency of the bank account. This is the foreign key to the FND_CURRENCIES table.
BankAccountReportPEODataSecurityFlag	Indicates whether the bank account is secured by users and roles. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEODescription	The detailed description of the bank account.
BankAccountReportPEOEftUserNum	The electronic file transfer user number for the bank account.
BankAccountReportPEOEndDate	The date when the bank account was inactivated.
BankAccountReportPEOGlCurExcRateType	The accounting conversion rate type used to convert external cash transaction amount from bank account currency to ledger currency.
BankAccountReportPEOGlReconStartDate	The date when manual journal entries start being available for reconciliation.
BankAccountReportPEOGlobalAttribute1	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute10	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute11	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute12	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute13	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute14	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute15	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute16	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute17	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute18	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute19	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute2	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute20	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute3	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute4	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute5	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute6	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute7	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute8	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttribute9	A segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeCategory	The global descriptive flexfield context name for the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeDate1	A date segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeDate2	A date segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeDate3	A date segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeDate4	A date segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeDate5	A date segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeNumber1	A number segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeNumber2	A number segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeNumber3	A number segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeNumber4	A number segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOGlobalAttributeNumber5	A number segment of the Bank Accounts global descriptive flexfield.
BankAccountReportPEOIbanNumber	The international bank account number of the bank account.
BankAccountReportPEOLastUpdateDate	The date when the bank account row was last updated.
BankAccountReportPEOLastUpdateLogin	The session login associated with the user who last updated the bank account.
BankAccountReportPEOLastUpdatedBy	The user who last updated the bank account row.
BankAccountReportPEOManualToleranceRuleId	The identifier of the manual tolerance rule attached to the bank account. This is a foreign key to the CE_RECON_TOLERANCE_RULES table.
BankAccountReportPEOMaskedAccountNum	The masked bank account number.
BankAccountReportPEOMaskedIban	The masked international bank account number.
BankAccountReportPEOMaxCheckAmount	The maximum payment amount allowed for bank account in a payment batch.
BankAccountReportPEOMaxOutlay	The maximum payment batch allowed for the bank account.
BankAccountReportPEOMinCheckAmount	The minimum payment amount allowed for bank account in a payment batch.
BankAccountReportPEOMultiCashReconEnabledFlag	Indicates whether multiple cash account combinations can be considered for journal reconciliation. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEOMultiCurrencyAllowedFlag	Indicates whether bank account can be used for multiple currency payments or receipts. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEONettingAcctFlag	Indicates whether the bank account is a netting account. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEOObjectVersionNumber	The number of times the bank account row has been updated.
BankAccountReportPEOParsingRuleSetId	The identifier of the parsing rule set attached to the bank account. This is a foreign key to the CE_PARSING_RULE_SETS table.
BankAccountReportPEOPayUseAllowedFlag	Indicates whether the bank account is enabled for payroll function. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEOPooledFlag	Indicates whether the bank account is pooled or not pooled. A list of accepted values is defined in the lookup type YES_NO.
BankAccountReportPEOReconDifferenceCcid	The unique identifier of the reconciliation difference account code combination. This is a foreign key to the GL_CODE_COMBINATIONS table.
BankAccountReportPEOReconRulesetId	The unique identifier of the reconciliation rule set attached to the bank account.
BankAccountReportPEOReconStartDate	The date when the bank account can be used for bank statement reconciliation.
BankAccountReportPEOReversalProcessCode	This specifies the method used to reverse receipts based on reversal bank statement lines during automatic reconciliation. A list of accepted values is defined in the lookup type ORA_CE_AUTOREC_REVERSAL.
BankAccountReportPEOSecondaryAccountReference	The secondary account reference such as building society roll number associated to the bank account.
BankAccountReportPEOStartDate	The date when the bank account was created.
BankAccountReportPEOTargetBalance	The target balance set for the bank account.
BankAccountReportPEOTransactionCalendarId	The identifier of the general ledger transaction calendar. This is a foreign key to the GL_TRANSACTION_CALENDAR table.
BankAccountReportPEOZeroAmountAllowed	Indicates whether the bank account can be used for zero amount payments. A list of accepted values is defined in the lookup type YES_NO.