Finance::AMEX::Transaction::EPTRN::Summary - Parse AMEX Transaction/Invoice Level Reconciliation (EPTRN) Summary Rows
version 0.001
use Finance::AMEX::Transaction; my $epraw = Finance::AMEX::Transaction->new(file_type => 'EPTRN'); open my $fh, '<', '/path to EPTRN file' or die "cannot open EPTRN file: $!"; while (my $record = $epraw->getline($fh)) { if ($record->type eq 'SUMMARY') { print $record->PAYMENT_DATE . "\n"; } } # to parse a single line my $record = $epraw->parse_line('line from an EPTRN file'); if ($record->type eq 'SUMMARY') { ... }
You would not normally be calling this module directly, it is one of the possible return objects from a call to Finance::AMEX::Transaction's getline method.
Returns a new Finance::AMEX::Transaction::EPTRN::Summary object.
my $record = Finance::AMEX::Transaction::EPTRN::Summary->new(line => $line);
This will always return the string SUMMARY.
print $record->type; # SUMMARY
Returns the full line that is represented by this object.
print $record->line;
This field contains the Service Establishment (SE) Number of the merchant that received the payment from American Express.
Note: SE Numbers are assigned by American Express.
This field is always zero filled in the Summary Record.
This field contains the Payment Year that corresponds to the entry in the Julian Date subfield of PAYMENT_NUMBER.
This field contains the Payment Number, a reference number used by the American Express Payee to reconcile the daily settlement to the daily payment.
The Julian date of the payment.
An alpha character assigned by the American Express settlement system.
The Number of the payment.
This field contains the constant literal “1”, a Record Type code that indicates that this is a Summary Record.
This field contains the Detail Record Type code that indicates the type of record used in this transaction.
For Summary Records, this entry is always “00” (zeros).
This field contains the Payment Date, which is the date the funds are actually available to the payee’s depository institution.
The format is: YYYYDDD
This field contains the actual Payment Amount paid to the payee for the activities listed in the Detail Records.
Note: For US Dollar (USD) and Canadian Dollar (CAD) transactions, two decimal places are implied.
A debit amount (positive) is indicated by an upper-case alpha code used in place of the last digit in the amount.
The debit codes and their numeric equivalents are listed below:
A credit amount (negative) is also indicated by an upper-case alpha code used in place of the last digit in the amount.
The credit codes and their numeric equivalents are listed below:
The following are examples of how amounts would appear:
Amount Debit Credit $1.11 0000000011A 0000000227} $345.05 0000003450E 0000003450N $22.70 0000000227{ 0000000011J
This field contains the Debit Balance Amount, which is a negative value if the merchant has an opening debit balance for the payment listed in PAYMENT_AMOUNT.
This field contains the ABA Bank Number to which the value in PAYMENT_AMOUNT, was transferred through the ACH banking system.
This field contains the payee’s Direct Deposit Account Number to which the value in PAYMENT_AMOUNT, was transferred through the ACH banking system.
Finance::AMEX::Transaction::EPTRN::Summary - Object methods for AMEX Reconciliation file summary records.
Tom Heady <theady@ziprecruiter.com>
This software is copyright (c) 2018 by ZipRecruiter.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
To install Finance::AMEX::Transaction, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Finance::AMEX::Transaction
CPAN shell
perl -MCPAN -e shell install Finance::AMEX::Transaction
For more information on module installation, please visit the detailed CPAN module installation guide.