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.
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.
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.
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.
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.
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.
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.
Added On:  09/29/16
SQL Column:  EXCEPTION_HINT
Java Field:  exceptionHint
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.