Pago Auth Retail Transaction UML

Added On: 05/16/18

SQL Table: PAGO_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: PagoAuthRetailTransaction

Represents information about realtime authorization transaction processed through Pago.

Available Fields:

Amount
Card Cvv 2
Card Expiry Date
Card Holder Name
Card Number
Charge Transaction
Currency
Customer Address 1
Customer City
Customer Country
Customer Dob
Customer Email

Customer First Name
Customer Ip
Customer Last Name
Customer Phone
Customer State Province
Customer Zip Code
Description
Id
Merchant Account Code
Merchant Id
Merchant Passcode
Order Id

Reason Code
Refund Amount
Response Amount
Response Code
Response Error Info
Response Executed
Response Refund Transaction Id
Response Transaction Id
Response Updated
Response Updated Transaction Id
Retail Transaction Cycle
Three D Secure Info

Transaction Id
Url Suffix

Amount

Added On: 01/17/18

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Card Cvv 2

Added On: 01/17/18

SQL Column: CARD_CVV2

Java Field: cardCvv2

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes: Transient

Card Expiry Date

Added On: 01/17/18

SQL Column: CARD_EXPIRY_DATE

Java Field: cardExpiryDate

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes: Transient

Card Holder Name

Added On: 01/17/18

SQL Column: CARD_HOLDER_NAME

Java Field: cardHolderName

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Card Number

Added On: 01/17/18

SQL Column: CARD_NUMBER

Java Field: cardNumber

Status: Active

SQL Type: varchar(26)

Java Type: String

Attributes: Transient

Charge Transaction

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:

Currency

Added On: 01/17/18

SQL Column: CURRENCY

Java Field: currency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Customer Address 1

Added On: 01/17/18

SQL Column: CUSTOMER_ADDRESS1

Java Field: customerAddress1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Customer City

Added On: 01/17/18

SQL Column: CUSTOMER_CITY

Java Field: customerCity

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Customer Country

Added On: 01/17/18

SQL Column: CUSTOMER_COUNTRY

Java Field: customerCountry

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Customer Dob

Added On: 01/17/18

SQL Column: CUSTOMER_DOB

Java Field: customerDob

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Customer Email

Added On: 01/17/18

SQL Column: CUSTOMER_EMAIL

Java Field: customerEmail

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Customer First Name

Added On: 01/17/18

SQL Column: CUSTOMER_FIRST_NAME

Java Field: customerFirstName

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Customer Ip

Added On: 01/17/18

SQL Column: CUSTOMER_IP

Java Field: customerIp

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Customer Last Name

Added On: 01/17/18

SQL Column: CUSTOMER_LAST_NAME

Java Field: customerLastName

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Customer Phone

Added On: 01/17/18

SQL Column: CUSTOMER_PHONE

Java Field: customerPhone

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Customer State Province

Added On: 01/17/18

SQL Column: CUSTOMER_STATE_PROVINCE

Java Field: customerStateProvince

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Customer Zip Code

Added On: 01/17/18

SQL Column: CUSTOMER_ZIP_CODE

Java Field: customerZipCode

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Description

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: 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.

Merchant Account Code

Added On: 01/17/18

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.\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.

Merchant Id

Added On: 01/17/18

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Merchant Passcode

Added On: 01/17/18

SQL Column: MERCHANT_PASSCODE

Java Field: merchantPasscode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes: Transient

Order Id

Added On: 01/17/18

SQL Column: ORDER_ID

Java Field: orderId

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Reason Code

Added On: 01/17/18

SQL Column: REASON_CODE

Java Field: reasonCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Refund Amount

Added On: 01/17/18

SQL Column: REFUND_AMOUNT

Java Field: refundAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Response Amount

Added On: 01/17/18

SQL Column: RESPONSE_AMOUNT

Java Field: responseAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Response Code

Added On: 01/17/18

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response Error Info

Added On: 01/17/18

SQL Column: RESPONSE_ERROR_INFO

Java Field: responseErrorInfo

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Response Executed

Added On: 01/17/18

SQL Column: RESPONSE_EXECUTED

Java Field: responseExecuted

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Response Refund Transaction Id

Added On: 01/17/18

SQL Column: RESPONSE_REFUND_TRANSACTION_ID

Java Field: responseRefundTransactionId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Transaction Id

Added On: 01/17/18

SQL Column: RESPONSE_TRANSACTION_ID

Java Field: responseTransactionId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Updated

Added On: 01/17/18

SQL Column: RESPONSE_UPDATED

Java Field: responseUpdated

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Response Updated Transaction Id

Added On: 01/17/18

SQL Column: RESPONSE_UPDATED_TRANSACTION_ID

Java Field: responseUpdatedTransactionId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Retail Transaction Cycle

Added On: 01/17/18

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Three D Secure Info

Added On: 01/17/18

SQL Column: THREE_D_SECURE_INFO

Java Field: threeDSecureInfo

Status: Active

SQL Type: varchar(1000)

Java Type: String

Attributes:

Transaction Id

Added On: 01/17/18

SQL Column: TRANSACTION_ID

Java Field: transactionId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Url Suffix

Added On: 01/17/18

SQL Column: URL_SUFFIX

Java Field: urlSuffix

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes: