CC Elavon Batch Transaction UML

Added On: 08/30/12

SQL Table: CC_ELAVON_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: CcElavonBatchTransaction

Entity that represents a batch transaction as it is defined in Elavon's batch processing specification.

Available Fields:

ACI
ALP Value
Amount
Auth Code
Auth Source Code
AVS Address
AVS Result
AVS ZIP Code
Card Number
CAT Value

CC Elavon Batch FK
Charge Transaction FK
CVV2 Response
Expanded Reply
Expiration Date
Format Data
Id
Merchant Account Code
MSDI
Original Authorized Amount

Original Transaction Id
Product Code
Reply Code
Swiped Indicator
Transaction Code
Transaction Date
Transaction Time
User Data
Visa Transaction ID
Visa Validation Code

ACI

Added On: 06/07/13

SQL Column: ACI

Java Field: aci

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Authorization Characteristic Indicator.

ALP Value

Added On: 06/07/13

SQL Column: ALP_VALUE

Java Field: alpValue

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Account Level Processing.
The ALP response code returned from authorization.

Amount

Added On: 08/30/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

The transaction amount in the cardholder’s currency in 9(10)v99 format.

Auth Code

Added On: 08/30/12

SQL Column: AUTH_CODE

Java Field: authCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

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

Auth Source Code

Added On: 08/30/12

SQL Column: AUTH_SOURCE_CODE

Java Field: authSourceCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

This value is used to indicate the source for the authorization response. The values in this response message are subject to additions.

For On-Line transactions, the codes are supplied by the Issuer and are returned by Elavon in the response message for all on line approvals.
For Off-Line transactions, this is a one character field in the table below contains the Authorization Source code:

9 = No Authorization Source Code. This is used for non-authorized transactions, such as Credit Card Returns.
E = Off-Line Approval. This is used when the approval code is manually entered, such as on a Referral or Force Transaction.
6 = Off-Line approval, POS generated the approval.

AVS Address

Added On: 08/30/12

SQL Column: AVS_ADDRESS

Java Field: avsAddress

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Address Verification Service mailing address.

AVS Result

Added On: 08/30/12

SQL Column: AVS_RESULT

Java Field: avsResult

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Address Verification Service Result Code.

AVS ZIP Code

Added On: 08/30/12

SQL Column: AVS_ZIP_CODE

Java Field: avsZipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Address Verification Service ZIP/postal code.

Card Number

Added On: 09/03/12

SQL Column:

Java Field: cardNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The number of the credit card or bank account.

CAT Value

Added On: 06/07/13

SQL Column: CAT_VALUE

Java Field: catValue

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

This value is used to indicate the type of Cardholder Activated Terminal Indicator for this transaction.

CC Elavon Batch FK

Added On: 08/30/12

SQL Column: CC_ELAVON_BATCH_FK

Java Field: ccElavonBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References CС Elavon Batch

Attributes:

Reference to the entity that represents Elavon 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.

CVV2 Response

Added On: 06/07/13

SQL Column: CVV2_RESPONSE

Java Field: cvv2Response

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

This value contains the Card verification response code returned in Authorization Response. It is also a required value for a terminal-based settlement message, if returned in the authorization response.

M = Match
N = No match
P = Not Processed
S = Issuer indicates that CVV2 data should be present on the card, but the merchant has indicated that the CVV2 data is not present on the card (Visa Only)
U = Issuer not certified or registered to process card verification

Expanded Reply

Added On: 08/30/12

SQL Column: EXPANDED_REPLY

Java Field: expandedReply

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Expanded reply code. Refer to the specification of te provider to view list of available expanded codes.

Expiration Date

Added On: 09/03/12

SQL Column:

Java Field: expirationDate

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The card expiration date (MMYY).

Format Data

Added On: 08/30/12

SQL Column: FORMAT_DATA

Java Field: formatData

Status: Active

SQL Type: varchar(63)

Java Type: String

Attributes:

The composite field to store different data depending on the industry, and the type of credit card (such as Tax Amount, Invoice Number, etc).

Added On: 08/30/12

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: 08/30/12

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.

MSDI

Added On: 08/05/13

SQL Column: MSDI

Java Field: msdi

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

The Market Specific Data Indicator value.

0 = Returned if the data was not presented in authorization
1 = Returned if the data passed the Hotel Edits (H)
2 = Returned if the data failed Edits (N)
3 = Healthcare / Auto-Substantiation (M)
4 = Transit / Auto-Substantiation (T)
5 = Returned if the data passed the Visa Aggregator edits (E)
6 = Returned if the data passed the Auto Rental edits (A)
7 = Returned if the data passed the Bill Payment edits (B)
8 = Returned if the data passed the MasterCard Payment Gateway edits (G)
9 = Business to Business Invoice Payments (J)

Original Authorized Amount

Added On: 06/07/13

SQL Column: ORIGINAL_AUTHORIZED_AMOUNT

Java Field: originalAuthorizedAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Original amount authorized for this transaction in 9(8)v99 format, or the amount of cashback for debit card transaction.

Original Transaction Id

Added On: 03/04/20

SQL Column: ORIGINAL_TRANSACTION_ID

Java Field: originalTransactionId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Product Code

Added On: 08/30/12

SQL Column: PRODUCT_CODE

Java Field: productCode

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

A part number or catalog number for the line item.

Reply Code

Added On: 08/30/12

SQL Column: REPLY_CODE

Java Field: replyCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Authorization Reply Code (in fact this is response code, indicating result of the transaction).

Swiped Indicator

Added On: 06/07/13

SQL Column: SWIPED_INDICATOR

Java Field: swipedIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates the card number in transaction swiped or keyed.

Transaction Code

Added On: 08/30/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

The code of the initial transaction. Provided by the processor.

A = Authorization Only
B = Cash Benefit Purchase (EBT)
C = Cash Advance
F = Food Stamp Purchase (EBT)
P = MC Payment Transaction
R = Return Voucher
S = Sales Draft
W = Food Stamp Return (EBT)
X = Sales Draft Reversal
Y = Cash Advance Reversal
Z = Return Voucher Reversal

Transaction Date

Added On: 08/30/12

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

The date when the transaction was initiated.

Transaction Time

Added On: 08/30/12

SQL Column: TRANSACTION_TIME

Java Field: transactionTime

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

The time when the transaction was initiated.

User Data

Added On: 08/30/12

SQL Column: USER_DATA

Java Field: userData

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Additional user data.

Visa Transaction ID

Added On: 06/07/13

SQL Column: VISA_TRANSACTION_ID

Java Field: visaTransactionId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

The CPS Transaction ID that is returned on the original authorization response.

Visa Validation Code

Added On: 06/07/13

SQL Column: VISA_VALIDATION_CODE

Java Field: visaValidationCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

The CPS Validation Code returned on the original authorization response.