6.1.8 PTI CSV Balance Only (NRT) Template 1¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 104-105 PDF pages: 104-105
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
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