Report field glossary

A detailed record of every payment event (sales, authorizations, captures, voids, refunds, and so on), with amounts, status, card or ACH details, interchange, fees, and response codes. Used for operational review, reconciliation, and dispute investigation.

• Created AtDate-time (UTC)

  Timestamp when the transaction or event was created (UTC). The Timezone column shows the designated report timezone.

• TimezoneText (ET | CT | MT | PT | AT | AKT | HT | NT | UTC)

  Designated timezone for this report (user profile or report selection). Date/time values themselves are output in UTC. Allowed: ET, CT, MT, PT, AT, AKT, HT, NT, or UTC. CSV only.

• Payment IDUUID

  Unique identifier of this transaction or event.

• Account NameText

  Internal merchant or account name.

• Merchant DBA NameText

  Doing Business As name shown to the cardholder.

• Merchant NumberText

  Merchant ID (MID).

• Payment SourceText (Card | ACH)

  Instrument used: Card or ACH.

• Transaction TypeText (Title-case)

  Type of event (Sale, Authorization, Capture, Void, Refund, Credit, Increment, Cancel, etc.).

• Transaction StateText (Title-case)

  Lifecycle state (Funded, Settled, Completed, Failed, Voided, Refunded, Open, etc.).

• AmountCurrency

  Positive face value of the event.

• NetNumber (signed; e.g. 10.00, -5.00)

  Signed balance impact of the event (positive for successful sales/captures, negative for successful refunds/credits, zero otherwise).

• Surcharge AmountCurrency

  Surcharge applied, if any.

• Authorization CodeText

  Auth code returned by the issuer or processor.

• ApprovedCurrency

  Amount approved by the issuer.

• CapturedCurrency

  Amount actually captured.

• Capture DetailsJSON text

  JSON metadata about captures (e.g. list of capture IDs and remaining amount).

• RefundedCurrency

  Amount refunded, when present.

• Refund DetailsJSON text

  JSON metadata about refunds.

• VoidedCurrency

  Amount voided, when present.

• SettledCurrency

  Settled amount once settlement occurs.

• Settled AtDate-time (UTC)

  Settlement timestamp (UTC).

• Funded AtDate-time (UTC)

  Funding timestamp , when money becomes available to the merchant (UTC).

• Tax AmountCurrency

  Tax portion of the transaction.

• Tip/GratuityCurrency

  Tip or gratuity amount.

• MethodText

  How the payment was entered or tokenized (platform-token, raw-data, ach, tap, dipped, swiped).

• ChannelText

  Channel type: ecommerce or card-present.

• Interchange CodeNumber / Text

  Interchange category code.

• Interchange DescriptionText

  Human-readable interchange category name.

• Int. PercentNumber

  Interchange rate.

• Int. FlatNumber

  Flat interchange fee component.

• Interchange AmountCurrency

  Total interchange amount in currency.

• Partner Gross AmountCurrency

  Gross amount attributed to the partner.

• Partner Fees AmountCurrency

  Fees attributed to the partner.

• Partner Net AmountCurrency

  Net amount to the partner.

• Merchant Gross AmountCurrency

  Gross amount before merchant fees.

• Merchant Fees AmountCurrency

  Fees charged to the merchant.

• Merchant Net AmountCurrency

  Net amount to the merchant after fees.

• Currency CodeISO 4217

  Currency of the transaction (e.g. USD).

• Card HolderText

  Name on the card or account.

• Card NumberText (masked)

  Masked card or account number (last 4 digits only).

• Expiry MonthInteger (1 to 12)

  Card expiry month (1 to 12). Blank for ACH.

• Expiry YearInteger (YYYY)

  Card expiry year (YYYY). Blank for ACH.

• Card TypeText

  Brand (Visa, MasterCard, Amex, Discover, etc.).

• BIN TypeText

  Classification such as Visa-Credit, Visa-Debit, ACH-checking, MasterCard-Unavailable.

• BIN / Routing NumberText

  Card BIN or bank routing number.

• Bank Response CodeText

  Issuer response code (cards) or NACHA return code (ACH). Examples: 00, 51, R01.

• Bank Response MessageText

  Corresponding bank or issuer message. Examples: Approved, Insufficient Funds.

• Exact Response CodeText

  Gateway-level response code (e.g. PE1).

• Exact Response MessageText

  Gateway-level message (decline reasons, etc.).

• Soft Descriptor DBA NameText

  Soft-descriptor DBA name override.

• Soft Descriptor StateText

  Soft-descriptor state.

• Soft Descriptor PhoneText

  Soft-descriptor phone.

• AVS Response CodeText

  Address Verification System result code.

• AVS Response MessageText

  AVS result message.

• CVC Response CodeText (M | N | P)

  Card Verification Code result. Allowed: M (Match), N (No Match), P (Not Processed).

• CVC Response MessageText

  CVC result message.

• E-Commerce IndicatorText (1 to 8)

  E-commerce indicator code sent with the payment. Allowed codes 1 through 8.

• Customer ReferenceText

  Merchant-supplied customer reference.

• Related Payment IDUUID / Text

  Links child events (Capture, Void, Refund, Increment, etc.) to the original transaction's Payment ID.

• Decline CodeText

  Specific decline code.

• Decline ReasonText

  Human-readable decline reason.

• Next StepsText

  Suggested next action or guidance (e.g. Get new card from cardholder).

Merchant and account profiles, including status, boarding information, processing volumes, risk indicators, and configuration settings. Used for portfolio management and account monitoring.

• StatusText

  Current status of the merchant account (e.g. autoApproved).

• Status Change ReasonText

  Reason code or category for the most recent status change.

• Status Change Reason NoteText

  Free-text note explaining the status change.

• OrganizationText

  Partner or organization the account belongs to.

• Account IDText / ID

  Unique identifier of the account.

• Elavon Chain IDText

  Elavon chain identifier associated with the account.

• Merchant NumberText

  Merchant ID (MID).

• Account NameText

  Internal name of the merchant account.

• Merchant DBA NameText

  Doing Business As name of the merchant.

• Entity TypeText

  Legal entity type of the merchant (e.g. US-LLC).

• Registration NumberText

  Business registration or tax identification number.

• Merchant Category CodeNumber / Text

  MCC assigned to the merchant (e.g. 1771).

• Billing Contact NameText

  Name of the billing contact for the merchant.

• Business PhoneText / Phone

  Primary business phone number.

• Business Billing EmailText / Email

  Email address used for billing.

• Merchant Address Line 1Text

  First line of the merchant's business address.

• Merchant Address Line 2Text

  Second line of the merchant's business address.

• Merchant Address CityText

  City of the merchant's business address.

• Merchant Address Postal CodeText

  Postal / ZIP code of the merchant's business address.

• Merchant Address CountryText

  Country of the merchant's business address.

• Merchant Address Country SubdivisionText

  State or province of the merchant's business address.

• KYC Results NameText

  Name of the KYC check recorded for the account (e.g. Rule1, Rule2).

• KYC Results StatusText

  Status of the KYC check (e.g. Failed, Passed).

• Established DateDate-time (UTC)

  Date the business was established (UTC). Timezone column sits to the right of this field.

• TimezoneText (ET | CT | MT | PT | AT | AKT | HT | NT | UTC)

  Designated timezone for this report. Date/time values are UTC. Allowed: ET, CT, MT, PT, AT, AKT, HT, NT, or UTC. CSV only.

• # of EmployeesNumber

  Number of employees at the merchant.

• Web SiteURL / Text

  Merchant website URL.

• Average TicketCurrency

  Average transaction amount (ticket size).

• Maximum Transaction SizeCurrency / Number

  Maximum allowed transaction amount.

• Average Monthly Card VolumeCurrency / Number

  Expected or reported average monthly card processing volume.

• Average Monthly ACH VolumeCurrency / Number

  Expected or reported average monthly ACH processing volume.

• Projected Total Processing VolumeCurrency / Number

  Projected total processing volume.

• Processing CurrencyISO 4217

  Currency in which the merchant processes (e.g. USD).

• Bank Account Holder Legal NameText

  Legal name of the bank account holder.

• Merchant Bank NameText

  Name of the merchant's bank.

• Merchant Routing NumberText (masked/raw)

  Bank routing number (ABA).

• Merchant DDA NumberText (masked)

  Merchant demand deposit account (DDA) number, typically masked.

• Merchant Bank NumberText

  Additional bank number or identifier.

• Merchant Service DescriptionText

  Description of the goods or services the merchant provides.

• Merchant Currently Accepting PaymentsBoolean (true | false)

  Whether the merchant is currently accepting payments.

• Merchant Acceptance Method MotoNumber (e.g. 20)

  Percent of the merchant's volume taken by Mail Order / Telephone Order payments.

• Merchant Acceptance Method InternetNumber (e.g. 25)

  Percent of volume taken by Internet (e-commerce) payments.

• Merchant Acceptance Method SwipeNumber (e.g. 15)

  Percent of volume taken by card-present swipe payments.

• Merchant Acceptance Method KeyedNumber (e.g. 40)

  Percent of volume taken by keyed-in card payments.

• Merchant Recurring ServiceBoolean (true | false)

  Whether the merchant offers recurring billing.

• Merchant Recurring Service DescriptionText

  Description of the merchant's recurring service.

• Merchant Subscription ServicesBoolean (true | false)

  Whether the merchant offers subscription services.

• Merchant Subscription Services DescriptionText

  Description of the merchant's subscription services.

• SurchargingBoolean (true | false)

  Whether the merchant applies surcharging.

• Merchant Refund Policy DescriptionText

  Description of the merchant's refund policy.

• Merchant Payment TimeText

  When the customer pays (e.g. Upon Purchase, Upon Download, At Time of Delivery).

• Merchant Delivery Time FrameText

  Typical delivery time frame (e.g. Immediate, Within 7 days, Within 14 days, Within 30+ days).

• Merchant Principal First NameText

  First name of the primary principal / owner.

• Merchant Principal Last NameText

  Last name of the primary principal / owner.

• Merchant Principal TitleText

  Title of the primary principal (e.g. CEO/President).

• Merchant Principal TelephoneText / Phone

  Telephone number of the primary principal.

• Merchant Principal EmailText / Email

  Email address of the primary principal.

• Merchant Principal Date of BirthDate-time

  Date of birth of the primary principal.

• Merchant Principal Drivers LicenseText (masked)

  Driver's license number (typically masked).

• Merchant Principal Drivers License StateText

  State that issued the principal's driver's license.

• Merchant Principal Drivers License CountryText

  Country that issued the principal's driver's license.

• Merchant Principal SSNText (masked)

  Social Security Number (typically masked).

• Merchant Principal SSN StateText

  State or province code associated with the principal's SSN (e.g. VT, CA).

• Merchant Principal SSN CountryText

  Country code associated with the principal's SSN (e.g. USA, CAN).

• Merchant Principal NationalityText

  Nationality of the primary principal.

• Merchant Principal Percent of OwnershipNumber (0 to 100)

  Percentage of ownership held by the primary principal.

• Merchant Principal Address Line 1Text

  First line of the principal's address.

• Merchant Principal Address Line 2Text

  Second line of the principal's address.

• Merchant Principal Address CityText

  City of the principal's address.

• Merchant Principal Address StateText

  State of the principal's address.

• Merchant Principal Address Postal CodeText

  Postal / ZIP code of the principal's address.

• Merchant Principal Address CountryText

  Country of the principal's address.

• Created AtDate-time (UTC)

  Timestamp when the account was created (UTC).

Settled batches, with settlement dates, amounts, fees, and the related transactions. Used to track when funds move from the processor to the platform.

• Transaction DateDate-time (UTC)

  Date and time the original transaction occurred (UTC). Timezone sits to the right of this field.

• TimezoneText (ET | CT | MT | PT | AT | AKT | HT | NT | UTC)

  Designated timezone for this report. Date/time values are UTC. Allowed: ET, CT, MT, PT, AT, AKT, HT, NT, or UTC. CSV only.

• Payment IDUUID

  Unique identifier of the payment / transaction.

• Payment Gateway IDText

  Identifier of the payment at the gateway layer.

• Account NameText

  Internal name of the merchant account.

• Merchant DBA NameText

  Doing Business As name of the merchant.

• Merchant ID (MID)Text

  Merchant ID (MID).

• Transaction TypeText

  Payment rail or type for the settled item (e.g. Card, ACH).

• Settlement AmountCurrency

  Amount included in settlement for this transaction.

• Surcharge AmountCurrency

  Surcharge amount associated with the transaction, if any.

• Authorization CodeText

  Authorization code from the issuer or processor.

• Settled AtDate-time (UTC)

  Date and time the transaction was settled (UTC).

• Currency CodeISO 4217

  Currency of the settlement (e.g. USD).

• Card HolderText

  Name on the card or account from the original transaction.

• Card NumberText (masked)

  Masked card or account number (typically last 4 digits).

• Expiry MonthInteger (1 to 12)

  Card expiry month (1 to 12). Blank for ACH.

• Expiry YearInteger (YYYY)

  Card expiry year (YYYY). Blank for ACH.

• Card TypeText

  Card brand (e.g. Visa, MasterCard, Amex, Discover). Blank for ACH.

• AVS Response CodeText

  Address Verification System result code from the original transaction.

• AVS Response MessageText

  AVS result message.

• CVC Response CodeText (M | N | P)

  Card Verification Code result. Allowed: M, N, P.

• CVC Response MessageText

  CVC result message.

• E-Commerce IndicatorText (1 to 8)

  E-commerce indicator code sent with the payment. Allowed codes 1 through 8.

• Customer ReferenceText

  Merchant-supplied customer reference from the original transaction.

• Reference NumberText

  Reference number associated with the transaction.

• Batch ReferenceText / Number

  Identifier of the settlement batch this transaction belongs to.

Fund transfers made to merchants or partners, with payout amounts, dates, bank account details, and status. Used for cash flow tracking and merchant statements.

• Transaction DateDate-time (UTC)

  Date and time associated with the payout (UTC). Timezone sits to the right of this field.

• TimezoneText (ET | CT | MT | PT | AT | AKT | HT | NT | UTC)

  Designated timezone for this report. Date/time values are UTC. Allowed: ET, CT, MT, PT, AT, AKT, HT, NT, or UTC. CSV only.

• Payout IDText / ID

  Unique identifier of the payout.

• Account NameText

  Internal name of the merchant account receiving the payout.

• TypeText

  Payout rail or funding type (e.g. card, ach).

• Payout AmountCurrency

  Amount of the payout.

• Payout StatusText

  Current status of the payout. Allowed: pending, approved, failed, voided, settled, returned, not-processed.

ACH credit transactions, such as credits, returns, and NOCs. Used for ACH-specific reconciliation and exception handling.

• Created AtDate-time (UTC)

  Timestamp when the ACH credit transaction was created (UTC). Timezone sits to the right of this field.

• TimezoneText (ET | CT | MT | PT | AT | AKT | HT | NT | UTC)

  Designated timezone for this report. Date/time values are UTC. Allowed: ET, CT, MT, PT, AT, AKT, HT, NT, or UTC. CSV only.

• Payment IDUUID

  Unique identifier of this ACH credit payment.

• Account NameText

  Internal name of the merchant account.

• Merchant DBA NameText

  Doing Business As name of the merchant.

• Merchant NumberText

  Merchant ID (MID).

• Transaction TypeText

  Type of transaction (e.g. ach-credit).

• AmountCurrency

  Amount of the ACH credit.

• Authorization CodeText

  Authorization or reference code returned for the ACH credit.

• Transfer StatusText

  Current status of the ACH credit transfer. Examples: Approved, Pending, Returned.

• Failure Reason CodeText

  Code identifying why the ACH credit failed, when applicable.

• Failure Reason DescriptionText

  Short description of the failure reason.

• Failure Reason ExplanationText

  Longer explanation of the failure reason.

• ACH Debit Payment IDText

  Payment ID of a related ACH debit, if this credit is linked to one.

• Customer ReferenceText

  Merchant-supplied customer reference.

When and how much money becomes available to each merchant, linking settlement to actual availability. Used for merchant cash flow visibility and funding schedule management.

• Payout IDText / ID

  Unique identifier of the payout this funding row belongs to.

• Payout DateDate-time (UTC)

  Date and time of the payout (UTC). Timezone sits to the right of this field.

• TimezoneText (ET | CT | MT | PT | AT | AKT | HT | NT | UTC)

  Designated timezone for this report. Date/time values are UTC. Allowed: ET, CT, MT, PT, AT, AKT, HT, NT, or UTC. CSV only.

• Payout AmountCurrency / Number

  Total amount of the payout.

• Account NameText

  Internal name of the merchant account.

• Merchant DBA NameText

  Doing Business As name of the merchant.

• Merchant NumberText

  Merchant ID (MID).

• TypeText

  Row type (e.g. payout, transaction, fee, fee-collection).

• Transaction TypeText

  Type of the line item (often mirrors Type).

• Transaction AmountCurrency / Number

  Amount of the individual transaction or fee line, when Type is transaction or fee.

• Authorization CodeText

  Authorization code for the underlying transaction, when applicable.

• Account TypeText

  Payment account type for the underlying transaction (e.g. ACH, Visa, MasterCard).

• Account NumberText (masked)

  Masked account or card number (e.g. last 4 digits).

• Account HolderText

  Name of the account or card holder on the underlying transaction.

• Transaction DateDate-time (UTC)

  Date of the underlying transaction (UTC).

• TransactionIdUUID / Text

  Unique identifier of the underlying transaction.

• SalesNumber

  Sales component contributing to the payout total.

• RefundsNumber

  Refunds component contributing to the payout total.

• DisputesNumber

  Card chargebacks only (not other dispute types), as a positive amount in dollars with two decimal places.

• ReturnsNumber

  ACH returns only, as a positive amount in dollars with two decimal places.

• FeesNumber

  Fees component contributing to the payout total.

• OtherNumber

  Other adjustments contributing to the payout total.

• Total AmountNumber

  Sales minus Refunds, Disputes, Returns, and Fees, plus Other.

Chargebacks and disputes, with reason codes, status, amounts, evidence deadlines, and the related transactions. Used for dispute management and win rate analysis.

• Account NameText

  Internal name of the merchant account.

• Merchant DBA NameText

  Doing Business As name of the merchant.

• Case IDText / ID

  Unique identifier of the dispute / chargeback case.

• Dispute StatusText

  Portal-level status (e.g. needs-response, lost, unknown).

• Acquirer Reference NumberText

  Reference number assigned by the acquirer for this case.

• BINText

  Bank Identification Number (first digits of the card).

• Card BrandText

  Card network / brand (e.g. Discover, Visa, MasterCard).

• Card Number Last 4Text (masked)

  Last 4 digits of the card number.

• Case StatusText

  Case lifecycle status from the network/acquirer (e.g. OPEN, CLOSED).

• Chargeback AmountNumber / Currency

  Amount of the chargeback / dispute.

• Chargeback Currency TypeISO 4217

  Currency of the chargeback amount (e.g. USD).

• Chargeback Reference NumberText

  Reference number specific to the chargeback, when present.

• Chargeback TypeText

  Chargeback type code from the network (e.g. D, R).

• Date Received By AcquirerDate-time

  Date/time the acquirer received the chargeback case.

• FIS Transaction IDText / ID

  FIS / processor transaction identifier linked to the case.

• Merchant NameText

  Merchant name as recorded on the case.

• Merchant IDText

  Merchant ID (MID).

• Original Transaction AmountNumber / Currency

  Amount of the original transaction being disputed.

• Original Transaction DateDate-time

  Date of the original transaction being disputed.

• Parent EntityText

  Parent entity identifier associated with the case.

• Pre Arbitration AmountNumber / Currency

  Pre-arbitration amount, if any.

• Pre Arbitration CurrencyISO 4217 / Text

  Currency of the pre-arbitration amount.

• Reason CodeText / Number

  Network reason code for the dispute (e.g. 4755).

• Reason Code DescriptionText

  Human-readable description of the reason code.

• Reply By DateDate-time

  Deadline by which the merchant must respond to the case.

• Report DateDate-time

  Date associated with this report row / extract.

• Represented AmountNumber / Currency

  Amount represented (re-presented) by the merchant, if any.

• Represented Currency TypeISO 4217 / Text

  Currency of the represented amount.

• Latest Stage CodeText

  Code for the latest stage (e.g. CH1 = First Chargeback).

• Latest Stage DescriptionText

  Description of the latest stage (e.g. First Chargeback).

• Latest Action CodeText

  Code for the latest action (e.g. CHGM, MACP, NACP).

• Latest Action DescriptionText

  Description of the latest action (e.g. Charge Merchant, Merchant Accepts Liability).

• TokenText

  Token associated with the payment method, when present.

• Transaction IDText / UUID

  Transaction identifier linked to the dispute, when present.

• Auth CodeText

  Authorization code from the original transaction.

• Customer Field 1Text

  Merchant or gateway customer field / reference value.

• Ticket NumberText

  Ticket number associated with the case, when present.

• Departure DateDate / Text

  Departure date (travel-related custom field), when present.

• Invoice NumberText

  Invoice number associated with the original sale, when present.

• Transaction TimestampDate-time

  Timestamp of the original transaction.