BankStatementReconciliationMatchingRule

The bank statement reconciliation matching rules contain reconciliation matching rules that are used during automatic reconciliation. Each rule determines how the bank statement lines and system transactions are automatically matched.

Expand all

Collapse all

Business Views

** Available for extracting data

• bankStatementReconciliationMatchingRulesExtract**

  The bank statement reconciliation matching rules contain reconciliation matching rules that are used during automatic reconciliation. Each rule determines how the bank statement lines and system transactions are automatically matched.

  Label, Plural Label

  Bank Statement Reconciliation Matching Rules, Bank Statement Reconciliation Matching Rules

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • activeFlag (boolean)

    Indicates whether the reconciliation matching rule is active.

    Label

    Active

  • advancedMatchingJoinCondition (string)

    The join condition formed from the match criteria.

    Label

    Join Condition

  • cashTransactionFlag (boolean)

    Indicates whether the reconciliation matching rule is used to reconcile cash management cash transactions.

    Label

    Receivables

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    The description of the reconciliation matching rule.

    Label

    Description

  • id (int64)

    The unique identifier of the reconciliation matching rule. This is the primary key of the Bank Statement Reconciliation Matching Rules view object.

    Label

    Matching Rule Identifier

    Properties

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

    Indicates whether the reconciliation matching rule is used to reconcile general ledger journal entry lines.

    Label

    Journal

  • matchByAmountFlag (boolean)

    Indicates whether the reconciliation matching rule should use amount when matching bank statement lines and system transactions. This option is applicable to the One to One, One to Many, Many to One, and Many to Many matching types.

    Label

    Amount

    Properties

    • not nullable
  • matchByDateFlag (boolean)

    Indicates whether the reconciliation matching rule should use date when matching bank statement lines and system transactions. This option is applicable to the One to One matching type.

    Label

    Date

    Properties

    • not nullable
  • matchByReconciliationReferenceFlag (boolean)

    Indicates whether the reconciliation matching rule should use reconciliation reference when matching bank statement lines and system transactions. This option is applicable to the One to One matching type.

    Label

    Reconciliation Reference

    Properties

    • not nullable
  • matchByTransactionTypeFlag (boolean)

    Indicates whether the reconciliation matching rule should use transaction type when matching bank statement lines and system transactions. This option is applicable to the One to One matching type.

    Label

    Transaction Type

    Properties

    • not nullable
  • matchingType (enumeration: ReconciliationMatchType)

    The matching type of the reconciliation matching rule. Valid values are One to One, One to Many, Many to One, Many to Many, Zero Amount, and Statement Net Zero Amount.

    Label

    Matching Type

    Type

    • Module: oraErpCoreCashManagementSetup

    • Enumeration Type: ReconciliationMatchType

    Properties

    • not nullable

    Valid Values

    • 0:M
    • 1:1
    • 1:M
    • M:0
    • M:1
    • M:M
    • REVERSAL
  • name (string)

    The name of the reconciliation matching rule.

    Label

    Name

    Properties

    • not nullable
  • payablesFlag (boolean)

    Indicates whether the reconciliation matching rule is used to reconcile payables transactions.

    Label

    Payables

  • payrollFlag (boolean)

    Indicates whether the reconciliation matching rule is used to reconcile payroll transactions.

    Label

    Payroll

  • receivablesFlag (boolean)

    Indicates whether the reconciliation matching rule is used to reconcile receivables transactions.

    Label

    Receivables

  • statementLineGroupingClause (string)

    The group by clause on the bank statement line side. It's used in automatic reconciliation.

    Label

    Statement Line Grouping Clause

  • systemTransactionGroupingClause (string)

    The group by clause on the system transaction side. It's used in automatic reconciliation.

    Label

    System Transaction Grouping Clause

  • 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
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

Back to Top