Moneris Retail File Batch

Parent: File Batch

Added On: 11/02/15

SQL Table: MONERIS_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: MonerisRetailFileBatch

Moneris specific File Batch representation for the settlement process. It represents a group of Moneris Auth Retail Transaction objects that are settled together as a group within a single file.
During Generation Process, Moneris Retail File Batch is converted into a settlement file, which is then registered into File Store for further processing.

Available Fields:

AmEx Correction Amount
AmEx Correction Count
AmEx Purchase Amount
AmEx Purchase Count
AmEx Refund Amount
AmEx Refund Count
API Token
Auth Code
Bank Totals
Card Type
Closed
Complete
Debit Correction Amount
Debit Correction Count
Debit Purchase Amount
Debit Purchase Count
Debit Refund Amount
Debit Refund Count
Diners Correction Amount
Diners Correction Count
Diners Purchase Amount
Diners Purchase Count

Diners Refund Amount
Diners Refund Count
Discover Novus Correction Amount
Discover Novus Correction Count
Discover Novus Purchase Amount
Discover Novus Purchase Count
Discover Novus Refund Amount
Discover Novus Refund Count
ECR Number
ISO
JCB Correction Amount
JCB Correction Count
JCB Purchase Amount
JCB Purchase Count
JCB Refund Amount
JCB Refund Count
Master Card Correction Amount
Master Card Correction Count
Master Card Purchase Amount
Master Card Purchase Count
Master Card Refund Amount
Master Card Refund Count

Merchant Account Code
Message
Receipt ID
Reference Num
Response Code
Sears Correction Amount
Sears Correction Count
Sears Purchase Amount
Sears Purchase Count
Sears Refund Amount
Sears Refund Count
Store ID
Timed Out
Trans Amount
Trans Date
Trans ID
Trans Time
Trans Type
Visa Correction Amount
Visa Correction Count
Visa Purchase Amount
Visa Purchase Count

Visa Refund Amount
Visa Refund Count

AmEx Correction Amount

Added On: 11/02/15

SQL Column: AMEX_CORRECTION_AMOUNT

Java Field: amexCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by American Express credit card.

AmEx Correction Count

Added On: 11/02/15

SQL Column: AMEX_CORRECTION_COUNT

Java Field: amexCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by American Express credit card.

AmEx Purchase Amount

Added On: 11/02/15

SQL Column: AMEX_PURCHASE_AMOUNT

Java Field: amexPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by American Express credit card.

AmEx Purchase Count

Added On: 11/02/15

SQL Column: AMEX_PURCHASE_COUNT

Java Field: amexPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by American Express credit card.

AmEx Refund Amount

Added On: 11/02/15

SQL Column: AMEX_REFUND_AMOUNT

Java Field: amexRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by American Express credit card.

AmEx Refund Count

Added On: 11/02/15

SQL Column: AMEX_REFUND_COUNT

Java Field: amexRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by American Express credit card.

API Token

Added On: 06/10/16

SQL Column:

Java Field: apiToken

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Auth Code

Added On: 11/02/15

SQL Column: AUTH_CODE

Java Field: authCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Authorization code returned from the issuing institution.

Bank Totals

Added On: 11/02/15

SQL Column: BANK_TOTALS

Java Field: bankTotals

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Bank totals information.

Card Type

Added On: 11/02/15

SQL Column: CARD_TYPE

Java Field: cardType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Type of the credit card used for the transaction.

Closed

Added On: 12/09/15

SQL Column: CLOSED

Java Field: closed

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Inicates that batch is closed.

Complete

Added On: 11/02/15

SQL Column: COMPLETE

Java Field: complete

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Transaction was sent to authorization host and a response was received.

Debit Correction Amount

Added On: 11/02/15

SQL Column: DEBIT_CORRECTION_AMOUNT

Java Field: debitCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by Debit card.

Debit Correction Count

Added On: 11/02/15

SQL Column: DEBIT_CORRECTION_COUNT

Java Field: debitCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by Debit card.

Debit Purchase Amount

Added On: 11/02/15

SQL Column: DEBIT_PURCHASE_AMOUNT

Java Field: debitPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by Debit card.

Debit Purchase Count

Added On: 11/02/15

SQL Column: DEBIT_PURCHASE_COUNT

Java Field: debitPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by Debit card.

Debit Refund Amount

Added On: 11/02/15

SQL Column: DEBIT_REFUND_AMOUNT

Java Field: debitRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by Debit card.

Debit Refund Count

Added On: 11/02/15

SQL Column: DEBIT_REFUND_COUNT

Java Field: debitRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by Debit card.

Diners Correction Amount

Added On: 11/02/15

SQL Column: DINERS_CORRECTION_AMOUNT

Java Field: dinersCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by Diners credit card.

Diners Correction Count

Added On: 11/02/15

SQL Column: DINERS_CORRECTION_COUNT

Java Field: dinersCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by Diners credit card.

Diners Purchase Amount

Added On: 11/02/15

SQL Column: DINERS_PURCHASE_AMOUNT

Java Field: dinersPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by Diners credit card.

Diners Purchase Count

Added On: 11/02/15

SQL Column: DINERS_PURCHASE_COUNT

Java Field: dinersPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by Diners credit card.

Diners Refund Amount

Added On: 11/02/15

SQL Column: DINERS_REFUND_AMOUNT

Java Field: dinersRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by Diners credit card.

Diners Refund Count

Added On: 11/02/15

SQL Column: DINERS_REFUND_COUNT

Java Field: dinersRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by Diners credit card.

Discover Novus Correction Amount

Added On: 11/02/15

SQL Column: DISCOVER_NOVUS_CORRECTION_AMOUNT

Java Field: discoverNovusCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by Discover Novus credit card.

Discover Novus Correction Count

Added On: 11/02/15

SQL Column: DISCOVER_NOVUS_CORRECTION_COUNT

Java Field: discoverNovusCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by Discover Novus credit card.

Discover Novus Purchase Amount

Added On: 11/02/15

SQL Column: DISCOVER_NOVUS_PURCHASE_AMOUNT

Java Field: discoverNovusPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by Discover Novus credit card.

Discover Novus Purchase Count

Added On: 11/02/15

SQL Column: DISCOVER_NOVUS_PURCHASE_COUNT

Java Field: discoverNovusPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by Discover Novus credit card.

Discover Novus Refund Amount

Added On: 11/02/15

SQL Column: DISCOVER_NOVUS_REFUND_AMOUNT

Java Field: discoverNovusRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by Discover Novus credit card.

Discover Novus Refund Count

Added On: 11/02/15

SQL Column: DISCOVER_NOVUS_REFUND_COUNT

Java Field: discoverNovusRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by Discover Novus credit card.

ECR Number

Added On: 11/02/15

SQL Column: ECR_NUMBER

Java Field: ecrNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Terminal ID – no spaces or dashes. The ECR/terminal number is 8 digits long and generally begins with the number “66” (ex. 66012345). The terminal ID is assigned when the merchant account is first set up. This number will be returned in the response as part of the ReferenceNum.

ISO

Added On: 11/02/15

SQL Column: ISO

Java Field: iso

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

ISO response code.

JCB Correction Amount

Added On: 11/02/15

SQL Column: JCB_CORRECTION_AMOUNT

Java Field: jcbCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by JCB credit card.

JCB Correction Count

Added On: 11/02/15

SQL Column: JCB_CORRECTION_COUNT

Java Field: jcbCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by JCB credit card.

JCB Purchase Amount

Added On: 11/02/15

SQL Column: JCB_PURCHASE_AMOUNT

Java Field: jcbPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by JCB credit card.

JCB Purchase Count

Added On: 11/02/15

SQL Column: JCB_PURCHASE_COUNT

Java Field: jcbPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by JCB credit card.

JCB Refund Amount

Added On: 11/02/15

SQL Column: JCB_REFUND_AMOUNT

Java Field: jcbRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by JCB credit card.

JCB Refund Count

Added On: 11/02/15

SQL Column: JCB_REFUND_COUNT

Java Field: jcbRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by JCB credit card.

Master Card Correction Amount

Added On: 11/02/15

SQL Column: MASTER_CARD_CORRECTION_AMOUNT

Java Field: masterCardCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by MasterCard credit card.

Master Card Correction Count

Added On: 11/02/15

SQL Column: MASTER_CARD_CORRECTION_COUNT

Java Field: masterCardCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by MasterCard credit card.

Master Card Purchase Amount

Added On: 11/02/15

SQL Column: MASTER_CARD_PURCHASE_AMOUNT

Java Field: masterCardPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by MasterCard credit card.

Master Card Purchase Count

Added On: 11/02/15

SQL Column: MASTER_CARD_PURCHASE_COUNT

Java Field: masterCardPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by MasterCard credit card.

Master Card Refund Amount

Added On: 11/02/15

SQL Column: MASTER_CARD_REFUND_AMOUNT

Java Field: masterCardRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by MasterCard credit card.

Master Card Refund Count

Added On: 11/02/15

SQL Column: MASTER_CARD_REFUND_COUNT

Java Field: masterCardRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by MasterCard credit card.

Merchant Account Code

Added On: 11/02/15

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Message

Added On: 11/02/15

SQL Column: MESSAGE

Java Field: message

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Response description returned from issuing institution.

Receipt ID

Added On: 11/02/15

SQL Column: RECEIPT_ID

Java Field: receiptId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Identification number of the receipt in the system.

Reference Num

Added On: 11/02/15

SQL Column: REFERENCE_NUM

Java Field: referenceNum

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Secondary identifier, which can be used to cross-reference records between UniPay and integrated systems.

Response Code

Added On: 11/02/15

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Gateway generated response code.

Sears Correction Amount

Added On: 11/02/15

SQL Column: SEARS_CORRECTION_AMOUNT

Java Field: searsCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by Sears credit card.

Sears Correction Count

Added On: 11/02/15

SQL Column: SEARS_CORRECTION_COUNT

Java Field: searsCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by Sears credit card.

Sears Purchase Amount

Added On: 11/02/15

SQL Column: SEARS_PURCHASE_AMOUNT

Java Field: searsPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by Sears credit card.

Sears Purchase Count

Added On: 11/02/15

SQL Column: SEARS_PURCHASE_COUNT

Java Field: searsPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by Sears credit card.

Sears Refund Amount

Added On: 11/02/15

SQL Column: SEARS_REFUND_AMOUNT

Java Field: searsRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by Sears credit card.

Sears Refund Count

Added On: 11/02/15

SQL Column: SEARS_REFUND_COUNT

Java Field: searsRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by Sears credit card.

Store ID

Added On: 11/02/15

SQL Column: STORE_ID

Java Field: storeId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Unique identification number of the store.

Timed Out

Added On: 11/02/15

SQL Column: TIMED_OUT

Java Field: timedOut

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Transaction failed due to a process timing out.

Trans Amount

Added On: 11/02/15

SQL Column: TRANS_AMOUNT

Java Field: transAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Amount of the transaction.

Trans Date

Added On: 11/02/15

SQL Column: TRANS_DATE

Java Field: transDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Actual date of the transaction.

Trans ID

Added On: 11/02/15

SQL Column: TRANS_ID

Java Field: transId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Identification number of the transaction in the system.

Trans Time

Added On: 11/02/15

SQL Column: TRANS_TIME

Java Field: transTime

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Actual time of the transaction.

Trans Type

Added On: 11/02/15

SQL Column: TRANS_TYPE

Java Field: transType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Type of the transaction.

Visa Correction Amount

Added On: 11/02/15

SQL Column: VISA_CORRECTION_AMOUNT

Java Field: visaCorrectionAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Correction amount of the transaction made by Visa credit card.

Visa Correction Count

Added On: 11/02/15

SQL Column: VISA_CORRECTION_COUNT

Java Field: visaCorrectionCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Correction count of the transaction made by Visa credit card.

Visa Purchase Amount

Added On: 11/02/15

SQL Column: VISA_PURCHASE_AMOUNT

Java Field: visaPurchaseAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Purchase amount of the transaction made by Visa credit card.

Visa Purchase Count

Added On: 11/02/15

SQL Column: VISA_PURCHASE_COUNT

Java Field: visaPurchaseCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Purchase count of the transaction made by Visa credit card.

Visa Refund Amount

Added On: 11/02/15

SQL Column: VISA_REFUND_AMOUNT

Java Field: visaRefundAmount

Status: Active

SQL Type: varchar(18)

Java Type: String

Attributes:

Refund amount of the transaction made by Visa credit card.

Visa Refund Count

Added On: 11/02/15

SQL Column: VISA_REFUND_COUNT

Java Field: visaRefundCount

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Refund count of the transaction made by Visa credit card.