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 |
|
||
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).
|
||
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.
|
||
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.
|
||
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:
|
||
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:
|
||
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.
|
||
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.
|
||
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.
|
||
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.
|
||
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.
|
||
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.
|
||
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.
|
||
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.
|
||
[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:
|
||
Transaction Reference Number |
This 17-digit value is the reference number to uniquely identify transactions. It consists of: Bytes 1-8 – ECR/Terminal 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.
|
||
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. |