7.1.4 FTI CSV Template 2

Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 137-139 PDF pages: 137-139

Numeric marks

File trailer Field Name Data type Expected Maximum size Description Transaction Count Numeric 18 Total number of transactions reported in this file

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.