6.1.6 PTI TXT (NRT) Template 1¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 99-101 PDF pages: 99-101
Herewith the layout for the standard Nedbank format for TXT transaction feeds:
TI PTI TXT (NRT) field lengths are variable and indicated below are maximum lengths TXT Field name Data type Actual Field Length 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 ADMIN Date Numeric 8 Displays the date on which the file is being sent. CCYYMMDD 20140916
HEADER (Example) 00000000123430000000014Product 0000001234ADMIN 00000000123430000000014Product 0000001234ADMIN20130130
TI PTI TXT (NRT) field lengths are variable and indicated below are maximum lengths TXT Field name Data Type Actual Field Length Description Sample value
TI Request
Alpha N/A Start of TXT body N/A 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 eg 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 eg 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 NarrText 0899
TI Request
Alpha End of TXT body
BODY (Example) 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
TI PTI TXT (NRT) field lengths are variable and indicated below are maximum lengths TXT Field name Data type Actual Field Length Description Sample value Record Count Numeric 18 Number of TI records in the file ie excluding header and footer
+000000003
FOOTER (Example) +000000003
PTI TXT layout - near real time.txt
Fixed width length file: Record length = 1000