CC Moneris Batch Transaction UML


Added On:  05/08/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  CcMonerisBatchTransaction 
Represents a batch transaction as it is defined in batch processing specification of Moneris.
Added On:  05/08/15
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the transaction.
Contains 3 digits with two penny values. The minimum value passed can be 0.01 and the maximum 9999999.99.
Added On:  05/08/15
SQL Column:  AUTH_CODE
Java Field:  authCode
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Authorization code returned from the issuing institution.
Added On:  05/08/15
SQL Column:  CARD_TYPE
Java Field:  cardType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the credit card that was used:

M = MasterCard;
V = Visa;
AX = American Express;
DC = Diners card;
NO = Novus / Discover;
SE = Sears;
CQ = ACH.
Added On:  05/08/15
SQL Column:  CC_MONERIS_BATCH_FK
Java Field:  ccMonerisBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References CC Moneris Batch
Attributes:
Reference to the entity that represents a batch of transactions as it is defined in Moneris' batch processing specification.
Added On:  05/08/15
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time transaction.
Added On:  05/08/15
SQL Column:  COMPLETE
Java Field:  complete
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Indicates whether the transaction was sent to the authorization host and in outgoing response was received (true/false).
Added On:  05/08/15
SQL Column:  CRYPT_TYPE
Java Field:  cryptType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
E-Commerce indicator:
1 - Mail Order / Telephone Order - Single
2 - Mail Order / Telephone Order - Recurring
3 - Mail Order / Telephone Order - Instalment
4 - Mail Order / Telephone Order - Unknown Classification
5 - Authenticated E-commerce transaction (VBV)
6 - Non Authenticated E-commerce transaction (VBV)
7 - SSL enabled merchant
8 - Non Secure transaction (web or email Based)
9 - SET non - authenticated transaction
Added On:  05/08/15
SQL Column:  CUST_ID
Java Field:  custId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Optional field that can be sent as a part of the request.
It is searchable from the Moneris Merchant Resource Centre. Commonly used for policy number, membership number, student ID or invoice number.
Added On:  06/09/16
SQL Column:  
Java Field:  expDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiry date of the credit card.
Added On:  05/08/15
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  06/25/15
SQL Column:  ISO
Java Field:  iso
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The merchant link header.
Added On:  11/22/18
SQL Column:  ISSUER_ID_REQUEST
Java Field:  issuerIdRequest
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  11/22/18
SQL Column:  ISSUER_ID_RESPONSE
Java Field:  issuerIdResponse
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  05/08/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.
Added On:  05/08/15
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Response description returned from the issuing institution.
Added On:  05/08/15
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Merchant defined unique transaction identifier - must be unique for every us_purchase, us_preauth and us_ind_refund attempt.
For us_refund, us_completion and us_purchase_correction must refer to the original transaction.

Refer to the specification of the processor for more information.
Added On:  06/09/16
SQL Column:  
Java Field:  pan
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PAN number of the credit card.
Added On:  11/22/18
SQL Column:  PAYMENT_INDICATOR
Java Field:  paymentIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  11/22/18
SQL Column:  PAYMENT_INFORMATION
Java Field:  paymentInformation
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  05/08/15
SQL Column:  RECUR_SUCCESS
Java Field:  recurSuccess
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Indicates whether the transaction is successfully registered (true/false).
Added On:  05/08/15
SQL Column:  REFERENCE_NUM
Java Field:  referenceNum
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Reference to the terminal used to process the transaction.
As well as the shift, batch and sequence number, this data is typically used to reference transactions on the host systems and must be displayed on any receipt presented to the customer.

Refer to the specification of the processor for more information.
Added On:  05/08/15
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Transaction response code:

< 50: Transaction approved;
>= 50: Transaction declined;
NULL: Transaction was not sent for authorization.

Refer to the specification of the processor for more information.
Added On:  05/27/15
SQL Column:  RESPONSE_TRANS_TYPE
Java Field:  responseTransType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of transaction that was performed.

  • 00 = Purchase, ACH Debit, Vault CC Purchase, Vault ACH Purchase
  • 01 = Preauthorization, Vault CC Preauthorization
  • 02 = Capture
  • 04 = Refund, Independent Refund, ACH Credit, Vault CC & ACH Ind Refund
  • 11 = Void, ACH Reversal
Added On:  05/08/15
SQL Column:  TICKET
Java Field:  ticket
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Reserved field.
Added On:  05/08/15
SQL Column:  TIMED_OUT
Java Field:  timedOut
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Indicates whether the process is timed out (true/false).
Added On:  05/18/15
SQL Column:  TRANS_AMOUNT
Java Field:  transAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the transaction. Must contain 3 digits with two penny values. The minimum value passed can be 0.01 and the maximum 9999999.99.
Added On:  05/08/15
SQL Column:  TRANS_DATE
Java Field:  transDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Processing host date stamp (yyyy-mm-dd).
Added On:  05/08/15
SQL Column:  TRANS_TIME
Java Field:  transTime
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Processing host time stamp (24 hour clock).
Added On:  05/08/15
SQL Column:  TRANS_TYPE
Java Field:  transType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
The type of initial transaction.

Must match one of these available transaction types:
  • us_purchase
  • o us_purchase:recur
    o us_purchase:avs_info
    o us_purchase:avs_info:recur or us_purchase:recur:avs_info
  • us_preauth
  • o us_preauth:avs_info
    • us_completion
    • us_purchasecorrection
    • us_refund
    • us_ind_refund

    Case sensitive field that must be all in lower case.
    Added On:  05/08/15
    SQL Column:  TXN_NUMBER
    Java Field:  txnNumber
    Status:  Active
    SQL Type:  varchar(255)
    Java Type:  String
    Attributes:
    Used when performing follow-on transactions: must be filled with the value that was returned as the Txn_number in the response to the original transaction.
    For capture this must refer to the pre-auth operation.
    For refund or void this must refer to the capture or purchase operation.