ANZ Transactive-Global File Formats v2 | Debits And Credits | Financial Transaction

    Classification:  Public   ANZ TRANSACTIVE –  GLOBAL FILE FORMAT 05 | 2015  2  INTRODUCTION ................................................. 3   AU DOMESTIC PAYMENTS FILE FORMATS .............. 6   File Formats Overview (Payables) .................... 6   ABA File Format ................................................. 6   Import Methods ............................................ 6   ABA File Layout and Character Set .................. 7   Descriptive Record (0) ................................... 8   Detail Record (1) .......................................... 9   Batch Control Record (7) .............................. 11   AU Domestic Payments CSV Detail Import ........... 12   CSV File Layout and Character Set ................ 12   Detail Record .............................................. 13   NZ DOMESTIC PAYMENTS FILE FORMATS ............ 14   NZ Domestic Payment CSV (Full File Import) ....... 14   File Layout and Character Set ....................... 14   Descriptive Record ...................................... 14   Detail Record .............................................. 16   Batch Control Record ................................... 17   NZ Domestic Payments CSV Detail Import (with Control Record) ............................................... 18   File Layout and Character Set ....................... 18   Descriptive Record ...................................... 18   Detail Record .............................................. 19   Batch Control Record ................................... 20   NZ Domestic Payments CSV Detail Import (without Control Record) ................................... 21   File Layout and Character Set ....................... 21   Detail Record .............................................. 21   SINGLE PAYMENTS FILE FORMATS ..................... 23   MT101 File Format (Australia & New Zealand)...... 23   File Naming Convention ............................... 23   MT101 File Layout and Character Set ............. 23   Character Set ............................................. 24   Sequence A –  General Information ................ 24   Sequence B –  Transaction Detail Record ........ 26   Clearing System Codes ................................ 30   WIRS file format (Australia only) ........................ 31   File Naming Convention ............................... 31   WIRS File Layout and Character Set .............. 31   Character Set ............................................. 31   Detail Record .............................................. 32   Miscellaneous Field Format Specifications ....... 34   NZ International Payment CSV file format (New Zealand only) .................................................. 35   File Naming Convention ............................... 35   NZ International CSV File Layout and Character Set ............................................. 35   BPAY File format (Australia only) ........................ 41   BPAY File Layout and Character Set ............... 41   Payment Instruction Record ......................... 42   File Trailer Record ....................................... 44   BTR AND RETURNED ITEMS FILE FORMATS ......... 45   BAI File ........................................................... 45   File Header Record ...................................... 47   Group Header Record .................................. 48   Account Identifier and Summary Status Record (03) ............................................... 49   Transaction Detail Record (16) ..................... 50   Continuation Record (88) ............................. 51   Account Trailer Record (49) ......................... 52   Group Trailer Record (98) ............................ 53   File Trailer Record (99) ................................ 53   Statement Files ............................................... 54   Statement Balance File Format ..................... 55   Statement Transaction File Format................ 57   SAP/Multi-cash Files ......................................... 59   SAP/Multi-cash Balance File Format .............. 60   SAP/Multi-cash Transaction File Format ......... 61   Returned Items File Layout .......................... 64   Header Record –  Returned Direct Debits and Credits ...................................................... 65   Detail Record –  Returned Direct Debits and Credits ...................................................... 65   Trailer Record –  Returned Direct Credits and Debits ....................................................... 67   Header Record –  Returned Cheques .............. 67   Detail Record –  Returned Cheques ................ 68   Trailer Record –  Returned Cheques ............... 69   Return Reason Codes –  Returned Direct Debits/Credits ............................................ 70   Return Reason Codes –  Returned Cheques ..... 70   NZ Statement Files (New Zealand Domestic Accounts only) ................................................ 72   NZ Statement File(s) –  Transaction File ......... 73   Transaction Record - Type 3 ........................ 74   Opening Balance Record - Type 5 ................. 75   Closing Balance Record - Type 6 ................... 76   Total Debits/Credits Record - Type 8 ............. 77   Grand Total Debits/Credits Record - Type 9 ... 78   MT940 ............................................................ 79   Block 1 (Basic Header) ................................ 79   Block 2 (Application Header) ........................ 80   Block 4 (Message Body) .............................. 81   CSV ............................................................... 84   Account Summary CSV Report ..................... 84   Account Statement CSV Report .................... 85   Balance Summary CSV Report ...................... 86   Net Position View ........................................ 87   Returned Items Cheques ............................. 88   Returned Items Payments ............................ 89   ANZ Transactive –  Global on screen exports ........ 91   Favourite Accounts List View Export .............. 91   Operating Accounts List View Export ............. 92   Net Position List View Export ........................ 93   Account Activity List View Export .................. 94   Transaction Search List View Export .............. 95   FURTHER ASSISTANCE .................................... 139   CONTENTS  3 ANZ Transactive and ANZ Transactive - Mobile are provided by Australia and New Zealand Banking Group Limited (ACN 005 357 522). References to ―Australia(n)‖ or ―AU‖ with respect to any payments, products and/or accounts means payment made by, accounts held with and products provided by Australia and New Zealand Banking Group Limited / ANZ Australia from or within Australia. References to ―New Zealand‖ or ―NZ‖ with respect to any payments, produc ts and/or accounts means payment made by, accounts held with and products provided by ANZ Bank New Zealand Limited from or within New Zealand.  4  INTRODUCTION About ANZ Transactive –  Global ANZ Transactive –  Global is a digital banking solution offering the convenience of accessing Cash, Liquidity, Trade and Markets services in one place using one set of security credentials, along with enhanced reporting capability. About this document This document is designed to: > collate the various file formats for ANZ Transactive –  Global and its underlying application ANZ Transactive –  AU & NZ. > This is intended to be a file format specification guide only, and as such does not include any training on how to use the different file formats. This document will be updated with new functionality and information when necessary. Please ensure you regularly check the available version to ensure you have the most up-to-date copy. Scope This document applies to the following ANZ Transactive –  Global web solution file formats:    AU Domestic Payments import file formats: o   ABA file format o   CSV file format    NZ Domestic Payments import file formats: o   NZ Domestic Payment CSV (Full File Import) o   NZ Domestic Payment CSV Detail Import (with Control Record) o   NZ Domestic Payment CSV Detail Import (Without Control Record)    Single Payments import file formats: o   MT101 file format o   WIRS file format o   NZ International Payment CSV file format o   BPAY file format    Reporting export file formats: o   BAI export format o   Statement export format o   SAP/Multi-cash export format o   Returned Items export format o   NZ Statement files