Moneris Auth Retail Transaction UML


Added On:  08/03/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  MonerisAuthRetailTransaction 
Moneris specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, EMoneris specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  08/03/15
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the order.
Added On:  08/17/15
SQL Column:  
Java Field:  apiToken
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  08/03/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:  08/04/15
SQL Column:  AVS_RESULT_CODE
Java Field:  avsResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Code that indicates the Address Verification Service (AVS) result.
Added On:  08/03/15
SQL Column:  AVS_STREET_NAME
Java Field:  avsStreetName
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Street name used to check AVS address verification.
Added On:  08/03/15
SQL Column:  AVS_STREET_NUMBER
Java Field:  avsStreetNumber
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Street number used to check AVS address verification. This must match the address that the issuing bank has on file.
Added On:  08/03/15
SQL Column:  AVS_ZIPCODE
Java Field:  avsZipcode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP (or postal) code used to check AVS address verification.
Added On:  08/04/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:  08/17/15
SQL Column:  
Java Field:  cavv
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CAVV code of the card.
Added On:  08/04/15
SQL Column:  CAVV_RESULT_CODE
Java Field:  cavvResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Code indicating the result of CAVV verification.
Added On:  08/03/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 financial transaction.
Added On:  08/03/15
SQL Column:  COMP_AMOUNT
Java Field:  compAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Used when performing a Capture transaction. This must contain 3 digits with two penny values. The minimum value passed can be 0.01 and the maximum 9999999.99.
Added On:  08/04/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:  08/04/15
SQL Column:  CORPORATE_CARD
Java Field:  corporateCard
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  08/03/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:  08/04/15
SQL Column:  CUST_ID
Java Field:  custId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Unique identification number of the customer. Can be sent as part of a Purchase or PreAuth request. It is searchable from the Moneris Merchant Resource Centre. It is commonly used for policy number, membership number, student ID or invoice number.
Added On:  08/03/15
SQL Column:  CVD_INDICATOR
Java Field:  cvdIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
CVD (Card Validation Digits) presence indicator.
Added On:  08/04/15
SQL Column:  CVD_RESULT_CODE
Java Field:  cvdResultCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code that indicates the Card Validation Digits (CVD) result.
Added On:  08/17/15
SQL Column:  
Java Field:  cvdValue
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit Card CVD value – this number accommodates either 3 or 4 digit CVD values.

Note: The CVD value supplied by the cardholder should simply be passed to the eSelectPlus payment gateway. Under no circumstances should it be stored for subsequent uses or displayed as part of the receipt information.
Added On:  08/03/15
SQL Column:  DYNAMIC_DESCRIPTOR
Java Field:  dynamicDescriptor
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Dynamic descriptor used by a client.
Added On:  08/25/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:  08/17/15
SQL Column:  
Java Field:  expdate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date of the card (MM/YY)
Added On:  08/03/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:  08/04/15
SQL Column:  IS_VISA_DEBIT
Java Field:  isVisaDebit
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Indicates whether the used card is Visa Debit card.
Added On:  08/04/15
SQL Column:  ISO
Java Field:  iso
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
ISO response code.
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:  01/11/16
SQL Column:  ITD_RESPONSE
Java Field:  itdResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  08/03/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:  08/04/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:  08/03/15
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Unique number of the order.
Added On:  08/03/15
SQL Column:  ORIGINAL_TXN_NUMBER
Java Field:  originalTxnNumber
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  08/17/15
SQL Column:  
Java Field:  pan
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PAN code of the 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:  08/25/15
SQL Column:  POS_CODE
Java Field:  posCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the POS device used in the transaction.
Added On:  08/04/15
SQL Column:  RECEIPT_ID
Java Field:  receiptId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Order ID specified in the request.
Added On:  08/04/15
SQL Column:  REFERENCE_NUM
Java Field:  referenceNum
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
References 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. This information should be stored by the merchant. The following illustrates the breakdown of this field where "660123450010690030” is the reference number returned in the message, "66012345" is the terminal ID, "001" is the shift number, "069" is the batch number and "003" is the transaction number within the batch.
Added On:  08/03/15
SQL Column:  REQUEST_TYPE
Java Field:  requestType
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Type of the request.
Added On:  08/04/15
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Gateway generated response code.
Added On:  08/03/15
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  08/03/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:  08/04/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:  08/26/15
SQL Column:  
Java Field:  track2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  08/04/15
SQL Column:  TRANS_AMOUNT
Java Field:  transAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Amount of the transaction.
Added On:  08/04/15
SQL Column:  TRANS_DATE
Java Field:  transDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Actual date of the original transaction.
Added On:  08/04/15
SQL Column:  TRANS_ID
Java Field:  transId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Unique identification number of the transaction.
Added On:  08/04/15
SQL Column:  TRANS_TIME
Java Field:  transTime
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Actual time of the original transaction.
Added On:  08/04/15
SQL Column:  TRANS_TYPE
Java Field:  transType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the transaction.