PaySafe Auth Retail Transaction UML


Added On:  03/16/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PaysafeAuthRetailTransaction 
PaySafe specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, PaySafe specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  03/16/16
SQL Column:  ACCOUNT_NUMBER
Java Field:  accountNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Account number in the system.
Added On:  03/16/16
SQL Column:  ACQUIRER_AUTH_CODE
Java Field:  acquirerAuthCode
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Acquirer authorization code.
Added On:  03/16/16
SQL Column:  ACQUIRER_AVS_CODE
Java Field:  acquirerAvsCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The raw AVS code returned by the acquirer.
Added On:  03/16/16
SQL Column:  ACQUIRER_BALANCE_RESPONSE
Java Field:  acquirerBalanceResponse
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The balance remaining on a gift card, if a gift card was used for the original transaction.
Added On:  03/16/16
SQL Column:  ACQUIRER_BATCH_NUMBER
Java Field:  acquirerBatchNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The batch number of the transaction.
Added On:  03/16/16
SQL Column:  ACQUIRER_CODE
Java Field:  acquirerCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Identification code of an acquirer, such as DJN, CRX, etc.
Added On:  03/16/16
SQL Column:  ACQUIRER_CVV2_RESULT
Java Field:  acquirerCvv2Result
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Acquirer CVV2 verification response result.
Added On:  03/16/16
SQL Column:  ACQUIRER_DESCRIPTION
Java Field:  acquirerDescription
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Description of the response.
Added On:  03/16/16
SQL Column:  ACQUIRER_EFFECTIVE_DATE
Java Field:  acquirerEffectiveDate
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
The date of the bank deposit associated with the transaction.
Added On:  03/16/16
SQL Column:  ACQUIRER_FINANCING_TYPE
Java Field:  acquirerFinancingType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The type of financing offered.
Added On:  03/16/16
SQL Column:  ACQUIRER_GRACE_PERIOD
Java Field:  acquirerGracePeriod
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
The grace period, in months, associated with deferred payment transactions.
Added On:  03/16/16
SQL Column:  ACQUIRER_MID
Java Field:  acquirerMid
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The acquirer MID that was sent to the clearing house.
Added On:  03/16/16
SQL Column:  ACQUIRER_PLAN
Java Field:  acquirerPlan
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The plan number for the financing transaction.
Added On:  03/16/16
SQL Column:  ACQUIRER_REFERENCE_NBR
Java Field:  acquirerReferenceNbr
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Bank Net transaction ID/Merch Tran Ref.
Added On:  03/16/16
SQL Column:  ACQUIRER_REQUEST_ID
Java Field:  acquirerRequestId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Request ID assigned by NETBANX.
Added On:  03/16/16
SQL Column:  ACQUIRER_RESPONSE_CODE
Java Field:  acquirerResponseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The raw response returned by the acquirer.
Added On:  03/16/16
SQL Column:  ACQUIRER_RESPONSE_ID
Java Field:  acquirerResponseId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The response ID assigned by Credorax.
Added On:  03/16/16
SQL Column:  ACQUIRER_RESPONSE_REASON_CODE
Java Field:  acquirerResponseReasonCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The raw response reason code returned by Credorax.
Added On:  03/16/16
SQL Column:  ACQUIRER_SEQ_NUMBER
Java Field:  acquirerSeqNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The merchant's sequence number.
Added On:  03/16/16
SQL Column:  ACQUIRER_TERM
Java Field:  acquirerTerm
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
The number of payments, in months, for equal payment transactions.
Added On:  03/16/16
SQL Column:  ACQUIRER_TERMINAL_ID
Java Field:  acquirerTerminalId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The merchant's terminal ID.
Added On:  03/16/16
SQL Column:  ACQUIRER_TXN_DATE_TIME
Java Field:  acquirerTxnDateTime
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
The actual transaction date and time.
Added On:  03/16/16
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount of the request, in minor units.

For example, to process US $10.99, this value should be 1099. To process 1000 Japanese yen, this value should be 1000. To process 10.139 Tunisian dinar, this value should be 10139.

Note: If the merchant account is set up for a currency that has 3 decimal units, our system will half round up the least significant digit. Therefore, a transaction of 10.139 Tunisian dinar would be processed as 10.14.
Added On:  03/23/16
SQL Column:  
Java Field:  apiKey
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
API key of the merchant.
Added On:  03/16/16
SQL Column:  AUTH_CODE
Java Field:  authCode
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Authorization code assigned by the issuing bank and returned in the response.
Added On:  03/16/16
SQL Column:  AUTH_ID
Java Field:  authId
Status:  Active
SQL Type:  varchar(36)
Java Type:  String
Attributes:
Authorization ID.
Added On:  03/16/16
SQL Column:  AVAILABLE_TO_REFUND
Java Field:  availableToRefund
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount of this settlement that is available to refund, in minor units.
Added On:  03/16/16
SQL Column:  AVAILABLE_TO_SETTLE
Java Field:  availableToSettle
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount of of the Authorization remaining to settle, in minor units.
Added On:  03/16/16
SQL Column:  AVS_RESPONSE
Java Field:  avsResponse
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
This is the AVS response from the card issuer.

  • MATCH
  • MATCH_ADDRESS_ONLY
  • MATCH_ZIP_ONLY
  • NO_MATCH
  • NOT_PROCESSED
  • UNKNOWN
Added On:  03/16/16
SQL Column:  
Java Field:  cardExpiryMonth
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Month part from the expiry date, specified on the credit card.
Added On:  03/16/16
SQL Column:  
Java Field:  cardExpiryYear
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Year part of expiration date, specified on the credit card.
Added On:  03/16/16
SQL Column:  
Java Field:  cardNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card number used for the request.
Added On:  03/16/16
SQL Column:  CARD_TYPE
Java Field:  cardType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of credit card used for the request.
Added On:  06/16/16
SQL Column:  
Java Field:  cavv
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CAVV code of the card.
Added On:  03/16/16
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:  03/16/16
SQL Column:  CHILD_ACCOUNT_NUM
Java Field:  childAccountNum
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The child merchant account number. It is returned only if the transaction was processed via a master account.
Added On:  03/16/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
City in the billing address.
Added On:  03/16/16
SQL Column:  COUNTRY
Java Field:  country
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code in the billing address.
Added On:  03/16/16
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Currency of the merchant account (e.g., USD or CAD) returned in the request response.
Added On:  03/16/16
SQL Column:  
Java Field:  cvv
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The 3- or 4-digit security code specified on the credit card following the card number.
Added On:  03/16/16
SQL Column:  CVV_VERIFICATION
Java Field:  cvvVerification
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
This is the response to the CVV submitted with the transaction request.
  • MATCH
  • NO_MATCH
  • NOT_PROCESSED
  • UNKNOWN
Added On:  03/16/16
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Description of the transaction, provided by the merchant.
Added On:  09/20/19
SQL Column:  DIRECTORY_SERVER_TRANSACTION_ID
Java Field:  directoryServerTransactionId
Status:  Active
SQL Type:  varchar(36)
Java Type:  String
Attributes:
Added On:  03/16/16
SQL Column:  DYNAMIC_DESCRIPTOR
Java Field:  dynamicDescriptor
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Dynamic description of a transaction. Appears on a statement and can be customized to simplify understanding of charge for a cardholder.
Added On:  03/21/16
SQL Column:  ECI
Java Field:  eci
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Electronic Commerce Indicator code, which gets returned by the card issuer indicating whether the cardholder was successfully authenticated.
Added On:  03/16/16
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Customer’s email address.
Added On:  03/16/16
SQL Column:  ERROR_CODE
Java Field:  errorCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Code of the occured error.
Added On:  03/16/16
SQL Column:  ERROR_DETAILS
Java Field:  errorDetails
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Detailed description of the occured error.
Added On:  03/16/16
SQL Column:  ERROR_FIELDS
Java Field:  errorFields
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The list of fields that have problems.
Added On:  03/16/16
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Short description of an occured error.
Added On:  03/16/16
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Customer’s first name.
Added On:  06/16/16
SQL Column:  
Java Field:  httpAuthorization
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/16/16
SQL Column:  
Java Field:  httpMethod
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/16/16
SQL Column:  
Java Field:  httpUrlSuffix
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  03/16/16
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:  03/16/16
SQL Column:  LAST_DIGITS
Java Field:  lastDigits
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
The last four digits of the credit card used for the request.
Added On:  03/31/16
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Customer’s last name.
Added On:  03/16/16
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:  03/16/16
SQL Column:  MERCHANT_REF_NUM
Java Field:  merchantRefNum
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The merchant reference number created by the merchant and submitted as part of the request. It must be unique for each request.
Added On:  03/16/16
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Customer's telephone number.
Added On:  03/16/16
SQL Column:  RECURRING
Java Field:  recurring
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Indicates whether this is an initial or repeat transaction for a customer for whom you will be processing recurring transactions.

The Recurring Indicator is used to identify transactions that are eligible for repeat processing. The merchant should identity the initial transaction processed with full billing information including the card security code (CVV) by setting the recurring indicator to “INITIAL”. Subsequent charges to the same card can be identified with the recurring indicator set to “RECURRING”. For these transactions the card security code is not required and could not be passed in because card regulations do not allow merchants to store it.
Added On:  03/16/16
SQL Column:  REQUEST_TYPE
Java Field:  requestType
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Type of initiated request.
Added On:  03/16/16
SQL Column:  RESPONSE_AMOUNT
Java Field:  responseAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount specified in the response.
Added On:  03/16/16
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the response.
Added On:  03/16/16
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Human readable response message explaining the response code.
Added On:  03/16/16
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:  03/16/16
SQL Column:  RISK_REASON_CODE
Java Field:  riskReasonCode
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
An array of integers is returned, displaying the detailed Risk reason codes if transaction was declined.

Note: It is returned only if the account is configured accordingly.
Added On:  03/16/16
SQL Column:  SETTLE_WITH_AUTH
Java Field:  settleWithAuth
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
This indicates whether the request is an Authorization only (no Settlement), or a Purchase (Authorization and Settlement).

  • false – the request is not settled
  • true – the request is settled

Note: This value defaults to false. If the merchant wants to find out whether an authorization has been settled, they should check the availableToSettle element. If the amount is 0, the authorization has been fully settled.
Added On:  03/16/16
SQL Column:  SHIPPING_CITY
Java Field:  shippingCity
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Recipient's city address used for the shipment.
Added On:  03/16/16
SQL Column:  SHIPPING_COUNTRY
Java Field:  shippingCountry
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Recipient's country code used for the shipment.
Added On:  03/16/16
SQL Column:  SHIPPING_RECIPIENT_NAME
Java Field:  shippingRecipientName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the recipient.
Added On:  03/16/16
SQL Column:  SHIPPING_STATE
Java Field:  shippingState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Recipient's state address used for the shipment.
Added On:  03/16/16
SQL Column:  SHIPPING_STREET
Java Field:  shippingStreet
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Recipient's street address used for the shipping.
Added On:  03/16/16
SQL Column:  SHIPPING_ZIP
Java Field:  shippingZip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Recipient's ZIP (or postal) code used for the shipment.
Added On:  03/21/16
SQL Column:  SIGNATURE_STATUS
Java Field:  signatureStatus
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This is the 3D Secure signature verification result value.

  • Y – All transaction and signature checks satisfied.
  • N – At least one transaction or signature check failed.
Added On:  03/16/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State in the billing address.

Note: 2-character state or province codes for Canada or the United States.
Added On:  03/16/16
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The status of the authentications request.
Added On:  03/16/16
SQL Column:  STREET
Java Field:  street
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First line of the street address in the billing address.
Added On:  03/21/16
SQL Column:  THREE_D_ENROLLMENT
Java Field:  threeDEnrollment
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether or not the cardholder is enrolled in 3D Secure.
Added On:  03/21/16
SQL Column:  THREE_D_RESULT
Java Field:  threeDResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the outcome of the authentication.
Added On:  09/20/19
SQL Column:  THREE_DSECURE_VERSION
Java Field:  threeDSecureVersion
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  03/16/16
SQL Column:  
Java Field:  track1
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Track 1 information read from the card's magnetic stripe.
Added On:  03/16/16
SQL Column:  
Java Field:  track2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Track 2 information read from the card's magnetic stripe.
Added On:  03/16/16
SQL Column:  TXN_TIME
Java Field:  txnTime
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
The date and time the transaction was processed.
Added On:  06/16/16
SQL Column:  
Java Field:  xid
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  03/16/16
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP (or postal) code in the billing address.