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 UniPay.

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 UniPay 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.