MWE Auth Retail Transaction UML

Added On: 04/26/14

SQL Table: MWE_AUTH_RETAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: MweAuthRetailTransaction

MWE specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.

During Generation Process, MWE specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.

Available Fields:

API Key
Auth Code
Auth Message
Auth Response Code
Auth Settled Date
Capture Amount
Card ID
Charge Transaction FK
Custom1
Custom2
Custom3
Customer Address
Customer City

Customer Country
Customer Email
Customer Phone
Customer Post Code
Customer State
Hash
Id
Merchant Account Code
Merchant UUid
Method
Payment Card CSC
Payment Card Expiry
Payment Card Name

Payment Card Number
Receipt No
Refund Amount
Response Code
Response Message
Retail Transaction Cycle FK
Transaction Amount
Transaction Currency
Transaction ID Request
Transaction ID Response
Transaction Product
Transaction Reference ID
URL Suffix

API Key

Added On: 05/16/14

SQL Column: API_KEY

Java Field: apiKey

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

The value of this parameter is assigned to you by Merchant Warrior.

Auth Code

Added On: 04/26/14

SQL Column: AUTH_CODE

Java Field: authCode

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contain the upstream provider response data.

Auth Message

Added On: 04/26/14

SQL Column: AUTH_MESSAGE

Java Field: authMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Contains additional text information about the transaction.

Auth Response Code

Added On: 04/26/14

SQL Column: AUTH_RESPONSE_CODE

Java Field: authResponseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

This field contain the upstream provider response data.

Auth Settled Date

Added On: 05/16/14

SQL Column: AUTH_SETTLED_DATE

Java Field: authSettledDate

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

This field contain the upstream provider response data.

Capture Amount

Added On: 04/26/14

SQL Column: CAPTURE_AMOUNT

Java Field: captureAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

The amount of the capture.

Card ID

Added On: 09/05/14

SQL Column: CARD_ID

Java Field: cardId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

A unique alphanumeric string returned by addCard, used to identify a specific card.

Charge Transaction FK

Added On: 04/26/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.

Custom1

Added On: 04/26/14

SQL Column: CUSTOM1

Java Field: custom1

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Freeform field. Returned as <custom1> in the XML response.

Custom2

Added On: 04/26/14

SQL Column: CUSTOM2

Java Field: custom2

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Freeform field. Returned as <custom2> in the XML response.

Custom3

Added On: 04/26/14

SQL Column: CUSTOM3

Java Field: custom3

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Freeform field. Returned as <custom3> in the XML response.

Customer Address

Added On: 04/26/14

SQL Column: CUSTOMER_ADDRESS

Java Field: customerAddress

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Customer's postal address.

Customer City

Added On: 04/26/14

SQL Column: CUSTOMER_CITY

Java Field: customerCity

Status: Active

SQL Type: varchar(75)

Java Type: String

Attributes:

City of the customer's postal address.

Customer Country

Added On: 04/26/14

SQL Column: CUSTOMER_COUNTRY

Java Field: customerCountry

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country of the customer's postal address.

Customer Email

Added On: 04/26/14

SQL Column: CUSTOMER_EMAIL

Java Field: customerEmail

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Customer's email address.

Customer Phone

Added On: 04/26/14

SQL Column: CUSTOMER_PHONE

Java Field: customerPhone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Customer's phone number.

Customer Post Code

Added On: 04/26/14

SQL Column: CUSTOMER_POST_CODE

Java Field: customerPostCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Post code of the customer's postal address.

Customer State

Added On: 04/26/14

SQL Column: CUSTOMER_STATE

Java Field: customerState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State of the customer's postal address.

Hash

Added On: 04/26/14

SQL Column: HASH

Java Field: hash

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

The verifica1on hash is a combination of the MD5 of your API Passphrase, and specific parameters sent in the transaction.

Added On: 04/26/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 Account Code

Added On: 04/26/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 UUid

Added On: 04/26/14

SQL Column: MERCHANT_UUID

Java Field: merchantUuid

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

The value of this parameter is assigned to you by Merchant Warrior.

Method

Added On: 04/26/14

SQL Column: METHOD

Java Field: method

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

This is case sensitive.

Payment Card CSC

Added On: 07/14/16

SQL Column:

Java Field: paymentCardCsc

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

CSC number of the credit card used for payment.

Payment Card Expiry

Added On: 07/14/16

SQL Column:

Java Field: paymentCardExpiry

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Expiry date of the credit card used for payment.

Payment Card Name

Added On: 04/26/14

SQL Column: PAYMENT_CARD_NAME

Java Field: paymentCardName

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

This must contain at the very least a space and no less than two characters. Only alphanumeric characters, hyphens, spaces and full stops are allowed.

Payment Card Number

Added On: 07/14/16

SQL Column:

Java Field: paymentCardNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Number of the card used for payment.

Receipt No

Added On: 05/16/14

SQL Column: RECEIPT_NO

Java Field: receiptNo

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Refund Amount

Added On: 04/26/14

SQL Column: REFUND_AMOUNT

Java Field: refundAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

The amount of the refund.

Response Code

Added On: 04/26/14

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Contains a numeric bit that indicates one or many response messages.

Response Message

Added On: 04/26/14

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Contains text response to the transaction.

Retail Transaction Cycle FK

Added On: 04/26/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.

Transaction Amount

Added On: 04/26/14

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

The amount of the transaction.

Transaction Currency

Added On: 04/26/14

SQL Column: TRANSACTION_CURRENCY

Java Field: transactionCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Currency in which the transaction is done.

Transaction ID Request

Added On: 04/26/14

SQL Column: TRANSACTION_ID_REQUEST

Java Field: transactionIdRequest

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

An optional element that contains a unique user defined ID to identify the transaction. The Transaction ID will be returned in the Authorization Gateway response.

Transaction ID Response

Added On: 05/16/14

SQL Column: TRANSACTION_ID_RESPONSE

Java Field: transactionIdResponse

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

The <transactionID> returned for the initial transaction.

Transaction Product

Added On: 04/26/14

SQL Column: TRANSACTION_PRODUCT

Java Field: transactionProduct

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

A product (or sale) description. This field’s primary purpose is to help the transaction be identfiable for reporting and accouning purposes.

Transaction Reference ID

Added On: 04/26/14

SQL Column: TRANSACTION_REFERENCE_ID

Java Field: transactionReferenceId

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

This is merchant’s unique reference ID for a transaction sent to Merchant Warrior. The main purpose of this ID is to verify the transaction via queryCard method in the event a valid response is not received.

URL Suffix

Added On: 07/14/16

SQL Column:

Java Field: urlSuffix

Status: Active

SQL Type:

Java Type: String

Attributes: Transient