SNGB Auth Retail Transaction UML


Added On:  08/07/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  SngbAuthRetailTransaction 
SNGB specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, SNGB specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  06/10/16
SQL Column:  
Java Field:  acsUrl
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  08/07/15
SQL Column:  ACTION
Java Field:  action
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Special number of a transaction type.
Added On:  08/07/15
SQL Column:  ADDR
Java Field:  addr
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street address of the customer.
Added On:  08/07/15
SQL Column:  AMT
Java Field:  amt
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
The amount of the transaction.
Added On:  08/17/15
SQL Column:  
Java Field:  card
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card or bank account number.
Added On:  08/07/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/07/15
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
The currency code of the transaction.
Added On:  08/17/15
SQL Column:  
Java Field:  cvv2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CVV2 code (must be in number format).
Added On:  08/17/15
SQL Column:  
Java Field:  expDay
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date day (must be in number format DD).
Added On:  08/17/15
SQL Column:  
Java Field:  expMonth
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date month (must be in number format MM).
Added On:  08/17/15
SQL Column:  
Java Field:  expYear
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date year (must be in number format YYYY).
Added On:  08/07/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/07/15
SQL Column:  MEMBER
Java Field:  member
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Cardholder’s full name.
Added On:  08/07/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:  06/10/16
SQL Column:  
Java Field:  paReq
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/10/16
SQL Column:  
Java Field:  paRes
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  08/17/15
SQL Column:  
Java Field:  password
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Password associated with the appropriate user.
Added On:  09/04/15
SQL Column:  PAYMENT_ID
Java Field:  paymentId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Payment ID used to identify the payment for subsequent transactions.
Added On:  08/07/15
SQL Column:  RESPONSE_AUTH
Java Field:  responseAuth
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The resulting authorization number of the transaction.
Added On:  08/07/15
SQL Column:  RESPONSE_AVR
Java Field:  responseAvr
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
A single letter providing information about the cardholder’s submitted data. The letter indicates how closely the submitted card number, address, and ZIP code match at the card-issuing bank.
Added On:  08/07/15
SQL Column:  RESPONSE_CARD_BALANCE
Java Field:  responseCardBalance
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
The resulting card balance of the stored value transaction instrument.
Added On:  09/07/15
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Gateway generated response code.
If any errors occur during the transmission of the transaction data, the response format will contain a single string indicating that an error occurred.
Added On:  08/07/15
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Transaction date in the format of the authorization system.
Added On:  09/07/15
SQL Column:  RESPONSE_ECI
Java Field:  responseEci
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Electronic Commerce Indicator (ECI) response.
Added On:  09/07/15
SQL Column:  RESPONSE_ERROR_CODE_TAG
Java Field:  responseErrorCodeTag
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The code of the error from the response.
Added On:  09/07/15
SQL Column:  RESPONSE_ERROR_TEXT
Java Field:  responseErrorText
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Text message explaining the occured error.
Added On:  09/07/15
SQL Column:  RESPONSE_PAYMENT_ID
Java Field:  responsePaymentId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Unique order ID generated by commerce gateway.
Added On:  08/07/15
SQL Column:  RESPONSE_REF
Java Field:  responseRef
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The resulting reference number of the transaction. This number or series of letters is used for referential purposes by some acquiring institutions and should be stored properly.
Added On:  08/07/15
SQL Column:  RESPONSE_RESULT
Java Field:  responseResult
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Returned as the transaction response evaluator. Check the Result for error and then evaluate the transaction to determine if it performed successfully.
Added On:  08/07/15
SQL Column:  RESPONSE_TRACK_ID
Java Field:  responseTrackId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The track ID sent by the merchant in the transaction request.
Added On:  08/07/15
SQL Column:  RESPONSE_TRANS_ID
Java Field:  responseTransId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Unique transaction ID issued by the ACI commerce gateway.
Added On:  08/07/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/07/15
SQL Column:  TRACK_ID
Java Field:  trackId
Status:  Active
SQL Type:  bigint(20)(60)
Java Type:  Long
Attributes:
A unique tracking ID issued by the merchant's commerce system which is stored with the transaction. (Avoid spaces and extended characters. Use only alphanumeric format.)
Added On:  08/07/15
SQL Column:  TRANS_ID
Java Field:  transId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Transaction ID used to identify the original transaction for a void, capture and refund transactions.
Added On:  08/17/15
SQL Column:  
Java Field:  userId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The identification number of the user in the system.
Added On:  08/07/15
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP code (or postal code) of the consumer.