Important: When viewing this file in ConvPay, set the display width to 100.
This help file explains the output format used for AAR processing (which produces PAR output
files). The output format uses the ACH (Automated Clearing House) standard defined by NACHA (the National Automated Clearing House Association).
Records in the ACH format are 94 characters long. The record type is identified by a digit in
column 1 (click a digit to jump to the corresponding section):
'1' = First line of file
'5' = First line of a batch (also known as a "transaction-set")
'6' = Second line of a batch
'7' = Third line of a batch (see note)
'8' = Final line of a batch
'9' = Last line of file
Note: Record Type 7 only appears under certain circumstances. It is not currently implemented
by ConvPay and thus is not documented here.
File Header Record (RecType 1)
Sample, Scale and Field Markers:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----
101 09900009912345123450504112359A094101superbank WHIZCOOFAMERICAINC DEPD0411
|| | | | | || | || | |
12 3 4 5 6 78 9 01 2 3
————————————————————————————————————————————————————————————————————————————————————————
FLD DESCRIPTION SIZE CONTENTS VARIABLE? EXAMPLE OR CONSTANT
———————————————————————————————————————————————————————————————————————————————————————
1 Record Type 1 1 - '1'
2 Priority Code 2 See example - '01'
3 Immediate Destination 10 See example - ' 099000099'
4 Immediate Origin 10 Federal ID (Note 4) Y '1234512345'
5 Transmit/File Create Date 6 YYMMDD from dated file name Y '050411'
6 Transmit/File Create Time 4 HHMM - '2359'
7 File Id Modifier 1 See example - 'A'
8 Record Size 3 094 - '094'
9 Blocking Factor 2 10 - '10'
10 Format Code 1 1 - '1'
11 Destination Name 23 See example - 'superbank '
12 Origin Name 23 See example - 'WHIZCOOFAMERICAINC '
13 Reference Code 8 DEPD & MMDD from file name Y 'DEPD0411'
——— —————————————————————————————— ——————————————————————————————————————————————————————
Note 4: Some banks use a different value, omitting the leading '1'. In such case the number
is padded with a space on the right. This variation is not yet supported by ConvPay,
which currently includes the '1' in all cases (thus: '1234512345').
Company Batch Header Record (RecType 5)
ample, Scale and Field Markers:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----
5200WHIZCOOFAMERICAInicelittlenewsstand 1234512345CCDRECEIVABLE050412050412 1099000090000001
|| | | | | | | | | || |
12 3 4 5 6 7 8 9 0 12 2
——— —————————————————————————————— —————————————————————————————— —————————————————————————
FLD DESCRIPTION SIZE CONTENTS VARIABLE? EXAMPLE OR CONSTANT
——— —————————————————————————————— —————————————————————————————— —————————————————————————
1 Record Type 1 5 - '5'
2 Service Class Code 2 200 - '200'
3 Company Name 16 Alphameric - 'WHIZCOOFAMERICAI'
4 Company Discretionary Data 20 Alphameric (Note 4) Y 'nicelittlenewsstand '
5 Company ID 10 Same a Rec Type 1 Field 4 Y '1234512345'
6 Standard Entry Class Code 3 CCD - 'CCD'
7 Company Entry Description 10 RECEIVABLE - 'RECEIVABLE'
8 Company Descriptive Date 6 YYMMDD (see Note 8/9) Y '050412'
9 Effective Entry Date 6 YYMMDD (see Note 8/9) Y '050412'
10 Settlement Date (Julian) 3 Alphameric (left blank) - (3 spaces)
11 Originator Status Code 1 1 - '1'
12 Originating Ident 8 Routing/Transit # - '09900009'
13 Batch Number 7 Batch Number Y '0000001'
——— —————————————————————————————— —————————————————————————————— —————————————————————————
Note 4: The agent name, letters only, lowercased, truncated at 20 characters, padded with
spaces on the right if necessary.
Note 8/9: Fields 8 and 9 are the same. They are derived from the date in the AAR file name,
plus one business day. ConvPay does not currently make allowances for bank
holidays.
Entry Detail Record (RecType 6)
Sample, Scale and Field Markers:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----
6279123450000504110000001 0000000101 0099000090000001
|| | || | | | | ||
12 3 45 6 7 8 9 01
——— —————————————————————————————— —————————————————————————————— —————————————————————————
FLD DESCRIPTION SIZE CONTENTS VARIABLE? EXAMPLE OR CONSTANT
——— —————————————————————————————— —————————————————————————————— —————————————————————————
1 Record Type 1 6 - '6'
2 Transaction Code 2 27 - '27'
3 Receiving Ident (Note 3) 8 ABA Digits 1 to 8 Y '912345000'
4 Check Digit (Note 3) 1 ABA Digit 9 Y '0'
5 Account Number 17 account_number from input Y '0504110000001 '
6 Amount 10 Payment (see Note 6) Y '0000000101'
7 Individual Ident Number 15 Left blank - (15 spaces)
8 Individual Name 22 Left blank - (22 spaces)
9 Discretionary Data 2 Blank - (2 spaces)
10 Addenda Record Ident 1 0 - '0'
11 Trace Number 15 Rec Type 5 Fields 12 & 13 Y 099000090000001
——— —————————————————————————————— —————————————————————————————— —————————————————————————
Note 3: ABA stands for "American Banking Association". The data comes from the ABA_Number
field in the AAR file.
Note 6: The amount field from the input file. This is a dollar value with the decimal
removed. Thus 9.99 yields 0000000999.
Record Type 7 (RecType 7)
This record type is not yet implemented by ConvPay and thus has not yet been documented.
Company/Batch Control Record (RecType 8)
Sample, Scale and Field Markers:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----
820000000100912345000000000001010000000000001234512345 099000090000001
|| | | | | | | | | |
12 3 4 5 6 7 8 9 0 1
——— —————————————————————————————— —————————————————————————————— —————————————————————————
FLD DESCRIPTION SIZE CONTENTS VARIABLE? EXAMPLE OR CONSTANT
——— —————————————————————————————— —————————————————————————————— —————————————————————————
1 Record Type 1 8 - '8'
2 Service Class Code 3 200 - '200'
3 Entry Addenda Count 6 See Note 3 - '000001'
4 Entry Hash 10 See Note 4 Y '0091234500'
5 Total Debit Amount 12 Same as Rec Type 6 Field 6 Y '000000000101'
6 Total Credit Amount 12 0 - '000000000000'
7 Company Identification 10 1234512345 - '1234512345'
8 Reserved 19 Blank - (19 spaces)
9 Reserved 6 Blank - (6 spaces)
10 Originating Ident 8 Same as Rec Type 5 Field 12 - '09900009'
11 Trace Number 7 Same as Rec Type 5 Field 13 Y '0000001'
——— —————————————————————————————— —————————————————————————————— —————————————————————————
Note 3: This is the number of type 6 records in this batch. For PAR processing this will
always be '000001', since each agent will only ever have one entry in the AAR
input file.
Note 4: We drop the last digit of the ABA number (in other words, the check digit) and pad
the field out to 10 digits with zeros on the left.
Record Type 7 (RecType 7)
This record type is not yet implemented by ConvPay and thus has not yet been documented.
Company/Batch Control Record (RecType 8)
File Control Record (RecType 9)
Sample, Scale and Field Markers:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----
9000018000006000000186422210153000000017145000000000000|------- Spaces to column 94 ---------|
|| | | | | | |
12 3 4 5 6 7 8
——— —————————————————————————————— —————————————————————————————— —————————————————————————
FLD DESCRIPTION SIZE CONTENTS VARIABLE? EXAMPLE OR CONSTANT
——— —————————————————————————————— —————————————————————————————— —————————————————————————
1 Record Type 1 9 - '9'
2 Batch Count 6 Numeric Y '000018'
3 Block Count (Note 3) 6 Numeric Y '000006'
4 Entry/Addenda Cnt (Note 4) 8 Numeric Y '00000018'
5 Entry Hash (Note 5) 10 Numeric Y '6422210153'
6 Total Debit Entry Amount 12 See Note 6 Y '000000017145'
7 Total Credit Entry Amount 12 0 - '000000000000'
8 Reserved 39 Blank - (39 spaces)
——— —————————————————————————————— —————————————————————————————— —————————————————————————
Note 3: Total count of output lines, including the first and last lines, divided by 10,
rounded up to the nearest integer e.g. 99.9 becomes 100); 6 columns, zero-padded on
the left.
Note 4: Same as Batch Count, with two leading zeros.
Note 5: Sum of the ABA Digits 1 to 8 in all Rec Type 6's; 10 columns (right-most 10 columns
if necessary), zero-padded on the left.
Note 6: Total of all Rec Type 6, Field 6's.
   
Parse-O-Matic Free and Advanced Editions are data conversion tools that allow you to parse, convert, mine, import and export data files, reports, web capture, logs, legacy databases, text, CSV (comma separated; comma delimited), ASCII, EBCDIC, and almost any data format that you may have.
|