Provider Transaction


Added On:  05/16/18 
SQL Table:  PROVIDER_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ProviderTransaction 
Represents information about the transaction present on the processor's side.
Added On:  09/08/17
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/08/17
SQL Column:  REMITTANCE_DATE
Java Field:  remittanceDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  09/08/17
SQL Column:  PROVIDER_NAME
Java Field:  providerName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  NOTE
Java Field:  note
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  09/08/17
SQL Column:  PROVIDER_AUTHORIZATION_TRANSACTION_CODE
Java Field:  providerAuthorizationTransactionCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  PROVIDER_SETTLEMENT_TRANSACTION_CODE
Java Field:  providerSettlementTransactionCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  CHARGEBACK_CASE_CODE
Java Field:  chargebackCaseCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  AUTHORIZATION_DATE
Java Field:  authorizationDate
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  SETTLEMENT_DATE
Java Field:  settlementDate
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  AUTHORIZATION_AMOUNT
Java Field:  authorizationAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  SETTLEMENT_AMOUNT
Java Field:  settlementAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  CHARGEBACK_AMOUNT
Java Field:  chargebackAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  AUTHORIZATION_CURRENCY_CODE
Java Field:  authorizationCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  SETTLEMENT_CURRENCY_CODE
Java Field:  settlementCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  CHARGEBACK_CURRENCY_CODE
Java Field:  chargebackCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  BIN
Java Field:  bin
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  ACCOUNT_NUMBER_LAST4
Java Field:  accountNumberLast4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  CUSTOMER_ACCOUNT_CODE
Java Field:  customerAccountCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  CUSTOMER_ACCOUNT_NAME
Java Field:  customerAccountName
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  INTERCHANGE_RATE_NAME
Java Field:  interchangeRateName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  INTERCHANGE_FEE_AMOUNT4P
Java Field:  interchangeFeeAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  INTERCHANGE_PERCENT_RATE4P
Java Field:  interchangePercentRate4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  INTERCHANGE_FLAT_AMOUNT4P
Java Field:  interchangeFlatAmount4p
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  09/08/17
SQL Column:  ISSUING_BANK
Java Field:  issuingBank
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  ISSUING_BANK_COUNTRY_CODE
Java Field:  issuingBankCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  BILLING_DESCRIPTOR
Java Field:  billingDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  STREET
Java Field:  street
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  AVS_RESPONSE_CODE
Java Field:  avsResponseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  AVS_RESPONSE_MESSAGE
Java Field:  avsResponseMessage
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  09/08/17
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required
Unique identifier assigned to the record.
Added On:  09/08/17
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  Object
Attributes:
Added On:  11/08/17
SQL Column:  ACCOUNT_TYPE_CL
Java Field:  accountTypeCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  Object
Attributes:
Added On:  11/22/17
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/22/17
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/09/17
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  08/14/18
SQL Column:  RAW_DATA
Java Field:  rawData
Status:  Active
SQL Type:  varchar(1024)
Java Type:  String
Attributes: Transient
Added On:  09/08/17
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes: