Moneris Retail File Batch
Parent: File Batch
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.
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
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.
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.
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.
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.
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.
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.
Added On: 06/10/16
SQL Column:
Java Field: apiToken
Status: Active
SQL Type:
Java Type: String
Attributes:
Transient
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On: 11/02/15
SQL Column: ISO
Java Field: iso
Status: Active
SQL Type: varchar(2)
Java Type: String
Attributes:
ISO response code.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 TidyPay and integrated systems.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Copyright ©
TidyPay. All Rights Reserved.
All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.