6.1 Near real time templates¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 84-114 PDF pages: 84-114
Appendix A
6.1.1 PTI XML (NRT) Template 1 Herewith the layout for the standard XML transaction feeds for near real time:
TI PTI XML (NRT) field lengths are variable and indicated below are maximum lengths XML Tag name Data type Expected Maximum size Description Sample value
PTI
1234
HEADER (Example)
TI PTI XML (NRT) field lengths are variable and indicated below are maximum lengths XML Tag name Data Type Expected Maximum size Description Sample value
Alpha N/A Start of XML body N/A
transaction.
622000.54
Alpha End of XML body
BODY (Example)
TI PTI XML (NRT) field lengths are variable and indicated below are maximum lengths XML Tag name Data type Expected Maximum size Description Sample value
in the file ie excluding header and footer 3FOOTER (Example)
PTI XML layout - near real time.txt
Sample file layout
6.1.2 PTI CSV (NRT) Template 1 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
6.1.3 PTI CSV (NRT) Template 2 Herewith the layout for the standard Nedbank format for CSV and Excel transaction feeds for PTI, with record identifiers and with balance information:
PTI CSV (NRT) Template 2 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 Channel 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 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 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 - Account Book Balance Numeric 16.2 Actual account balance including any uncleared funds (eg cheque deposits -7 days clearance). Account Available Balance Numeric 16.2 Actual account balance plus account overdraft limit, less any uncleared funds 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 2.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,622000.54,635406.46,"NarrText 0899" 03,2,0001,1200,0012,1009000951,"C Deposit","INTERNET BANKING",141.11,"D",20130916,12:37:28:33,622000.54,635406.46,"NarrText 0899" 04,1009000951,2 05,1,2
6.1.4 PTI CSV (NRT) Template 3 Herewith the layout for the standard Nedbank format for CSV and Excel transaction feeds for PTI, with record identifiers and without balances:
PTI CSV (NRT) Template 2 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 Channel an d 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 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 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
6.1.5 PTI CSV (NRT) Template 4 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
6.1.6 PTI TXT (NRT) Template 1 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
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
6.1.7 PTI TXT Balance Only (NRT) Template 1
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
TI_PTI_TXT_Balance_Only.txt
Fixed width length file: Record length = 1000 All Value fields with be preceded by the sign = + (Credit balance) and - (Debit balance)
Sample file layout
010000000012343000000014Product 1234ADMIN 20130130 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 03000000000000000002
6.1.8 PTI CSV Balance Only (NRT) Template 1
Herewith the layout for the standard Nedbank format for CSV transaction feeds:
PTI CSV Balance only (NRT) field lengths are variable and ind icated below are expected maximum lengths Field Name Data type Expected maximum 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
HEADER (Example) 01,1234,3000000014,Product,1234,ADMIN,20130130
PTI CSV Balance only (NRT) field lengths are variable and ind icated below are expected maximum lengths Field Name Data type Expected maximum 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 This is the opening available balance for this statement. Available balance= (Actual balance + Account Overdraft facility) less uncleared funds (Cheque deposits). All Negative Value fields will be preceded by the sign "-" (Debit balance). All Positive Value fields will NOT be preceded by a sign. Opening Book Balance Decimal 16,2 Actual opening balance including uncleared funds but excluding overdraft. All Negative Value fields will be preceded by the sign "-" (Debit balance). All Positive Value fields will NOT be preceded by a sign. Total Debits Decimal 16,2 (20 characters long including sign) The value of the debit transactions on this statement for this account. All Negative Value fields will be preceded by the sign "-" (Debit balance). All Positive Value fields will NOT be preceded by a sign. Total Credits Decimal 16,2 (20 characters long including sign) The Value of all the credit transactions on this statement for this account. All Negative Value fields will be preceded by the sign "-" (Debit balance). All Positive Value fields will NOT be preceded by a sign. 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 Negative Value fields will be preceded by the sign "-" (Debit balance). All Positive Value fields will NOT be preceded by a sign. Closing Book Balance Decimal 16,2 (20 characters long including sign) Actual closing balance including uncleared funds but excluding overdraft facilities. All Negative Value fields will be preceded by the sign "-" (Debit balance). All Positive Value fields will NOT be preceded by a sign.
BODY (Example) 02,1234567890,20130130,000000,1000.00,1003.00,1005.00,1006.00,25,23,1001.00,1002.00 02,1234567891,20130130,000000,1003.00,1007.23,1009.00,1010.00,15,13,1005.00,1006.00
Field Name Data type Expected maximum 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
FOOTER (Example) 03,2 TI_PTI_CSV_Balance _Only.txt
All Negative Value fields will be preceded by the sig n "-"(Debit balance) All Positive Value fields will NOT be preceded by a sign. Fixed width files length of 1000 characters.
Sample file layout
01,1234,3000000014,Product,1234, ADMIN,20130130 02,1234567890,20130130,000000,1000.00,1003.00,1005.00,1006.00,25,23,1001.00,1002.00 02,1234567891,20130130,000000,1003.00,1007.23,1009.00,1010.00,15,13,1005.00,1006.00 03,2
6.1.9 SWIFT MT942 (NRT) Template 1 It is used to transmit information about provisional entries debited or credited to the account for a specified interval. The SWIFT template is to be read in conjunction with the SWIFT Standards Document 2011. Refer to Appendix D to access to the respective document SWIFT MT942 Standard Statement Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1 O 21 Related Reference 16x 2 M 25 Account Identification 35x 3 M 28C Statement Number / Sequence Number 5n[/5n] 4 M 34F Floor Limit Indicator 3!a[1!a]15d 5 M 13D Date / Time Indication 6!n4!n1!nx4!n 6
O 61 Statement Line
M 90D Number and Sum of Entries 5n3!a15d 9 O 90C Number and Sum of Entries 5n3!a15d 10 O 86 Information to Account Owner 6*65x 11 M = Mandatory O = Optional
SWIFT MT942 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number A unique reference number will be created by Nedbank for each message O 21 Related Reference This will be populated with your Nedbank profile number and instance number. The profile number and
instance number will be separated by a "+" sign. Your profile number is always 10 numeric and instance number can be from 1 to 9999. Each PTI instance is a group of accounts, settings and destination. Client can load up to 9999 different PTI instances per profile. M 25 Account Identification This will be the Nedbank account number for which the statement is sent M 28C Statement Number / Sequence Number One statement number per statement sent. Will reset to zero on the 1st of January every year If only one message is sent for the same statement then this will be the statement number/1 If more than one message is sent for the same statement then this will be the statement number followed by the sequence number of the statement E.g. statement number/1, statement number/2 and so on M 34F Floor Limit Indicator If you have specified to only be notified for transactions above a certain value this amount is indicated in this field. If you have chosen to receive all transactions amounts then this field will contain the value zero. Applicable to both debit and credit amounts. M 13D Date / Time Indication Date is expressed as YYMMDD. Time is expressed as HHMM Sign is either "+" or "-". Refer to SWIFT Standards document O 61 Statement Line * Refer to Field 61 -definition below O 86 Information to Account Owner Line 1 - Will include Transaction Key, Separator ("+") and Process Key Line 2 - Will include the Resend Key, Separator ("+") and Destination Key Line 3 - Will include the channel through which this transaction was processed (List of valid channels to be provided by Nedbank) Line 4 - Will include the transaction type (A valid list of transaction types to be provided by Nedbank)
Transaction Key: Each transaction in Nedbank is allocated a unique key for PTI. IF you receive the same transaction key on another PTI message it is for the same transaction ie a duplicate. Transaction Keys are not unique across FTI and PTI
Process Key: Uniquely identifies the client preferences effective for this statement ie format, accounts, destination addresses, etc
Resend Key: Any value greater than zero means this statement was resent on customer request
Destination Key: If your PTI instance has more than one destination address it will have different destination keys ie you request to send the same statement to multiple swift addresses, the first one will have a destination key "1", the second swift address will have a destination key "2", etc M 90D Closing Balance (Booked Funds) This field indicates the total number and total amount of debit entries in this report O 90C Closing Available Balance (Available Balance) This field indicates the total number and total amount of credit entries in this report O 86 Information to Account Owner Is not used
- Field 61: Statement Line This field contains the details of each transaction as listed below: Subfield Format Name Description 1 6!n Value Date Date the financial is posted to the account for the transaction 2 [4!n] Entry Date Is not used 3 2a Debit / Credit Mark C = Credit D = Debit RC = Reversal of credit RD = Reversal of debit 4 [1!a] Funds Code Is not used 5 15d Amount Transaction amount 6 1!a3!c Transaction Type Identification Code Will always be populated with NMSC 7 16x Reference for the Account Owner Will always insert 'NONREF' 8 [//16x] Account Servicing Institution's Reference Will Insert the transaction type (A list of transaction types will be provided by Nedbank) 9 [34x] Supplementary Details Your statement narrative will be populated in this field (Maximum 34 characters)
MT942 Sample Message:
:20:PNS0000003847690 :21:4000402493+27 :25:1454023619 :28C:23/1 :34F:ZAR0,00 :13D:1501231115+0200 :61:150123C89,89NMSCNONREF//EFT PAYMENT MIB GROUP PTY LTD 05/13081/07 :86:104091806+81 0+1 Electronic Banking EFT PAYMENT :90D:0ZAR0,00 :90C:1ZAR89,89 -}
6.1.10 SWIFT MT942 (NRT) Template 2 It is used to transmit information about provisional entries debited or credited to the account for a specified interval. The SWIFT template is to be read in conjunction with the SWIFT Standards Document 2016. Refer to Appendix D to access to the respective document SWIFT MT942 Standard Statement Message Status Tag Field Name Content / Option No. M 20 Transaction Reference Number 16x 1 O 21 Related Reference 16x 2 M 25P Account Identification 35x
O 61 Statement Line
M 90D Number and Sum of Entries 5n3!a15d 9 O 90C Number and Sum of Entries 5n3!a15d 10 O 86 Information to Account Owner 6*65x 11 M = Mandatory O = Optional
SWIFT MT942 Definitions of fields Status Tag Field Name Field Description M 20 Transaction Reference Number A unique reference number will be created by Nedbank for each message O 21 Related Reference This will be populated with your Nedbank profile number and instance number. The profile number and instance number will be separated by a "+" sign. Your profile number is always 10 numeric and instance number can be from 1 to 9999. Each PTI instance is a group of accounts, settings and destination. Client can load up to 9999 different PTI instances per profile. M 25P Account Identification This will be the Nedbank account number for which the statement is sent And the senders address, which will always be populated with Nedbank's Swift address.
M 28C Statement Number / Sequence Number One statement number per statement sent. Will reset to zero on the 1st of January every year If only one message is sent for the same statement then this will be the statement number/1 If more than one message is sent for the same statement then this will be the statement number followed by the sequence number of the statement E.g. statement number/1, statement
number/2 and so on M 34F Floor Limit Indicator If you have specified to only be notified for transactions above a certain value this amount is indicated in this field. If you have chosen to receive all transactions amounts then this field will contain the value zero. Applicable to both debit and credit amounts. M 13D Date / Time Indication Date is expressed as YYMMDD. Time is expressed as HHMM Sign is either "+" or "-". Refer to SWIFT Standards document O 61 Statement Line * Refer to Field 61 -definition below O 86 Information to Account Owner Line 1 - Will include Transaction Key, Separator ("+") and Process Key Line 2 - Will include the Resend Key, Separator ("+") and Destination Key Line 3 - Will include the channel through which this transaction was processed (List of valid channels to be provided by Nedbank) Line 4 - Will include the transaction type (A valid list of transaction types to be provided by Nedbank)
Transaction Key: Each transaction in Nedbank is allocated a unique key for PTI. IF you receive the same transaction key on another PTI message it is for the same transaction ie a duplicate. Transaction Keys are not unique across FTI and PTI
Process Key: Uniquely identifies the client preferences effective for this statement ie format, accounts, destination addresses, etc
Resend Key: Any value greater than zero means this statement was resent on customer request
Destination Key: If your PTI instance has more than one destination address it will have different destination keys ie you request to send the same statement to multiple swift addresses, the first one will have a destination key "1", the second swift address will have a destination key "2", etc M 90D Closing Balance (Booked Funds) This field indicates the total number and total amount of debit entries in this report O 90C Closing Available Balance (Available Balance) This field indicates the total number and total amount of credit entries in this report O 86 Information to Account Owner Is not used
- Field 61: Statement Line This field contains the details of each transaction as listed below: Subfield Format Name Description 1 6!n Value Date Date the financial is posted to the account for the transaction 2 [4!n] Entry Date Is not used 3 2a Debit / Credit Mark C = Credit D = Debit RC = Reversal of credit RD = Reversal of debit 4 [1!a] Funds Code Is not used
5 15d Amount Transaction amount 6 1!a3!c Transaction Type Identification Code Will always be populated with NMSC 7 16x Reference for the Account Owner Will always insert 'NONREF' 8 [//16x] Account Servicing Institution's Reference Will Insert the transaction type (A list of transaction types will be provided by Nedbank) 9 [34x] Supplementary Details Your statement narrative will be populated in this field (Maximum 34 characters)
MT942 Sample Message: :20:PNS0000050945104 :21:4000367932+16 :25P:1339407027 NEDSZAJJ :28C:348/1 :34F:ZAR0,00 :13D:1612131148+0200 :61:161213C951,00NMSCNONREF//EFT DEPOSIT PENSION AND PROVIDENT FUND :86:406617658+8 0+1 NBB EFT DEPOSIT PENSION AND PROVIDENT FUND :90D:0ZAR0,00 :90C:1ZAR951,00 -}
6.1.11 TI SWIFT MX942 (NRT)
6.1.12 Multicash AUSZUG (Header) (NRT) All Numeric fields should be right aligned and Zero filled. All amount / value fields have two implied decimal points. Multicash format description: - Filename: AUSZUG (header) Examples: Multi-cash - AUSZUG.txt
- The files have to be ASCII coded
- The delimiter between the fields is a semicolon (;)
- Type description: A (Alphanumeric) N (Numeric) X (Date in format DD.MM.YY)
Multicash AUSZUG (Header) Field Type Minimum Maximum Optional Description 1 A 0 12 Bank key (ibt) 2 A 0 24 Bank account number 3 N 1 4 Statement number 4 X 8 8 Statement date 5 A 3 3 Currency key (zar) 6 N 1 18.2 Opening balance 7 N 1 18.2 Debit total 8 N 1 18.2 Credit total 9 N 1 18.2 Closing balance amount 10 A 0 35 Bank account holder 11 A 0 35 Special account name 12 0 0 Not used 13 0 0 Not used 14 0 0 Not used 15 0 0 Not used 16 0 0 Not used 17 0 0 Not used 18 N 1 5 Number of memo records in account statement
6.1.13 Multicash UMSATZ (Line Items) (NRT) All Numeric fields should be right aligned and Zero filled. All amount / value fields have two implied decimal points. Multicash format description: - Filename: UMSATZ (line items) Examples: Multi-cash - UMSATZ.txt
- The files have to be ASCII coded
- The delimiter between the fields is a semicolon (;)
- Type description: A (Alphanumeric) N (Numeric) X (Date in format DD.MM.YY)
Multicash UMSATZ (Line Items) Field Type Minimum Maximum Optional Description 1 A 0 12 Bank key (ibt) 2 A 0 24 Bank account number 3 N 1 4 Statement number 4 X 8 8 Value date - transaction date 5 N 1 10 X Primary zero's note number 6 A 0 27 X Note to payee 7 A 0 27 Bank posing text - statement description 8 0 0 Not used 9 0 0 Not used 10 A 0 16 Cheque number 11 N 1 18.2 Amount 12 0 0 Not used 13 0 0 Not used 14 X 8 8 Posing date - transaction date 15 0 0 Not used 16 0 0 Not used 17 A 0 27 X Note to payee2 18 A 0 27 X Note to payee3 19 A 0 27 X Note to payee4 20 A 0 27 X Note to payee5 21 A 0 27 X Note to payee6 22 A 0 27 X Note to payee7 23 A 0 27 X Note to payee8
24 A 0 27 X Note to payee9 25 A 0 27 X Note to payee10 26 A 0 27 X Note to payee11 27 A 0 27 X Note to payee12 28 A 0 27 X Note to payee13 29 A 0 27 X Note to payee14 30 A 0 27 X Business partner 31 A 0 27 X Business partner 32 A 0 12 X Bank key of business partner's bank 33 A 0 24 X Bank account of business partner 34 A 0 3 X Business transaction code 35 0 0 Not used
IMPORTANT:
- Field 34 (Business Transaction Code) or Field 7 (Bank Posing Text) are used as the 'External Business Transaction' in Table T028G
- Please use Field 7 if Field 34 is too short. In this case, Field 34 has to have the Value Space