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
- 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"
- 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.
- Validation Pattern:
- 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}$
- Bank A: 10-digit reference
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)