6.1.5 PTI CSV (NRT) Template 4¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 96-98 PDF pages: 96-98
Herewith the layout for the standard Nedbank format for CSV and Excel transaction feeds for PTI, with record identifiers, without balances, and credit transactions only:
PTI CSV (NRT) Template 3 field lengths are variable and indicated below are maximum lengths
FILE HEADER RECORD CSV 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 Unique client number issued by Nedbank Profile Number Numeric 10 Profile number on which the PTI product is setup Product Alpha Numeric 10 Will contain the value PTI to indicate it is a provisional transaction file 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 RECORD CSV Field name Data type Actual field length 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
TRANSACTION DETAIL RECORD CSV 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 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 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. 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. 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 Account Numeric 23 The account number on which the transaction was processed. Tran Type Alpha Numeric 30 This field indicates the type of transaction eg Cash or Cheque. Refer to no 3.8 for a list of Ch annel and Transaction type combinations Channel Alpha Numeric 30 Indicates the channel through which the transaction was processed eg Teller. Refer to no 3.8 for a list of Channel and Transaction type combinations Amount Numeric 16.2 The amount of the transaction 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 Date Numeric 8 The date on which the transaction was processed to the account. Format - Time Alpha Numeric 11 Time at which the provisional transaction was processed to the account. Format - User Ref Alpha Numeric 30 Statement description / narrative will always be displayed in quotation marks
ACCOUNT FOOTER RECORD 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 FOOTER RECORD CSV Field name Data type Expected Maximum size Description Record Identifier Numeric 2 Record will start with "04" 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 PTI CSV (NRT) Template 3.txt
Sample file layout
01,100200001234,3000000014,"Product",1234,"ADMIN",20130130 02,1009000951 03,1,0001,1200,0012,1009000951,"Cash Deposit","INTERNET BANKING",-
141.11,"RD",20130916,12:34:28:33,"NarrText 0899" 03,2,0001,1200,0012,1009000951,"C Deposit","INTERNET BANKING",141.11,"D",20130916,12:37:28:33,"NarrText 0899" 04,1009000951,2 05,1,2