Transaction List Export


Added On:  11/07/18 
SQL Table:  TRANSACTION_LIST_EXPORT 
Module:  UniCore 
Type:  Entity  Status:  Active 
Java Class:  TransactionListExport 
Added On:  11/07/18
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.
Added On:  11/06/18
SQL Column:  ACCOUNT_ID
Java Field:  accountId
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  ACCOUNT_NAME
Java Field:  accountName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ACCOUNT_CODE
Java Field:  accountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  RESELLER_ID
Java Field:  resellerId
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  RESELLER_NAME
Java Field:  resellerName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  STATEMENT_ID
Java Field:  statementId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  SUBMISSION_TYPE
Java Field:  submissionType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  SUBMISSION_ID
Java Field:  submissionId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  DEPOSIT_TYPE
Java Field:  depositType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
References Deposit Classifier
Attributes:
Added On:  11/06/18
SQL Column:  ACTIVITY_DATE
Java Field:  activityDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/06/18
SQL Column:  CAPTURE_DATE
Java Field:  captureDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/06/18
SQL Column:  CAPTURE_AMOUNT
Java Field:  captureAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  CAPTURE_CURRENCY_CODE
Java Field:  captureCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  INDUSTRY_TYPE
Java Field:  industryType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  TYPE
Java Field:  type
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  CATEGORY_TYPE
Java Field:  categoryType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  MEMO
Java Field:  memo
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ORIGINAL_AMOUNT
Java Field:  originalAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  REMAINING_AMOUNT
Java Field:  remainingAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  ORIGINAL_TRANSACTION_REMAINING_AMOUNT
Java Field:  originalTransactionRemainingAmount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  ORIGINAL_TRANSACTION_ID
Java Field:  originalTransactionId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  ORIGINAL_TRANSACTION_CODE
Java Field:  originalTransactionCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
References Account Classifier
Attributes:
Added On:  11/06/18
SQL Column:  TOKEN
Java Field:  token
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ACCOUNT_NUMBER
Java Field:  accountNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ACCOUNT_ACCESSORY
Java Field:  accountAccessory
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  HOLDER_NAME
Java Field:  holderName
Status:  Active
SQL Type:  varchar(151)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  TERMINAL_CODE
Java Field:  terminalCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_STREET
Java Field:  billingAddressStreet
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_CITY
Java Field:  billingAddressCity
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_STATE
Java Field:  billingAddressState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_ZIP_CODE
Java Field:  billingAddressZipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_COUNTRY_CODE
Java Field:  billingAddressCountryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_PHONE
Java Field:  billingAddressPhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  BILLING_ADDRESS_EMAIL
Java Field:  billingAddressEmail
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  11/06/18
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  INTERNAL_CODE
Java Field:  internalCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  ITEM_CODE
Java Field:  itemCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  USER_CODE
Java Field:  userCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  CUSTOMER_ACCOUNT_INTERNAL_CODE
Java Field:  customerAccountInternalCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  TICKET_NUMBER
Java Field:  ticketNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  CASE_NUMBER
Java Field:  caseNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  AVS_RESPONSE_CODE
Java Field:  avsResponseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  CSC_RESPONSE_CODE
Java Field:  cscResponseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  PROCESSOR_TRANSACTION_ID
Java Field:  processorTransactionId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  PROCESSOR_RESPONSE_CODE
Java Field:  processorResponseCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  PROCESSOR_RESPONSE_MESSAGE
Java Field:  processorResponseMessage
Status:  Active
SQL Type:  varchar(350)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  PROCESSOR_AVS_RESPONSE_CODE
Java Field:  processorAvsResponseCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  PROCESSOR_CSC_RESPONSE_CODE
Java Field:  processorCscResponseCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  INTERCHANGE_NAME
Java Field:  interchangeName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  11/06/18
SQL Column:  INTERCHANGE_PERCENTAGE_RATE
Java Field:  interchangePercentageRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Added On:  11/06/18
SQL Column:  INTERCHANGE_PERCENTAGE_AMOUNT
Java Field:  interchangePercentageAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  INTERCHANGE_ITEM_AMOUNT
Java Field:  interchangeItemAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  INTERCHANGE_TOTAL_AMOUNT
Java Field:  interchangeTotalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_PERCENTAGE_RATE
Java Field:  surchargePercentageRate
Status:  Active
SQL Type:  decimal(10,2)
Java Type:  Double
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_PERCENTAGE_AMOUNT
Java Field:  surchargePercentageAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_ITEM_RATE
Java Field:  surchargeItemRate
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_ITEM_AMOUNT
Java Field:  surchargeItemAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_TOTAL_AMOUNT
Java Field:  surchargeTotalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  SURCHARGE_FLAT_AMOUNT
Java Field:  surchargeFlatAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/06/18
SQL Column:  DATA_REGISTRY_EXPORT_CODE
Java Field:  dataRegistryExportCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  08/02/19
SQL Column:  CLIENT_HOST
Java Field:  clientHost
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  08/02/19
SQL Column:  REQUEST_HOST
Java Field:  requestHost
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes: