Bank details validation rules for Netherlands

When using a format code of NB (Netherlands) 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 Address Code

    Mandatory

    Bank Account Name

    Mandatory

    Bank Account Number

    Mandatory

    For bank accounts, must be 10 digits (with leading zeroes)

    For giro accounts, must be 7 digits (with leading zeros)

    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)

    NB

    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

    Optional for Foreign

    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

    Salary Account (Y/N Flag 1)

    Mandatory

    'N' for Direct Debits

    Net Account (Y/N Flag 2)

    Mandatory

    Bank accounts must be 'Y'

    Giro accounts can be either

    Cheque to Code (Flag 1)

    Mandatory for Foreign

    Must be in range 1 to 3

    Payment DNB Code (Flag 2)

    Mandatory for Foreign

    3 characters

    DNB Trader number (Flag 3)

    Mandatory if DNB Code =2

    4 characters

    DNB Registration (Flag 4)

    Mandatory if DNB Code = 4 or 5

    Item Code (Flag 4)

    Mandatory if DNB Code = 1or 2

    3 numeric digits

  3. Save your changes.