7.1.7 FTI TXT Template 2¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 147-149 PDF pages: 147-149
Fixed width length file: Record length = 1000 All Value fields with be preceded by the sign = + (Credit balance) and - (Debit balance)
File Header Record
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 FTI for the Final Transaction Information product Instance number Numeric 4 You can load up to 9999 different instances per profile for the FTI 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
Account Header Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "02" to indicate Account header
Account
Numeric 23 The transactions that follow are for this account Statement Number Number 6 Provides a single statement number per message. Will reset to 1 for the first file sent in the new calendar year Statement Sequence Number Alpha 6 If your statement is broken up into multiple messages it will have different sequence numbers. Opening Available Balance Decimal 16,2 (20 characters long including sign) This is the opening 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) 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 The value of the debit transactions on this statement for this account. All Value
including sign) 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
Transaction Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "03" to indicate Transaction Record
Account
Numeric 23 The transaction reported is for this account Transaction Key Numeric 16 Each transaction in Nedbank is allocated a unique key for FTI. IF you receive the same transaction key on another message it is for the same transaction Process Key Numeric 9 Uniquely identifies the client preferences effective for this transaction Resend Key Numeric 9 Any value greater zero means the transaction was resent on customer request 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 allowed per instance Transaction List Number Numeric 6 Your transaction list number as you displayed on your official posted statement Statement Line Number Numeric 2 Each transaction list can have a maximum of 20 transactions. This
indicates this was transaction 2 in statement list 1. Helps client match transaction to posted statement Transaction Code Numeric 4 Nedbank transaction codes identifying the type of transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Sub Transaction Code Numeric 4 Reserved for future use ie for multiple transactions using the same transaction code. Sub trancodes will be used to uniquely identify the type transaction Refer to no 4.9 for a list of Transaction and Sub Transaction codes Transaction Amount Decimal 16,2 (20 characters long including sign) The actual transaction amount. All Value fields with be preceded by the sign = "+" (Credit balance) or "-" (Debit balance). Debit Credit AlphaNu meric 2 Is transaction a debit (Money out) or credit (Money in) to the account being reported on. Values D = Debit, C = Credit, RD = Reversal of Debit, RC = Reversal of Credit Date Numeric 8 The date on which the transaction was performed. Format 'CCYYMMDD' Account Closing 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). User Ref Alpha 30 Statement description/narrative Filler Alpha 836 Spaces
Account footer Record
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
Filler Alpha 957 Spaces
File footer Record
Field Name Data type Actual field length Description Record Identifier Numeric 2 Record will start with "05" to indicate file footer record Account Record Count Numeric 18 Number of accounts reported in this file