BankAccountStatement

The bank account statement provides the details of the statement header issued by the bank, which includes information for reconciliation and cash balances such as Prior-day bank statements and intra-day bank statements.

Expand all

Collapse all

Business Views

** Available for extracting data

• bankAccountStatementsExtract**

  The bank account statement provides the details of the statement header issued by the bank, which includes information for reconciliation and cash balances such as Prior-day bank statements and intra-day bank statements.

  Label, Plural Label

  Bank Account Statements, Bank Account Statements

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • autoreconciliationProcessID (int64)

    Identifier of the automatic reconciliation program.

    Label

    Autoreconciliation Process ID

  • autoreconciliationProcessStatus (enumeration: AutoReconciliationProcessStatus)

    Identifier of the automatic reconciliation program.

    Label

    Autoreconciliation Process Status

    Type

    • Module: oraErpCoreBankStatements

    • Enumeration Type: AutoReconciliationProcessStatus

    Valid Values

    • INPROCESS
    • PROCESSED
    • UNPROCESSED
  • balanceCheck (big-decimal)

    Amount difference between the opening balance plus all activities compared to the closing balance reported on the bank statement. If the amount does not equal zero there is an issue with the bank statement and needs to be investigated.

    Label

    Balance Check

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • entryType (enumeration: StatementEntryType)

    Indicates how the bank statement was added to the system. Valid values are Manual (entered by a user) and Electronic (automatically imported from the bank).

    Label

    Entry Type

    Type

    • Module: oraErpCoreBankStatements

    • Enumeration Type: StatementEntryType

    Valid Values

    • AUTO
    • MANUAL
  • id (int64)

    The unique identifier of the bank statement. This is the primary key of the Bank Statement Headers view object.

    Label

    Statement Header ID

    Properties

    • searchable
    • sortable
    • not nullable
  • intradayStatementFlag (boolean)

    Indicates whether the bank statement is an intraday bank statement. A list of accepted values is defined in the lookup type YES_NO.

    Label

    Intraday

  • legalSequenceNumber (string)

    The legal sequential number of the bank statement, assigned by the account servicer.

    Label

    Legal Sequence Number

  • periodEndDate (date)

    End date or time for which the account statement is issued.

    Label

    Period End Date

    Properties

    • not nullable
  • periodStartDate (date)

    Start date or time for which the account statement is issued.

    Label

    Period Start Date

    Properties

    • not nullable
  • reconciliationStatus (enumeration: StatementHeaderReconciliationStatus)

    Status of Bank Statement Reconciliation.

    Label

    Reconciliation Status

    Type

    • Module: oraErpCoreBankStatements

    • Enumeration Type: StatementHeaderReconciliationStatus

    Properties

    • not nullable

    Valid Values

    • COMPLETE
    • INCOMPLETE
    • REVIEWED
  • sequenceNumber (string)

    The sequential number of the statement, assigned by the account servicer. It's increased incrementally for each statement sent electronically.

    Label

    Sequence Number

  • statementDate (date)

    Date when the bank statement was created. It appears on the bank statement.

    Label

    Statement Date

    Properties

    • not nullable
  • statementNumber (string)

    The number of the bank statement.

    Label

    Statement ID

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Time Created

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • bankAccount (BankAccount)

    The bank account provides the details of the internal bank accounts of a company that are used to receive payments and disburse funds. It contains legal entity-level bank account information. Each bank account must be affiliated with one bank branch.

    Business Object

    BankAccount

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier for the bank account.

      Label

      Bank Account ID

      Properties

      • searchable
      • sortable
      • not nullable

    Expand all

    Collapse all

    Reference Object

    • bank (Bank)

      The bank is a financial institution that allows customers to deposit, withdraw, and manage funds. A bank can have multiple operating branches. This object provides details of the bank.

      Business Object

      Bank

      Expand all

      Collapse all

      Fields

      • id (int64)

        Unique identifier for the bank.

        Label

        Bank ID

        Properties

        • searchable
        • sortable
        • not nullable
      • name (string)

        The name of the bank.

        Label

        Name

        Properties

        • searchable
        • sortable
        • not nullable

  • currency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • inboundFile (BankStatementFile)

    A bank statement file represents a file received from an external payment system for processing bank statements.

    Business Object

    BankStatementFile

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of the inbound file.

      Label

      Inbound File ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Back to Top