A Glossary of Report Field Names

This page is designed to provide a list of field names that appear on reports and an explanation of the data that is presented. It will also provide the report names on which the field is available. The list is presented in alphabetical order. 

Field name Explanation/Description Visible on these reports:
Acquirer Reference Number This field presents a unique 23-digit number linked to online Visa and MasterCard credit/debit transactions between a merchant's bank and the cardhlder's bank. The ARN is created when a transaction is processed via a payment gateway. 
Actions This field presents a unique 23-digit number linked to online Visa and MasterCard credit/debit transactions between a merchant's bank and the cardhlder's bank. The ARN is created when a transaction is processed via a payment gateway. 
Activated Amount This field displays the amount loaded onto the Gift Card within the selected month.
Activated Count This field displays the total quantity of Moneris Gift Cards activated at this location within the date range. 
Adjustment Amount This field displays the total dollar amount of balance adjustments made to Moneris Gift Cards at this location within the date range. 
Adjustment Count This field displays the total quantity of balance adjustments made to Moneris Gift Cards at this location within the date range. 
Authorization Code This is a unique 6-digit code assigned to the authorization of the original transaction.
Authorization Number An alphanumeric field that indicates the Authorization identifier of the
transaction.
Average Purchase This field displays the average purchase (redemption) amount of Moneris Gift Cards that were redeemed at this location within the date range.
Bank Account Identifies the bank account which the payment is to be credited to or debited from.
Batch
This 6-digit value is the number assigned by Moneris to a group of transactions sent to Moneris for settlement at the same time (e.g., at end of day). The batch may include multiple transactions.  
Batch Number This 6-digit value is the number assigned by Moneris to a group of transactions sent to Moneris for settlement at the same time (e.g., at end of day). The batch may include multiple transactions.  
Batched / Duplicate Indicator

This 1-digit value is only applicable to some American Express disputes. It indicates if the dispute is applicable to multiple (batch) transactions or if it is for a transaction processed a second time in error (duplicate). 

  • Value B = Batch chargeback
  • Value D = Duplicate chargeback
  • Value " " = Not a batch or duplicate chargeback.
Cardholder Number This is the 16-19-digit credit/debit card number used by the cardholder to process the original transaction. 
Cardholder Origin

This 4-digit code represents the origin of the card's issuing bank. 

  • Value IERR = foreign
  • Value IRAC = domestic
  • Value IRAR = domestic
  • Value ONUS = domestic
Cardholder Transaction Amount This is the dollar amount of original sales transaction between the merchant and cardholder, and represents the transaction amount settled to the  cardholder. Negative transaction amounts are displayed with a leading minus sign.
Cardholder Transaction Currency This 3-digit value represents the ISO currency code. 
Card Type

The type of card used for a transaction. 

  • Value 01 = Visa
  • Value 02 = MasterCard
  • Value 03 = American Express
  • Value 06 = Discover
  • Value 07 = Sears
  • Value 08 = HSBC card
  • Value 09 = PWB card
  • Value 10 = Interac
  • Value 11 = Air Miles
  • Value 12 = CITICOMM
  • Value 13 = Cheque authorization
  • Value 14 = Maestro
  • Value 15 = JCB
  • Value 16 = UnionPay
  • Value PG = PetroTrak 
Case ID This unique 12-digit number is assigned by Moneris to identify Copy Requests and Chargebacks. 
Case Record Number This 2-digit value is the sequential number associated with each Case ID.
Case Status

This 2-digit value represents the status of the case being investigated. Values include:

  • Blank = Pending response
  • F = Fulfilled
  • FI = Fulfilled with illegible/incomplete
  • I = Illegible
  • U = Incomplete
  • C = Closed - response not received
Chain This 11-digit number is the unique number assigned by Moneris identifying the Chain.
Chain Number This is a unique 13-digit number assigned by Moneris to identify the chain. 
Chargeback Event Date This 8-digit value represents the date the Chargeback, Reverse Chargeback (Representment), or Second Chargeback was processed by Moneris. The date is presented in YYYYMMDD format. 
Chargeback Event Type

This 1-digit value means the following:

  • Value 1 = Original chargeback
  • Value 2 = Representment - the reversal of the original chargeback
  • Value 3 = Reversal of reversed chargeback 
  • Value 4 = Second Representment - reversal of the second chargeback 
  • Value 5 = Declined on first chargeback rebuttal
  • Value 6 = Declined on second chargeback rebuttal
  • Value 7 = Special handling
  • Value 8 = Merchant response acknowledgement 
  • Value A = Pre-compliance adjustment
  • Value B = Pre-compliance adjustment reversal
  • Value C = Declined on pre-compliance rebuttal
  • Value D = Pre-compliance clode decision
  • Value J = Arbitration case decline - final
  • Value K = Arbitration ruling decline
  • Value L = Arbitration adjustment
  • Value M = Arbitration adjustment reversal
Chargeback Reason Code This 6-digit value represents the reason the chargeback was requested/processed. Refer to the Chargeback/Decline Reason Codes topic for more information. 
Chargeback Type This is the same as the Chargeback Event Type.  
Clerk ID This is the ID assigned by the merchant to the clerk/operator of the terminal which processed the transaction. Only available if the POS device has the relevant functionality. 
Closing Balance This field displays the total liability that the merchant has for Moneris Gift Cards that have been activated but not fully redeemed by the cardholder for the selected month. This value may be a positive or negative amount.
Copy Request Date Date of the request for a copy of the Sales draft which was sent to the merchant. The date is presented in YYYYMMDD format. 
Copy Request Type The Copy Request type refers to the first or second request for information regarding the transaction in question.  
Currency

This 3-digit value identifies the currency of the original transaction. 

Value CAD = Canadian

Value USD = US

Currency Conversion Indicator

This 1-digit value appears if Dynamic Currency Conversion (DCC) occurred during the original transaction. 

  • Value D = DCC transaction
  • Value M = Multicurrency Pricing (MCP) transaction
  • Value " " = Single currency transaction (DCC & MCP not used when transaction was processed)
Customer ID This value represents the ID of the customer associated with the transaction. 
Date of Illegible Notification

If available, this value indicates the date Moneris informed customer that an illegible Sales Draft was received. The date is presented in YYYYMMDD format.

If no notification was sent, this shows as zeroes.

Date of Incomplete Notification

The data for this field is currently available if the original transaction date was after April 15, 2012. If available, this value indicates the date Moneris informed the customer that an incomplete Sales Draft was received. The date is presented in YYYYMMDD format.

If no notification was sent, this shows as zeroes.

Date This field represents the date of the transaction. The date is presented in YYYYMMDD format.
Deactivated Amount This field displays the total dollar amount of Moneris Gift Cards which were deactivated at this location within the date range.
Deactivated Count This field displays the total number of Moneris Gift Cards deactivated at this location within the date range. 
Description This field can contain up to 60 characters and is a description of fee programs. 
Device This is the device ID of the POS device (e.g., Moneris terminal or PINPad) used to perform the transaction. 
Device Number This value represents the 8-digit Moneris device ID on which the transaction was processed.
Dispute Category

This 1-digit value represents the process flow defined for the chargeback. 

Value C = Collaboration

Value A = Allocation

Value " " = Not applicable 

Disputed Amount This 14-digit value appears for disputed American Express or JCB card types. It represents the amount the cardholder is disputing. This will show 0 for all other card types.
Disputed Amount Currency This 3-digit ISO code is populated for American Express or JCB card types. It will be blank for all other card types. 
Entry Method

This field indicates how the Moneris Gift Card was entered at the point of sale.

Possible values include Swiped, Keyed, or Unknown.

Expiry Amount This field displays the total dollar amount of Moneris Gift Cards which expired at this location within the date range. 
Expiry Count This field displays the total quantity of Moneris Gift Cards which expired at this location within the date range. 
Expired Cards Amount This field displays the total dollar value remaining on Moneris Gift Cards that have expired within the selected month. 
Fee Program This 4-digit code identifies the interchange fee applied to the transaction. Refer to the Fee Program Descriptions topic for more information. 
Fee Program Code This is the combination of card type, fee program region, and fee program code. This identifies the interchange fee applied to the transaction. 
Fee Program Region

Indicates whether the fee program is Canadian or international. 

  • Value INT = International
  • Value CAN = Canadian
Fulfilled Date This is the date that the Copy Request was fulfilled. The date is presented in YYYYMMDD format.  If the Copy Request is not fulfilled, this will be presented as zeroes.
Gift Card Number This field displays the 19-digit gift card number that was used in the transaction. 
Invoice Number

This value is available only if entered by the merchant and the POS device has the relevant functionality. 


ONLY included on the CSV from the Chain report.

Markup % Rate

This field refers to the percentage that is added to the total sale when Dynamic Currency Conversion (DCC) or Multi-Currency Pricing (MCP) is selected.  

Merchant This is the 13-digit Moneris merchant ID that processed the transactions. 
Merchant Adjustment Amount The actual amount of the chargeback or representment (Reverse Chargeback), or second chargeback. Always zero for additional transactions in duplicate or batched chargeback.
Merchant Adjustment Currency

This 3-digit field shows the currency in which the adjustment was made from the Merchant’s bank. The values are either CAD or USD. 

Merchant Name This field displays the merchant's name associated with the merchant account. 
Merchant Number This is a unique 13-digit number assigned by Moneris to identify the merchant.
Merchant Reference Number If available, this is the identifier assigned by the merchant to the original transaction.
Merchant Settled Transaction Amount This is the dollar amount of original sales transaction between merchant and cardholder. It represents the transaction amount settled to the merchant. Negative transaction amounts displayed with a leading minus sign.
Merchant Settled Transaction Currency

This 3-digit code represents the transaction currency settled to the merchant. 

  • Value CAD = Canadian $
  • Value USD = U.S. $
Month This field lists the month and year (e.g., April 2024) during which the transactions occurred. 
Net Total A calculation of the Sales/Payment Corrections minus Refunds/Payments.
No Recourse Flag

This 1-digit value indicates whether or not there is a recourse for the chargeback. 

  • Value Y = No recourse for this chargeback.
  • Value N = Recourse possible for this chargeback. 
Order ID This value represents the Moneris order ID associated with the transaction.
Original Date This field shows the date on which the transactions were originally processed. The date is presented in YYYYMMDD format.
Original Transaction Date This is the date of the original transaction between the merchant and cardholder. The date is presented in YYYYMMDD format.  
Partial Chargeback Indicator

This 1-digit value is only applicable to some American Express disputes. “P" indicates if the dispute is for only part of a transaction amount. This will always appear blank for additional transactions in duplicate or batched disputes.

  • Value P = Partial Copy Request
  • Value " " = Not a Partial Copy Request
Partial Copy Request
  • Value P = Partial Copy Request
  • Value " " = Not a Partial Copy Request
Payment Amount This 13-digit value is the amount of the payment transaction after deposit retention. This is the amount that will actually be deposited into the bank account.
Payment Date This 8-digit field represents the date the payment transaction was issued. The date is presented in YYYYMMDD format.  
Point of Sale Entry Mode

This field lists a 2-digit code representing how the card was entered at the point of sale. 

  • Value 00 = PAN entry mode unknown
  • Value 01 = PAN manual entry
  • Value 02 = PAN auto-entry via magnetic stripe
  • Value 03 = PAN auto-entry via barcode reader
  • Value 04 = PAN auto-entry via Optical Character Read (OCR)
  • Value 05 = PAN auto-entry via chip 
  • Value 06 = PAN auto-entry via chip, contactless mapping service applied
  • Value 07 = PAN auto-entry via contactless mobile/chip
  • Value 09 = PAN entry via electronic commerce, including remote chip
  • Value 10 = Credential on file
  • Value 79 = Chip card at a chip-capable terminal was unable to process the transaction using data on the chip or magnetic strip - PAN entry via manual entry
  • Value 80 = Chip card at a chip-capable terminal was unable to process the transaction using data on the chip or magnetic strip - terminal defaulted to magnetic stripe-read PAN
  • Value 81 = PAN entry via electronic commerce, including chip
  • Value 82 = PAN auto-entry via server (issuer, acquirer, or third-party vendor system)
  • Value 90 = PAN auto-entry via magnetic stripe - full track data has been read without alteration or truncation
  • Value 91 = PAN entry via contactless magnetic stripe
  • Value 95 = Visa only - Chip card with unreliable Card Verification Value (CVV) data
Pre-Tax Amount This field provides the amount of the fee before tax is applied. 
Province This is a 2-digit value representing the merchant's province. 
Purchase Amount This is the total dollar value of gift cards that have been used by cardholders for purchases during the reporting month.
Real Time Fund Amount This alphanumeric field shows the amount leveraged in a Moneris Real Time Funds transaction. 
Real Time Fund Count This alphanumeric field shows the number (quantity) of Moneris Real Time Funds transactions. 
Reason Code This 4-digit value refers to the reason the copy request was requested/processed. Refer to the Copy Request Reason Codes topic for more information. 
Refund Amount The total dollar value of refunds.
Refund Count Total number of refunds.
Report Date This value represents the date chargebacks/adjustments were reported by Moneris. The date is presented in YYYYMMDD format. 
Response Due Date

If a Copy Request is outstanding or illegible or incomplete, it will show the last date by which the requested Sales Draft must be received by Moneris. The date is presented in YYYYMMDD format.  

If a Copy Request has been fulfilled, or if past the Response Due Date, field is blank.

If the Response Due Date not available and a Copy Request was not fulfilled, "N/A" is displayed in the field.

Retained Amount This value is the amount retained due to deposit retention.
Sales Amount The total dollar amount of sales.
Sales Number The total number of sales. 
Settlement Amount Amount of the original settlement, prior to performing deposit retention.
Settlement Date This field provides the date the transactions were first processed at Moneris. The date is presented in YYYYMMDD format. 
Starting Balance This field displays the total dollar amount of unused value on Moneris Gift Cards that have been activated but not fully redeemed by cardholders as of the beginning of the month. The Starting Balance in the current month is the same as the Closing Balance in the previous month.
Store Number This is the merchant store number assigned by the customer. 
Supporting Documentation

This 1-digit value is only applicable to some American Express disputes. 

  • Value Y = Supporting documents sent by Moneris to the merchant.
  • Value N = No supporting documents were sent by Moneris to the merchant. 
  • Value " " = N/A 

[Tax] Amount

(PST, HST, GST, QST)

This 11-digit value represents the amount of provincial/federal tax that is included in the payment amount for fee payment transactions.
Terminal ID This 8-digit value is the terminal used to process an online transaction. 
Tier

This 4-digit code is used in calculating the Merchant Discount Rate (MDR). 

Refer to the Tier Codes topic for more information. 

Token Data Key If the transaction was tokenized using Moneris Vault solution, this is the token associated with the card number. This field will only be populated if the card number is masked. 
Total Number of Transactions This field displays the total number of transactions in which the Moneris Gift Card was used during the date range. 
Transaction Amount This field displays the amount of the transaction redeemed/loaded/adjusted on the Moneris Gift Card. This field will display negative numbers for Payments, Refunds, or Purchase Corrections. 
Transaction Date This is the date on which the original transaction was processed between the merchant and cardholder. The date is presented in YYYYMMDD format. 
Transaction ID This field displays the unique transaction ID, also known as the Ref # for the transaction involving a Moneris Gift Card.
Transaction Reference ID

This unique 17-digit value represents the transaction, and is comprised of the following information:

  • Characters 1-8 = ECR/Terminal ID
  • Characters 9-11 = Shift number
  • Characters 12-14 = Batch number
  • Characters 15-17 = Sequence number
Transaction Reference Number

This 17-digit value is the reference number to uniquely identify transactions. It consists of: 

Bytes 1-8 – ECR/Terminal Number
Bytes 9-11 = shift #
Bytes 12-14 = batch number
Bytes 15-17 = Sequence Number

Transaction Response This 2-digit code represents the response from the card issuer. Refer to the Transaction Response Codes topic for more information. 
Transaction Time This is the time the transaction takes place at the Point of Sale terminal. The time is presented in HH:MM:SS format. Displays as "00:00:00" if no value is  available.
Transaction Type

This value identifies whether the original transaction is a Purchase, Refund, Payment, or a Correction. 

  • Value 1 = Purchase
  • Value 4 = Refund
  • Value 6 = Refund correction
  • Value 7 = Purchase correction
  • Value 8 = Payment 
  • Value 9 = Payment correction
View Details This function enables you to view transaction details for a selected transaction. 
Void Adjustment Amount This field displays the total dollar value of any void transactions performed by the merchant or at the Processing Centre to correct previous transactions within the selected month.
Void/Refund Amount This field displays the total dollar value of Gift refunds or voids processed at this location within the date range. 
Void/Refund Count This field displays the total quantity of Gift refunds or voids processed at this location within the date range.