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:  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:  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:  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:  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:  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:  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:  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.
    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:  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/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:  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_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:  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:  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:  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:  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/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:  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:  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:  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/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/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:  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:  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:  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:  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:  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: