PaySafe Auth Retail Transaction UML
Added On: 03/16/16
Module: UniCharge
Type: Entity
Status: Active
Java Class: PaysafeAuthRetailTransaction
Added On: 03/16/16
SQL Column: ACCOUNT_NUMBER
Java Field: accountNumber
Status: Active
SQL Type: varchar(10)
Java Type: String
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Added On: 03/16/16
SQL Column: AUTH_CODE
Java Field: authCode
Status: Active
SQL Type: varchar(50)
Java Type: String
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
Added On: 03/16/16
SQL Column: AVAILABLE_TO_REFUND
Java Field: availableToRefund
Status: Active
SQL Type: int(11)
Java Type: Integer
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
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
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
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
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
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
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
Added On: 03/16/16
SQL Column: CHARGE_TRANSACTION_FK
Java Field: chargeTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
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
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
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
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
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
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
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
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
Added On: 03/16/16
SQL Column: DYNAMIC_DESCRIPTOR
Java Field: dynamicDescriptor
Status: Active
SQL Type: varchar(20)
Java Type: String
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
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
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
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
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
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
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
Added On: 06/16/16
SQL Column:
Java Field: httpAuthorization
Status: Active
SQL Type:
Java Type: String
Added On: 06/16/16
SQL Column:
Java Field: httpMethod
Status: Active
SQL Type:
Java Type: String
Added On: 06/16/16
SQL Column:
Java Field: httpUrlSuffix
Status: Active
SQL Type:
Java Type: String
Added On: 03/16/16
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
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
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
Added On: 03/16/16
SQL Column: MERCHANT_ACCOUNT_CODE
Java Field: merchantAccountCode
Status: Active
SQL Type: int(11)
Java Type: Integer
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
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
Customer's telephone number.
Added On: 03/16/16
SQL Column: RECURRING
Java Field: recurring
Status: Active
SQL Type: varchar(10)
Java Type: String
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
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
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
Added On: 03/16/16
SQL Column: RESPONSE_MESSAGE
Java Field: responseMessage
Status: Active
SQL Type: varchar(255)
Java Type: String
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
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
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
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
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
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
Added On: 03/16/16
SQL Column: SHIPPING_STATE
Java Field: shippingState
Status: Active
SQL Type: varchar(3)
Java Type: String
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
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
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
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
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
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
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
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
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
Added On: 03/16/16
SQL Column:
Java Field: track1
Status: Active
SQL Type:
Java Type: String
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
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
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
Added On: 03/16/16
SQL Column: ZIP
Java Field: zip
Status: Active
SQL Type: varchar(10)
Java Type: String
ZIP (or postal) code in the billing address.