UniPay Retail File Batch

Parent: File Batch

Added On: 09/29/16

SQL Table: UNI_PAY_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: UniPayRetailFileBatch

Represents information about retail file batch within TidyPay.

Available Fields:

Cycle Code
Error Code
Error Message
Exception Cause
Exception Field
Exception Format
Exception Hint
Exception Level
Exception Processor
Exception Value

Failed Request Type
Failure Code
Failure Message
Last Reference Number
Password
Provider Merchant Account Code
Total Credit Amount
Total Credit Auth Amount
Total Credit Auth Count
Total Credit Count

Total Decline Amount
Total Decline Count
Total Sale Amount
Total Sale Auth Amount
Total Sale Auth Count
Total Sale Count
Total Transaction Amount
Total Transaction Count
Total Void Amount
Total Void Count

Username

Cycle Code

Added On: 09/29/16

SQL Column: CYCLE_CODE

Java Field: cycleCode

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Cycle code of associated with the record.

Error Code

Added On: 09/29/16

SQL Column: ERROR_CODE

Java Field: errorCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Error code generated by the system.

Error Message

Added On: 09/29/16

SQL Column: ERROR_MESSAGE

Java Field: errorMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Error message generated by the system.

Exception Cause

Added On: 09/29/16

SQL Column: EXCEPTION_CAUSE

Java Field: exceptionCause

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Cause of the exception error that occurred within the system.

Exception Field

Added On: 09/29/16

SQL Column: EXCEPTION_FIELD

Java Field: exceptionField

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Field that caused exception error within the system.

Exception Format

Added On: 09/29/16

SQL Column: EXCEPTION_FORMAT

Java Field: exceptionFormat

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Additional information about formatting exception error.

Exception Hint

Added On: 09/29/16

SQL Column: EXCEPTION_HINT

Java Field: exceptionHint

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Exception Level

Added On: 09/29/16

SQL Column: EXCEPTION_LEVEL

Java Field: exceptionLevel

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Place where exception error occurred.

Exception Processor

Added On: 09/29/16

SQL Column: EXCEPTION_PROCESSOR

Java Field: exceptionProcessor

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Processor associated with occurred exception.

Exception Value

Added On: 09/29/16

SQL Column: EXCEPTION_VALUE

Java Field: exceptionValue

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Code value of the exception error.

Failed Request Type

Added On: 09/29/16

SQL Column: FAILED_REQUEST_TYPE

Java Field: failedRequestType

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Type of the request failed to process.

Failure Code

Added On: 09/29/16

SQL Column: FAILURE_CODE

Java Field: failureCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Failure code generated by the system.

Failure Message

Added On: 09/29/16

SQL Column: FAILURE_MESSAGE

Java Field: failureMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Failure message generated by the system.

Last Reference Number

Added On: 09/29/16

SQL Column: LAST_REFERENCE_NUMBER

Java Field: lastReferenceNumber

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Last assigned secondary identifier which can be used to cross-reference records between TidyPay and integrated systems.

Password

Added On: 09/29/16

SQL Column:

Java Field: password

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Password of the user associated with the file.

Provider Merchant Account Code

Added On: 09/29/16

SQL Column: PROVIDER_MERCHANT_ACCOUNT_CODE

Java Field: providerMerchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant account code assigned by a processor for identification in processor's system.

Total Credit Amount

Added On: 09/29/16

SQL Column: TOTAL_CREDIT_AMOUNT

Java Field: totalCreditAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount included in credit transactions within the batch file.

Total Credit Auth Amount

Added On: 09/29/16

SQL Column: TOTAL_CREDIT_AUTH_AMOUNT

Java Field: totalCreditAuthAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount included in credit auth transactions within the batch file.

Total Credit Auth Count

Added On: 09/29/16

SQL Column: TOTAL_CREDIT_AUTH_COUNT

Java Field: totalCreditAuthCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of credit auth transactions included in batch file.

Total Credit Count

Added On: 09/29/16

SQL Column: TOTAL_CREDIT_COUNT

Java Field: totalCreditCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of credit transactions within the batch file.

Total Decline Amount

Added On: 09/29/16

SQL Column: TOTAL_DECLINE_AMOUNT

Java Field: totalDeclineAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount included in decline transactions within the batch file.

Total Decline Count

Added On: 09/29/16

SQL Column: TOTAL_DECLINE_COUNT

Java Field: totalDeclineCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of decline transactions included in batch file.

Total Sale Amount

Added On: 09/29/16

SQL Column: TOTAL_SALE_AMOUNT

Java Field: totalSaleAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount included in sale transactions within the batch file.

Total Sale Auth Amount

Added On: 09/30/16

SQL Column: TOTAL_SALE_AUTH_AMOUNT

Java Field: totalSaleAuthAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount included in sale auth transactions within the batch file.

Total Sale Auth Count

Added On: 09/29/16

SQL Column: TOTAL_SALE_AUTH_COUNT

Java Field: totalSaleAuthCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of sale auth transactions included in the batch file.

Total Sale Count

Added On: 09/29/16

SQL Column: TOTAL_SALE_COUNT

Java Field: totalSaleCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of sale transactions included in batch file.

Total Transaction Amount

Added On: 09/29/16

SQL Column: TOTAL_TRANSACTION_AMOUNT

Java Field: totalTransactionAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount of all transactions included in batch file.

Total Transaction Count

Added On: 09/29/16

SQL Column: TOTAL_TRANSACTION_COUNT

Java Field: totalTransactionCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of the transactions included in the batch file.

Total Void Amount

Added On: 09/29/16

SQL Column: TOTAL_VOID_AMOUNT

Java Field: totalVoidAmount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Amount included in void transactions within the batch file.

Total Void Count

Added On: 09/29/16

SQL Column: TOTAL_VOID_COUNT

Java Field: totalVoidCount

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Number of void transactions included in batch file.

Username

Added On: 09/29/16

SQL Column:

Java Field: userName

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Name of the user associated with the file.

All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.