Records are up to 80 characters long. Fields are delimited with a comma (,); a slash (/) is used to delimit the last non-text field in a record if the statement line needs to be continued in a new record.
Each record begins with a two-digit identifier:
The first record in each 'logical file' for a customer begins with 01; the last record begins with 99.
Within the 'logical file', the first record in each group (Originator/As-Of Date combination ) begins with 02; the last record begins with 98.
Within each group, the first record in each account block begins with 03; the last record begins with 49.
Transaction records begin with 16.
Continuation records begin with 88.
Coins ERP+ only imports record types 02, 03 and 16.
Record type 01 - File header
The first record in the file is the File header.
Field | Description |
Record type | Always '01' |
Sender identification | Not used |
Receiver identification | Next recipient of file |
File creation date | System date, format yymmdd |
File creation time | System time, Format hhmm. Expressed in AEST using a 24-hour clock. For End-of-day (Main) files this will be '0000' |
File sequence number | Always '1' |
Physical record length | Number of characters in each record This includes the two-character Record type and the record delimiter (if any) |
Blocking factor | Number of physical records in a block |
Record type 02 - Group header
The first record in each group of records is the Group header. It follows either the File header record (record type '01') or a Group trailer record (record type '98').
Field | Description |
Record type | Always '02' |
Ultimate receiver identification | As for the Receiver identification field in the File header (record type '01') record |
Originator identification | Originator of file. This is the bank ID, an 8-character alphanumeric field used by NAB to identify banks |
Group status | Always '1' (original) |
As-of date | Statement date in format yymmdd |
As-of time | This is always '0000' |
Record 03 - Account identification and summary status
The first record for each account is the Account identifier and summary status record. It follows either a Group header (record type '02') or an Account trailer (record type '49') record.
Field | Description |
Record type | Always '03' |
Commercial account number | Customer commercial account number at the bank of origin. This is your bank account number. It excludes the BSB number for NAB domestic accounts. |
Currency code | SWIFT currency code |
Transaction codes | Three-digit account summary code |
Amounts | Amount expressed with two implied decimal places and optional trailing sign. For currencies with no decimal component, for example Japanese Yen, the last two digits are always zero. If there is no trailing sign, the amount is positive. |
The Transaction code and Amount fields are repeated for each account summary code. The account summary codes can appear in any order, but each code appears only once.
Record type 16 - Transaction detail
A Transaction detail record follows either the Account identifier and summary status (record type '03') record or another Transaction detail (record type '16') record.
Field | Description |
Record type | Always '16' |
Transaction code | Three-digit transaction detail code |
Amount | Amount expressed with two implied decimal places. For currencies with no decimal component, for example Japanese Yen, the last two digits are always zero. The amount is unsigned. The transaction code determines DR or CR. |
Funds type | Always '0' (immediately available) |
Reference number | Optional alphanumeric field defined by the originator. The contents of this field depend upon the source of the transaction. For example, it could be a cheque number for cheque transactions. |
Text | Optional alphanumeric field defined by the originator. The contents of this field depend upon the source of the transaction. For example, it could provide dishonour details for a dishonoured cheque. No delimiter is used at the end of a record that has text in the last field. |
Record type 49 - Account trailer
The last record for each account is the Account trailer. That is, it follows the last Transaction detail record (record type '16') for an account. If there are no transactions, it follows the Account identifier and summary status record (record type '03').
Field | Description |
Record type | Always '49' |
Account control total A | The sum of amount fields in record types '03' (including the amounts for account summary codes 965,966,967,968,969), '16', and '88' for the account. |
Account control total B | The sum of all amount fields in record types '03' (excluding the amounts for account summary codes 965,966,967,968,969), '16' and '88' for the account. |
Account control totals A and B have two implied decimal places and an optional preceding sign. If there is no preceding sign, the amount is positive.
Record type 88 - Continuation (optional)
Continuation records are used as overflow records. That is, the format of this record continues the same format as the record immediately preceding it. It can follow any record type.
In practice, it is only required for the following records:
Account identifier and summary status (record type '03')
Transaction detail (record type '16').
Field | Description |
Record type | Always '88' |
Remainder of record | Continuation of record format from record immediately preceding this continuation record |
Record type 98 - Group trailer
The last record in each group of records is the Group trailer. It follows the last Account trailer (record type '49') record for the group.
Field | Description |
Record type | Always '98' |
Group control total A | The sum of the Account control totals A in all Account trailer (record type '49') records in this group |
Number of accounts | The number of accounts in this group. That is the number of Account identifier and summary status (record type '03') records in this group. |
Group control total B | The sum of the Account control totals B in all Account trailer (record type '49') records in this group |
Record type 99 - File trailer
The last record in each file of records is the File trailer.
Field | Description |
Record type | Always '99' |
File control total A | The sum of the Group control totals A in all Group Trailer (record type '98') records in this file |
Number of groups | The number of groups in this file. That is, the number of Group header (record type '02') records in this file. |
Number of records | The total number of records in this file. This includes the File header and File trailer records but excludes any device-oriented or job control records. |
File control total B | The sum of the Group control totals B in all Group Trailer (record type '98') records in this file |