BankStatementReconciliationToleranceRule

The bank statement reconciliation tolerance rules contain amount and date tolerances that prevent or warn users when reconciliation would be a breach of a defined tolerance. The reconciliation tolerance rules are used during automatic and manual reconciliation.

Expand all

Collapse all

Business Views

** Available for extracting data

• bankStatementReconciliationToleranceRulesExtract**

  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 Tolerance Rules, Bank Statement Reconciliation Tolerance Rules

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • activeFlag (boolean)

    Indicates whether the reconciliation tolerance rule is active.

    Label

    Active

    Properties

    • not nullable
  • amountAbove (big-decimal)

    The amount tolerance above the statement line amount.

    Label

    Amount Above

  • amountBelow (big-decimal)

    The amount tolerance below the statement line amount.

    Label

    Amount Below

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • daysAfter (int64)

    The number of days after the statement booking date that's used for the date tolerance.

    Label

    Days After

  • daysBefore (int64)

    The number of days before the statement booking date that's used for the date tolerance.

    Label

    Days Before

  • description (string)

    The description of the reconciliation tolerance rule.

    Label

    Description

  • enableAmountToleranceFlag (boolean)

    Indicates whether the reconciliation tolerance rule is enabled for amount tolerance.

    Label

    Enable Amount Tolerance

  • enableDateToleranceFlag (boolean)

    Indicates whether the reconciliation tolerance rule is enabled for date tolerance.

    Label

    Enable Date Tolerance

  • enablePercentageAmountToleranceFlag (boolean)

    Indicates whether the reconciliation tolerance rule is enabled for percentage amount tolerance.

    Label

    Enable Percentage Amount Tolerance

  • id (int64)

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

    Label

    Tolerance Rule Identifier

    Properties

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

    The name of the reconciliation tolerance rule.

    Label

    Name

    Properties

    • not nullable
  • percentAbove (big-decimal)

    The tolerance percentage above the statement line amount.

    Label

    Percent Above

  • percentBelow (big-decimal)

    The tolerance percentage below the statement line amount.

    Label

    Percent Below

  • 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