The file consists of the following 8 record types:
Type 0 Extraction Header Record
Type 1 Client Header Record
Type 2 Account Header Record(s)
Type 3 Account Balance Record(s)
Type 4 Credit Transaction Record(s)
Type 5 Debit Transaction Record(s)
Type 6 Account Totals Record(s)
Type 8 Client Trailer Record
Coins ERP+ reads only the records highlighted in blue (that is, types 0, 4 and 5). Each record is a fixed length of 80 bytes.
Type 0: Extraction Header Record
RELATIVE ADDRESS | LENGTH | CONTENTS | DETAIL |
1 | 1 | 0 | Record Type |
2 | 4 | 0000 | Always Zeros |
6 | 2 | Blanks | Always Blanks |
8 | 6 | 000000 | Always Zeros |
14 | 6 | Numeric | Date DDMMYY |
20 | 37 | Blanks | Always Blanks |
57 | 4 | 0000 | Always Zeros |
61 | 20 | Blanks | Always Blanks |
Type 4: Credit Transaction Record
RELATIVE ADDRESS | LENGTH | CONTENTS | DETAIL |
1 | 1 | 4 | Record Type |
2 | 4 | Numeric | Branch Number |
6 | 8 | Numeric | Account Number |
14 | 8 | Numeric | Agent Number, Depositing Branch, or blanks |
22 | 3 | Alpha/Numeric | Transaction Type Code |
25 | 11 | Numeric | Transaction Amount ($$$$$$$$$¢¢) |
36 | 9 | Numeric | Number of cheques in deposit, or zeros. |
45 | 30 | Alpha/Numeric | Statement Narrative |
75 | 6 | Blanks | Always Blanks |
Type 5: Debit Transaction Record
RELATIVE ADDRESS | LENGTH | CONTENTS | DETAIL |
1 | 1 | 5 | Record Type |
2 | 4 | Numeric | Branch Number |
6 | 8 | Numeric | Account Number |
14 | 8 | Blanks | Always Blanks |
22 | 3 | Alpha/Numeric | Transaction Type Code |
25 | 11 | Numeric | Transaction Amount ($$$$$$$$$¢¢) |
36 | 9 | Numeric | cheque serial number or branch number |
45 | 30 | Alpha/Numeric | Statement Narrative |
75 | 6 | Blanks | Always Blanks |