Investbank Auth Retail Transaction UML

Added On: 09/01/14

SQL Table: INVESTBANK_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: InvestbankAuthRetailTransaction

InvestBank specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, InvestBank specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.

Available Fields:

Amount
Auth Code
Billing Adr
CAVV
Charge Transaction FK
Currency
CVV 2
Description
ECI

Email
Exp Date
Ext Error
Id
Merchant
Merchant Account Code
Merchant Code
Name
Operation

PAN
Phone
Rel Data
Retail Transaction Cycle FK
RRN
Shipping Adr
Status
Surname
Time

Tr ID
XID

Amount

Added On: 09/01/14

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.

Auth Code

Added On: 09/01/14

SQL Column: AUTH_CODE

Java Field: authCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

The authCode element specifies the authorization code from the associated Authorization or Sale transaction.

Billing Adr

Added On: 09/01/14

SQL Column: BILLING_ADR

Java Field: billingAdr

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

CAVV

Added On: 09/15/14

SQL Column:

Java Field: cavv

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

CAVV code of the card.

Charge Transaction FK

Added On: 09/01/14

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.

Currency

Added On: 09/01/14

SQL Column: CURRENCY

Java Field: currency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

CVV 2

Added On: 09/15/14

SQL Column:

Java Field: cvv2

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Description

Added On: 09/01/14

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ECI

Added On: 09/01/14

SQL Column: ECI

Java Field: eci

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Added On: 09/01/14

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Exp Date

Added On: 09/15/14

SQL Column:

Java Field: expdate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Ext Error

Added On: 09/01/14

SQL Column: EXT_ERROR

Java Field: extError

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 09/01/14

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

Added On: 09/01/14

SQL Column: MERCHANT

Java Field: merchant

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

Merchant Account Code

Added On: 09/01/14

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.

Merchant Code

Added On: 09/01/14

SQL Column: MERCHANT_CODE

Java Field: merchantCode

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Name

Added On: 09/01/14

SQL Column: NAME

Java Field: name

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Operation

Added On: 09/01/14

SQL Column: OPERATION

Java Field: operation

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

PAN

Added On: 09/15/14

SQL Column:

Java Field: pan

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Phone

Added On: 09/01/14

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Rel Data

Added On: 09/01/14

SQL Column: REL_DATA

Java Field: relData

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 09/01/14

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Reference to the entity that represents a group of real-time transactions which must be settled together.

RRN

Added On: 09/01/14

SQL Column: RRN

Java Field: rrn

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Shipping Adr

Added On: 09/01/14

SQL Column: SHIPPING_ADR

Java Field: shippingAdr

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Status

Added On: 09/01/14

SQL Column: STATUS

Java Field: status

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Surname

Added On: 09/01/14

SQL Column: SURNAME

Java Field: surname

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Time

Added On: 09/01/14

SQL Column: TIME

Java Field: time

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Tr ID

Added On: 09/01/14

SQL Column: TR_ID

Java Field: trId

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

XID

Added On: 09/15/14

SQL Column:

Java Field: xid

Status: Active

SQL Type:

Java Type: String

Attributes: Transient