Payment reference rule examples

Use these examples as templates when configuring payment reference rules in Continia Banking. Each example demonstrates how to match common payment reference formats.

Example 1: Finnish Reference Number (FI)

  • Format: Numeric, includes a check digit (Modulus 10)
  • Sample Reference: 12345672

Configuration

  • Validation Pattern: ^\d{8}$
  • Check Digit: Enabled (Modulus 10)
  • Direct Match: Enabled
  • Match to Table: Customer Ledger Entry
  • Match to Field: Document No.

Note

When Direct Match is enabled, Reference Start Position and Reference Length are automatically cleared and not used.

Example 2: Swedish OCR Number

  • Format: Numeric, variable length, check digit (Modulus 10)
  • Sample Reference: 12345678903

Configuration

  • Validation Pattern: ^\d{10,12}$
  • Check Digit: Enabled (Modulus 10)
  • Direct Match: Enabled
  • Match to Table: Customer Ledger Entry
  • Match to Field: Document No.

Example 3: Norwegian KID Number

  • Format: Numeric, variable length, check digit (Modulus 10 or 11)
  • Sample Reference: 12345678903

Configuration

  • Validation Pattern: ^\d{5,25}$
  • Check Digit: Enabled (Modulus 10 or 11)
  • Direct Match: Enabled
  • Match to Table: Customer Ledger Entry
  • Match to Field: Document No.

Example 4: Reference with embedded document type

  • Format: "INV2024001" (where "INV" is the document type indicator, "2024001" is the reference)
  • Sample References:
    • INV2024001 (Invoice)
    • CM2024002 (Credit Memo)

Configuration

  1. Create document type mappings:
    • Code = "INV_MAPPING", Document Type Indicator = "INV", Document Type = "Invoice"
    • Code = "CM_MAPPING", Document Type Indicator = "CM", Document Type = "Credit Memo"
  2. Configure the rule:
    • Validation Pattern: ^[A-Z]{2,3}\d{7}$
    • Direct Match: Disabled
    • Reference Start Position: 4
    • Reference Length: 7
    • Match Document Type: Enabled
    • Document Type Start Position: 1
    • Document Type Length: 3
    • Match to Table: Customer Ledger Entry
    • Match to Field: Document No.
  3. Link Mappings to Rule:
    • Use the Related Document Types to link "INV_MAPPING" and "CM_MAPPING".

The system extracts "2024001" for matching and identifies it as an invoice document type.

Example 5: Bank-specific reference format

  • Format: Varies by bank
  • Examples:
    • Bank A: 10-digit reference ^\d{10}$
    • Bank B: 12-digit reference ^\d{12}$

Configuration:

  • Create separate rules filtered by Bank Code:
    • Rule 1: Bank Code BANKA
    • Rule 2: Bank Code BANKB

Each rule applies only to transactions from the specified bank.

Example 6: Modulus 10 Recursive check digit

  • Format: Scandinavian payment reference using Modulus 10 recursive check digit
  • Sample Reference: 1234567890 (where the last digit is the check digit)

Configuration

  • Validation Pattern: ^\d{10,15}$
  • Check Digit: Enabled
  • Check Digit Algorithm: Modulus 10 recursive
  • Check Digit Position: 10 (position of the check digit)
  • Check Digit Calc. Start Pos.: 1
  • Check Digit Calc. Length: 9
  • Direct Match: Enabled
  • Match to Table: Customer Ledger Entry
  • Match to Field: Document No.

Expected behavior: The system validates the check digit using the Modulus 10 recursive algorithm before matching the reference.

Example 7: Combined filters

  • Format: CAMT053 statements from specific bank with ISO transaction codes
  • Sample Reference: 98765432

Configuration

  • Validation Pattern: ^\d{8}$
  • Direct Match: Enabled
  • Statement Type: CAMT053
  • Bank Code: NORDEA
  • Domain Code: PMNT
  • Family Code: RCDT
  • Sub-Family Code: ESCT
  • Match to Table: Customer Ledger Entry
  • Match to Field: Document No.

Expected behavior: This rule only applies to:

  • CAMT053 statements
  • From bank NORDEA
  • With ISO transaction code PMNT-RCDT-ESCT (payment received credit transfer)