7.1.19 Multicash UMSATZ (Line Items)- Template 2¶
Source: TI_Host_to_Host_Client_User_Manual_v52.pdf Document pages: 163-164 PDF pages: 163-164
- 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 that 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,
- 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 Nedbank NedAcad Transaction Code 7 A 0 27 Not populated 8 0 0 Not populated 9 0 0 Populate CASA statement number 10 A 0 16 Populated with zero 11 N 1 18.2 Transaction Amount. If debit it will have a "-" sign at the end. If credit it will have a "+" sign at the end. 12 0 0 Not populated 13 0 0 Not populated 14 X 8 8 Transaction Date always same as value date 15 0 0 Not populated 16 0 0 Not populated 17 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 hypen "-"
to ensure it is not interpreted as the end of this field. 18 A 0 27 X Last 3 character of the Statement Narrative if applicable. If there is a semi colon within the text it will be replaced with a hypen "-" to ensure it is not interpreted as the end of this field. 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