Credorax Epower Auth Retail Transaction UML

Added On: 09/01/14

SQL Table: CREDORAX_EPOWER_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: CredoraxEpowerAuthRetailTransaction

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

Available Fields:

C7
C8
Charge Transaction FK
D1
D2
G2
G3
G4
H3
H9
I1
I2
I8
Id
M
Merchant Account Code

O
Retail Transaction Cycle FK
Sign Key
T
Z1
Z13
Z14
Z15
Z16
Z17
Z2
Z3
Z4
Z5
Z6
Z9

Added On: 09/01/14

SQL Column: A1

Java Field: a1

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Reference number of the transaction. Corresponds to the referenceNumber field in the gateway.

Added On: 09/01/14

SQL Column: A2

Java Field: a2

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Payment source of the transaction. Corresponds to the transactionIndustryType field in the gateway.

Added On: 09/01/14

SQL Column: A4

Java Field: a4

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the transaction. Corresponds to the amount field in the gateway.
Two exponents are implied. No decimal point is used (except for currencies with zero exponents).

Added On: 08/07/15

SQL Column: A5

Java Field: a5

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Presentment currency.

Indicates the presentment currency that should be used in the transaction (the use of this field depends on MID setup).

Added On: 08/07/15

SQL Column: A6

Java Field: a6

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Transaction date (local date when transaction generated).

Added On: 08/07/15

SQL Column: A7

Java Field: a7

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Transaction time (local time when transaction generated).

Added On: 09/01/14

SQL Column: A9

Java Field: a9

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Category of the transaction. Corresponds to the transactionCategory field in the gateway.

Added On: 09/09/14

SQL Column:

Java Field: b1

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

PAN – primary account number.

Added On: 09/15/14

SQL Column:

Java Field: b3

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card expiration month (two digit number; format - mm).

Added On: 09/15/14

SQL Column:

Java Field: b4

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card expiration year (two digit number; format - yy).

Added On: 09/15/14

SQL Column:

Java Field: b5

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card security code (CVV / CVC) as it is printed on the card.

Added On: 09/01/14

SQL Column: C1

Java Field: c1

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Name of the cardholder. Corresponds to the holderName field in the gateway.

C10

Added On: 09/01/14

SQL Column: C10

Java Field: c10

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Cardholder's billing address postal/zip code. Corresponds to the zipCode field in the gateway.

Added On: 09/01/14

SQL Column: C2

Java Field: c2

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Cardholder's contact phone number (e.g., 999-999-9999). Corresponds to the phone field in the gateway.

Added On: 09/01/14

SQL Column: C3

Java Field: c3

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Cardholder's email address. Corresponds to the email field in the gateway.

Added On: 09/01/14

SQL Column: C5

Java Field: c5

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Street name of the cardholder's billing address. Corresponds to the street field in the gateway.

Added On: 09/01/14

SQL Column: C7

Java Field: c7

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

City name of cardholder's billing address. Corresponds to the city field in the gateway.

Added On: 08/07/15

SQL Column: C8

Java Field: c8

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Cardholder's billing address territory code, level 2 country subdivision code according to ISO-3166-2.

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.

Added On: 08/28/15

SQL Column: D1

Java Field: d1

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

IP address of cardholder.

Required for most operations except 5, 8, 16, 17, 18, 101. If required and not available, send dummy value 1.1.1.1. For card-present transactions, the IP address of the server that’s connecting to the Credorax gateway should always be sent.

Added On: 08/25/15

SQL Column: D2

Java Field: d2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Echo parameter.

Any value up to 128 bytes long sent with a request will be returned within the response.

Added On: 09/01/14

SQL Column: G2

Java Field: g2

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Response ID.

The Z1 parameter from the corresponding past transaction.

Added On: 09/01/14

SQL Column: G3

Java Field: g3

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Authorisation code.

The Z4 parameter from the corresponding past transaction.

Added On: 09/01/14

SQL Column: G4

Java Field: g4

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Request ID.

The A1 parameter from the corresponding past transaction.

Added On: 08/17/15

SQL Column: H3

Java Field: h3

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Sub-Merchant ID.

The merchant ID of a sub-merchant that belongs to a Payment
Facilitator.

Added On: 09/01/14

SQL Column: H9

Java Field: h9

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Value identifying the transaction in a submitter’s system. Corresponds to the transactionCode field in the gateway.

Added On: 09/01/14

SQL Column: I1

Java Field: i1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Description of the transaction. Corresponds to the memo field in the gateway.

Added On: 09/01/14

SQL Column: I2

Java Field: i2

Status: Active

SQL Type: varchar(39)

Java Type: String

Attributes:

Descriptor associated with the transaction. Corresponds to the descriptor field in the gateway.

Added On: 09/15/14

SQL Column: I8

Java Field: i8

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes: Transient

3D Secure data.

Consists of 3 different values, delimited by a colon sign:

ECI (сorresponds to the authenticationStatus field)
CAVV/AAV (сorresponds to the authenticationVerificationValue field)
XID (сorresponds to the authenticationCode field)

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.

Added On: 09/01/14

SQL Column: M

Java Field: m

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Merchant ID associated with the merchant account. Corresponds to the merchantAccountCode field in the gateway.

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.

Added On: 09/01/14

SQL Column: O

Java Field: o

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Operation code that is used to determine the requested service.

Possible values:

1 - Sale
2 - Authorisation
3 - Capture
4 - Authorisation Void
5 - Referral Credit
6 - Independent Credit
7 - Sale Void
8 - Refund Void
9 - Capture Void

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.

Sign Key

Added On: 06/10/16

SQL Column:

Java Field: signKey

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Added On: 09/01/14

SQL Column: T

Java Field: t

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Date of the transaction. Corresponds to the transactionDate field in the gateway.

Added On: 09/01/14

SQL Column: Z1

Java Field: z1

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Response ID.

Z13

Added On: 09/01/14

SQL Column: Z13

Java Field: z13

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Returns reference number of underlying provider. Corresponds to the providerReferenceNumber field in the gateway.

Z14

Added On: 09/01/14

SQL Column: Z14

Java Field: z14

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

CVV2 response code. Corresponds to the cvv2ResponseCode field in the gateway.

M - CVV2/CVC2 Match
N – CVV2/CVC2 No Match
P – Not processed
S – The CVV2 should be on the card but the merchant indicates it is not.
U – CVV2/CVC2 Unavailable – issuer does not support
Y – CVC1 Incorrect
- – Not processed

Z15

Added On: 09/01/14

SQL Column: Z15

Java Field: z15

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Authorized amount. Corresponds to the amount field in the gateway.

Z16

Added On: 09/01/14

SQL Column: Z16

Java Field: z16

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Remaining balance on the card (debit and gift cards only; not always available). Corresponds to the balance field in the gateway.

Z17

Added On: 09/01/14

SQL Column: Z17

Java Field: z17

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Indicates currency of transaction. Corresponds to the currencyCode field in the gateway.

Added On: 09/01/14

SQL Column: Z2

Java Field: z2

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Response code returns by the underlying processor/bank. Corresponds to the providerResponseCode field in the gateway.

Added On: 09/01/14

SQL Column: Z3

Java Field: z3

Status: Active

SQL Type: varchar(256)

Java Type: String

Attributes:

Response message returns by the underlying processor/bank. Corresponds to the providerResponseMessage field in the gateway.

Added On: 09/01/14

SQL Column: Z4

Java Field: z4

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Authorization number issued by the processor; often shown on credit card receipt. Corresponds to the approvalCode field in the gateway.

Added On: 09/01/14

SQL Column: Z5

Java Field: z5

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Risk score.

Added On: 09/01/14

SQL Column: Z6

Java Field: z6

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Gateway generated response code. Corresponds to the responseCode field in the gateway.

Added On: 09/01/14

SQL Column: Z9

Java Field: z9

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Address verification response code. Corresponds to the avsResponseCode field in the gateway.