Skip to content

7.1.18 Multicash UMSATZ (Line Items) Template 1

Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 161-162 PDF pages: 161-162

  • All Numeric fields should be right aligned and Zero filled.
  • All amount / value fields have decimal points followed by 2 digits
  • All Amount value fields have the sign on the right hand side.
  • The files have to be ASCII coded
  • The line item file will include one or more accounts based on client preference. It will only report transactions on accounts that are present on the header file. However if no transaction have occurred on the account during the period of the statement t hat account will not report any transactions in the line item file even though reported on the header file.
  • The delimiter between the fields is a semicolon (;)
  • Type description: A (Alphanumeric) N (Numeric) X (Date in format DD.MM.YY)

Field Type Minimum Maximum Optional Description 1 A 0 12 It will include the Nedbank universal branch code ie, 198765 2 A 0 24 Bank account number 3 N 1 4 It will include a single statement number generated by FTI 4 X 8 8 Value date - transaction date 5 N 1 10 X Not populated 6 A 0 27 X First 27 characters of the Statement Narrative. If there is a semi colon within the text it will be replaced with a coma to ensure it is not interpreted as the end of this field. 7 A 0 27 Last 3 character of the Statement Narrative if applicable. If there is a semi colon within the text it will be replaced with a coma to ensure it is not interpreted as the end of this field. 8 0 0 Not populated 9 0 0 Not populated 10 A 0 16 Populated with zero 11 N 1 18.2 Transaction Amount. If debit or reversal of credit it will have a "-" sign at the end. If credit or reversal of debit it will have a "+" sign at the end. If field 23 is populated with the word "DEBIT" and the sign of the

amount is "+" in field 11 then the transaction is a debit reversal. If field 23 is populated with the word "CREDIT" and the sign of the amount is "-" in field 11 then the transaction is a credit reversal 12 0 0 Not populated 13 0 0 Not populated 14 X 8 8 Transaction Date 15 0 0 Not populated 16 0 0 Not populated 17 A 0 27 X Statement Number as displayed on you official bank statement 18 A 0 27 X Statement Line item as displayed on your official bank statement 19 A 0 27 X Transaction Key 20 A 0 27 X Process Key 21 A 0 27 X Resend Key 22 A 0 27 X Destination Key 23 A 0 27 X Will be populated with "DEBIT" or "CREDIT" 24 A 0 27 X Not populated 25 A 0 27 X Not populated 26 A 0 27 X Not populated 27 A 0 27 X Not populated 28 A 0 27 X Not populated 29 A 0 27 X Not populated 30 A 0 27 X Not populated 31 A 0 27 X Not populated 32 A 0 12 X Not populated 33 A 0 24 X Not populated 34 A 0 3 X NedAcad transaction Code 35 0 0 Not used

IMPORTANT:

  • Field 34
  • Please use Field 7 if Field 34 is too short. In this case, Field 34 has to have the V alue Space