Pago Auth Retail Transaction UML


Added On:  05/16/18 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  PagoAuthRetailTransaction 
Represents information about realtime authorization transaction processed through Pago.
Added On:  01/17/18
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/17/18
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required, CreateOnly
Code of Merchant Account to which instance of this object is attributed to.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe 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/17/18
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Added On:  01/17/18
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  01/17/18
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  MERCHANT_PASSCODE
Java Field:  merchantPasscode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes: Transient
Added On:  01/17/18
SQL Column:  URL_SUFFIX
Java Field:  urlSuffix
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CURRENCY
Java Field:  currency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_IP
Java Field:  customerIp
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_EMAIL
Java Field:  customerEmail
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_PHONE
Java Field:  customerPhone
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_FIRST_NAME
Java Field:  customerFirstName
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_LAST_NAME
Java Field:  customerLastName
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_ADDRESS1
Java Field:  customerAddress1
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_CITY
Java Field:  customerCity
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_ZIP_CODE
Java Field:  customerZipCode
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_STATE_PROVINCE
Java Field:  customerStateProvince
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_COUNTRY
Java Field:  customerCountry
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CUSTOMER_DOB
Java Field:  customerDob
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  CARD_NUMBER
Java Field:  cardNumber
Status:  Active
SQL Type:  varchar(26)
Java Type:  String
Attributes: Transient
Added On:  01/17/18
SQL Column:  CARD_CVV2
Java Field:  cardCvv2
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes: Transient
Added On:  01/17/18
SQL Column:  CARD_EXPIRY_DATE
Java Field:  cardExpiryDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes: Transient
Added On:  01/17/18
SQL Column:  CARD_HOLDER_NAME
Java Field:  cardHolderName
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(64)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  THREE_D_SECURE_INFO
Java Field:  threeDSecureInfo
Status:  Active
SQL Type:  varchar(1000)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  REFUND_AMOUNT
Java Field:  refundAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  REASON_CODE
Java Field:  reasonCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_TRANSACTION_ID
Java Field:  responseTransactionId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_AMOUNT
Java Field:  responseAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_EXECUTED
Java Field:  responseExecuted
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_ERROR_INFO
Java Field:  responseErrorInfo
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_REFUND_TRANSACTION_ID
Java Field:  responseRefundTransactionId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_UPDATED
Java Field:  responseUpdated
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  01/17/18
SQL Column:  RESPONSE_UPDATED_TRANSACTION_ID
Java Field:  responseUpdatedTransactionId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes: