(updated January 5, 2015)
The definition for the comma-delimited file format contains one
bill per record with no header record. The fields in the
record
are separated by commas and optionally enclosed in double-quotes
("). The filename has a suffix of ".csv". The
fields in
the file are as follows:
# |
Field
Name |
Format |
Req |
Comment |
---|---|---|---|---|
1 |
BillDate |
MM/DD/YYYY |
Y |
|
2 |
MANumber |
50 char |
Y |
Assigned by merchant - identifies customer to merchant |
3 |
DueDate |
MM/DD/YYYY | Y |
|
4 |
Amount |
$###,###.## -$###,###.## $###,###.##- ($##,###.##) $###,###.##CR |
Y |
Dollars.cents, dollar sign ($) &
commas (,) ignored Negative number indicates credit due Negative number indicates credit due Negative number indicates credit due Inclusion of 'CR' indicate credit due |
5 |
Name |
50 char | Y |
|
6 |
ServiceAddress | 100 char |
Y |