8 Appendix C - IR Templates

Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 166-175 PDF pages: 166-175

Appendix C

8.1 Near real time templates 8.1.1 SWIFT MT940 It is used to transmit detailed information about all entries booked to the account. This template can be utilised in SAP. The SWIFT template is to be read in conjunction with the SWIFT Standards document. As this message may require the implementation of special procedures, its use is governed by bilateral agreements between correspond ents. Refer to Appendix D to access to the respective document

SWIFT MT940 Standard Statement Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1 O 21 Related Reference 16x 2 M 25 Account Identification 35x 3 M 28C Statement Number / Sequence Number 5n[/5n] 4 M 60a Opening Balance F or M 5

O 61 Statement Line

6!n[4!n]2a[1!a]15d1!

a3!c1 6x[//16x] [34x] 6 O 86 Information to Account Owner 6*65x 7

M 62a Closing Balance (Booked Funds) F or M 8 O 64 Closing Available Balance (Available Balance) 1!a6!n3!a15d 9

O 65 Forward Available Balance 1!a6!n3!a15d 10

O 86 Information to Account Owner 6*65x 11 M = Mandatory O = Optional

SWIFT MT940 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number A unique reference number will be created by Nedbank for each message O 21 Related Reference This will be populated with your Nedbank profile number and instance number. The profile number and instance number will be separated by a "+" sign. Your profile number is always 10 numeric and instance number can be from 1 to 9999. Each FTI instance is a group of accounts, settings and destination. Client can load up to 9999 different FTI instances per profile. M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number One statement number per statement sent. Will reset to zero on the 1st of January every year If only one message is sent for the same statement then this will be the statement number/1 If more than one message is sent for the same statement then this will be the statement number followed by the sequence number of the statement E.g. statement number/1, statement number/2 and so on M 60a Opening Balance F or M O 61 Statement Line * Refer to Field 61 -definition below O 86 Information to Account Owner Line 1 - Will include Transaction Key, Separator ("+") and Process Key Line 2 - Will include the Resend Key, Separator ("+") and Destination Key Line 3 - Will include a Deposit slip number if the transaction relates to a branch deposit (Credit transaction) and will always start with D followed by the deposit slip number. Will include a cheque number if the transactions relates to cheque payment (Debit transaction) and will always start with C followed by the cheque number. For all other transactions this line will report not applicabe Line 4 - Will include the transaction list number, Separator ("+") and transaction line number. The transaction list is the statement number on which this transaction appears as displayed on your official posted statement. Each transaction list can have a maximum of 20 transactions. The transaction line number indicates for example this was transaction 2 in statement list 1 as displayed in your official bank statement.. Helps client match transaction to posted statement

Transaction Key: Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another FTI message it is for the same transaction ie a duplicate. Transaction Keys are not unique across FTI and PTI

Process Key: Uniquely identifies the client preferences effective for this statement ie format, accounts, destination addresses, etc

Resend Key: Any value greater than zero means this statement was resent on customer request

Destination Key: If your FTI instance has more than one destination address it will have different destination keys ie you request to send the same statement to multiple swift addresses, the first one will have a destination key "1", the second swift address will have a destination key "2", etc M 62a Closing Balance (Booked Funds) This will be the debit or credit book closing balance

O 64 Closing Available Balance (Available Balance) This will be the debit or credit available closing available balance O 65 Forward Available Balance Is not used O 86 Information to Account Owner Is not used

• Field 61: Statement Line - This field contains the details of each transaction as listed below: Subfield Form at Name Description 1 6!n Value Date Date the financial is posted to the account for the transaction 2 [4!n] Entry Date Is not used 3 2a Debit / Credit Mark C = Credit D = Debit RC = Reversal of Credit RD = Reversal of Debit 4 [1!a] Funds Code Is not used 5 15d Amount Transaction amount 6 1!a3!c Transaction Type Identification Code Will always be populated with NMSC 7 16x Reference for the Account Owner Will always insert 'NONREF' 8 [//16x] Account Servicing Institution's Reference Will Insert the Nedbank transaction code (4 numeric) separator ("+") and Nedbank Sub- Transaction code (Valid values 1 -9999). Trancode helps identify the type of transaction ie Cash deposit or EFT or Cash withdrawal, etc. Sub Trancode reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction. (A list of trancodes will be provided by Nedbank Refer to no 4.9 for a list of Transaction and Sub Transaction codes ) 9 [34x] Supplementary Details This will always include your statement narrative (Maximum 34 characters)

MT940 Sample Message:

:20:FNS0000003846681 :21:4000402101+5 :25:1015278434 :28C:7/1 :60F:C150122ZAR4698039,30 :61:150122C10000,00NMSCNONREF//1324+0 ABSA BANK IN104231 :86:103746726+3 0+1 Not Applicable 1468+20 :61:150122C2000,00NMSCNONREF//1324+0 JPJ LE ROUX :86:103746727+3 0+1 Not Applicable 1469+01 :62F:C150123ZAR4710039,30 :64:C150123ZAR4710039,30 -}

8.1.2 SWIFT MT942

It is used to transmit detailed and/or summary information about entries debited or credited to the account since:

• the last statement or balance report, or
• the last interim transaction report (sent in the period since the last statement or balance report). The SWIFT template is to be read in conjunction with the SWIFT Standards document. Refer to Appendix D to acc ess to the respective document

SWIFT MT942 Standard Statement Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1 O 21 Related Reference 16x 2 M 25 Account Identification 35x 3 M 28C Statement Number / Sequence Number 5n[/5n] 4 M 34F Floor Limit Indicator 3!a[1!a]15d 5 M 13D Date / Time Indication 6!n4!n1!nx4!n 6

O 61 Statement Line

6!n[4!n]2a[1!a]15d1!a3

!c1 6x[//16x] [34x] 7 O 86 Information to Account Owner 6*65x 8

M 90D Number and Sum of Entries 5n3!a15d 9 O 90C Number and Sum of Entries 5n3!a15d 10 O 86 Information to Account Owner 6*65x 11 M = Mandatory O = Optional

SWIFT MT942 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number A unique reference number will be created by Nedbank for each message O 21 Related Reference This will be populated with your Nedbank profile number and instance number. The profile number and instance number will be separated by a "+" sign. Your profile number is always 10 numeric and instance number can be from 1 to 9999. Each IR instance is a group of accounts, settings and destination. Client can load up to 9999 different PTI instances per profile. M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number One statement number per statement sent. Will reset to zero on the 1st of January every year If only one message is sent for the same

statement then this will be the statement number/1 If more than one message is sent for the same statement then this will be the statement number followed by the sequence number of the statement E.g. statement number/1, statement number/2 and so on M 34F Floor Limit Indicator If you have specified to only be notified for transactions above a certain value this amount is indicated in this field. If you have chosen to receive all transactions amounts then this field will contain the value zero. Applicable to both debit and credit amounts. M 13D Date / Time Indication Local date and time in accordance to the SWIFT standards as indicated in the SWIFT manual O 61 Statement Line * Refer to Field 61 -definition below O 86 Information to Account Owner Line 1 - Will include Transaction Key, Separator ("+") and Process Key Line 2 - Will include the Resend Key, Separator ("+") and Destination Key Line 3 - Will include the channel through which this transaction was processed (List of valid channels to be provided by Nedbank) Line 4 - Will include the transaction type (A valid list of transaction types to be provided by Nedbank)

Transaction Key: Each transaction in Nedbank is allocated a unique key for IR. IF you receive the same transaction key on another IR message it is for the same transaction ie a duplicate.

Process Key: Uniquely identifies the client preferences effective for this statement ie format, accounts, destination addresses, etc

Resend Key: Any value greater than zero means this statement was resent on customer request

Destination Key: If your IR instance has more than one destination address it will have different destination keys ie you request to send the same statement to multiple swift addresses, the first one will have a destination key "1", the second swift address will have a destination key "2", etc M 90D Closing Balance (Booked Funds) This field indicates the total number and total amount of debit entries in this report O 90C Closing Available Balance (Available Balance) This field indicates the total number and total amount of credit entries in this report O 86 Information to Account Owner Is not used

• Field 61: Statement Line - This field contains the details of each transaction as listed below: Subfield Format Name Description 1 6!n Value Date Date the financial is posted to the account for the transaction 2 [4!n] Entry Date Is not used 3 2a Debit / Credit Mark C = Credit D = Debit RC = Reversal of credit RD = Reversal of debit 4 [1!a] Funds Code Is not used 5 15d Amount Transaction amount 6 1!a3!c Transaction Type Identification Code Will always be populated with NMSC

7 16x Reference for the Account Owner Will always insert 'NONREF' 8 [//16x] Account Servicing Institution's Reference Will Insert the transaction type (A list of transaction types will be provided by Nedbank) 9 [34x] Supplementary Details This will always include your statement narrative (Maximum 34 characters)

MT942 Sample Message: :20:PNS0000003847690 :21:4000402493+27 :25:1454023619 :28C:23/1 :34F:ZAR0,00 :13D:1501231115+0200 :61:150123C89,89NMSCNONREF//EFT PAYMENT MIB GROUP PTY LTD 05/13081/07 :86:104091806+81 0+1 Electronic Banking EFT PAYMENT :90D:0ZAR0,00 :90C:1ZAR89,89 -}

8.1.3 SWIFT MT950

This message type is sent by an account servicing institution to an account owner. It is used to transmit detailed information about all entries, whether or not caused by a SWIFT message, booked to the account. The SWIFT template is to be read in conjunction with the SWI FT Standards document. Refer to Appendix D to acc ess to the respective document

SWIFT MT950 Standard Statement Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1 M 25 Account Identification 35x 2 M 28C Statement Number / Sequence Number 5n[/5n] 3 M 60a Opening Balance F or M 4

O 61 Statement Line

6!n[4!n]2a[1!a]15d1!a3!

c1 6x[//16x] [34x] 5

M 62a Closing Balance (Booked Funds) F or M 6 O 64 Closing Available Balance (Available Balance) 1!a6!n3!a15d 7 M = Mandatory O = Optional

SWIFT MT950 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number A unique reference number will be created by Nedbank for each message M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number One statement number per statement sent. Will reset to zero on the 1st of January every year If only one message is sent for the same statement then this will be the statement number/1 If more than one message is sent for the same statement then this will be the statement number followed by the sequence number of the statement E.g. statement number/1, statement number/2 and so on M 60a Opening Balance F or M O 61 Statement Line * Refer to Field 61 -definition below M 62a Closing Balance (Booked Funds) This will be the debit or credit book closing balance O 64 Closing Available Balance (Available Balance) This will be the debit or credit available closing available balance

• Field 61: Statement Line - This field contains the details of each transaction as listed below: Subfield Format Name Description 1 6!n Value Date Date the financial is posted to the account for the transaction 2 [4!n] Entry Date Is not used 3 2a Debit / Credit Mark C = Credit D = Debit RC = Reversal of Credit RD = Reversal of Debit 4 [1!a] Funds Code Is not used 5 15d Amount Transaction amount 6 1!a3!c Transaction Type Identification Code Will always be populated with NMSC 7 16x Reference for the Account Owner Will always insert 'NONREF' 8 [//16x] Account Servicing Institution's Reference Will Insert the Nedbank transaction code (4 numeric) separator ("+") and Nedbank Sub- Transaction code (Valid values 1 -9999). Trancode helps identify the type of transaction ie Cash deposit or EFT or Cash withdrawal, etc. Sub Trancode reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction. (A list of trancodes will be provided by Nedbank. Refer to no 4.9 for a list of Transaction and Sub Transaction codes) 9 [34x] Supplementary Details This will always include your statement narrative (Maximum 34 characters)

8.2 Real time templates 8.2.1 SWIFT MT941

It is used to transmit balance information, reflecting the situation at the identified time in field 13D. The SWIFT template is to be read in conjunction with the SWIFT Standards document. Refer to Appendix D to acc ess to the respective document

SWIFT MT941 Standard Statement Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1 O 21 Related Reference 16x 2 M 25 Account Identification 35x 3 M 28 Statement Number / Sequence Number 5n[/2n] 4 O 13D Date / Time Indication 6!n4!n1!nx4!n 5 O 60F Opening Balance 1!a6!n3!a15d 6 O 90D Number and Sum of Entries 5n3!a15d 7 O 90C Number and Sum of Entries 5n3!a15d 8 M 62F Closing Balance (Booked Funds) 1!a6!n3!a15d 9 O 64 Closing Available Balance (Available Funds) 1!a6!n3!a15d 10

O 65 Forward Available Balance 1!a6!n3!a15d 11

O 86 Information to Account Owner 6*65x 12 M = Mandatory O = Optional

SWIFT MT941 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number A unique reference number will be created by Nedbank for each message O 21 Related Reference This will be populated with your Nedbank profile number and instance number. The profile number and instance number will be separated by a "+" sign. Your profile number is always 10 numeric and instance number can be from 1 to

1. Each PTI instance is a group of accounts, settings and destination. Client can load up to 9999 different PTI instances per profile M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number One statement number per statement sent. Will reset to zero on the 1st of January every year If only one message is sent for the same statement then this will be the statement number/1 If more than one message is sent for the same statement then this will be the statement number followed by the sequence number of the statement E.g. statement number/1, statement number/2 and so on O 13D Date / Time Indication This filed indicates the date, time and time zone at which the report was created O 60F Opening Balance This field specifies the opening balance whether it is a debit or credit balance, the date, the currency and the amount of the balance. It should be the same as field 62F, the closing balance from the previous statement (MT940 or MT950) or balance report (MT941) for this account for the same day. If there were no previous statements or balance reports sent for that day then this must be the closing balance of the previous day O 90D Number and Sum of Entries This is the total number and total amount of debit entries since the last statement (MT940 or MT950) or balance report (MT941) for this account for the same day. If there were no previous statements or balance reports sent for that day then this must be the sum of debit entries from the closing balance of the previous day O 90C Number and Sum of Entries This is the total number and total amount of credit entries since the last statement (MT940 or MT950) or balance report (MT941) for this account for the same day. If there were no previous statements or balance reports sent for that day then this must be the sum of credit entries from the closing balance of the previous day M 62F Closing Balance (Booked Funds) This field contains the closing book balance for the account as at the requested time O 64 Closing Available Balance (Available Funds) This will be the debit or credit closing available balance as at the requested time O 65 Forward Available Balance Is not used O 86 Information to Account Owner Is not used

8.2.2 SWIFT MT920

It is used to request the account servicing institution to transmit one or more MT 940 Customer Statement(s), MT 941 Balance Report(s), MT 942 Interim Transaction Report(s), or MT 950 Statement Message(s) containing the latest information available for the account(s) identified in the message. The SWIFT template is to be read in conjunction with the SWIFT Standards document.

• No RMA required
• Max. length of characters in message = 2000 Refer to Appen dix D to access to the respective document

SWIFT MT920 Standard Request Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1

M 12 Message Requested 3!n 2 M 25 Account Identification 35x 3 O 34F Floor Limit Indicator 3!a[1!a]15d 4 O 34F Floor Limit Indicator 3!a[1!a]15d 5

M = Mandatory O = Optional

SWIFT MT920 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number This specifies the reference assigned by the Sender to unambiguously identify the message

• Look at possibly including: o For MT940 and MT950, indicate after normal run, after final run or after both normal and final runs M 12 Message Requested This must identify the message type being requested ie: a MT940, MT941, MT942 or MT950 M 25 Account Identification This will be the Nedbank account number for which the information is requested Although current account numbers are 10 digits long, this field must still cater for 35 digits O 34F Floor Limit Indicator Is not used O 34F Floor Limit Indicator Is not used M = Mandatory O = Optional