Bank details validation rules for Luxembourg

When using a format code of LX (Luxembourg) within Bank Details Extension Setup (BDE) the following validation rules are applied, in additional to normal validation for Bank Details Setup (BNK) and Bank Details Extension Setup (BDE), to ensure details adhere to an internationally recognised format.

  1. Complete this information in Bank Details Setup:
    Bank Name

    Mandatory

    Bank Branch

    Optional

    Bank Sort Code

    Mandatory

    Numeric

    Bank Address Code

    Mandatory

    Bank Account Name

    Mandatory

    Bank Account Number

    Optional

    Numeric

    Transaction Limit

    Optional, can set limit of single transaction

    Transaction Reference

    Optional

    Direct Debit Transaction Type

    First, Normal, Re-present, or Last

    Comment

    Optional

  2. Complete this information in Bank Details Extension Setup:
    Format Code (Format Identifier)

    LX

    SunSystems User (Record Type)

    'U' for Own

    ' ' blank for regular Debtor / Creditor

    Domestic / Foreign (Code 1)

    Mandatory

    'D' or 'F'

    If Record Type = 'U', then must be 'D'

    Country Code (Code 2)

    Not required for Domestic

    Mandatory for Foreign

    Maximum 3 characters

    Pay by Account / Ref. (Code 3)

    Mandatory for Record Type ' ' blank

    Must be 'A' or 'R'

    Currency Code (Code 4)

    Not required for Domestic

    Optional for Foreign

    Swift Code

    Mandatory for Foreign if IBAN Number not entered

    Not required if IBAN Number entered

    Bank Code (Code 5)

    Mandatory if IBAN Number not entered

    3 numeric digits

    Beneficiary A/C Country (Code 6)

    Mandatory if IBAN Number not entered

    2 character ISO

    Control Digits (Code 7)

    Mandatory if IBAN Number not entered

    2 digits

    Foreign Payee (Y/N Flag 1)

    Default = Y

    Charge Allocation (Code 8)

    Optional

    'R', 'S', 'C' or '' blank

    IBAN Number (Description 1)

    Mandatory if Bank Account Number not entered

    20 digits for Domestic

    34 digits for Foreign

    Foreign Exchange Text (Text 1)

    Mandatory

    Maximum 70 characters

  3. Save your changes.