Report formats

(1)

C&I Online Format Description

Report formats

M arch 2016

(2)

Revision history

Version Section Description

February 2010 1 and 3 Balance report and SEB account statement: Latest booked balance and latest value dated balance is now available to select.

6 ETEBAC file: Amounts should not be in HEX value in record type 05

June 2010 4 SEB Account statement Extended: New report in pdf format

2, 3 New format in Structured information and some additions October 2010 2,3,5,6 New available fields in Account statement and Transaction report

Changes in the description of MT940 and MT940DE.

October 2011 9 Polish "Reconciliation file". New report

December 2011 8 Removed section regarding France

May 2014 4 and 5 New and changed fields in reports

(3)

Table of Content

1. NOTATION ... 4

2. BALANCE REPORT ... 5

2.1 B

ALANCE

R

EPORT

–

FORMAT DESCRIPTION

... 5

2.2 B

ALANCE

R

EPORT

-

EXAMPLE

... 5

2.3 B

ALANCE REPORT

–

CREATE A REPORT LAYOUT

... 5

3. SEB TRANSACTION REPORT ... 7

3.1 T

RANSACTION REPORT

–

FORMAT DESCRIPTION

... 7

3.2 T

RANSACTION REPORT

-

EXAMPLE

... 7

3.3 T

RANSACTION REPORT

–

... 7

4. SEB ACCOUNT STATEMENT ... 9

4.1 A

CCOUNT STATEMENT

–

FORMAT DESCRIPTION

... 9

4.2 A

CCOUNT

S

TATEMENT

-

EXAMPLE

... 9

4.3 A

CCOUNT

S

TATEMENT

–

... 9

5. SEB ACCOUNT STATEMENT EXTENDED ... 12

5.1 A

CCOUNT STATEMENT

E

XTENDED

–

FIELDS

... 12

5.2 A

CCOUNT

S

TATEMENT

E

XTENDED

-

EXAMPLE

... 13

6. MT 940 ... 14

6.1 MT940 –

FORMAT DESCRIPTION

... 14

6.1.1 Field 61, subfield specifications... 14

6.1.2 Field 86, subfield specifications... 16

6.2 MT940 –

EXAMPLE

... 18

7. MT 940DE ... 19

7.1 MT940DE –

FORMAT DESCRIPTION

... 19

7.1.1 MT940DE, Field 61, subfield specification ... 19

7.1.2 MT940DE, Field 86, subfield specification ... 20

7.2 MT940DE, E

XAMPLE

... 25

8. POLISH RECONCILIATION FILE ... 26

8.1 F

ORMAT DESCRIPTION

... 26

8.2 E

XAMPLE

... 26

(4)

1. Notation

In the format descriptions each tag has an attribute stating if data is mandatory or optional.

If data can be repeated also the minimum or maximum of occurrences is stated within curly brackets. The following symbols are used to state if data is mandatory or optional.

Descriptor Description

O Optional data

M Mandatory data

Example O{2..2} means data is optional but if entered there must be exactly two lines of data.

Format

The format descriptor specifies the syntax for valid data. The following symbols are used to describe the data format.

Descriptor Interpretation

n Digits

x Alphanumeric characters

c Numeric characters

d decimals

(n) Data can have a variable length with a minimum of zero and a maximum of "n" digits.

(n!) Data must have a length of exactly "n" characters.

(n..m) Data can be repeated from "m" to "n" times.

[ X(3) ] Optional value

'/' Literal character '/’.

'BEN' Literal value "BEN".

a | b Selection clause, either value/format "a" or "b" can be used.

Examples

Format

2n Up to 2 digits 3!x Exactly 3 characters

4*35x 4 rows with up to 35 characters

(1..5)x must have at least 1 and up to 5 characters

['/'1!a] An optional value but if existing it must start with / and have exactly 1 character. E.g. /k

(5)

2. Balance Report

A default report providing account and balance information.

2.1 Balance Report – format description

Category Field Description

Account Account Holder Account Holder

Account BIC Code BIC Code of account holding bank

Account Account Number Account Number

Account Currency Currency ( ISO standard ) in which the account is handled

Balance Date Date

Balance Opening Booked Balance Opening Booked Balance Balance Closing Booked Balance Closing Booked Balance Balance Opening Value dated Balance Opening Value dated Balance Balance Closing Value dated Balance Closing Value dated Balance

2.2 Balance Report - example

Example of a SEB Balance Report in PDF format

2.3 Balance report – create a report layout

When creating a Report layout based on a SEB Balance Report, the following fields are available.

Account Bank Name Name of account holding bank

(6)

Account Currency Currency ( ISO standard ) of account number

Account Account Name Account Name

Account Country of Account Use the country code in pos 5-6 in the BIC. (Only country code is used)

Balance Date Date

Balance Opening Booked Balance Opening Booked Balance Balance Closing Booked Balance Closing Booked Balance

Balance Booked Balance Latest booked balance = the latest of Opening booked, Intermediate, booked and closing booked balances Balance Opening Value dated Balance Opening Value dated Balance

Balance Closing Value dated Balance Closing Value dated Balance

Balance Value dated Balance Latest value dated balance = the latest of Opening Value dated, Intermediate value dated and closing value dated balances Balance No Of Total Booked Debits Number of Booked Debits

Balance No Of Total Booked Credits Number of Booked Credits Balance No Of Total Valued Debits Number of Valued Debits Balance No Of Total Valued Credits Number of Valued Credits Balance Total Booked Debit Amount Sum of Booked Debits Balance Total Booked Credit Amount Sum of Booked Credits Balance Total Valued Debit Amount Sum of Valued Debits Balance Total Valued Credit Amount Sum of Valued Credits

Balance Booked Net Amount Booked Net Amount

Balance Valued Net Amount Valued Net Amount

(7)

3. SEB Transaction Report

A default report designed primarily for reconciliation purpose. The report includes account and detailed transaction information.

3.1 Transaction report – format description

Transaction Entry Date Entry Date

Transaction Value Date Value Date

Transaction

Amount

Amount in details, including all amounts in lump sum bookings

Transaction Text Business description

Transaction Reference Verification number / Money Transfer Reference Number / Account Servicing Institution’s Reference )

Transaction Structured information Structured information type, id, currency and amount Transaction Additional information Free text

3.2 Transaction report -example

Example of a SEB Transaction Report in CSV format

3.3 Transaction report – create a report layout

When creating a Report layout based on a SEB Transaction Report, the following fields are available.

Transaction Amount Amount in details, including all amounts in lump sum bookings

Transaction Text KK-text / Business description

Transaction Original Amount Incoming transactions: Amount received by SEB

Outgoing transactions: Amount instructed by the customer Transaction Original Currency Currency in the Original amount

Transaction Exchange Rate Exchange Rate

Transaction Instructed amount Amount sent from initiating party in an incoming transaction Transaction Instructed amount Currency Currency in the instructed amount

(8)

Transaction Remitted amount Amount sent from SEB in an outgoing transaction Transaction Remitted amount Currency Currency in the amount sent from SEB

Transaction T-Account T-Account

Transaction Remitter/Receiver Name Remitter/Receiver Name Transaction Remitter/Receiver Address Remitter/Receiver Address Transaction Remitter/Receiver Bank Remitter/Receiver Bank Transaction Remitter/Receiver Branch

Code/Address

Remitter/Receiver Branch Code/Address

Transaction Remitter/Receiver Account Number

Remitter/Receiver Account Number

Transaction Remitter/Receiver Correspondent Bank

Remitter/Receiver Correspondent Bank

Transaction Structured Information Structured information type, id, currency and amount Transaction Additional Information Free text

Transaction Business Description Business Description

Transaction Reason Code UBTC code

Transaction Additional Booking Reference Additional Booking Reference Transaction Remitter Reference Senders own reference

Transaction Acceptance Date Date when the bank balance check inquiry has been made.

Transaction Originators reference, End to End

End to end reference from a SCT Payment.

Transaction Counterparty identification Id type of Countrparty identificationid.

Counterparty:

Outgoing payment: Creditor Incoming payment: Debtor Direct Debit Creditor flow: Debtor Direct Debit Debtor Flow: Creditor Transaction Counterparty identification Counterparty identification

Transaction Beneficiary identification type Id type of beneficiary id

Transaction Beneficiary identification The beneficiary’s unique id on the remitter

Transaction Purpose Purpose of the Credit transfer

Transaction Ultimate Debtor I Name Name of the beneficiary reference party Transaction Ultimate Debtor Identification Identification of the beneficiary reference party Transaction Ultimate Creditor Name Name of the originator reference party Transaction Ultimate Creditor Identification Identification of the originator reference party

Transaction Charges Total Amount of charges

Transaction Charges currency Currency of total amount of charges Transaction Charges details Amount for every charges code:

Currency, Amount and Type of charge in plain language

Transaction Transaction Code UBTC code (low level)

Transaction GVC German GVC code

Transaction GVC text German GVC code text

Transaction Bank reference

Transaction R message initiator Party that has initiated a Reject, Return etc.

Transaction R reference Reference in the R message.

Transaction Reason of Rejection The reasons of Rejection. ISO code and text.

Transaction Date of Signature Date of signature in the Mandate Transaction Amendment, Original Mandate

Reference

If a Mandate is changed this field shows the original mandate reference.

Transaction Amendment, Original Creditor If a Mandate is changed Transaction Creditor Bank Reference

Transaction Settlement Date

Transaction Original Bank reference Reference in the original transaction

(9)

4. SEB Account Statement

A default report designed to provide a statement of balances and booked items.

4.1 Account statement – format description

Balance Date Date

Transaction Text Business description

Transaction Amount Booked amount

4.2 Account Statement - example

Example of a SEB Account Statement Report in XLS format

4.3 Account Statement – create a report layout

When creating a Report layout based on a SEB Account Statement, the following fields are available.

Balance Date Date

Balance Opening Booked Balance Opening Booked Balance Balance Closing Booked Balance Closing Booked Balance

Balance Booked Balance Latest booked balance = the latest of Opening booked, Intermediate, booked and closing booked balances Balance Opening Value dated Balance Opening Value dated Balance

Balance Closing Value dated Balance Closing Value dated Balance

(10)

Balance Value dated Balance Latest value dated balance = the latest of Opening Value dated, Intermediate value dated and closing value dated balances Balance No Of Total Booked Debits Number of Booked Debits

Balance No Of Total Booked Credits Number of Booked Credits Balance No Of Total Valued Debits Number of Valued Debits Balance No Of Total Valued Credits Number of Valued Credits Balance Total Booked Debit Amount Sum of Booked Debits Balance Total Booked Credit Amount Sum of Booked Credits Balance Total Valued Debit Amount Sum of Valued Debits Balance Total Valued Credit Amount Sum of Valued Credits

Balance Booked Net Amount Booked Net Amount

Balance Valued Net Amount Valued Net Amount

Transaction Original Amount Incoming transactions: Amount received by SEB

Outgoing transactions: Amount instructed by the customer Transaction Original Currency Currency in the Original amount

Transaction Instructed amount Amount sent from initiating party in an incoming transaction Transaction Instructed amount Currency Currency in the instructed amount

Transaction Remitted amount Amount sent from SEB in an outgoing transaction Transaction Remitted amount Currency Currency in the amount sent from SEB

Transaction Remitter/Receiver Name Remitter/Receiver Name Transaction Remitter/Receiver Address Remitter/Receiver Address Transaction Remitter/Receiver Bank Remitter/Receiver Bank Transaction Remitter/Receiver Branch

Code/Address

Transaction Remitter Country

Transaction Remitter/Receiver Account Number

Transaction Remitter/Receiver Correspondent Bank

Remitter/Receiver Correspondent Bank

Transaction Structured information Structured information type, id, currency and amount Transaction Additional Information Free text

Transaction Business Description Business Description (UBTC code)

Transaction Reason Code UBTC code

Transaction Additional Booking Reference Additional Booking Reference Transaction Remitter Reference Senders own reference

Transaction Acceptance Date Date when the bank balance check inquiry has been made.

Transaction Originators reference, End to End

End to end reference from a SCT Payment.

Transaction Counterparty identification Id type of Countrparty identificationid.

Counterparty:

Outgoing payment: Creditor Incoming payment: Debtor Direct Debit Creditor flow: Debtor Direct Debit Debtor Flow: Creditor Transaction Counterparty identification Counterparty identification

Transaction Beneficiary identification type Id type of beneficiary id

(11)

Transaction Beneficiary identification The beneficiary’s unique id on the remitter

Transaction Purpose Purpose of the Credit transfer

Transaction Ultimate Debtor I Name Name of the beneficiary reference party Transaction Ultimate Debtor Identification Identification of the beneficiary reference party Transaction Ultimate Creditor Name Name of the originator reference party Transaction Ultimate Creditor Identification Identification of the originator reference party Transaction Originator Reference Party

Identification type

Type of identification

Transaction Originator Reference Party Identification

Identification of the originator reference party

Transaction Charges currency Currency of total amount of charges Transaction Charges details Amount for every charges code:

Currency, Amount and Type of charge in plain language

Transaction Transaction Code UBTC code (low level)

Transaction GVC German GVC code

Transaction GVC text German GVC code text

Transaction Text Key Extension

Transaction Customer Reference Number Transaction Acceptance Date

Transaction Bank reference

Transaction R message initiator Party that has initiated a Reject, Return etc.

Transaction R reference Reference in the R message.

Transaction Reason of Rejection The reasons of Rejection. ISO code and text.

Transaction Date of Signature Date of signature in the Mandate Transaction Amendment, Original Mandate

Reference

If a Mandate is changed this field shows the original mandate reference.

Transaction Amendment, Original Creditor If a Mandate is changed Transaction Creditor Bank Reference

Transaction Settlement Date

Transaction Original Bank reference Reference in the original transaction

(12)

5. SEB Account statement Extended

SEB Extended Account Statement is a standard report that is only presented in pdf format. The report can be ordered in the function "Order report" in C&IOnline. The report layout can not be changed and the rows in the report are written only if there is a value to present.

5.1 Account statement Extended – fields All possible fields in the report

Balance Date Date

Transaction Original Amount Original Amount

Transaction Original Currency Original Currency

Transaction Remitter / Receiver Name Remitter/Receiver Name Transaction Remitter / Receiver Address Remitter/Receiver Address Transaction Remitter / Receiver Bank Remitter/Receiver Bank Transaction Remitter / Receiver Bank

Code/Address

Transaction Remitter / Receiver ACCONT Number

Transaction Structured information Structured information type, id, currency and amount Transaction Additional information (Details

of payment)

Additional Booking Reference

Transaction Remitter Reference Senders own reference

Transaction Charges Currency Code Currency of total amount of charges

Transaction Customer Reference Number Customer Reference Number

(13)

5.2 Account Statement Extended - example

(14)

6. MT 940

MT940 is an account statement based on the SWIFT standard. The MT940 presents each booking as one tag 61 and if applicable one tag 86. Depending on if the report is ordered to specify details or not the report can include all beneficiaries in a mass transfer or only the lump sum level (see 4.1.1).

6.1 MT940 – format description

Tag Field Name Format Option Definition

20 Transaction Reference Number 16x M

25 Account Identification 35x M This field identifies the account for which the statement is sent.

28C Statement Number 5n[/5n] (Statement Number)

M This field contains the sequential number of the statement.

60a Opening Balance 1!a6!n3!a15d

(D/C Mark) (Date) (Currency) (Amount)

M This field specifies, for the opening balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance.

61 Statement Line 6!n[4!n]2a[1!a]15d1!a 3!c16x[//16x][34x]

O This field contains the details of each transaction.

See subfield specification below 86 Information to Account Owner 6*65x O This field contains additional information

on the transaction detailed in the preceding statement line and which is to be passed on to the account owner.

See subfield specification below 62a Closing Balance (Booked

Funds)

F or M Option F 1!a6!n3!a15d (D/C Mark) (Date) (Currency) (Amount)

Option M 1!a6!n3!a15d (D/C Mark) (Date) (Currency) (Amount)

M This field specifies, for the (intermediate) closing balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance.

64 Closing Available Balance (Available Funds)

1!a6!n3!a15d

M

65 Forward Available Balance 1!a6!n3!a15d

O

6.1.1 Field 61, subfield specifications

Subfield Field Name Format Details selected ¹⁾ Definition

Yes No

1 Value Date (YYMMDD) 6!n X X

2 Entry Date (MMDD) [4!n] X X

(15)

Subfield Field Name Format Details selected ¹⁾ Definition

Yes No

3 Debit/Credit Mark 2a X X D=Debit

C=Credit

RC=Reversal of credit (debit entry)

RD=Reversal of debit (credit entry 4 Funds Code (3rd character of the

currency code, if needed)

[1!a] X X

5 Amount 15d 2) 3) See comment below

6 Transaction Type Identification Code 1!a3!c X X See codes in the code table below 7 Reference for the Account Owner 16x X 4) If the code EREF occurs it points

to the End-to-End reference witch is included in field 86.

If no reference can be presented the value ´NONREF´ is presented.

8 Account Servicing Institution's Reference [//16x] X X

9 Supplementary Details [34x] X X

Comments

1) Fields in a mass transfer if the report is ordered to show the details.

2) Booked amount in a single booking or amount for each detail in a mass transfer. Details for a salary payment are never presented.

3) Booked amount, details in a mass transfer are not presented.

4) Only references in the booking level can be presented.

5) If an invoice is presented in field 86 the invoice amount is presented in field 61

6.1.1.1 Field 61, Subfield 6, Transaction Type Identification Code

Code Definition

BNK Securities Related Item - Bank fees BOE Bill of exchange

BRF Brokerage fee

CAR Securities Related Item - Corporate Actions Related (Should only be used when no specific corporate action event code is available)

CAS Securities Related Item - Cash in Lieu CHG Charges and other expenses CHK Cheques

CLR Cash letters/Cheques remittance CMI Cash management item - No detail CMN Cash management item - Notional pooling CMP Compensation claims

CMS Cash management item - Sweeping CMT Cash management item -Topping CMZ Cash management item - Zero balancing

COL Collections (used when entering a principal amount) COM Commission

CPN Securities Related Item - Coupon payments

DCR Documentary credit (used when entering a principal amount) DDT Direct Debit Item

DIS Securities Related Item - Gains disbursement DIV Securities Related Item - Dividends

ECK Euro cheques EQA Equivalent amount

EXT Securities Related Item - External transfer for own account

(16)

Code Definition FEX Foreign exchange INT Interest

LBX Lock box LDP Loan deposit

MAR Securities Related Item - Margin payments/Receipts MAT Securities Related Item - Maturity

MGT Securities Related Item - Management fees MSC Miscellaneous

NWI Securities Related Item - New issues distribution ODC Overdraft charge

OPT Securities Related Item - Options

PCH Securities Related Item - Purchase (including STIF and Time deposits) POP Securities Related Item - Pair-off proceeds

PRN Securities Related Item - Principal pay-down/pay-up REC Securities Related Item - Tax reclaim

RED Securities Related Item - Redemption/Withdrawal RIG Securities Related Item - Rights

RTI Returned item

SAL Securities Related Item - Sale (including STIF and Time deposits) SEC Securities (used when entering a principal amount)

SLE Securities Related Item - Securities lending related STO Standing order

STP Securities Related Item - Stamp duty SUB Securities Related Item - Subscription SWP Securities Related Item - SWAP payment TAX Securities Related Item - Withholding tax payment TCK Travellers cheques

TCM Securities Related Item - Tripartite collateral management TRA Securities Related Item - Internal transfer for own account TRF Transfer

TRN Securities Related Item - Transaction fee

UWC Securities Related Item - Underwriting commission

VDA Value date adjustment (used with an entry made to withdraw an incorrectly dated entry - it will be followed by the correct entry with the relevant code)

WAR Securities Related Item - Warrant

6.1.2 Field 86, subfield specifications

Order Field Name Format Details selected ¹⁾ Definition ²⁾

Yes No Information to Account Owner 6*65x

line break after 65x

The fields should be presented in order specified in the order column. The field starts with 86: and then it is filled with the different codes below.

Example:

86:/EREF/ABCD1234/ORDP//NAME/CORP ORATE X /ID/456789/REMI/INVOICE INFORMATION 78 AND

79/ULTD//ID/CUS98765

1 Originators reference, End to End 35x X -- (AT41 in pain001) - Use the code EREF followed by max 35 characters from the End-to-End ID

Example: 86:/EREF/ABCD1234

(17)

2 Ordering party Name 70x

ID 35 x

(AT10 in pain001).

Code:

ORDP = Account owner name ID = Originators identification

Example :

86:/EREF/ABCD1234/ORDP//NAME/CORP ORATE EX/ID/456789

3 Remittance information Structure

d:

Type: 3x Informati on: 26x

Unstruct ured:

140x

X X Details of payment (AT05 in pain001) Code = REMI

Structured information Example:

/REMI//CDTRREFTP//CD/SCOR/CDTRREF/

010806817183/

or (if not SCOR) /REMI/010806817183/

Unstructured information:

Example: /REMI/Details_of_payment

If both occur the structured information is presented

4 Ultimate debtor Name

70x

ID 35 x

X X Originator Reference Party (AT08 and AT09 in pain001)

Code = ULTD

Format:

/ULTD//NAME/party_name/ID/Identifivc ation

5 Ultimate Creditor Name

70x

ID 35 x

X -- Beneficiary Reference Party (AT28 and AT29 in pain001)

Code = ULTB

Format:

/ULTB//NAME/party_name/ID/identifica tion

6 Purpose 35x X -- Purpose (AT44 in PAIN001)

Code = PURP

Format: /PURP//CD/Reference text

7 Target / Source account X X Format: 833 or 834 and then the value

8 Charges X X Format: /CHGS/Currency and amount

9 Original amount X X Format: : /OCMT/Currency and amount

10 Exchange Rate X X Format: /EXCH/Exchange_rate

11 Beneficiary party X -- Format: /BENM/Beneficiary name

Comments

1) Fields in a mass transfer if the report is ordered to show the details.

2) Reference to the XML message pain.001.001.02, (UNIFI, ISO 20022) is indicated in

parentheses.

(18)

6.2 MT940 – example

:20:0902061550000019 :25:ESSEFRPXXXX/41719024 :28C:90204

:60F:C090203EUR46588432,91

:61:0902040204D8,00N281EREF//PAR 09020400084 SCT OUTGOING REGULATED PAYMENT

:86:/EREF/End to End (AT41)/REMI/10020(AT05)050060070080099/ULTD/

/NAME/Name of orig ref party (AT08)/ID/123 (AT09)/ULTB//NAME/Bene f ref party name (AT28)/ID/999 (AT29)/PURP//CD/WTER/OCMT/EUR8,00/

BENM/SEPA paym - Beneficiary name :62F:C090204EUR46588424,91 :64:C090204EUR46588424,91

(19)

7. MT 940DE

MT940DE is a German account statement.

7.1 MT940DE – format description

Field

Field Name Format Option

20 Transaction Reference Number 9(1..16) M

25 Account Identification X(1..35) M This field identifies the account for which the statement is sent.

28C Statement Number/Sequence Number 9(1..5)'/'9(0..3) M/O This field contains the sequential number of the statement.

60a

Opening Balance M

D/C Mark X(1) M D=debit, C=Credit

Date 9(6) M YYMMDD

Currency X(3) M Currency key as per ISO 4217

Amount 9(1..15) M

61 Statement Line O See subfield specifications in field 61

below

86 Information to Account Owner O See subfield specifications for field 86 below

62a

Closing Balance (Booked Funds) M

D/C Mark X(1) M D=debit, C=Credit

Date 9(6) M YYMMDD

Currency X(3) M Currency key as per ISO 4217

Amount 9(1..15) M

64

Closing Available Balance (Available Funds)

O

D/C Mark X(1) M

Date 9(6) M

Currency X(3) M

Amount 9(1..15) M

7.1.1 MT940DE, Field 61, subfield specification

Subfield Field Name Format Option Definition

1 Value Date YYMMDD M

2 Entry Date MMDD O

3 Debit/Credit Mark X(1..2) M D=Debit

C=Credit

RC=Reversal of credit (debit entry) RD=Reversal of debit (credit entry

4 Funds Code X(1) O Not used

5 Amount 9(1..15) M Booked amount

This is the invoice amount if a invoice is presented in field 86

6 Transaction Type Identification Code X(4) M Always starts with N

See "Transaction Type Identification Code" for the MT940 report above.

(20)

Subfield Field Name Format Option Definition

7 Reference for the Account Owner X(1..16) M If the reference in this field is more than 16 characters KREF+ is displayed to indicate that the reference is displayed in field 86 subfield 20

If no reference is presented "NONREF" is displayed.

Zero Balancing Transaction SEB site

External bank

8 Account Servicing Institution's Reference X(1..16) O Starts with // if subfield 8 exists.

9 Supplementary Details X(1..34) O Further information/original amount and charges amount

Description /OCMT/ Format:

/OCMT/Currency of original amount and Original amount (entered amount)/

Description /EXCH/ Specified if Account currency differs from

Currency of amount.

Format:

/EXCH/Account currency/Currency of amount/Exchange rate/

7.1.2 MT940DE, Field 86, subfield specification

The lines in field 86 are separated with <CR><LF>. A subfield is identified by the "?"

followed by the subfield number.

Subfield Field Name Format Option Definition ¹⁾

Transaction code 9(3) M GVC code, see the transaction codes below.

00 Booking text X(1..27) O

10 Journal no 9(1..10) O

20-29 Description X(1..27) O

End to End reference 35x Originators reference, End to End (AT41 in pain001)

In line 1 the code EREF+ followed by the End- to-End ID

Format: ?20EREF+ABCD1234 Customer reference See field 61

subfield 7 above.

Remitter reference

If not presented in field 61-7 it is presented with the code KREF in this field.

Format: KREF+reference

Originators identifier 35x Originators identification private or organization (AT10 in pain001)

Format: DEBT+identification

(21)

Subfield Field Name Format Option Definition ¹⁾ SEPA reason for payment Structured:

Information:

1..26x

Unstructured:

1..140x

Details of payment (AT05 in pain001)

Unstructured information:

Format: ?20SVWZ+INVOICE INFORMATION 78 AND 79

Structured information

Format: ?20SVWZ+010806817183

If both occur the structured information is presented

Ultimate debtor 1..70x Originator Reference Party name (AT08 in

pain001)

Format: ?20ABWA+Party name

30 Bank Code X(1..12) O

31 Account number 9(1..24) O

32-33 Name X(1..27) O

34 Text key extension 9(3) O

60 Description /CHGS/ 1..27 O /CHGS/Currency X(3) and charges amount

9(1..15)/

61 T-account X(1..27) O Only if Account Type = C or S

62-63 Rimittance information X(1..27) O Continuation of field 86-?20 to ?29

Comments

1) Reference to the XML message pain.001.001.02, (UNIFI, ISO 20022) is indicated in parentheses.

7.1.2.1 MT940DE, Field 86, Transaction codes

Transaction codes are defined for all business transactions that result from bank operations;

they consist of a standard three-digit code which allows customers to map transaction information into the transaction categories used within their specific systems.

Bilaterally agreed transaction codes for reporting transactions (digit 1 to digit 3 in multi-purpose field 86)

0XX D O M E S T I C P A Y M E N T T R A F F I C 001 Personal cheque (except eurocheque) 002 Draft or money order

003 DM traveller's cheque

004 Direct debit (preauthorised payment procedure) 005 Direct debit (automatic debit transfer)

006 Other debits 008 Standing order

009 Return (debit) for debit instruction, reversing transfer of data carrier file interchange, debit (return) - DTA - 010 Return invoice (debit) for

- direct return

- BSE cheque not redeemed Folder (debit) for

- ordered BSE cheque

- New submission of guaranteed BSE cheque - Delivery of BSE cheque copy or BSE original cheque - Replacement for lost cheque

(22)

Code Definition 011 Eurocheque

012 Invoice payment instruction

014 Debit for foreign-currency eurocheque / debit for foreign cheques cleared through GZS 015 International funds transfer without text message

017 Remittance instruction: blank remittance/payment form with checksum-protected processing instructions 018 Remittance instruction: blank remittance/payment form

019 Remittance instruction: blank charitable contribution remittance/payment form 020 Remittance instruction

051 Remittance credit 052 Standing order credit

053 Wages, salaries, pension credit

054 Employment benefit capital savings scheme credit 056 Public treasury remittance

058 Interbank payment (remittance credit)

059 Return (credit) of undeliverable remittance, credit (reversing transfer) - DTA - 065 Remittance credit (international funds transfer without text message) 066 Cheque redemption credit E.v. (export cheque processing via GZS)

067 Credit: blank remittance/payment form with checksum-protected processing instructions 068 Credit: blank remittance/payment form EZÜ

069 Credit: blank charitable contribution remittance/payment form EZÜ 070 Cheque redemption

071 Debit redemption

072 Presentation of bill of exchange 073 Bill of exchange

074 TC (cheque debit) 075 BSE cheque 076 Telephone instruction 077 BTX remittance

078 Remittance (maintenance payment credit) 079 Collective

080 Salary 081 Compensation 082 Payment on account 083 Withdrawal

084 BTX direct debit instruction

087 Remittance instruction with fixed foreign exchange 088 Remittance credit with fixed foreign exchange

089 Wired remittance instruction with fixed foreign exchange 090 Wired remittance credit with fixed foreign exchange 091 DATA submission: remittances

092 DATA submission: direct debits 093 Discount bill

094 Rediscount bill

095 Bank guarantee credit (domestic) 096 Carryover (debit)

097 Carryover (credit)

098 Cash card (electronic wallet transactions)

099 Cash card (dealer commission for payment guarantee) 1XX D O M E S T I C P A Y M E N T T R A F F I C

Reserved

2XX I N T E R N A T I O N A L P A Y M E N T T R A F F I C 201 Payment instruction

202 Foreign compensation 203 Collection

(23)

Code Definition 204 Letter of credit 205 Bank guaranty credit 206 International remittance 207 not assigned

208 Documentary acceptance credit 209 Cheque payment

210 Electronic payment 211 Electronic payment receipt 212 Standing order

213 International direct debit 214 Documentary collection (Import) 215 Documentary collection (Export) 216 Bill of exchange collection (Import) 217 Bill of exchange collection (Export) 218 Import letter of credit

219 Export letter of credit

220 Redemption of international cheque e.V.

221 Credit for international cheque collection 222 Debit for international cheque

223 Debit for international ec cheque 224 Foreign exchange buy

225 Foreign exchange sell

3XX S E C U R I T I E S T R A F F I C 301 Collection

302 Coupons / dividends 303 Stocks and bonds 304 Carryover 305 Registered bond

306 Note

307 Securities subscription 308 Stock rights trade 309 Premium rights trade 310 Options trade 311 Futures trade 320 Securities trading fees 321 Custodian fees 330 Securities income

340 Credit for securities at maturity 399 Reversal

4XX F O R E I G N - E X C H A N G E T R A F F I C 401 Direct exchange

402 Forward exchange 403 Travel exchange 404 Foreign currency cheque 405 Financial innovation 406

407 408 409 410

411 Spot exchange buy 412 Spot exchange sell 413 Forward exchange buy 414 Forward exchange sell

(24)

415 FW - Day money – active 416 FW - Day money – passive 417 FW - Time deposit – active 418 FW - Time deposit – passive 419 Call money: active

420 Call money: passive 421 Options

422 Swap

423 Precious metals: buy 424 Precious metals: sell 5XX M A O B E

6XX C R E D I T T R A N S A C T I O N 601 Debit of instalments/annuities 602 Transfer of instalments/annuities 603 Redemption

604 Interest on loans

605 Interest on loans with additional services 7XX R E S E R V E D

8XX M I S C E L L A N E O U S 801 Cheque card

802 Chequebook 803 Custodianship 804 Standing order charge 805 Closing

806 Postage and handling 807 Fees and expenses

808 Fees

809 Commission 810 Dunning charges 811 Credit cost

812 Interest on delinquent taxes 813 Discount

814 Interest

815 Capitalised interest 816 Interest rate change 817 Interest correction 818 Debit

819 Remuneration 820 Carryover 821 Telephone 822 Payment plan 823 Fixed-term deposits 824 Loan monies 825 General loan

826 Time-adjusted savings 827 Surplus savings 828 Savings certificate 829 Savings plan

830 Bonus

831 Old invoice 832 Mortgage

833 Cash concentrating: main account booking 834 Cash concentrating: advice for subsidiary account 835 Other transactions

(25)

Code Definition 836 Claim booking

888 Book transfer due to euro conversion 899 Reversal

9XX U N S T R U C T U R E D C O N T E N T S 997 List of portfolio securities -> MT 571

999 Unstructured assignment of multi-purpose field '86'

7.2 MT940DE, Example

:20:0902061603000020 :25:ESSEDEF0XXX/62851000 :28C:90205

:60F:D090204EUR1123945666,13

:61:0902060206C88,77NTRFNONREF//FRA 09020500211/OCMT/EUR88,77/

:86:166?00SEPA SCT Einzel Haben?10020500211?20EREF+TestavMT940Rap port?21DEBT+SE12345678?22SVWZ+03609020500211M09C0 0?230 F?24ABWA +TimHamilton?32TACTEL, TEST

:62F:D090205EUR1123945577,36 :64:D090205EUR1123945666,13

(26)

8. Polish Reconciliation file

8.1 Format description

Nr Field Option Format Description

1 Transaction type M 3!n Transaction type, codes from 110 to 114 110 = Payment order

114 = payment order between indirect clearing member banks

2 Execution due date M 8!n Execution due date in format YYYYMMDD E.g. 20080303

3 Amount M 15n Amount without decimal separator

E.g. 531200

4 Intermediary bank 1 BSC M 8!n BSC (Bank Sorting Code) of intermediary bank 1 E.g. 12402076

5 Intermediary bank 2 BSC M 8!n BSC (Bank Sorting Code) of intermediary bank 2 E.g. 13700001

6 Ordering party account M 26!n Ordering party account in NRB standard.

E.g. 79124015161111000016745034

7 Beneficiary account number M 26!n Your virtual account number in NRB standard (26 digits without commas, spaces, etc)

E.g. 57237000080000010020006002 8 Ordering party name and

address

M 4*35x Lines are separated with „ |” (Hex 7C).

“Name 1|Name2|Street|Town”

E.g. “Ronal Polska Sp z. o.o. ||Ul. Szturmowa 2a |00-678 WARSZAWA”

9 Beneficiary name and address M 4*35x Lines are separated with „ |” (Hex 7C).

Name 1|Name2|Street|Town

E.g. “Kropka Sp. z o.o.||Ul. Odwrotna 3a|00-678 Warszawa”

10 Ordering party (branch) BSC M 8!n BSC (Bank Sorting Code) of ordering part bank E.g. 12401516

11 Beneficiary bank BSC M 8!n BSC (Bank Sorting Code) of beneficiary E.g. 23700008

12 Payment details M 4*35x Lines are separated with „ |” (Hex 7C).

E.g. “ZAPLATA ZA TOWAR |F-RA VAT 17 I 21/2006

|ZAMOWIENIE 2368/2989283/2005|333”

13 Empty field M 0 " "

14 Empty field M 0 " "

15 Transaction classification M 2!n 32x

Document code :"51" for payment order Additional clearing ID

E.g. “51200802018451715”

16 interbank information O 6*35x Additional interbank information:

E.g. "0630201602300148"

8.2 Example

114,20080201,100,12402076,13700001,"79124015161111000016745034","43237000089876543220083008","RONAL POLSKA SP. Z O.O|RACHUNEK BIEZ||02-678 WARSZAWA","SEB AB SA",12401516,23700008,"TEST