6.1.2 PTI CSV (NRT) Template 1¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 87-89 PDF pages: 87-89
Herewith the layout for the standard Nedbank format for CSV and Excel transaction feeds for PTI and FTI:
TI PTI CSV (NRT) field lengths are variable and indicated below are maximum lengths CSV Field name Data type Expected maximum size Description Sample value CIS Number Numeric 12 Unique client number issued by Nedbank 1234 Profile Number Numeric 10 Profile number on which the PTI product is setup 30000000014 Product Alpha Numeric 10 Will contain the value PTI to indicate it is a provisional transaction file
PTI
Instance Number Numeric 4 You can load up to 9999 different instances per profile. An instance is a group of accounts, settings and destination
1234
Instance Name Alpha Numeric 30 Instance name as specified by the client will always be displayed with quotation marks "ADMIN" Date Numeric 8 Displays the date on which the file is being sent. CCYYMMDD 20140916
HEADER (Example) 1234,30000000014,"Product",1234,"ADMIN",20130130
TI PTI CSV (NRT) field lengths are variable and indicated below are maximum lengths CSV Field name Data Type Expected Maximum size Description Sample value Transaction Key Numeric 16 Each PTI transaction is allocated a unique key. If you receive the same transaction key on another PTI message then it will be for the same transaction ie the key is not unique across TI products 1 Process Key Alpha Numeric 9 Uniquely identifies the current client preferences for this transaction. This value is for internal purposes and does not have to be interpreted by you in processing this transaction. 0001 Resend Key Numeric 9 Any value greater than zero means that the transaction was resent. It will have the same transaction key as the initial transaction. 1 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 address is allowed per instance 0012
Account Numeric 23 The account number on which the transaction was processed. 1009000951 Tran Type Alpha Numeric 30 This field indicates the type of transaction e.g. Cash or Cheque. Refer to no 3.8 for a list of Channel and Transaction type combinations C Deposit Channel Alpha Numeric 30 Indicates the channel through which the transaction was processed e.g. Teller. Refer to no 3.8 for a list of Channel and Transaction type combinations INTERNET BANKING Amount Numeric 16.2 The amount of the transaction -141.11 Debit / Credit Alpha 2 Is the transaction a debit (Money out) or credit (Money in) to the account which is being reported on? Values are indicated by; D=Debit, C=Credit, RD=Reversal of Debit, RC=Reversal of Credit RD Date Numeric 8 The date on which the transaction was processed to the account. Format - 20140916 Time Alpha Numeric 11 Time at which the provisional transaction was processed to the account. Format - 12:34:28:33 Account Book Balance Numeric 16.2 Actual account balance including any uncleared funds (eg cheque deposits -7 days clearance).
622000.54 Account Available Balance Numeric 16.2 Actual account balance plus account overdraft limit, less any uncleared funds 635406.46 User Ref Alpha Numeric 30 Statement description / narrative will always be displayed in quotation marks "NarrText 0899" BODY (Example) 1,0001,1200,0012,1009000951,"C Deposit","INTERNET BANKING",- 141.11,"RD",20130916,12:34:28:33,622000.54,635406.46,"NarrText 0899" 2,0001,1200,0012,1009000951,"C Deposit","INTERNET BANKING",141.11,"D",20130916,12:37:28:33,622000.54,635406.46,"NarrText 0899" 1234565781,0001,1200,0012,1234567890,"Cash
TI PTI CSV (NRT) field lengths are variable and indicated below are maximum lengths CSV Field name Data type Expected Maximum size Description Sample value Record Count Numeric 18 Number of TI records in the file i.e. excluding header and footer
FOOTER (Example) 3
PTI CSV (NRT) Template 1.txt
Sample file layout
1234,30000000014,"Product",1234,"ADMIN",20130130 1,0001,1200,0012,1009000951,"C Deposit","INTERNET BANKING",-
141.11,"RD",20130916,12:34:28:33,622000.54,635406.46,"NarrText 0899" 2,0001,1200,0012,1009000951,"C Deposit","INTERNET BANKING",141.11,"D",20130916,12:37:28:33,622000.54,635406.46,"NarrText 0899" 1234565781,0001,1200,0012,1234567890,"Cash