Transaction List Export

Added On:  11/07/18 

SQL Table:  TRANSACTION_LIST_EXPORT 

Module:  UniCore 

Type:  Entity  Status:  Active 

Java Class:  TransactionListExport 

Available Fields:

• Account Accessory
• Account Code
• Account Id
• Account Name
• Account Number
• Account Type
• Activity Date
• Amount
• Approval Code
• Avs Response Code
• Billing Address City
• Billing Address Country Code
• Billing Address Email
• Billing Address Phone
• Billing Address State
• Billing Address Street
• Billing Address Zip Code
• Capture Amount
• Capture Currency Code
• Capture Date
• Case Number
• Category Type
• Client Host
• Csc Response Code

• Customer Account Code
• Customer Account Internal Code
• Data Registry Export Code
• Deposit Type
• Holder Name
• Id
• Industry Type
• Interchange Item Amount
• Interchange Name
• Interchange Percentage Amount
• Interchange Percentage Rate
• Interchange Total Amount
• Internal Code
• Item Code
• Memo
• Original Amount
• Original Transaction Code
• Original Transaction Id
• Original Transaction Remaining Amount
• Processor Avs Response Code
• Processor Csc Response Code
• Processor Response Code
• Processor Response Message
• Processor Transaction Id

• Remaining Amount
• Request Host
• Reseller Code
• Reseller Id
• Reseller Name
• Response Code
• Response Message
• Statement Id
• Status
• Submission Id
• Submission Type
• Surcharge Flat Amount
• Surcharge Item Amount
• Surcharge Item Rate
• Surcharge Percentage Amount
• Surcharge Percentage Rate
• Surcharge Total Amount
• Terminal Code
• Terminal Id
• Ticket Number
• Token
• Transaction Code
• Transaction Id
• Type

• User Code

Account Accessory

Added On:  11/06/18

SQL Column:  ACCOUNT_ACCESSORY

Java Field:  accountAccessory

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Account Code

Added On:  11/06/18

SQL Column:  ACCOUNT_CODE

Java Field:  accountCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Account Id

Added On:  11/06/18

SQL Column:  ACCOUNT_ID

Java Field:  accountId

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Account Name

Added On:  11/06/18

SQL Column:  ACCOUNT_NAME

Java Field:  accountName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Account Number

Added On:  11/06/18

SQL Column:  ACCOUNT_NUMBER

Java Field:  accountNumber

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Account Type

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:

Activity Date

Added On:  11/06/18

SQL Column:  ACTIVITY_DATE

Java Field:  activityDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Amount

Added On:  11/06/18

SQL Column:  AMOUNT

Java Field:  amount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Approval Code

Added On:  11/06/18

SQL Column:  APPROVAL_CODE

Java Field:  approvalCode

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Avs Response Code

Added On:  11/06/18

SQL Column:  AVS_RESPONSE_CODE

Java Field:  avsResponseCode

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Billing Address City

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_CITY

Java Field:  billingAddressCity

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Billing Address Country Code

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_COUNTRY_CODE

Java Field:  billingAddressCountryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Billing Address Email

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_EMAIL

Java Field:  billingAddressEmail

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Billing Address Phone

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_PHONE

Java Field:  billingAddressPhone

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Billing Address State

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_STATE

Java Field:  billingAddressState

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Billing Address Street

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_STREET

Java Field:  billingAddressStreet

Status:  Active

SQL Type:  varchar(128)

Java Type:  String

Attributes:

Billing Address Zip Code

Added On:  11/06/18

SQL Column:  BILLING_ADDRESS_ZIP_CODE

Java Field:  billingAddressZipCode

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Capture Amount

Added On:  11/06/18

SQL Column:  CAPTURE_AMOUNT

Java Field:  captureAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Capture Currency Code

Added On:  11/06/18

SQL Column:  CAPTURE_CURRENCY_CODE

Java Field:  captureCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Capture Date

Added On:  11/06/18

SQL Column:  CAPTURE_DATE

Java Field:  captureDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Case Number

Added On:  11/06/18

SQL Column:  CASE_NUMBER

Java Field:  caseNumber

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Category Type

Added On:  11/06/18

SQL Column:  CATEGORY_TYPE

Java Field:  categoryType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Transaction Category Classifier

Attributes:

Client Host

Added On:  08/02/19

SQL Column:  CLIENT_HOST

Java Field:  clientHost

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Csc Response Code

Added On:  11/06/18

SQL Column:  CSC_RESPONSE_CODE

Java Field:  cscResponseCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Customer Account Code

Added On:  11/06/18

SQL Column:  CUSTOMER_ACCOUNT_CODE

Java Field:  customerAccountCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Customer Account Internal Code

Added On:  11/06/18

SQL Column:  CUSTOMER_ACCOUNT_INTERNAL_CODE

Java Field:  customerAccountInternalCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Data Registry Export Code

Added On:  11/06/18

SQL Column:  DATA_REGISTRY_EXPORT_CODE

Java Field:  dataRegistryExportCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Deposit Type

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:

Holder Name

Added On:  11/06/18

SQL Column:  HOLDER_NAME

Java Field:  holderName

Status:  Active

SQL Type:  varchar(151)

Java Type:  String

Attributes:

Id

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.

Industry Type

Added On:  11/06/18

SQL Column:  INDUSTRY_TYPE

Java Field:  industryType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Transaction Industry Classifier

Attributes:

Interchange Item Amount

Added On:  11/06/18

SQL Column:  INTERCHANGE_ITEM_AMOUNT

Java Field:  interchangeItemAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Interchange Name

Added On:  11/06/18

SQL Column:  INTERCHANGE_NAME

Java Field:  interchangeName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Interchange Percentage Amount

Added On:  11/06/18

SQL Column:  INTERCHANGE_PERCENTAGE_AMOUNT

Java Field:  interchangePercentageAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Interchange Percentage Rate

Added On:  11/06/18

SQL Column:  INTERCHANGE_PERCENTAGE_RATE

Java Field:  interchangePercentageRate

Status:  Active

SQL Type:  decimal(10,2)

Java Type:  Double

Attributes:

Interchange Total Amount

Added On:  11/06/18

SQL Column:  INTERCHANGE_TOTAL_AMOUNT

Java Field:  interchangeTotalAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Internal Code

Added On:  11/06/18

SQL Column:  INTERNAL_CODE

Java Field:  internalCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Item Code

Added On:  11/06/18

SQL Column:  ITEM_CODE

Java Field:  itemCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Memo

Added On:  11/06/18

SQL Column:  MEMO

Java Field:  memo

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Original Amount

Added On:  11/06/18

SQL Column:  ORIGINAL_AMOUNT

Java Field:  originalAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Original Transaction Code

Added On:  11/06/18

SQL Column:  ORIGINAL_TRANSACTION_CODE

Java Field:  originalTransactionCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Original Transaction Id

Added On:  11/06/18

SQL Column:  ORIGINAL_TRANSACTION_ID

Java Field:  originalTransactionId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Original Transaction Remaining Amount

Added On:  11/06/18

SQL Column:  ORIGINAL_TRANSACTION_REMAINING_AMOUNT

Java Field:  originalTransactionRemainingAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Processor Avs Response Code

Added On:  11/06/18

SQL Column:  PROCESSOR_AVS_RESPONSE_CODE

Java Field:  processorAvsResponseCode

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Processor Csc Response Code

Added On:  11/06/18

SQL Column:  PROCESSOR_CSC_RESPONSE_CODE

Java Field:  processorCscResponseCode

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Processor Response Code

Added On:  11/06/18

SQL Column:  PROCESSOR_RESPONSE_CODE

Java Field:  processorResponseCode

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Processor Response Message

Added On:  11/06/18

SQL Column:  PROCESSOR_RESPONSE_MESSAGE

Java Field:  processorResponseMessage

Status:  Active

SQL Type:  varchar(350)

Java Type:  String

Attributes:

Processor Transaction Id

Added On:  11/06/18

SQL Column:  PROCESSOR_TRANSACTION_ID

Java Field:  processorTransactionId

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Remaining Amount

Added On:  11/06/18

SQL Column:  REMAINING_AMOUNT

Java Field:  remainingAmount

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Request Host

Added On:  08/02/19

SQL Column:  REQUEST_HOST

Java Field:  requestHost

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Reseller Code

Added On:  11/06/18

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Reseller Id

Added On:  11/06/18

SQL Column:  RESELLER_ID

Java Field:  resellerId

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Reseller Name

Added On:  11/06/18

SQL Column:  RESELLER_NAME

Java Field:  resellerName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Response Code

Added On:  11/06/18

SQL Column:  RESPONSE_CODE

Java Field:  responseCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Response Message

Added On:  11/06/18

SQL Column:  RESPONSE_MESSAGE

Java Field:  responseMessage

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Statement Id

Added On:  11/06/18

SQL Column:  STATEMENT_ID

Java Field:  statementId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Status

Added On:  11/06/18

SQL Column:  STATUS

Java Field:  status

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Transaction Status Classifier

Attributes:

Submission Id

Added On:  11/06/18

SQL Column:  SUBMISSION_ID

Java Field:  submissionId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Submission Type

Added On:  11/06/18

SQL Column:  SUBMISSION_TYPE

Java Field:  submissionType

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Submission Classifier

Attributes:

Surcharge Flat Amount

Added On:  11/06/18

SQL Column:  SURCHARGE_FLAT_AMOUNT

Java Field:  surchargeFlatAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Surcharge Item Amount

Added On:  11/06/18

SQL Column:  SURCHARGE_ITEM_AMOUNT

Java Field:  surchargeItemAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Surcharge Item Rate

Added On:  11/06/18

SQL Column:  SURCHARGE_ITEM_RATE

Java Field:  surchargeItemRate

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Surcharge Percentage Amount

Added On:  11/06/18

SQL Column:  SURCHARGE_PERCENTAGE_AMOUNT

Java Field:  surchargePercentageAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Surcharge Percentage Rate

Added On:  11/06/18

SQL Column:  SURCHARGE_PERCENTAGE_RATE

Java Field:  surchargePercentageRate

Status:  Active

SQL Type:  decimal(10,2)

Java Type:  Double

Attributes:

Surcharge Total Amount

Added On:  11/06/18

SQL Column:  SURCHARGE_TOTAL_AMOUNT

Java Field:  surchargeTotalAmount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Terminal Code

Added On:  11/06/18

SQL Column:  TERMINAL_CODE

Java Field:  terminalCode

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Terminal Id

Added On:  11/06/18

SQL Column:  TERMINAL_ID

Java Field:  terminalId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Ticket Number

Added On:  11/06/18

SQL Column:  TICKET_NUMBER

Java Field:  ticketNumber

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Token

Added On:  11/06/18

SQL Column:  TOKEN

Java Field:  token

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Transaction Code

Added On:  11/06/18

SQL Column:  TRANSACTION_CODE

Java Field:  transactionCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Transaction Id

Added On:  11/06/18

SQL Column:  TRANSACTION_ID

Java Field:  transactionId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Type

Added On:  11/06/18

SQL Column:  TYPE

Java Field:  type

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

User Code

Added On:  11/06/18

SQL Column:  USER_CODE

Java Field:  userCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes: