Payvision Auth Retail Transaction UML


Added On:  03/01/14 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PayvisionAuthRetailTransaction 
PayVision specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, PayVision 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/01/14
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
Added On:  03/10/14
SQL Column:  AUTHENTICATION_INDICATOR
Java Field:  authenticationIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Review the Appendix of your acquirer, provided separately, to check how to format this parameter.
Added On:  06/16/16
SQL Column:  
Java Field:  authenticationValue
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  03/01/14
SQL Column:  AVS_ADDRESS
Java Field:  avsAddress
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Street address for AVS verification. Review the Appendix of your acquirer, provided separately, to check how to format this parameter.
Added On:  03/01/14
SQL Column:  AVS_AUTHORIZATION_ENTITY
Java Field:  avsAuthorizationEntity
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the entity that provides the AVS response.
Added On:  03/01/14
SQL Column:  AVS_RESULT
Java Field:  avsResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the result of the AVS check.
Added On:  03/01/14
SQL Column:  AVS_ZIP
Java Field:  avsZip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP Code for AVS verification. Review the Appendix of your acquirer, provided separately, to check how to format this parameter.
Added On:  03/01/14
SQL Column:  BANK_APPROVAL_CODE
Java Field:  bankApprovalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The specific code returned by the acquiring in the CDC field, indicating whetehr the transaction is approved or not.
Added On:  03/01/14
SQL Column:  BANK_CODE
Java Field:  bankCode
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
The specific code returned by the acquiring in the CDC field.
Added On:  03/01/14
SQL Column:  BANK_MESSAGE
Java Field:  bankMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The specific code returned by the acquiring in the CDC field in text message.
Added On:  06/16/16
SQL Column:  
Java Field:  cardCvv
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/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:  06/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/30/14
SQL Column:  CARD_GUID
Java Field:  cardGuid
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Card Guid obtained during a RegisterCard operation
Added On:  03/01/14
SQL Column:  CARD_HOLDER
Java Field:  cardHolder
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Card holder name as it appears in the card.
Added On:  03/30/14
SQL Column:  CARD_ID
Java Field:  cardId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Card identifier obtained during a RegisterCard operation
Added On:  06/16/16
SQL Column:  
Java Field:  cardNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card number.
Added On:  03/01/14
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 transaction of type Sale.
Added On:  03/01/14
SQL Column:  COUNTRY_ID
Java Field:  countryId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
ISO 3166 Country code (numeric) that indicates the country where the transaction took place.
Added On:  03/01/14
SQL Column:  CURRENCY_ID
Java Field:  currencyId
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
ISO 4217 Currency code (numeric) that indicates the currency of the transaction.
Added On:  03/01/14
SQL Column:  CVV_RESULT
Java Field:  cvvResult
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
A code that reflects the outcome of the CVV2/CVC2 check.

The CVV code must be sent for E-Commerce transactions. This field is optional depending on the merchant account.
Added On:  03/01/14
SQL Column:  DBA_CITY
Java Field:  dbaCity
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Second part of dynamic descriptor. Check the Appendix of your acquirer, provided separately, to know how to format this parameter.
Added On:  03/01/14
SQL Column:  DBA_NAME
Java Field:  dbaName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
First part of dynamic descriptor. Check the Appendix of your acquirer, provided separately, to know how to format this parameter.
Added On:  03/16/14
SQL Column:  ERROR_CODE
Java Field:  errorCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Special code that identifies the type of occurred error.
Added On:  03/16/14
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Special text message from the provider about occurred error.
Added On:  03/01/14
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/01/14
SQL Column:  MEMBER_GUID
Java Field:  memberGuid
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
This value is provided by Payvision and is used to authenticate a merchant.
Added On:  03/01/14
SQL Column:  MEMBER_ID
Java Field:  memberId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
This value is provided by Payvision and is used to authenticate a merchant.
Added On:  03/01/14
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/01/14
SQL Column:  MERCHANT_ACCOUNT_TYPE
Java Field:  merchantAccountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This value represents the type of the merchant account that will be used to perform the transaction. Valid values are:

1 – E-Commerce
2 – Mail Order / Telephone order
4 - Recurring
Added On:  03/01/14
SQL Column:  MESSAGE
Java Field:  message
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Friendly message indicating the result of the card registration.
Added On:  03/01/14
SQL Column:  REQUEST_TYPE
Java Field:  requestType
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Type of request from the client.
Added On:  03/01/14
SQL Column:  RESULT_CODE
Java Field:  resultCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This value indicates if the card was successfully registered or not. A 0 means OK, different than 0 means error.

The codes represent group of common errors, in some cases you will be able to obtain a detailed code in the CDC.
Added On:  03/01/14
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/01/14
SQL Column:  TRACKING_MEMBER_CODE
Java Field:  trackingMemberCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
This value is the order number or tracking code, it can contain any alphanumeric value with a maximum length of 100 chars. The value must be unique during 24 hours.
Added On:  03/01/14
SQL Column:  TRANSACTION_DATE_TIME
Java Field:  transactionDateTime
Status:  Active
SQL Type:  varchar(28)
Java Type:  String
Attributes:
UTC date and time in which the transaction was processed by Payvision.
Added On:  03/01/14
SQL Column:  TRANSACTION_GUID
Java Field:  transactionGuid
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Guid obtained with an Authorize transaction.
Added On:  03/01/14
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
ID, obtained with an Authorize transaction.
Added On:  06/16/16
SQL Column:  
Java Field:  xid
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient