Bank Account Balances

The Bank Account Balances view object contains information related to bank account balances reported in the bank statements, such as balance code, balance code, balance amount, and so on.

Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountBalanceExtractPVO

Primary Keys : BankAccountBalanceStmtBalanceId

Initial Extract Date : BankAccountBalanceCreationDate

Incremental Extract Date : BankAccountBalanceLastUpdateDate

Attributes

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

Name	Description
BankAccountBalanceBalanceAmount	The balance amount corresponding to the balance code.
BankAccountBalanceBalanceCode	The nature of the bank account balance. A list of accepted values is defined in the lookup type CE_INTERNAL_BALANCE_CODES.
BankAccountBalanceBalanceCurr	The currency of the bank account balance. This is a foreign key to the FND_CURRENCIES table.
BankAccountBalanceBalanceDate	The date of the bank account balance.
BankAccountBalanceBankAccountId	The unique identifier of the bank account on which the balance is reported. This is a foreign key to the CE_BANK_ACCOUNTS table.
BankAccountBalanceCreatedBy	The user who created the bank account balance.
BankAccountBalanceCreationDate	The date and time when the bank account balance was created.
BankAccountBalanceLastUpdateDate	The date and time when the bank account balance was last updated.
BankAccountBalanceLastUpdateLogin	The session login associated with the user who last updated the bank account balance.
BankAccountBalanceLastUpdatedBy	The user who last updated the bank account balance.
BankAccountBalanceObjectVersionNumber	The number of times the bank account balance row has been updated.
BankAccountBalanceStatementHeaderId	The unique identifier of the bank statement on which the balance is reported. This is a foreign key to the CE_STATEMENT_HEADERS table.
BankAccountBalanceStmtBalanceId	The unique identifier of the bank account balance. This is the primary key of the Bank Account Balances view object.