6.1.7 PTI TXT Balance Only (NRT) Template 1

Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 102-103 PDF pages: 102-103

Sample file layout

00000000123430000000014Product 0000001234ADMIN 00000000123430000000014Product 0000001234ADMIN20130130 000000000000000100000000100000120000000001200000000000001009000951C Deposit INTERNET BANKING -

00000000000000141.11RD2013091612:34:28:33+0000000000622000.54+0000000000635406.46NarrText 0899 000000000000000200000000100000120000000001200000000000001009000951C Deposit INTERNET BANKING +00000000000000141.11D 2013091612:37:28:33+0000000000622000.54+0000000000635406.46NarrText 0899 000000123456578100000000100000120000000001200000000000001234567890CashN/A +0000000000001000.00D 2013013000:00:00:00+0000000000001002.00+0000000000001001.00Deposit/EFT narrative +000000003

Herewith the layout for the standard Nedbank format for TXT transaction feeds:

PTI TXT Balance on ly (NRT) field lengths are variable and ind icated below are maximum lengths 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 PTI for the Final Transaction Information product Instance number Numeric 4 You can load up to 9999 different instances per profile for the PTI 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

HEADER (Example) 010000000012343000000014Product 1234ADMIN 20130130

PTI TXT Balance only (NRT) field lengths are variable and ind icated below are maximum lengths Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "02" to indicate Account Balance Record

Account

Numeric 23 The transactions that follow are for this account Date Numeric 8 Displays the date the balance was checked. CCYYMMDD Time Numeric 6 Displays the time the balance was checked. HH:MM:SS Opening Available Balance Decimal 16,2 (20 characters long This is the opening available balance for this statement. Available balance=

including sign) (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

BODY (Example) 020000000000000123456789020130130000000+0000000000001000.00+0000000000001003.00+00000000000010

05.00+0000000000001006.0000000000250000000023+0000000000001001.00+0000000000001002.00 020000000000000123456789120130130000000+0000000000001003.00+0000000000001007.23+00000000000010 09.00+0000000000001010.0000000000150000000013+0000000000001005.00+0000000000001006.00

PTI TXT Balance only (NRT) field lengths are variable and ind icated below are maximum lengths Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "03" to indicate file footer record Account Record Count Numeric 18 Number of accounts reported in this file

Filler Alpha 962 980 Filler

FOOTER (Example) 03000000000000000002