BankAccountStatementLine

The bank account statement lines contain information related to bank statement lines, such as line number, booking date, transaction code, transaction type, reconciliation reference, transaction amount, transaction identification information, and so on. It includes reconciled and unreconciled bank statements lines.

Expand all

Collapse all

Business Views

** Available for extracting data

• bankAccountStatementLinesExtract**

  The bank account statement lines contain information related to bank statement lines, such as line number, booking date, transaction code, transaction type, reconciliation reference, transaction amount, transaction identification information, and so on. It includes reconciled and unreconciled bank statements lines.

  Label, Plural Label

  Bank Account Statement Lines, Bank Account Statement Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountServicerReference (string)

    The account servicing institution's reference for the entry.

    Label

    Account Servicer Reference

  • additionalEntryInformation (string)

    The additional information on the entry details.

    Label

    Additional Entry Information

  • amount (big-decimal)

    The amount of the bank statement line.

    Label

    Amount

    Properties

    • not nullable
  • bookingDate (date)

    The date and time when an entry is posted to an account on the account servicer's books.

    Label

    Booking Date

    Properties

    • not nullable
  • checkNumber (string)

    The check number on the bank statement line.

    Label

    Check Number

  • clearingSystemReference (string)

    The unique and unambiguous identifier for a payment instruction, assigned by the clearing system.

    Label

    Clearing System Reference

  • commissionFlag (boolean)

    Indicates whether bank commissions or charges are waived for the transaction.

    Label

    Commission

  • contractIdentifier (string)

    The unique and unambiguous identifier of the foreign exchange contract.

    Label

    Contract ID

  • conversionRate (big-decimal)

    Conversion rate of the bank statement line.

    Label

    Conversion Rate

  • counterpartyBankAccount (string)

    The identifier of the supplier or customer bank account.

    Label

    Counterparty Bank Account

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerReference (string)

    The customer reference text in the bank statement line.

    Label

    Customer Reference

  • endToEndIdentifier (string)

    The unique identification assigned by the initiating party to unambiguously identify the transaction. This identification is passed on, unchanged, throughout the entire end-to-end chain.

    Label

    End to End ID

  • flowIndicator (enumeration: FlowIndicator)

    Indicates whether the bank statement line amount is a debit or credit. Possible values are Debit and Credit.

    Label

    Flow Indicator

    Type

    • Module: oraErpCoreBankStatements

    • Enumeration Type: FlowIndicator

    Valid Values

    • CRDT
    • DBIT
  • id (int64)

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

    Label

    Statement Line Identifier

    Properties

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

    The unique identification as assigned by an instructing party for an instructed party to unambiguously identify the instruction. It's a point to point reference.

    Label

    Instruction ID

  • lineNumber (int64)

    A number assigned to a bank statement line.

    Label

    Line Number

    Properties

    • not nullable
  • originalAmount (big-decimal)

    The amount of the underlying foreign currency transaction.

    Label

    Original Amount

  • quotationDate (date)

    The date and time at which a conversion rate is quoted.

    Label

    Quotation Date

  • reconciliationExceptionFlag (boolean)

    Indicates whether a reconciliation exception is found for the bank statement line. An exception occurs when the reconciliation process can't find a system transaction to match with a particular bank statement line.

    Label

    Reconciliation Exception

  • reconciliationReference (string)

    The reconciliation reference of the bank statement line. It's an identifier used for reconciliation matching.

    Label

    Reconciliation Reference

  • reconciliationStatus (enumeration: ReconciliationStatus)

    Indicates the reconciliation status of a bank statement line. Valid values are reconciled and unreconciled.

    Label

    Reconciliation Status

    Type

    • Module: oraErpCoreBankStatements

    • Enumeration Type: ReconciliationStatus

    Properties

    • not nullable

    Valid Values

    • REC
    • UNR
  • reversalFlag (boolean)

    Indicates whether the bank statement line is the result of a reversal operation.

    Label

    Reversal

  • servicerStatus (enumeration: ServicerStatus)

    The status of an entry on the books of an account servicer.

    Label

    Servicer Status

    Type

    • Module: oraErpCoreBankStatements

    • Enumeration Type: ServicerStatus

    Valid Values

    • BOOKED
    • NOT_BOOKED
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • transactionIdentifier (string)

    The unique identification assigned by the first instructing agent to unambiguously identify the transaction and passed on, unchanged, throughout the entire interbank chain.

    Label

    Transaction ID

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • valueDate (date)

    The date assets become available to the account owner in a credit entry, or cease to be available to the account owner in a debit entry.

    Label

    Value Date

  Expand all

  Collapse all

  Reference Object

  • bankAccountStatement (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.

    Business Object

    BankAccountStatement

    Expand all

    Collapse all

    Fields

    • 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

  • bankReconciliationGroup (BankReconciliationGroup)

    A bank reconciliation group contains the grouping, status, and details of reconciliation actions performed on a bank account, including information about the reconciliation matching and tolerance rules used, and whether the reconciliation was performed automatically. Each reconciliation group helps track which transactions and transaction sources were reconciled over time and supports the review of reconciliation history.

    Business Object

    BankReconciliationGroup

    Expand all

    Collapse all

    Fields

    • id (int64)

      Identifier of the bank reconciliation group.

      Label

      Bank Reconciliation Group ID

      Properties

      • searchable
      • sortable
      • not nullable

  • cashTransaction (CashTransaction)

    The cash transaction provides the details of the external transactions related to cash activity that isn't recorded within the application, such as bank charges or interest transactions created from bank statement lines, bank account balance adjustments, bank statement reconciliation differences, transactions imported from third-party systems and so on.

    Business Object

    CashTransaction

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the external transaction. This is the primary key of the External Cash Transactions view object.

      Label

      External cash transaction identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • originalCurrency (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

  • transactionCode (BankStatementTransactionCode)

    A bank statement transaction code contains the details of standardized or bank-specific codes used to classify and identify the type of transaction reported on a bank statement line. It includes the code, description, associated transaction type, domain, family, and subfamily. This enables consistent categorization and clear identification of nature of each transaction on the bank statement.

    Business Object

    BankStatementTransactionCode

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the transaction code. This is the primary key of the Bank Statement Transaction Codes view object.

      Label

      Transaction Code Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionType (ERPLookupCode)

    Transaction type associated with the transaction code.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Back to Top