ProPay Auth Retail Transaction UML


Added On:  01/21/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PropayAuthRetailTransaction 
Propay specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Propay specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  04/11/16
SQL Column:  ACCOUNT_NAME
Java Field:  accountName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Name of the account in the system.
Added On:  01/21/16
SQL Column:  ACCOUNT_NUM
Java Field:  accountNum
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Bank account number. Required if adding bank account info as part of the signup.
Added On:  04/11/16
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Bank account number of the client.
Added On:  04/11/16
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Type of client's account.
Added On:  01/21/16
SQL Column:  ADDR
Java Field:  addr
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Street address of the client.
Added On:  01/21/16
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of the purchase.
Added On:  01/21/16
SQL Column:  AUTH_CODE
Java Field:  authCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Issuer authorization code.
Added On:  01/21/16
SQL Column:  AVS
Java Field:  avs
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Issuer returns AVS response. Most issuers approve even if mismatch, but you can turn around and void the transaction if unsatisfactory response is received.
Added On:  01/21/16
SQL Column:  CARDHOLDER_NAME
Java Field:  cardholderName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the credit card holder (owner).
Added On:  01/21/16
SQL Column:  
Java Field:  ccNum
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card number.
Added On:  01/21/16
SQL Column:  
Java Field:  certStr
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Data supplied by ProPay.
Added On:  01/21/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:  01/21/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
City of the client's address.
Added On:  01/21/16
SQL Column:  COMMENT1
Java Field:  comment1
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Optional field.
Added On:  01/21/16
SQL Column:  CONVERTED_AMOUNT
Java Field:  convertedAmount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Returned on multi-currency transactions. Amount expressed in the currency of the merchant account.
Added On:  01/21/16
SQL Column:  CONVERTED_CURRENCY_CODE
Java Field:  convertedCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Converted currency code of the one used in the transaction.
Added On:  01/21/16
SQL Column:  CURRENCY_CONVERSION_RATE
Java Field:  currencyConversionRate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Returned on multi-currency transactions. Exchange rate of the currency conversion.
Added On:  01/21/16
SQL Column:  
Java Field:  cvv2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CVV2 code of the credit card.
Added On:  01/21/16
SQL Column:  CVV2_RESP
Java Field:  cvv2Resp
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Issuer returns CVV2 response. Almost all issuers also decline if CVV mismatch.
Added On:  01/21/16
SQL Column:  
Java Field:  expDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiry date of the credit card.
Added On:  01/21/16
SQL Column:  GROSS_AMT
Java Field:  grossAmt
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Transaction Gross Amount.
Added On:  01/21/16
SQL Column:  GROSS_AMT_LESS_NET_AMT
Java Field:  grossAmtLessNetAmt
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The resulting sum of both types of fee applied to this transaction.
Added On:  01/21/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:  01/21/16
SQL Column:  INV_NUM
Java Field:  invNum
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Return of the value the client passed.
Added On:  01/21/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:  01/21/16
SQL Column:  NET_AMT
Java Field:  netAmt
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Transaction Net Amount after ProPay applies fees.
Added On:  01/21/16
SQL Column:  PER_TRANS_FEE
Java Field:  perTransFee
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The ‘flat’ per transaction portion of the ProPay fee applied to this transaction.
Added On:  01/21/16
SQL Column:  RATE
Java Field:  rate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The percentage based fee applied to this transaction.
Added On:  01/21/16
SQL Column:  RECURRING_PAYMENT
Java Field:  recurringPayment
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Inicates whether the payment is recurring.
Added On:  01/21/16
SQL Column:  RESP
Java Field:  resp
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Textual representation of the responseCode.
Added On:  01/21/16
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Issuer response code.
Added On:  01/21/16
SQL Column:  RESPONSE_TRANS_NUM
Java Field:  responseTransNum
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Transaction number that comes in the response.
Added On:  01/21/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:  04/11/16
SQL Column:  
Java Field:  routingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Routing number of the account.
Added On:  04/11/16
SQL Column:  STANDARD_ENTRY_CLASS_CODE
Java Field:  standardEntryClassCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Standart entry class code.
Added On:  01/21/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
If domestic signup this value MUST be one of the standard 2 character abbreviations. Rule also applies for Canadian signups.
Added On:  01/21/16
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Status of the transaction.
Added On:  01/21/16
SQL Column:  
Java Field:  track1
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
As read directly off the credit card without parsing.
Added On:  01/21/16
SQL Column:  
Java Field:  track2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
As read directly off the credit card without parsing.
Added On:  01/21/16
SQL Column:  TRANS_NUM
Java Field:  transNum
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The ProPay transaction identifier.
Added On:  01/21/16
SQL Column:  TRANS_TYPE
Java Field:  transType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of transaction.
Added On:  01/21/16
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code of the address.