NAME

Finance::AMEX::Transaction::CBNOT::Detail - Parse AMEX Chargeback Notification Files (CBNOT) Detail Rows

VERSION

version 0.005

SYNOPSIS

use Finance::AMEX::Transaction;

my $cbnot = Finance::AMEX::Transaction->new(file_type => 'CBNOT');
open my $fh, '<', '/path to CBNOT file' or die "cannot open CBNOT file: $!";

while (my $record = $cbnot->getline($fh)) {

  if ($record->type eq 'DETAIL') {
    print $record->REC_TYPE . "\n";
  }
}

# to parse a single line

my $record = $cbnot->parse_line('line from a CBNOT file');
if ($record->type eq 'DETAIL') {
  ...
}

DESCRIPTION

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.

METHODS

new

Returns a new Finance::AMEX::Transaction::CBNOT::Detail object.

my $record = Finance::AMEX::Transaction::CBNOT::Detail->new(line => $line);

type

This will always return the string DETAIL.

print $record->type; # DETAIL

line

Returns the full line that is represented by this object.

print $record->line;

field_map

Returns a hashref where the name is the record name and the value is an arrayref of the start position and length of that field.

# print the start position of the DATE_OF_ADJUSTMENT field
print $record->field_map->{DATE_OF_ADJUSTMENT}->[0]; # 77

REC_TYPE

This field contains the constant literal "D", a record type code that indicates that this is a Chargeback Notifications (CBNOT) File Detail Record.

print $record->REC_TYPE; # D

SE_NUMB

This field contains the Service Establishment (SE) Number that STARS searches for and routes data to, based on the setup for the corresponding CBNOT data type (for outbound data).

CM_ACCT_NUMB

This field contains the Cardmember Account Number that corresponds to this chargeback.

CURRENT_CASE_NUMBER

This field contains the unique, American Express-assigned, current case (identification) number for this transaction, if this is a chargeback notification or final resolution.

For Customer Service Systems, you can use the CSS_CASE_NUMBER.

For SIREN/SOFA (SE Information Retrieval Entry Network/SE Online Financial Adjustment), you can use the SS_CASE_NUMBER.

FINCAP_TRACKING_ID_A

For FINCAP transactions (indicated when FINCAP_TRACKING_ID_A is not blank), this field contains the FINCAP Tracking ID.

FINCAP_TRACKING_A_DATE

FINCAP_TRACKING_A_PCID

FINCAP_TRACKING_A_SEQUENCE

CSS_CASE_NUMBER

See CURRENT_CASE_NUMBER

SS_CASE_NUMBER

See CURRENT_CASE_NUMBER

CURRENT_ACTION_NUMBER

Internal use only.

PREVIOUS_CASE_NUMBER

This field contains a case number from various sources, or is blank (character space filled), depending on the specific details of this record. (See also CSS_P_CASE_NUMBER)

CSS_P_CASE_NUMBER

This field contains a case number from various sources, or is blank (character space filled), depending on the specific details of this record. (See also PREVIOUS_CASE_NUMBER)

PREVIOUS_ACTION_NUMBER

Internal use only.

RESOLUTION

This field contains a code that indicates if this record is a Resolution Letter:

Y = Yes
N = No

Note: If this value is "Y", then CB_RESOLUTION_ADJ_NUMBER should be populated.

FROM_SYSTEM

This field contains a code that indicates the originating system that transmitted the file:

F = FINCAP
R = Statement Review
S = SIREN/SOFA (SE Information Retrieval Entry Network/SE Online Financial Adjustment)
T = Triumph
X = Customer Service Systems
P = Enhanced Case Management Platform
G = Globestar
_ = Other (underline represents a character space)
D = Global Disputes Management

Note: Internal use only

REJECTS_TO_SYSTEM

This field contains a code that indicates the system to which STARS (Split, Transmit And Receive System) should forward rejects:

R = Statement Review
S = SIREN/SOFA (SE Information Retrieval Entry Network/SE Online Financial Adjustment)
T = Triumph
X = Customer Service Systems
P = Enhanced Case Management Platform
G = Globestar
_ = No rejects (underline represents a character space)
D = Global Disputes Management

DISPUTES_TO_SYSTEM

This field contains a code that indicates the system to which STARS (Split, Transmit And Receive System) should forward disputes from the SE:

R = Statement Review
S = SIREN/SOFA (SE Information Retrieval Entry Network/SE Online Financial Adjustment)
T = Triumph
X = Customer Service Systems
P = Enhanced Case Management Platform
G = Globestar
_ = No disputes (underline represents a
D = Global Disputes Management

DATE_OF_ADJUSTMENT

This field contains the date of the adjustment. The format is: CCYYMMDD

CC = Century
YY = Year
MM = Month
DD = Day

For example, the date October 21st, 2010 would appear as: 20101021

DATE_OF_CHARGE

This field contains the date of the charge. The format is: CCYYMMDD

CC = Century
YY = Year
MM = Month
DD = Day

For example, the date October 21st, 2010 would appear as: 20101021

AMEX_ID

This field contains the American Express ID number of the representative that did the adjustment.

Note: Internal use only.

CASE_TYPE

This field contains a code that indicates the case type assigned to this chargeback by American Express. The entry in this field determines the type of response code that appears in the response file.

AIRDS = Airline Credit Requested
AIRLT = Airline Lost/Stolen Ticket
AIRRT = Airline Returned Ticket
AIRTB = Airline Support of Charge
AREXS = Reservation/Cancellation
CARRD = Car Rental
GSDIS = Goods/Services
NAXMG = Merchandise Not Received
NAXMR = Merchandise Returned
SEDIS = General Dispute
FRAUD = Fraud Dispute
CRCDW = Collision Damage Waiver Liability

LOC_NUMB

This field may contain the store or location number where the charge occurred. Also, refer to LOC_REF_NUMBER.

CB_REAS_CODE

This field contains a three-character, chargeback reason code.

Authorization

A01 - The amount of the Authorization Approval was less than the amount of the Charge you submitted.
A02 - The Charge you submitted did not receive a valid Authorization Approval; it was declined or the Card was expired.
A08 - The Charge was submitted after the Authorization Approval expired.

Cardmember Dispute

C02 - We have not received the Credit (or partial Credit) you were to apply to the Card.
C04 - The goods or services were returned or refused but the Cardmember did not receive Credit.
C05 - The Cardmember claims that the goods/services ordered were cancelled.
C08 - The Cardmember claims to have not received (or only partially received) the goods/services.
C14 - The Cardmember has provided us with proof of payment by another method.
C18 - The Cardmember claims to have cancelled a lodging reservation or a Credit for a CARDeposit Charge was not received by the Cardmember.
C28 - Cardmember claims to have cancelled or attempted to cancel Recurring Billing Charges for goods or services. Please discontinue all future billing for this Recurring Billing Charge.
C31 - The Cardmember claims to have received goods/services that are different than the written description provided at the time of the Charge.
C32 - The Cardmember claims to have received damaged or defective goods/services.

Fraud

F10 - The Cardmember claims they did not participate in this Charge and you have not provided a copy of an imprint of the Card.
F14 - The Cardmember claims they did not participate in this Charge and you have not provided a copy of the Cardmember's signature to support the Charge.
F22 - The Cardmember denies participation in the Charge you submitted and the Card was expired or was not yet valid when you processed the Charge.
F24 - The Cardmember denies participation in the Charge you submitted and you have failed to provide proof that the Cardmember participated in the Charge.
F29 - The Cardmember denies participation in a mail order, telephone order, or internet Charge.
F30 - A counterfeit Chip Card was used at a terminal that was not capable of processing a Chip Card Transaction.
F31 - A lost/stolen/non-received Chip Card was used at a terminal that was not capable of processing a Chip Card Transaction with PIN validation.

Full Recourse

FR2 - The Cardmember denies authorizing the Charge and your Establishment has been placed in the Fraud Full Recourse Program.
FR4 - The Cardmember has disputed the Charge and you have been placed in the Immediate Chargeback Program.
FR5 - Your account is on the Immediate Chargeback program. Under these circumstances, disputed charges are debited from your account with no further recourse. These chargebacks cannot be reversed unless you issue a credit to the account, or the Cardholder advises the charge(s) are valid.
FR6 - The Cardmember has disputed the Charge and you have been placed in the Partial Immediate Chargeback Program.

Processing Error

P01 - You have submitted a Charge using an invalid or otherwise incorrect Card Number.
P03 - The Cardmember claims the Charge you submitted should have been submitted as a Credit.
P04 - The Cardmember claims the Credit you submitted should have been submitted as a Charge.
P05 - The Charge amount you submitted differs from the amount the Cardmember agreed to pay.
P07 - The Charge was not submitted within the required timeframe.
P08 - The individual Charge was submitted more than once.
P22 - The Card Number in the Submission does not match the Card Number in the original Charge.
P23 - The Charge was incurred in an invalid currency.
P09 - We have processed duplicate payments to your account for the same transaction.

Miscellaneous Adjustments and Resolutions

M49 - The Cardmember claims to have been incorrectly Charged for theft, loss of use, or other fees related to theft or loss of use of a rental vehicle.
M01 - We have received your authorization to process Chargeback for the Charge.
M10 - The Cardmember claims to have been incorrectly billed for Capital Damages.

Chargeback Reversal Adjustments

M11 - We recently debited your account for the adjustment amount indicated. We have now received your credit for this charge and we are reversing the debit and crediting your account.
M38 - We recently debited your account for the adjustment amount indicated. We are now reversing the debit and crediting your account

Non-dispute Adjustments

M19 - According to our records, your credit was inadvertently deducted from another merchant's account. This has now been corrected, and a debit for this amount will be issued. We apologize for any inconvenience this may have caused.
M21 - Our records indicate that your charge or summary was inadvertently paid to another merchant. This has been corrected and a credit has been issued.
M22 - Our records indicate that your service establishment was inadvertently paid for a submission sent to us by another service establishment. To correct this erroneous payment, an adjustment debiting your account has been processed.
M23 - A review of our records indicates that your service establishment inadvertently cashed a check that belonged to another service establishment. To correct this erroneous payment, an adjustment debiting your account for the amount of this check has been processed. Please submit your charges to cover this amount, or send us a check as soon as possible.
M24 - We have processed an adjustment transferring a debit balance from your previous account to the account listed. This balance owed us was aging on an account that is no longer active.
M25 - Our records indicate that your affiliated account has an outstanding debit balance. This debit has not cleared because charges are no longer being submitted by this account. Consequently, we have processed an adjustment to transfer this debit to your account.
M27 - Your cheque was returned to us by your bank. Since your account was previously credited for this cheque, we are debiting your account for the amount involved. Please send us a replacement cheque immediately.
M28 - According to our records, an incorrect discount rate was applied to your summaries. Since the rate should have been lower, credit has been issued.
M29 - The invoice and report provided includes details regarding discount fees for American Express charges processed for the month indicated. This invoice amount will be debited to your bank account.
M32 - We have processed an adjustment to your account. This adjustment represents your share of the media costs incurred in your participation in our cooperative advertisement program.
M33 - In accordance with your request, an adjustment to your account has been processed.
M39 - We have issued an adjustment to your account to correct a transaction that was previously processed in error.
M43 - We have processed an adjustment to your account. This adjustment represents your participation in American Express Marketing Programs. Our records indicate a recent change in payment options for your participation. Therefore, future adjustments will be invoiced on a monthly frequency.
M44 - We have processed an adjustment to your account. This adjustment represents your participation in American Express Marketing Programs. Our records indicate a recent change in payment options for your participation. Therefore, future adjustments will be deducted on a monthly frequency from payments for charges submitted.
M45 - A review of our records indicates that a cheque was applied to your account in error. Therefore an adjustment has been processed to debit your account.
M46 - We have determined that your establishment was inadvertently debited for item(s) which were submitted to us by another establishment. To correct this erroneous debit, an adjustment crediting your account has been processed, and will be included in a future statement.

Informational Chargeback Reason Codes

M02 - The Cardmember no longer disputes the charge(s). Please discontinue further investigation.
M04 - We previously received your authorization to debit your account. Please deal directly with the Cardholder for resolution on this matter.
M36 - Please see the additional notes related to this dispute.
M42 - Due to the length of time between the chargeback to your account and receiving your dispute, we are unable to review this for reversal.

Retrieval/Support

R03 Complete support and/or documentation were not provided as requested.
R13 We did not receive your response to our Inquiry within the specified timeframe.

Status Updates

S01 - Your request for a chargeback reversal has been reviewed. The chargeback will remain, and your account will not be credited.
S03 - Support received.
S04 - We have received your request for a chargeback reversal. Please allow 2 to 3 weeks for research.

CB_AMOUNT

Numeric, signed, with decimal point and two decimal places, right justified, zero filled

This field contains the adjustment or chargeback amount, which can be a debit or credit. The format for this field is a one-digit "sign,"” followed by a 13-digit "dollar amount" (right justified and zero filled), one-digit "decimal point," and two-digit "cents." For negative amounts, the first-digit "sign" is a negative sign. For a "negative $100.00", this would appear as:

0         1
12345678901234567
-----------------
-0000000000100.00

For a positive amount, the first-digit "sign" is a blank (character space), which would appear as:

0         1
12345678901234567
-----------------
_0000000000100.00

Note: The underline character ( _ ) represents a character space.

CB_ADJUSTMENT_NUMBER

This field contains the Chargeback Adjustment Number.

Note: This is the Adjustment Number that appears in the associated financial file and corresponds to the financial reporting specification.

CB_RESOLUTION_ADJ_NUMBER

This field contains the Chargeback Resolution Adjustment Number, if applicable. Normally blank (character space filled), this field is only populated when this record is a combination resolution and adjustment (such as in the reversal of a prior chargeback).

Note: This is the Adjustment Number that appears in the associated financial file and corresponds to the financial reporting specification.

CB_REFERENCE_CODE

This field contains the merchant’s reference number that was assigned to the transaction by the merchant when the charge was originated, to help identify this specific charge. For Reference Numbers greater than 12 digits, refer to IND_REF_NUMBER.

BILLED_AMOUNT

This field contains the statement bill amount or ROC amount, which can be a debit or credit. The format for this field is a one-digit "sign," followed by a 13-digit "dollar amount" (right justified and zero filled), one-digit "decimal point," and two- digit "cents."

For negative amounts, the first-digit "sign" is a negative sign, which would appear as:

0         1
12345678901234567
-----------------
-2345678901234.67

For a positive amount, the first-digit "sign" is a blank (character space), which would appear as:

0         1
12345678901234567
-----------------
_2345678901234.67

Where the underline character represents a character space.

Note: The entries in CB_AMOUNT and BILLED_AMOUNT fields may differ.

SOC_AMOUNT

This field contains the Summary of Charge (SOC) or Summary Amount, which can be a debit or credit. The format for this field is a one-digit "sign," followed by a 13-digit "dollar amount" (right justified and zero filled), one-digit "decimal point," and two-digit "cents."

For negative amounts, the first-digit "sign" is a negative sign, which would appear as:

0         1
12345678901234567
-----------------
-2345678901234.67

For a positive amount, the first-digit "sign" is a blank (character space), which would appear as:

0         1
12345678901234567
-----------------
_2345678901234.67

Where the underline character represents a character space.

SOC_INVOICE_NUMBER

This field contains the Summary of Charge (SOC) Invoice Number that corresponds to the batch in which the merchant submitted the charge for payment.

ROC_INVOICE_NUMBER

This field contains the Record of Charge (ROC) Invoice Number that corresponds to the charge that the merchant submitted for payment.

FOREIGN_AMT

This field contains the Foreign Amount (the disputed amount, if the charge was made in a currency other than US Dollars).

If unused, this field is character space filled.

CURRENCY

This field contains the currency code that corresponds to the value in the FOREIGN_AMT field.

124 CAD Canada
840 USD United States

If unused, this field is character space filled.

SUPP_TO_FOLLOW

This field contains a code that indicates whether additional support is being forwarded. The codes are:

Y = Support is coming via mail or fax.
I = A scanned image provides support.
R = Both forms of support to follow: Mail or fax, and scanned image.
N = No support.

CM_NAME1

This field contains the Card members name, concatenated from the following fields:

CM_FIRST_NAME_1
CM_MIDDLE_NAME_1
CM_LAST_NAME_1

CM_NAME2

This field contains a secondary Card member name. Usually, this is the name of a supplemental cardholder to the primary Card members account.

CM_ADDR1

This field contains the first line of the Card member’s street address.

CM_ADDR2

This field contains the second line of the Card member’s street address.

CM_CITY_STATE

This field contains the city and state portion of the Card member's address.

CM_ZIP

This field contains the ZIP code portion of the Cardmember's address.

For U.S. addresses, this is may be a 9-digit "5+4" ZIP code, or a 5-digit ZIP code, left justified and zero filled to 9 digits.

Alphanumeric Canadian postal codes are left justified and padded with zeros or character spaces.

If ZIP code is unavailable, this field is zero filled.

CM_FIRST_NAME_1

This field contains the first name of the Cardmember who made the charge.

Note: The value in this field is a component of the entry in the CM_NAME1 field.

CM_MIDDLE_NAME_1

This field contains the middle name of the Card member who made the charge.

Note: The value in this field is a component of the entry in the CM_NAME1 field.

CM_LAST_NAME_1

This field contains the last name of the Card member who made the charge.

Note: The value in this field is a component of the entry in the CM_NAME1 field.

CM_ORIG_ACCT_NUM

This field contains the Cardmember Account Number that corresponds to this chargeback.

Developer note: the documentation for this field sometimes refers to it as CM_ACCT_NUM, which conflicts with an earlier field.

CM_ORIG_NAME

If the Card member has a different name, this field contains the Card member’s original name at the time the charge was made.

If this field is populated, it contains the Card members original name, concatenated from the following fields:

CM_ORIG_FIRST_NAME
CM_ORIG_MIDDLE_NAME
CM_ORIG_LAST_NAME

CM_ORIG_FIRST_NAME

If the Card member has a different name, this field contains the Card member’s original first name at the time the charge was made.

Note: The value in this field is a component of the entry in the CM_ORIG_NAME field.

CM_ORIG_MIDDLE_NAME

If the Card member has a different name, this field contains the Card member’s original middle name at the time the charge was made.

Note: The value in this field is a component of the entry in the CM_ORIG_NAME field.

CM_ORIG_LAST_NAME

If the Card member has a different name, this field contains the Card member’s original last name at the time the charge was made.

Note: The value in this field is a component of the entry in the CM_ORIG_NAME field.

NOTE1

Case notes may appear in the fields labeled Note1 through Note7.

NOTE2

Case notes may appear in the fields labeled Note1 through Note7.

NOTE3

Case notes may appear in the fields labeled Note1 through Note7.

NOTE4

Case notes may appear in the fields labeled Note1 through Note7.

NOTE5

Case notes may appear in the fields labeled Note1 through Note7.

NOTE6

Case notes may appear in the fields labeled Note1 through Note7.

NOTE7

Case notes may appear in the fields labeled Note1 through Note7.

TRIUMPH_SEQ_NO

This field contains the Triumph Sequence Number and is an internal field used by American Express.

AIRLINE_TKT_NUM

This record only pertains to airline case types; e.g., CASE_TYPE = AIRDS, AIRLT, AIRRT or AIRTB). For these case types this field may contain the airline passenger ticket number.

AL_SEQUENCE_NUMBER

This record only pertains to airline case types. If this record involves multiple airline tickets, this field contains the sequence number.

FOLIO_REF

If this record pertains to a hotel chargeback, this field contains the hotel reference number (if applicable).

For all other transactions — this field is unused and is character space filled.

MERCH_ORDER_NUM

This field contains the merchandise order number (if applicable).

MERCH_ORDER_DATE

This field contains the merchandise order date (if applicable).

The format is: CCYYMMDD

CC = Century
YY = Year
MM = Month
DD = Day

For example, the date October 21st, 2010 would appear as: 20101021

CANC_NUM

This field contains the cancellation number (if applicable).

CANC_DATE

This field contains the cancellation date (if applicable).

The format is: CCYYMMDD

CC = Century
YY = Year
MM = Month
DD = Day

For example, the date October 21st, 2010 would appear as: 20101021

FINCAP_TRACKING_ID

For FINCAP transactions — This field contains the FINCAP load number that is composed of the Julian date, the PCID and the sequence number.

The format is: JJJPPPPPPSS

JJJ = Julian date
PPPPPP = PCID
SS = Sequence number

For all other transactions — This field is unused and is character space filled.

Note: This field is part of the “FINCAP Area.”

FINCAP_TRACKING_DATE

FINCAP_TRACKING_PCID

FINCAP_TRACKING_SEQUENCE

FINCAP_FILE_SEQ_NUM

For FINCAP transactions — This field contains the FINCAP file sequence number.

For all other transactions — This field is unused and is character space filled.

Note: This field is part of the “FINCAP Area.”

FINCAP_BATCH_NUMBER

For FINCAP transactions — this field contains the FINCAP batch number.

For all other transactions — this field is unused and is character space filled.

Note: This field is part of the “FINCAP Area.”

FINCAP_BATCH_INVOICE_DT

For FINCAP transactions — This field contains the batch invoice date.

The format is: CCYYMMDD

CC = Century
YY = Year
MM = Month
DD = Day

For example, the date October 21st, 2010 would appear as: 20101021

For all other transactions — This field is unused and is character space filled.

Note: This field is part of the “FINCAP Area.”

LABEL1

This field is reserved for use by upstream host systems that may download undefined “free form” data. This field may contain additional information pertaining to the case. If unused, it is character space filled.