CC MWE Batch Transaction UML

Added On: 05/16/14

SQL Table: CC_MWE_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: CcMweBatchTransaction

Entity that represents a batch transaction as it is defined in batch processing specification of MWE (Merchant Warrior Express).

Available Fields:

Card ID
CC MWE Batch FK
Charge Transaction FK
Created Date
Created Time
Custom1
Custom2
Custom3
Customer Address

Customer City
Customer Country
Customer Email
Customer Phone
Customer Post Code
Customer State
Id
Merchant Account Code
MW Response

Payment Card Expiry
Payment Card Name
Payment Card Number
Processed Date
Processed Time
Provider Response
Result Message
Transaction Amount
Transaction ID

Transaction Product
Transaction Reference ID

Card ID

Added On: 09/16/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.

CC MWE Batch FK

Added On: 05/16/14

SQL Column: CC_MWE_BATCH_FK

Java Field: ccMweBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References CC MWE Batch

Attributes:

Reference to the entity that represents MWE credit card batch file.

Charge Transaction FK

Added On: 06/09/16

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.

Created Date

Added On: 05/16/14

SQL Column: CREATED_DATE

Java Field: createdDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

This field contains a value that corresponds to the date that the file is created.

Created Time

Added On: 05/16/14

SQL Column: CREATED_TIME

Java Field: createdTime

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

This field contains a value that corresponds to the time that the file is created.

Custom1

Added On: 05/16/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: 05/16/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: 05/16/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: 05/16/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: 05/16/14

SQL Column: CUSTOMER_CITY

Java Field: customerCity

Status: Active

SQL Type: varchar(75)

Java Type: String

Attributes:

City of customer's postal address.

Customer Country

Added On: 05/16/14

SQL Column: CUSTOMER_COUNTRY

Java Field: customerCountry

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country of customer's postal address.

Customer Email

Added On: 05/16/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: 05/16/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: 05/16/14

SQL Column: CUSTOMER_POST_CODE

Java Field: customerPostCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Customer's postal code.

Customer State

Added On: 05/16/14

SQL Column: CUSTOMER_STATE

Java Field: customerState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State of customer's postal address.

Added On: 05/16/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: 05/16/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.

MW Response

Added On: 06/20/14

SQL Column: MW_RESPONSE

Java Field: mwResponse

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

The response message from the Merchant Warrior.

Payment Card Expiry

Added On: 06/09/16

SQL Column:

Java Field: paymentCardExpiry

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Expiration date of the payment card.

Payment Card Name

Added On: 05/16/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: 06/09/16

SQL Column:

Java Field: paymentCardNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Card number of the payment card.

Processed Date

Added On: 05/16/14

SQL Column: PROCESSED_DATE

Java Field: processedDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

This field contains a value that corresponds to the date that the file was processed.

Processed Time

Added On: 05/16/14

SQL Column: PROCESSED_TIME

Java Field: processedTime

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

This field contains a value that corresponds to the time that the file was processed.

Provider Response

Added On: 05/16/14

SQL Column: PROVIDER_RESPONSE

Java Field: providerResponse

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

The response text message from the provider.

Result Message

Added On: 05/16/14

SQL Column: RESULT_MESSAGE

Java Field: resultMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

The result text message from the provider.

Transaction Amount

Added On: 05/16/14

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

The amount must be formatted to have two decimal places. Any amounts without two decimal places or amounts less than one cent will be rejected.

Transaction ID

Added On: 05/16/14

SQL Column: TRANSACTION_ID

Java Field: transactionId

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

The <transactionID> returned for the initial transaction.

Transaction Product

Added On: 05/16/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 identifiable for reporting and accounting purposes.

Transaction Reference ID

Added On: 05/16/14

SQL Column: TRANSACTION_REFERENCE_ID

Java Field: transactionReferenceId

Status: Active

SQL Type: varchar(50)

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.