Mercury Pay Retail File Batch

Parent: File Batch

Added On: 01/11/13

SQL Table: MERCURY_PAY_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: MercuryPayRetailFileBatch

Mercury Pay specific File Batch representation for the settlement process. It represents a group of Mercury Pay Capture Retail Transaction objects that are settled together as a group within a single file.
During Generation Process, Mercury Pay Retail File Batch is converted into a settlement file, which is then registered into File Store for further processing.

Available Fields:

Batch Item Count
Batch No
Batch Validation Message
CMD Status
Control No
Credit Purchase Amount
Credit Purchase Count
Credit Return Amount
Credit Return Count
Debit Purchase Amount

Debit Purchase Count
Debit Return Amount
Debit Return Count
DSIX Return Code
Expected Credit Purchase Amount
Expected Credit Purchase Count
Expected Credit Return Amount
Expected Credit Return Count
Expected Debit Purchase Amount
Expected Debit Purchase Count

Expected Debit Return Amount
Expected Debit Return Count
Memo
Merchant ID
Net Batch Total
Operator ID
Password
Response Origin
Text Response
Tran Code

User Trace Data

Batch Item Count

Added On: 01/11/13

SQL Column: BATCH_ITEM_COUNT

Java Field: batchItemCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The number of transactions.

Batch No

Added On: 01/11/13

SQL Column: BATCH_NO

Java Field: batchNo

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Batch Validation Message

Added On: 01/11/13

SQL Column: BATCH_VALIDATION_MESSAGE

Java Field: batchValidationMessage

Status: Active

SQL Type: varchar(400)

Java Type: String

Attributes:

CMD Status

Added On: 01/11/13

SQL Column: CMD_STATUS

Java Field: cmdStatus

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Status, received if there are transactions with the same amount and on the same card.

The Command Status is the outcome of the transaction:
"Approved", "Declined" (for Credit, Debit, EBT, Check and Prepaid), "Success" (for Admin requests) or "Error."

Control No

Added On: 01/11/13

SQL Column: CONTROL_NO

Java Field: controlNo

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Credit Purchase Amount

Added On: 01/11/13

SQL Column: CREDIT_PURCHASE_AMOUNT

Java Field: creditPurchaseAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

The amount for sale transactions by credit card.

Credit Purchase Count

Added On: 01/11/13

SQL Column: CREDIT_PURCHASE_COUNT

Java Field: creditPurchaseCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The number of sale transactions by credit card.

Credit Return Amount

Added On: 01/11/13

SQL Column: CREDIT_RETURN_AMOUNT

Java Field: creditReturnAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Credit Return Count

Added On: 01/11/13

SQL Column: CREDIT_RETURN_COUNT

Java Field: creditReturnCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Debit Purchase Amount

Added On: 01/11/13

SQL Column: DEBIT_PURCHASE_AMOUNT

Java Field: debitPurchaseAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Debit Purchase Count

Added On: 01/11/13

SQL Column: DEBIT_PURCHASE_COUNT

Java Field: debitPurchaseCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Debit Return Amount

Added On: 01/11/13

SQL Column: DEBIT_RETURN_AMOUNT

Java Field: debitReturnAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Debit Return Count

Added On: 01/11/13

SQL Column: DEBIT_RETURN_COUNT

Java Field: debitReturnCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

DSIX Return Code

Added On: 01/11/13

SQL Column: DSIX_RETURN_CODE

Java Field: dsixReturnCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Server specific or DSIClientX specific TCP/IP six digit codes corresponding to a single or dynamic or variable message text.

Expected Credit Purchase Amount

Added On: 01/11/13

SQL Column: EXPECTED_CREDIT_PURCHASE_AMOUNT

Java Field: expectedCreditPurchaseAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Expected Credit Purchase Count

Added On: 01/11/13

SQL Column: EXPECTED_CREDIT_PURCHASE_COUNT

Java Field: expectedCreditPurchaseCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Expected Credit Return Amount

Added On: 01/11/13

SQL Column: EXPECTED_CREDIT_RETURN_AMOUNT

Java Field: expectedCreditReturnAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Expected Credit Return Count

Added On: 01/11/13

SQL Column: EXPECTED_CREDIT_RETURN_COUNT

Java Field: expectedCreditReturnCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Expected Debit Purchase Amount

Added On: 01/11/13

SQL Column: EXPECTED_DEBIT_PURCHASE_AMOUNT

Java Field: expectedDebitPurchaseAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Expected Debit Purchase Count

Added On: 01/11/13

SQL Column: EXPECTED_DEBIT_PURCHASE_COUNT

Java Field: expectedDebitPurchaseCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Expected Debit Return Amount

Added On: 01/11/13

SQL Column: EXPECTED_DEBIT_RETURN_AMOUNT

Java Field: expectedDebitReturnAmount

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Expected Debit Return Count

Added On: 01/11/13

SQL Column: EXPECTED_DEBIT_RETURN_COUNT

Java Field: expectedDebitReturnCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Memo

Added On: 01/11/13

SQL Column: MEMO

Java Field: memo

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Required field in all ActiveX and WebServices integrations

Merchant ID

Added On: 01/11/13

SQL Column: MERCHANT_ID

Java Field: merchantId

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Merchant identifier, assigned by the processor

Net Batch Total

Added On: 01/11/13

SQL Column: NET_BATCH_TOTAL

Java Field: netBatchTotal

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Total sum of money.

Operator ID

Added On: 01/11/13

SQL Column: OPERATOR_ID

Java Field: operatorId

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Identifier of the operator carrying the transaction

Password

Added On: 06/10/16

SQL Column:

Java Field: password

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Response Origin

Added On: 01/11/13

SQL Column: RESPONSE_ORIGIN

Java Field: responseOrigin

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

The source of the response as "Client" (from the DSIClientX control), "Server," (Mercury's platform processing servers) or "Processor" (the back end processing network).

Text Response

Added On: 01/11/13

SQL Column: TEXT_RESPONSE

Java Field: textResponse

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

TextResponse is used to qualify the CmdStatus.

Tran Code

Added On: 01/11/13

SQL Column: TRAN_CODE

Java Field: tranCode

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

The actual transactions run (as in Sale, Return, Balance, etc.) under these specific tenders.

User Trace Data

Added On: 01/11/13

SQL Column: USER_TRACE_DATA

Java Field: userTraceData

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Сertain information associated with the authorization.