7.1.3 FTI CSV Template 1

Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 135-136 PDF pages: 135-136

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