7 Appendix B - FTI Templates¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 128-165 PDF pages: 128-165
Appendix B
7.1 Near real time templates 7.1.1 FTI XML Template 1
Herewith the layout for the standard XML transaction feeds for near real time:
XML Tag name Data type Expected Maximum size Description
XML Tag name Data Type Expected Maximum size Description
Numeric 23 The transactions that follow are for this account
statement for this account
XML Tag name Data Type Expected Maximum size Description
meric credit (Money in) to the account being reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit
XML Tag name Data Type Expected Maximum size Description
reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit
XML Tag name Data type Expected Maximum size Description
7.1.2 FTI XML Template 2 Layout customised for Foskor Herewith the layout for the standard XML transaction feeds for near real time:
XML Tag name Data type Expected Maximum size Description
XML Tag name Data Type Expected Maximum size Description
Numeric 23 The transactions that follow are for this account
XML Tag name Data Type Expected Maximum size Description
XML Tag name Data Type Expected Maximum size Description
indicates this was transaction 2 in statement list 1. Helps client match transaction to posted statement
XML Tag name Data type Expected Maximum size Description
7.1.3 FTI CSV Template 1
Herewith the layout for the standard CSV transaction feeds for near real time: File Header Field Name Data type Expected Maximum size Description CIS Number Numeric 12 This field will display the client's CIS number Profile Number Numeric 10 This field will display the client's profile number Product Alpha 10 Will contain the F for the FTI product Instance number Numeric 4 You can load up to 9999 different instances per profile. An instance is a group of accounts, settings and destination Instance Name Alpha Numeric 30 Instance name as specified by the client will always be displayed with quotation marks Date Numeric 8 Displays the date on which the file is being sent. CCYYMMDD
Account Header Field Name Data type Expected Maximum size Description Account
Numeric 23 The transactions that follow are for this account Statement Number Number 6 Provides a single statement number per message Statement Sequence Number Alpha 6 If your statement is broken up into multiple messages it will have different sequence numbers. Opening Available Balance Decimal 16,2 This is the opening available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits) Opening Book Balance Decimal 16,2 Actual opening balance Total Debits Decimal 16,2 Sum of the debit transactions on this statement for this account Total Credits Decimal 16,2 Sum of the credit transactions on this statement for this account Total Debit Count Numeric 10 Number of debit transactions on this statement for this account Total Credit Count Numeric 10 Number of credit transactions on this statement for this account Closing Available Balance Decimal 16,2 This is the closing available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits) Closing Book Balance Decimal 16,2 Actual closing balance
Transaction Detail Field Name Data type Expected Maximum size Description Transaction Key Numeric 16 Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another message it is for the same transaction Process Key Numeric 9 Uniquely identifies the client preferences effective for this transaction Resend Key Numeric 9 Any value greater zero means the transaction was resent on customer request Destination Key Numeric 9 If a single instance has more than one destination address it will have different destination keys. In the case of using Web Service only one destination allowed per instance Transaction List Number Numeric 6 Your transaction list number as you displayed on your official posted statement Statement Line Number Numeric 2 Each transaction list can have a maximum of 20 transactions. This indicates this was transaction 2 in statement list 1. Helps client match transaction to posted statement Account Alpha 30 The transaction was affected on this account Transaction Code Numeric 4 Nedbank transaction codes identifying the type of transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Sub Transaction Code Numeric 4 Reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Amount Decimal 16,2 The actual transaction amount Debit Credit Alpha Numeric 2 Is transaction a debit (Money out) or credit (Money in) to the account being reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit Date Numeric 8 The date on which the transaction was performed. Format 'CCYYMMDD' Account Available Balance Decimal 16,2 This is the available balance after this transaction has taken place. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits) User Ref Alpha 30 Statement description / narrative will always be displayed in quotation
Numeric marks
File trailer Field Name Data type Expected Maximum size Description Transaction Count Numeric 18 Total number of transactions reported in this file
7.1.4 FTI CSV Template 2
Below is the layout for the CSV transaction feeds for near real time: This template includes Record Key and headings
Account Opening Balance Field Name Data type Expected Maximum size Description Record key Numeric 1 Uniquely identifies the beginning of new account. This value will always be one i.e. 1. Account No Numeric 23 This is the bank account number. The transactions that follow are for this account Account Name String 40 This is the full legal name of the account e.g. ABC Investments Pty Ltd Statement Number Number 6 Provides a single statement number per message Date Numeric 8 The date for which this opening balance is applicable. Format shall follow CCYYMMDD User ref String Statement description for the account transaction. This value must be "Opening Balance". Amount Numeric 1 This field is not applicable. Value shall be zero i.e. 0. Account Balance Decimal 16,2 Actual opening balance of this account Statement line number Numeric 4 This field is not applicable. Value shall be blank. Transaction No Numeric 6 This field is not applicable. Value shall be blank. Transaction Code Numeric 4 This field is not applicable. Value shall be blank. Transaction Key Numeric 16 This field is not applicable. Value shall be blank.
Table C: Format specification for account opening balance. 1Max Length: If the field does not reach its maximum length then the field length shall be taken.
Account Transaction Detail Field Name Data type Expected Maximum size Description Record key Numeric 1 Uniquely identifies the beginning of new account. This value will always be two i.e. 2. Account No Numeric 23 This is the bank account number. The transactions that follow are for this account Account Name String 40 This is the full legal name of the account e.g. ABC Investments Pty Ltd Statement Number Number 6 Provides a single statement number per message Date Numeric 8 The date on which the transaction was performed. Format 'CCYYMMDD' User ref String Statement description / narrative will always be displayed in quotation marks Amount Numeric 1 The actual transaction amount. This value shall be zero as this record represents the opening balance of the account. Account Balance Decimal 16,2 This is the available balance after this transaction has taken place. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits) Statement line number Numeric 4 Each transaction list can have a maximum of 20 transactions. This indicates this was transaction 2 in statement list 1. Helps client match transaction to posted statement Transaction No Numeric 6 Your transaction list number as you displayed on your official posted statement Transaction Code Numeric 4 Nedbank transaction codes identifying the type of transaction Transaction Key Numeric 16 Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another message it is for the same transaction
Table D: Format specification for account transaction detail. 1Max Length: If the field does not reach its maximum length then the field length shall be taken.
Account Closing Balance Field Name Data type Expected Maximum size Description Record key Numeric 1 Uniquely identifies the beginning of new account. This value will always be three i.e. 3. Account No Numeric 23 This is the bank account number. The transactions that follow are for this account Account Name String 40 This is the full legal name of the account e.g. ABC Investments Pty Ltd Statement Number Number 6 Provides a single statement number per message Date Numeric 8 The date for which this closing balance is applicable. Format shall follow User ref String Statement description for the account transaction. This value must be "Closing Balance". Amount Numeric 1 This field is not applicable. Value shall be zero i.e. 0. Account Balance Decimal 16,2 Actual closing balance of this account Statement line number Numeric 4 This field is not applicable. Value shall be blank. Transaction No Numeric 6 This field is not applicable. Value shall be blank. Transaction Code Numeric 4 This field is not applicable. Value shall be blank. Transaction Key Numeric 16 This field is not applicable. Value shall be blank.
7.1.5 FTI CSV Template 3 Herewith the layout for the standard CSV transaction feeds for near real time, this template has record identifiers: File Header Field Name Data type Expected Maximum size Description Record Identifier Numeric 2 Record will start with "01" to indicate File header record CIS Number Numeric 12 This field will display the client's CIS number Profile Number Numeric 10 This field will display the client's profile number Product Alpha 10 Will contain the F for the FTI product Instance number Numeric 4 You can load up to 9999 different instances per profile. An instance is a group of accounts, settings and destination Instance Name Alpha Numeric 30 Instance name as specified by the client will always be displayed with quotation marks Date Numeric 8 Displays the date on which the file is being sent. CCYYMMDD
Account Header Field Name Data type Expected Maximum size Description Record Identifier Numeric 2 Record will start with "02" to indicate Account header record Account
Numeric 23 The transactions that follow are for this account Statement Number Number 6 Provides a single statement number per message Statement Sequence Number Alpha 6 If your statement is broken up into multiple messages it will have different sequence numbers. Opening Available Balance Decimal 16,2 This is the opening available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits) Opening Book Balance Decimal 16,2 Actual opening balance Total Debits Decimal 16,2 Sum of the debit transactions on this statement for this account Total Credits Decimal 16,2 Sum of the credit transactions on this statement for this account Total Debit Count Numeric 10 Number of debit transactions on this statement for this account Total Credit Count Numeric 10 Number of credit transactions on this statement for this account Closing Available Balance Decimal 16,2 This is the closing available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits) Closing Book Balance Decimal 16,2 Actual closing balance
Transaction Detail Field Name Data type Expected Maximum size Description Record Identifier Numeric 2 Record will start with "03" to indicate Transaction detail record Transaction Key Numeric 16 Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another message it is for the same transaction Process Key Numeric 9 Uniquely identifies the client preferences effective for this transaction Resend Key Numeric 9 Any value greater zero means the transaction was resent on customer request Destination Key Numeric 9 If a single instance has more than one destination address it will have different destination keys. In the case of using Web Service only one destination allowed per instance Transaction List Number Numeric 6 Your transaction list number as you displayed on your official posted statement Statement Line Number Numeric 2 Each transaction list can have a maximum of 20 transactions. This indicates this was transaction 2 in statement list 1. Helps client match transaction to posted statement Account Alpha 30 The transaction was affected on this account Transaction Code Numeric 4 Nedbank transaction codes identifying the type of transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Sub Transaction Code Numeric 4 Reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Amount Decimal 16,2 The actual transaction amount Debit Credit Alpha Numeric 2 Is transaction a debit (Money out) or credit (Money in) to the account being reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit Date Numeric 8 The date on which the transaction was performed. Format 'CCYYMMDD' Account Available Balance Decimal 16,2 This is the available balance after this transaction has taken place. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits)
User Ref Alpha Numeric 30 Statement description / narrative will always be displayed in quotation marks
ACCOUNT FOOTER CSV Field name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "04" to indicate account footer record
Account
Numeric 23 The transaction reported are for this account Transaction Record Count Numeric 18 Number of transaction records reported for the account above
File trailer Field Name Data type Expected Maximum size Description Record Identifier Numeric 2 Record will start with "04" to indicate File trailer record Transaction Count Numeric 18 Total number of transactions reported in this file
7.1.6 FTI TXT Template 1
Fixed width length file: Record length = 1000 All Value fields with be preceded by the sign = + (Credit balance) and - (Debit balance)
File Header Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "01" to indicate file header CIS Number Numeric 12 This field will display the client's CIS number Profile Number Numeric 10 This field will display the client's profile number Product Alpha 10 Will contain the FTI for the Final Transaction Information product Instance number Numeric 4 You can load up to 9999 different instances per profile for the FTI product. An instance is a group of accounts, settings and destination Instance name Alpha Numeric 30 Instance name as specified by the client Date Numeric 8 Displays the date on which the file is being sent. CCYYMMDD Filler Alpha 924 Spaces
Account Header Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "02" to indicate Account header
Account
Numeric 23 The transactions that follow are for this account Statement Number Number 6 Provides a single statement number per message. Will reset to 1 for the first file sent in the new calendar year Statement Sequence Number Alpha 6 If your statement is broken up into multiple messages it will have different sequence numbers. Opening Available Balance Decimal 16,2 (20 characters long including sign) This is the opening available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits). All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance) Opening Book Balance Decimal 16,2 (20 characters long including sign) Actual opening balance including uncleared funds but excluding overdraft. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Total Debits Decimal 16,2 (20 characters long including sign) The value of the debit transactions on this statement for this account. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance).
Total Credits Decimal 16,2 (20 characters long including sign) The Value of all the credit transactions on this statement for this account. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Total Debit Count Numeric 10 Number of debit transactions reported for this account Total Credit Count Numeric 10 Number of credit transactions reported for this account Closing Available Balance Decimal 16,2 (20 characters long including sign) This is the closing available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits). All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Closing Book Balance Decimal 16,2 (20 characters long including sign) Actual closing balance including uncleared funds but excluding overdraft facilities. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Filler Alpha 823 Spaces
Transaction Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "03" to indicate Transaction Record
Account
Numeric 23 The transaction reported is for this account Transaction Key Numeric 16 Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another message it is for the same transaction Process Key Numeric 9 Uniquely identifies the client preferences effective for this transaction Resend Key Numeric 9 Any value greater zero means the transaction was resent on customer request Destination Key Numeric 9 If a single instance has more than one destination address it will have different destination keys. In the case of using Web Service only one destination allowed per instance Transaction List Number Numeric 6 Your transaction list number as you displayed on your official posted statement Statement Line Number Numeric 2 Each transaction list can have a maximum of 20 transactions. This indicates this was transaction 2 in statement list 1. Helps client match
transaction to posted statement Transaction Code Numeric 4 Nedbank transaction codes identifying the type of transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Sub Transaction Code Numeric 4 Reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Transaction Amount Decimal 16,2 (20 characters long including sign) The actual transaction amount. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Debit Credit AlphaNu meric 2 Is transaction a debit (Money out) or credit (Money in) to the account being reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit Date Numeric 8 The date on which the transaction was performed. Format 'CCYYMMDD' Account Available Balance Decimal 16,2 (20 characters long including sign) This is the available balance after this transaction has taken place. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits). All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). User Ref Alpha 30 Statement description/narrative Filler Alpha 836 Spaces
Account footer Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "04" to indicate account footer record
Account
Numeric 23 The transaction reported are for this account Transaction Record Count Numeric 18 Number of transaction records reported for the account above
Filler Alpha 957 Spaces
File footer Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "05" to indicate file footer record
Account Record Count Numeric 18 Number of accounts reported in this file
Transaction Record Count Numeric 18 Total number of transaction records reported in this file for all accounts Filler Alpha 962 Filler
7.1.7 FTI TXT Template 2
Fixed width length file: Record length = 1000 All Value fields with be preceded by the sign = + (Credit balance) and - (Debit balance)
File Header Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "01" to indicate file header CIS Number Numeric 12 This field will display the client's CIS number Profile Number Numeric 10 This field will display the client's profile number Product Alpha 10 Will contain the FTI for the Final Transaction Information product Instance number Numeric 4 You can load up to 9999 different instances per profile for the FTI product. An instance is a group of accounts, settings and destination Instance name Alpha Numeric 30 Instance name as specified by the client Date Numeric 8 Displays the date on which the file is being sent. CCYYMMDD Filler Alpha 924 Spaces
Account Header Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "02" to indicate Account header
Account
Numeric 23 The transactions that follow are for this account Statement Number Number 6 Provides a single statement number per message. Will reset to 1 for the first file sent in the new calendar year Statement Sequence Number Alpha 6 If your statement is broken up into multiple messages it will have different sequence numbers. Opening Available Balance Decimal 16,2 (20 characters long including sign) This is the opening available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits). All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance) Opening Book Balance Decimal 16,2 (20 characters long including sign) Actual opening balance including uncleared funds but excluding overdraft. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Total Debits Decimal 16,2 (20 characters long The value of the debit transactions on this statement for this account. All Value
including sign) fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Total Credits Decimal 16,2 (20 characters long including sign) The Value of all the credit transactions on this statement for this account. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Total Debit Count Numeric 10 Number of debit transactions reported for this account Total Credit Count Numeric 10 Number of credit transactions reported for this account Closing Available Balance Decimal 16,2 (20 characters long including sign) This is the closing available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits). All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Closing Book Balance Decimal 16,2 (20 characters long including sign) Actual closing balance including uncleared funds but excluding overdraft facilities. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Filler Alpha 823 Spaces
Transaction Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "03" to indicate Transaction Record
Account
Numeric 23 The transaction reported is for this account Transaction Key Numeric 16 Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another message it is for the same transaction Process Key Numeric 9 Uniquely identifies the client preferences effective for this transaction Resend Key Numeric 9 Any value greater zero means the transaction was resent on customer request Destination Key Numeric 9 If a single instance has more than one destination address it will have different destination keys. In the case of using Web Service only one destination allowed per instance Transaction List Number Numeric 6 Your transaction list number as you displayed on your official posted statement Statement Line Number Numeric 2 Each transaction list can have a maximum of 20 transactions. This
indicates this was transaction 2 in statement list 1. Helps client match transaction to posted statement Transaction Code Numeric 4 Nedbank transaction codes identifying the type of transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Sub Transaction Code Numeric 4 Reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Transaction Amount Decimal 16,2 (20 characters long including sign) The actual transaction amount. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Debit Credit AlphaNu meric 2 Is transaction a debit (Money out) or credit (Money in) to the account being reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit Date Numeric 8 The date on which the transaction was performed. Format 'CCYYMMDD' Account Closing Balance Decimal 16,2 (20 characters long including sign) Actual closing balance including uncleared funds but excluding overdraft facilities. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). User Ref Alpha 30 Statement description/narrative Filler Alpha 836 Spaces
Account footer Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "04" to indicate account footer record
Account
Numeric 23 The transaction reported are for this account Transaction Record Count Numeric 18 Number of transaction records reported for the account above
Filler Alpha 957 Spaces
File footer Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "05" to indicate file footer record Account Record Count Numeric 18 Number of accounts reported in this file
Transaction Record Count Numeric 18 Total number of transaction records reported in this file for all accounts Filler Alpha 962 Filler
7.1.8 SWIFT MT940 Template 1
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 correspondents. 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
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 applicable. 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. Line 5 - This will include your full statement narrative (The statement narrative is also reported in Tag 61 Subfield 9). It is repeated here if the narrative is truncated in Tag 61 due to character length being longer than 34 characters (Currently in testing, will be available by end of May 2016)
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 ABSA BANK IN104231 :61:150122C2000,00NMSCNONREF//1324+0 JPJ LE ROUX :86:103746727+3 0+1 Not Applicable 1469+01 JPJ LE ROUX :62F:C150123ZAR4710039,30 :64:C150123ZAR4710039,30 -}
7.1.9 SWIFT MT940 Template 2 This message type is a copy of SWIFT MT940 Template 1, it is compliant with 2016 SWIFT standards.
7.1.10 SWIFT MT940 Template 3
Note: This template is for clients that have been migrated from CASA SWIFT
The SWIFT template is to be read in conjunction with the SWIFT Standards document. Refer to Appendix D to access to the respective document
NED 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
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
NED SWIFT MT940 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number This field specifies the reference assigned by the Sender to clearly identify the message O 21 Related Reference If the MT940 is sent in response to MT920 Request Message, this field must contain the field 20: Transaction Reference Number of the request message. If this is a push to the client, this filed is not used M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number This field contains the sequence number of the message within that statement when more than one message is sent for one statement. 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 eg statement number/1, statement number/2 etc M 60a Opening Balance This field specifies, (for the intermediate) opening balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance O 61 Statement Line * Refer to Field 61 -definition below O 86 Information to Account Owner This field will not be used M 62a Closing Balance (Booked Funds) This filed specifies, for the (intermediate) closing balance, whether it is a debit or credit balance, the date the currency and the amount of the balance O 64 Closing Available Balance (Available Balance) This field is not being used O 65 Forward Available Balance . This field will not be used O 86 Information to Account Owner This field will not be 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 be populated with NMSC 7 16x Reference for the Account Owner The first 16 characters of the statement narrative is inserted 8 [//16x] Account Servicing Institution's Reference Additional characters of statement narrative longer than 16 characters 9 [34x] Supplementary Details 4 digit Nedbank transaction code, Trancode helps identify the type of transaction ie Cash deposit or EFT or Cash withdrawal, etc 7.1.11 SWIFT MT940 Template 4 This message type is a copy of SWIFT MT940 Template 3, it is compliant with 2016 SWIFT standards.
7.1.12 TI 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 SWIFT Standards document. Refer to Appendix D to access 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
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 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)
7.1.13 NED SWIFT MT940
Note: This template is for clients that have been migrated from CASA SWIFT and is no longer available for selection.
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
NED 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
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
NED SWIFT MT940 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number This field specifies the reference assigned by the Sender to clearly identify the message O 21 Related Reference If the MT940 is sent in response to MT920 Request Message, this field must contain the field 20: Transaction Reference Number of the request message. If this is a push to the client, this filed is not used M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number This field contains the sequence number of the message within that statement when more than one message is sent for one statement. 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 eg statement number/1, statement number/2 etc M 60a Opening Balance This field specifies, (for the intermediate) opening balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance O 61 Statement Line * Refer to Field 61 -definition below O 86 Information to Account Owner This field will not be used M 62a Closing Balance (Booked Funds) This filed specifies, for the (intermediate) closing balance, whether it is a debit or credit balance, the date the currency and the amount of the balance O 64 Closing Available Balance (Available Balance) This field is not being used O 65 Forward Available Balance . This field will not be used O 86 Information to Account Owner This field will not be 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 be populated with NMSC 7 16x Reference for the Account Owner The first 16 characters of the statement narrative is inserted 8 [//16x] Account Servicing Institution's Reference Additional characters of statement narrative longer than 16 characters
9 [34x] Supplementary Details 4 digit Nedbank transaction code, Trancode helps identify the type of transaction ie Cash deposit or EFT or Cash withdrawal, etc
7.1.14 NED SWIFT MT950
Note: This template is for clients that have been migrated from CASA SWIFT and is no longer available for selection.
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
NED 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
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
NED SWIFT MT950 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number This field specifies the reference assigned by the Sender to clearly identify the message M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number This field contains the sequence number of the message within that statement when more than one message is sent for one statement. 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 eg statement number/1, statement number/2 etc M 60a Opening Balance This field specifies, (for the intermediate) opening balance, whether it is a debit or credit balance, the date, the currency and the amount of the balance O 61 Statement Line * Refer to Field 61 -definition below M 62a Closing Balance (Booked Funds) This filed specifies, for the (intermediate) closing balance, whether it is a debit or credit balance, the date the currency and the amount of the balance O 64 Closing Available Balance (Available Balance) This field is not being 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 Insert the NedAcad transaction codes preceded by an N Refer to Appendix C - NedAcad Transaction Codes 7 16x Reference for the Account Owner Insert 4 digit CASA transaction codes plus the 3 digit subtransaction code 8 [//16x] Account Servicing Institution's Reference Is not used 9 [34x] Supplementary Details Insert full narrative
7.1.15 TI SWIFT MX940
7.1.16 TI SWIFT MX950
7.1.17 Multicash AUSZUG (Header) Template 1
- All Numeric fields should be right aligned and Zero filled.
- All amount / value fields have decimal points followed by 2 digits
- All Amount value fields have the sign on the right hand side
- The files have to be ASCII coded
- The header record can include one or more accounts based on client preference.
- The delimiter between the fields is a semicolon (;)
- Type description: A (Alphanumeric) N (Numeric) X (Date in format DD.MM.YY)
Field Type Minimum Maximu m Description 1 A 0 12 It will include the Nedbank universal branch code ie, 198765. 2 A 0 24 Bank account number 3 N 1 4 It will include a single statement number generated by FTI 4 X 8 8 Date the Statement is generated 5 A 3 3 Currency key (ZAR) 6 N 1 18.2 This field will be populated with the opening current / book balance: If it ends with a negative it will be a debit balance. If it ends with a positive sign it will be a credit balance 7 N 1 18.2 This field will be populated with the sum of total value of all debits in the statement for this account. It will usually have a negative sign unless Reversals of debits are greater than actual debits. In this case it will have positive sign 8 N 1 18.2 This field will be populated with the sum of total value of all credits in the statement for this account. It will usually have a positive sign unless Reversals of credits are greater than actual credits. In this case it will have negative sign 9 N 1 18.2 This field will be populated by your closing current / book balance: If it ends with a negative it will be a debit balance. If it ends with a positive sign it will be a credit balance 10 A 0 35 Customer Name 11 A 0 35 Account Name 12 0 0 Not used 13 0 0 Not used 14 0 0 Not used 15 0 0 Not used 16 0 0 Not used 17 0 0 Not used 18 N 1 5 Number of transactions for the reported account
7.1.18 Multicash UMSATZ (Line Items) Template 1
- All Numeric fields should be right aligned and Zero filled.
- All amount / value fields have decimal points followed by 2 digits
- All Amount value fields have the sign on the right hand side.
- The files have to be ASCII coded
- The line item file will include one or more accounts based on client preference. It will only report transactions on accounts that are present on the header file. However if no transaction have occurred on the account during the period of the statement t hat account will not report any transactions in the line item file even though reported on the header file.
- The delimiter between the fields is a semicolon (;)
- Type description: A (Alphanumeric) N (Numeric) X (Date in format DD.MM.YY)
Field Type Minimum Maximum Optional Description 1 A 0 12 It will include the Nedbank universal branch code ie, 198765 2 A 0 24 Bank account number 3 N 1 4 It will include a single statement number generated by FTI 4 X 8 8 Value date - transaction date 5 N 1 10 X Not populated 6 A 0 27 X First 27 characters of the Statement Narrative. If there is a semi colon within the text it will be replaced with a coma to ensure it is not interpreted as the end of this field. 7 A 0 27 Last 3 character of the Statement Narrative if applicable. If there is a semi colon within the text it will be replaced with a coma to ensure it is not interpreted as the end of this field. 8 0 0 Not populated 9 0 0 Not populated 10 A 0 16 Populated with zero 11 N 1 18.2 Transaction Amount. If debit or reversal of credit it will have a "-" sign at the end. If credit or reversal of debit it will have a "+" sign at the end. If field 23 is populated with the word "DEBIT" and the sign of the
amount is "+" in field 11 then the transaction is a debit reversal. If field 23 is populated with the word "CREDIT" and the sign of the amount is "-" in field 11 then the transaction is a credit reversal 12 0 0 Not populated 13 0 0 Not populated 14 X 8 8 Transaction Date 15 0 0 Not populated 16 0 0 Not populated 17 A 0 27 X Statement Number as displayed on you official bank statement 18 A 0 27 X Statement Line item as displayed on your official bank statement 19 A 0 27 X Transaction Key 20 A 0 27 X Process Key 21 A 0 27 X Resend Key 22 A 0 27 X Destination Key 23 A 0 27 X Will be populated with "DEBIT" or "CREDIT" 24 A 0 27 X Not populated 25 A 0 27 X Not populated 26 A 0 27 X Not populated 27 A 0 27 X Not populated 28 A 0 27 X Not populated 29 A 0 27 X Not populated 30 A 0 27 X Not populated 31 A 0 27 X Not populated 32 A 0 12 X Not populated 33 A 0 24 X Not populated 34 A 0 3 X NedAcad transaction Code 35 0 0 Not used
IMPORTANT:
- Field 34
- Please use Field 7 if Field 34 is too short. In this case, Field 34 has to have the V alue Space
7.1.19 Multicash UMSATZ (Line Items)- Template 2
- All Numeric fields should be right aligned and Zero filled.
- All amount / value fields have decimal points followed by 2 digits
- All Amount value fields have the sign on the right hand side.
- The files have to be ASCII coded
- The line item file will include one or more accounts based on client preference. It will only report transactions on accounts that are present on the header file. However if no transaction have occurred on the account during the period of the statement that account will not report any transactions in the line item file even though reported on the header file.
- The delimiter between the fields is a semicolon (;)
- Type description: A (Alphanumeric) N (Numeric) X (Date in format DD.MM.YY)
Field Type Minimum Maximum Optional Description 1 A 0 12 It will include the Nedbank universal branch code ie,
- 2 A 0 24 Bank account number 3 N 1 4 It will include a single statement number generated by FTI 4 X 8 8 Value date - transaction date 5 N 1 10 X Not populated 6 A 0 27 X Nedbank NedAcad Transaction Code 7 A 0 27 Not populated 8 0 0 Not populated 9 0 0 Populate CASA statement number 10 A 0 16 Populated with zero 11 N 1 18.2 Transaction Amount. If debit it will have a "-" sign at the end. If credit it will have a "+" sign at the end. 12 0 0 Not populated 13 0 0 Not populated 14 X 8 8 Transaction Date always same as value date 15 0 0 Not populated 16 0 0 Not populated 17 A 0 27 X First 27 characters of the Statement Narrative. If there is a semi colon within the text it will be replaced with a hypen "-"
to ensure it is not interpreted as the end of this field. 18 A 0 27 X Last 3 character of the Statement Narrative if applicable. If there is a semi colon within the text it will be replaced with a hypen "-" to ensure it is not interpreted as the end of this field. 19 A 0 27 X Transaction Key 20 A 0 27 X Process Key 21 A 0 27 X Resend Key 22 A 0 27 X Destination Key 23 A 0 27 X Will be populated with "DEBIT" or "CREDIT", 24 A 0 27 X Not populated 25 A 0 27 X Not populated 26 A 0 27 X Not populated 27 A 0 27 X Not populated 28 A 0 27 X Not populated 29 A 0 27 X Not populated 30 A 0 27 X Not populated 31 A 0 27 X Not populated 32 A 0 12 X Not populated 33 A 0 24 X Not populated 34 A 0 3 X NedAcad transaction Code 35 0 0 Not used
7.1.20 NedInform Fixed Width Layout Template 1
File layout Field Name Data type Length Description Account number 10 Numeric The account number for this transaction. Statement number 6 Numeric Zero-padded. The statement number of the statement on which this transaction appears. Date 8 Numeric In the form yyyymmdd. The date on which the transaction was processed in the format Description 30 Alphanumeri c The description of the transaction. Transaction amount 14 Numeric Zero-padded. The amount of this transaction in cents. Amount sign 1 Alphanumeri c Value '-' if the amount is a debit Value '+' if the amount is a credit. Balance 14 Numeric Zero padded. The account balance after the transaction was passed, in cents Balance sign 1 Alphanumeri c Value '-' if the amount is a debit. Value '+' if the amount is a credit. Charge 8 Numeric Zero-padded. The amount of the service fee, if any, levied on this transaction, in cents. Transaction code 8 Numeric Zero-padded. From 1 to 99: A debit transaction (see appendix for description). From 101 to 199: A credit transaction (see appendix for description). Other numbers: Cheque or deposit numbers. Sequence number 1 Alphanumeri c This field indicates whether the sequence number is a: T = transaction code C = cheque number D = deposit number NedInform Fixed width Sample.prd
Sample file
14541177370007182016012980000300 00000000011356+00000001401889+0000013500000151T 145411773700071820160129IP205313ESKOM HOLDINGS SOC L 00080000000000+00080001401889+0000000000000152T 145411773700071820160129TRANSFER FROM 1454117788 00000000100000+00080000501889+0000000000000142T 145411773700071920160129TRANSFER FROM 1454117842 00000000250000+00080000751889+0000000000000142T 145411773700071920160129TRANSFER FROM 1454117818 00000000400000+00080001151889+0000000000000142T 145411773700071920160129TRANSFER FROM 1454117761 00000000600000+00080001751889+0000000000000142T 145411773700071920160130TRANSFER FROM 1454117818 00000000050000+00080001801889+0000000000000142T