• Guidance: importing Euro IM (SEPA Credit Transfer) in Commercial Banking Online (CSV file) for LloydsLink customers

    Last updated:  07  December  2015

    Importing Euro IM (SEPA Credit Transfer) in a CSV file

    Importing Euro IM (SEPA Credit Transfer) payments to Commercial Banking Online will be different to importing them in LloydsLink:

    • Euro IM (SEPA Credit Transfer) will now be called Euro Payment on Commercial Banking Online

    Header Indicator and Trailer Indicator

    Each payment you import will need to contain a header record at the start and a trailer record at the end. The header record will need to include:

    • Header Indicator: H
    • Import date: YYYYMMDD
    • Unique Sequence Number: every payment submitted by a user on the same day must have a different number. Each user can choose which number to enter.

    The Trailer Indicator field must always be ‘T’.

    Comments

    The comments field allows you to add notes about the payment. The field is optional and any text entered will not be shown on Commercial Banking Online.

    LloydsLink

    This table shows a breakdown of new, changed and removed fields on Commercial Banking Online.

    New mandatory fields  

    Fields have changed position or format  

    New optional fields  

    Removed fields  

    Header Indicator

    Payment Type

    Debit Amount

    Filter Description

    Date

     

    Beneficiary Address Line 1

    Version

    Sequence

    Value Date

    Beneficiary Address Line 2

    Freeze

    Trailer Indicator

    Payment Amount

     

    Urgency Code

     

    FX Exchange Rate

     

    Currency

     

    FX Contract ID

    Beneficiary Reference Line 2

    Transfer Currency

     

    IBAN

    Beneficiary Reference Line 3

    Beneficiary Short Code

     

    Beneficiary Name

    Beneficiary Reference Line 4

    Pay on Application

     

    Beneficiary Reference Line 1

    Comments

     
     

    Debit Account

    Originator Name

     
     

    Debit Account Reference

    Originator Address 1

    Debit Account Code

     

    Beneficiary Bank Address Line 2

    Originator Address 2

    Debit Account Currency

       

    Originator Country

     
       

    Beneficiary Bank Name

     
       

    Beneficiary Bank Code

     
       

    Beneficiary Bank Address Line 1

     
       

    Beneficiary Bank Country

     
       

    Beneficiary Country

     




    New mandatory fields

    These fields are new mandatory fields which must be completed for the imported payment to pass validation

    Fields have changed position or format

    These fields have changed position and/or format. They are a mixture of mandatory and optional fields. Mandatory fields must be completed for the imported payment to pass validation.

    New optional fields

    These fields are new and are optional.

    Removed fields

    These LloydsLink fields will no longer appear on Commercial Banking Online.

    This table shows the differences between your existing payment import file and the payment import file on Commercial Banking Online

     LloydsLinkCommercial Banking Online 
    Field namePositionMandatory/OptionalField formatPositionMandatory/OptionalField formatDescription of the change

    Header Indicator  

    n/a

    n/a

    n/a

    H1

    Mandatory

    H

    New mandatory field

    Date

    n/a

    n/a

    n/a

    H2

    Mandatory

    YYYYMMDD

    New mandatory field

    Sequence

    n/a

    n/a

    n/a

    H3

    Mandatory

    35 characters

    New mandatory field

    Filter Description

    H1

    Mandatory

    35 characters

    n/a

    n/a

    n/a

    Field has been removed

    Version

    H2

    Mandatory

    10 characters

    n/a

    n/a

    n/a

    Field has been removed

    Freeze

    H3

    Optional

    YES or NO

    n/a

    n/a

    n/a

    Field has been removed

    Payment Type

    1

    Mandatory

    LV

    1

    Mandatory

    EURSEPA

    Mandatory field must be filled with EURSEPA

    Beneficiary Country

    2

    Mandatory

    2 characters

    15

    Optional

    2 characters

    Field is now optional and has changed position

    Urgency Code

    3

    Optional

    1 character

    n/a

    n/a

    n/a

    Field has been removed

    Value Date

    4

    Mandatory

    DDMMYY

    2

    M

    YYYYMMDD

    Field has changed position and format

    Currency

    5

    Mandatory

    3 characters

    n/a

    n/a

    n/a

    Field has been removed

    Transfer Currency

    6

    Mandatory

    3 characters

    n/a

    n/a

    n/a

    Field has been removed

    Payment Amount

    7

    Mandatory

    N10

    3

    Optional

    N18.2

    Field is now optional and has changed position and format

    Debit Amount

    n/a

    n/a

    n/a

    6

    Mandatory/ Optional

    N18.3

    New field, mandatory if Credit Amount is not populated)

    FX Exchange Rate

    24

    Optional

    15 characters

    7

    Optional

    N10

    Field has changed position and format

    FX Contract ID

    25

    Optional

    1 character+N10 or ’AGREED’

    8

    Optional

    16 characters

    Field has changed position and format

    Beneficiary Short Code

    11

    Optional

    10 characters

    n/a

    n/a

    n/a

    Field has been removed

    IBAN

    12 and 13

    Mandatory

    6 and 10 characters

    10

    Mandatory

    34 characters

    Field has changed position and format

    Pay on Application

    13

    Optional

    1 character

    n/a

    n/a

    n/a

    Field has been removed

    Beneficiary Name

    14

    Mandatory

    35 characters

    9

    Mandatory

    35 characters

    Field has changed position

    Beneficiary Bank Name

    15

    Optional

    35 characters

    16

    Optional

    16 characters

    New optional field

    Beneficiary Bank Code

    n/a

    n/a

    n/a

    17

    Optional

    35 characters

    New optional field

    Beneficiary Bank Address Line 1

    16

    Optional

    35 characters

    18

    Optional

    35 characters

    Field has changed position

    Beneficiary Bank Address Line 2

    16

    Optional

    35 Characters

    19

    Optional

    35 characters

    Field has changed position

    Beneficiary Address Line 1

    n/a

    n/a

    n/a

    11

    Optional

    35 characters

    New optional field

    Beneficiary Address Line 2

    n/a

    n/a

    n/a

    12

    Optional

    35 characters

    New optional field

    Beneficiary Country

    n/a

    n/a

    Beneficiary Country

    15

    Optional

    2 characters (must be a valid ISO country code)

    New optional field

    Beneficiary Bank Country

    n/a

    n/a

    Beneficiary Bank Country

    21

    Optional

    2 characters (must be a valid ISO country code)

    New optional field

    Beneficiary Reference Line 1

    17

    Optional

    35 characters x 4

    22

    Optional

    35 characters

    Field has changed position and format

    Beneficiary Reference Line 2

    n/a

    n/a

    n/a

    23

    Optional

    35 characters

    New optional field

    Beneficiary Reference Line 3

    n/a

    n/a

    n/a

    24

    Optional

    35 characters

    New optional field

    Beneficiary Reference Line 4

    n/a

    n/a

    n/a

    25

    Optional

    35 characters

    New optional field

    Debit Account Code

    18

    Optional

    10 characters

    n/a

    n/a

    n/a

    Field has been removed

    Debit Account

    19 and 20

    Mandatory

    6 and 8 characters

    5

    Mandatory

    [Sort Code]-[Account Number]

    15 characters

    Sort Code and Account Number are now in a single field separated with a hyphen.

    Debit Account Currency

    21

    Mandatory

    3 characters

    n/a

    n/a

    n/a

    Field has been removed

    Debit Account Reference

    34

    Optional

    16 characters

    4

    Optional

    16 characters

    Field has changed position

    Comments

    n/a

    n/a

    n/a

    33

    Optional

    140 Characters

    Field will be auto-filled

    Originator Name

    22

    Optional

    35 characters

    29

    Optional

    35 characters

    New optional Field

    Originator Address 1

    n/a

    n/a

    n/a

    30

    Optional

    35 characters

    New optional field

    Originator Address 2

    n/a

    n/a

    n/a

    31

    Optional

    35 characters

    New optional field

    Originator Country

    n/a

    n/a

    n/a

    44

    Optional

    2 characters

    New optional field

    Trailer Indicator

    n/a

    n/a

    n/a

    T1

    Mandatory

    T

    New mandatory field

    A key to the abbreviations used in the tables above

     

    Key 
    PositionThe number shows the field position within the file. Where there are two numeric values, e.g. 3 and 4, this means two fields will be consolidated into one. For example Commercial Banking Online combines the sort code and account number into one field.
    Field Formatn/aNot applicable – this field does not exist
    DDays
    MMonths
    YYears
    N(16.2) means 16 numeric characters with 2 decimal places
    25 characters x 5means five lines of 25 characters
    'H' or 'T'means Header or Trailer

    Check your payment import files are compatible with Commercial Banking Online.

    We have provided a range of example files that demonstrate what a working payment import file will look like on Commercial Banking Online.

    You can use these files to compare them with and make changes to your current import files.

    Find out more about using payment import example files on Commercial Banking Online.

Lloyds Bank plc. Registered office: 25 Gresham Street, London, EC2V 7HN. Registered in England and Wales no. 2065. Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. Authorisation can be checked on the Financial Services Register at www.fca.org.uk under the Firm Registration Number 119278.

We subscribe to The Lending Code; copies of the Code can be obtained from www.lendingstandardsboard.org.uk. Eligible deposits with us are protected by the Financial Services Compensation Scheme (FSCS). We are covered by the Financial Ombudsman Service (FOS). Please note that due to FSCS and FOS eligibility criteria not all Business customers will be covered.