Taba Pay Auth Retail Transaction UML

Added On: 08/01/18

SQL Table: TABA_PAY_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TabaPayAuthRetailTransaction

Available Fields:

Account Id
Account Number
Amount
Approval Code
Avs Authorize Id
Avs Code Avs
Avs Code Security Code
Avs Ec
Avs Network Rc
Avs Result Text
Card Pull Country
Card Pull Currency
Card Pull Enabled
Card Pull Network
Card Pull Regulated
Card Pull Type
Card Push Availability
Card Push Country
Card Push Currency
Card Push Enabled
Card Push Network
Card Push Regulated
Card Push Type
Charge Transaction
Corresponding Id
Currency

Ec
Em
Errors
Expiration Date
Fees Interchange
Fees Network
Fees Pull Interchange
Fees Pull Network
Fees Pull Tabapay
Fees Push Interchange
Fees Push Network
Fees Push Tabapay
Fees Tabapay
Id
Memo
Merchant Account Code
Network
Network Rc
Owner Address City
Owner Address Country
Owner Address Line 1
Owner Address Line 2
Owner Address State
Owner Address Zip Code
Owner First Name
Owner Last Name

Owner Phone
Pull Options 3ds ECI
Pull Options 3ds UCAF
Pull Options 3ds XID
Pull Options Recurring
Quasi Cash
Reference Id
Retail Transaction Cycle
Reversal Error
Reversal Network Rc
Reversal Status
Sc
Security Code
Soft Descriptor Address City
Soft Descriptor Address Country
Soft Descriptor Address County
Soft Descriptor Address Line 1
Soft Descriptor Address Line 2
Soft Descriptor Address State
Soft Descriptor Address Zip Code
Soft Descriptor Name
Soft Descriptor Phone Code
Soft Descriptor Phone Number
Status
Transaction Id
Transaction Type

Type

Account Id

Added On: 08/01/18

SQL Column: ACCOUNT_ID

Java Field: accountId

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes: Transient

Account Number

Added On: 08/01/18

SQL Column: ACCOUNT_NUMBER

Java Field: accountNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes: Transient

Amount

Added On: 08/01/18

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Approval Code

Added On: 08/01/18

SQL Column: APPROVAL_CODE

Java Field: approvalCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Avs Authorize Id

Added On: 08/01/18

SQL Column: AVS_AUTHORIZE_ID

Java Field: avsAuthorizeId

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Avs Code Avs

Added On: 08/01/18

SQL Column: AVS_CODE_AVS

Java Field: avsCodeAvs

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Avs Code Security Code

Added On: 08/01/18

SQL Column: AVS_CODE_SECURITY_CODE

Java Field: avsCodeSecurityCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Avs Ec

Added On: 08/01/18

SQL Column: AVS_EC

Java Field: avsEc

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Avs Network Rc

Added On: 08/01/18

SQL Column: AVS_NETWORK_RC

Java Field: avsNetworkRc

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Avs Result Text

Added On: 08/01/18

SQL Column: AVS_RESULT_TEXT

Java Field: avsResultText

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Card Pull Country

Added On: 08/01/18

SQL Column: CARD_PULL_COUNTRY

Java Field: cardPullCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Card Pull Currency

Added On: 08/01/18

SQL Column: CARD_PULL_CURRENCY

Java Field: cardPullCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Card Pull Enabled

Added On: 08/01/18

SQL Column: CARD_PULL_ENABLED

Java Field: cardPullEnabled

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Card Pull Network

Added On: 08/01/18

SQL Column: CARD_PULL_NETWORK

Java Field: cardPullNetwork

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Card Pull Regulated

Added On: 08/01/18

SQL Column: CARD_PULL_REGULATED

Java Field: cardPullRegulated

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Card Pull Type

Added On: 08/01/18

SQL Column: CARD_PULL_TYPE

Java Field: cardPullType

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Card Push Availability

Added On: 08/01/18

SQL Column: CARD_PUSH_AVAILABILITY

Java Field: cardPushAvailability

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Card Push Country

Added On: 08/01/18

SQL Column: CARD_PUSH_COUNTRY

Java Field: cardPushCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Card Push Currency

Added On: 08/01/18

SQL Column: CARD_PUSH_CURRENCY

Java Field: cardPushCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Card Push Enabled

Added On: 08/01/18

SQL Column: CARD_PUSH_ENABLED

Java Field: cardPushEnabled

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Card Push Network

Added On: 08/01/18

SQL Column: CARD_PUSH_NETWORK

Java Field: cardPushNetwork

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Card Push Regulated

Added On: 08/01/18

SQL Column: CARD_PUSH_REGULATED

Java Field: cardPushRegulated

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Card Push Type

Added On: 08/01/18

SQL Column: CARD_PUSH_TYPE

Java Field: cardPushType

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Charge Transaction

Added On: 08/01/18

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Corresponding Id

Added On: 08/01/18

SQL Column: CORRESPONDING_ID

Java Field: correspondingId

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Currency

Added On: 08/01/18

SQL Column: CURRENCY

Java Field: currency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Added On: 08/01/18

SQL Column: EC

Java Field: ec

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Added On: 08/01/18

SQL Column: EM

Java Field: em

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Errors

Added On: 08/01/18

SQL Column: ERRORS

Java Field: errors

Status: Active

SQL Type: varchar(27)

Java Type: String

Attributes:

Expiration Date

Added On: 08/01/18

SQL Column: EXPIRATION_DATE

Java Field: expirationDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes: Transient

Fees Interchange

Added On: 08/01/18

SQL Column: FEES_INTERCHANGE

Java Field: feesInterchange

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Network

Added On: 08/01/18

SQL Column: FEES_NETWORK

Java Field: feesNetwork

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Pull Interchange

Added On: 08/01/18

SQL Column: FEES_PULL_INTERCHANGE

Java Field: feesPullInterchange

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Pull Network

Added On: 08/01/18

SQL Column: FEES_PULL_NETWORK

Java Field: feesPullNetwork

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Pull Tabapay

Added On: 08/01/18

SQL Column: FEES_PULL_TABAPAY

Java Field: feesPullTabapay

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Push Interchange

Added On: 08/01/18

SQL Column: FEES_PUSH_INTERCHANGE

Java Field: feesPushInterchange

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Push Network

Added On: 08/01/18

SQL Column: FEES_PUSH_NETWORK

Java Field: feesPushNetwork

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Push Tabapay

Added On: 08/01/18

SQL Column: FEES_PUSH_TABAPAY

Java Field: feesPushTabapay

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Fees Tabapay

Added On: 08/01/18

SQL Column: FEES_TABAPAY

Java Field: feesTabapay

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Added On: 08/01/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.

Memo

Added On: 08/01/18

SQL Column: MEMO

Java Field: memo

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Merchant Account Code

Added On: 08/01/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.

Network

Added On: 08/01/18

SQL Column: NETWORK

Java Field: network

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Network Rc

Added On: 08/01/18

SQL Column: NETWORK_RC

Java Field: networkRc

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Owner Address City

Added On: 08/01/18

SQL Column: OWNER_ADDRESS_CITY

Java Field: ownerAddressCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Owner Address Country

Added On: 08/01/18

SQL Column: OWNER_ADDRESS_COUNTRY

Java Field: ownerAddressCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Owner Address Line 1

Added On: 08/01/18

SQL Column: OWNER_ADDRESS_LINE1

Java Field: ownerAddressLine1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Owner Address Line 2

Added On: 08/01/18

SQL Column: OWNER_ADDRESS_LINE2

Java Field: ownerAddressLine2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Owner Address State

Added On: 08/01/18

SQL Column: OWNER_ADDRESS_STATE

Java Field: ownerAddressState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Owner Address Zip Code

Added On: 08/01/18

SQL Column: OWNER_ADDRESS_ZIP_CODE

Java Field: ownerAddressZipCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Owner First Name

Added On: 08/01/18

SQL Column: OWNER_FIRST_NAME

Java Field: ownerFirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Owner Last Name

Added On: 08/01/18

SQL Column: OWNER_LAST_NAME

Java Field: ownerLastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Owner Phone

Added On: 08/01/18

SQL Column: OWNER_PHONE

Java Field: ownerPhone

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Pull Options 3ds ECI

Added On: 08/01/18

SQL Column: PULL_OPTIONS3DS_ECI

Java Field: pullOptions3dsECI

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Pull Options 3ds UCAF

Added On: 08/01/18

SQL Column: PULL_OPTIONS3DS_UCAF

Java Field: pullOptions3dsUCAF

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Pull Options 3ds XID

Added On: 08/01/18

SQL Column: PULL_OPTIONS3DS_XID

Java Field: pullOptions3dsXID

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Pull Options Recurring

Added On: 08/01/18

SQL Column: PULL_OPTIONS_RECURRING

Java Field: pullOptionsRecurring

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Quasi Cash

Added On: 08/01/18

SQL Column: QUASI_CASH

Java Field: quasiCash

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes:

Reference Id

Added On: 08/01/18

SQL Column: REFERENCE_ID

Java Field: referenceId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Retail Transaction Cycle

Added On: 08/01/18

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Reversal Error

Added On: 08/01/18

SQL Column: REVERSAL_ERROR

Java Field: reversalError

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Reversal Network Rc

Added On: 08/01/18

SQL Column: REVERSAL_NETWORK_RC

Java Field: reversalNetworkRc

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Reversal Status

Added On: 08/01/18

SQL Column: REVERSAL_STATUS

Java Field: reversalStatus

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Added On: 08/01/18

SQL Column: SC

Java Field: sc

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Security Code

Added On: 08/01/18

SQL Column: SECURITY_CODE

Java Field: securityCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes: Transient

Soft Descriptor Address City

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_CITY

Java Field: softDescriptorAddressCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Soft Descriptor Address Country

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_COUNTRY

Java Field: softDescriptorAddressCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Soft Descriptor Address County

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_COUNTY

Java Field: softDescriptorAddressCounty

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Soft Descriptor Address Line 1

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_LINE1

Java Field: softDescriptorAddressLine1

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Soft Descriptor Address Line 2

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_LINE2

Java Field: softDescriptorAddressLine2

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Soft Descriptor Address State

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_STATE

Java Field: softDescriptorAddressState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Soft Descriptor Address Zip Code

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_ADDRESS_ZIP_CODE

Java Field: softDescriptorAddressZipCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Soft Descriptor Name

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_NAME

Java Field: softDescriptorName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Soft Descriptor Phone Code

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_PHONE_CODE

Java Field: softDescriptorPhoneCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Soft Descriptor Phone Number

Added On: 08/01/18

SQL Column: SOFT_DESCRIPTOR_PHONE_NUMBER

Java Field: softDescriptorPhoneNumber

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Status

Added On: 08/01/18

SQL Column: STATUS

Java Field: status

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Transaction Id

Added On: 08/01/18

SQL Column: TRANSACTION_ID

Java Field: transactionId

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Transaction Type

Added On: 08/01/18

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Type

Added On: 08/01/18

SQL Column: TYPE

Java Field: type

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes: