6.1.9 SWIFT MT942 (NRT) Template 1¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 106-108 PDF pages: 106-108
FOOTER (Example) 03,2 TI_PTI_CSV_Balance _Only.txt
All Negative Value fields will be preceded by the sig n "-"(Debit balance) All Positive Value fields will NOT be preceded by a sign. Fixed width files length of 1000 characters.
Sample file layout
01,1234,3000000014,Product,1234, ADMIN,20130130 02,1234567890,20130130,000000,1000.00,1003.00,1005.00,1006.00,25,23,1001.00,1002.00 02,1234567891,20130130,000000,1003.00,1007.23,1009.00,1010.00,15,13,1005.00,1006.00 03,2
It is used to transmit information about provisional entries debited or credited to the account for a specified interval. The SWIFT template is to be read in conjunction with the SWIFT Standards Document 2011. Refer to Appendix D to access 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
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 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 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 Date is expressed as YYMMDD. Time is expressed as HHMM Sign is either "+" or "-". Refer to SWIFT Standards document 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 PTI. IF you receive the same transaction key on another PTI 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 PTI 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 Your statement narrative will be populated in this field (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 -}