Chargeback Transaction UML


Added On:  02/13/12 
SQL Table:  CHARGEBACK_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ChargebackTransaction 
Represents CC chargebacks, chargeback reversals and ACH returns.
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when ACH return/CC chargeback was received.
Added On:  02/13/12
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of selected transaction processing mode.
Added On:  02/13/12
SQL Column:  CHARGEBACK_CL
Java Field:  chargebackCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of chargeback.
Added On:  02/13/12
SQL Column:  SEQUENCE_NUMBER
Java Field:  sequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Default:1
Sequence number of a chargeback.
Added On:  02/13/12
SQL Column:  CALLBACK_DATE
Java Field:  callbackDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when transaction was posted back to merchant's front-end system through a callback mechanism.
Added On:  02/13/12
SQL Column:  PROVIDER_DATE
Java Field:  providerDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when ACH return/CC chargeback was received by an underlined processor.
Added On:  02/13/12
SQL Column:  BANK_DATE
Java Field:  bankDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when ACH return/CC chargeback was received by a bank.
Added On:  02/13/12
SQL Column:  DEPOSIT_DATE
Java Field:  depositDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when this ACH return/CC chargeback got incorporated into a Merchant Statement.
Added On:  12/02/12
SQL Column:  CUSTOM_FIELD
Java Field:  customField
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Implementation specific field to pass some custom information to the merchants.
Added On:  01/31/13
SQL Column:  INTERCHANGE_RATE_NAME
Java Field:  interchangeRateName
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
The name of the interchange rate that this transaction is qualified.
Added On:  01/31/13
SQL Column:  INTERCHANGE_PERCENTAGE_FEE
Java Field:  interchangePercentageFee
Status:  Active
SQL Type:  int(11)(60)
Java Type:  Integer
Attributes:
Percentage fee, charged of a total transaction amount by an association for processing of the card.
Added On:  01/31/13
SQL Column:  INTERCHANGE_FLAT_FEE
Java Field:  interchangeFlatFee
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Flat fee charged on a transaction by an association for processing of the card.
Added On:  01/31/13
SQL Column:  INTERCHANGE_FEE_AMOUNT
Java Field:  interchangeFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The total amount of Interchange Percentage Fee and Interchange Flat Fee.
Added On:  01/31/13
SQL Column:  ASSESSMENTS_FEE_AMOUNT
Java Field:  assessmentsFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The total of assessment fees charged by an association for processing/settlement of the transaction.
Added On:  01/31/13
SQL Column:  PROCESSOR_FEE_AMOUNT
Java Field:  processorFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Flat fee charged by the processor for processing of a transaction.
Added On:  01/31/13
SQL Column:  PROCESSING_FEE_AMOUNT
Java Field:  processingFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Surcharge that is charged as a percentage of the transaction total by the third party processor (gateway owner) for processing of the transaction.
Added On:  01/31/13
SQL Column:  FLAT_FEE_AMOUNT
Java Field:  flatFeeAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Flat fee charged on the transaction by the third party processor (gateway owner) for processing of the transaction.
Added On:  11/13/13
SQL Column:  AGGREGATE_TRANSACTION_FK
Java Field:  aggregateTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents aggregate transaction information.
Added On:  11/14/13
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code. The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  11/14/13
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.
Added On:  11/14/13
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Gateway generated response code.
Added On:  11/14/13
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Gateway generated response message.
Added On:  11/14/13
SQL Column:  PROVIDER_RESPONSE_CODE
Java Field:  providerResponseCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Original response code generated by the provider.
Added On:  11/22/13
SQL Column:  IS_AGGREGATE_TRANSACTION
Java Field:  isAggregateTransaction
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the type of transaction is aggregation.
Added On:  04/04/14
SQL Column:  SUBMISSION_FK
Java Field:  submission
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Submission
Attributes:
Reference to the entity that represents submission information.
Added On:  04/04/14
SQL Column:  ORIGINAL_CHARGEBACK_TRANSACTION_FK
Java Field:  originalChargebackTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents original chargeback transaction.
Added On:  06/10/16
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  06/06/18
SQL Column:  TRANSACTION_TYPE
Java Field:  transactionType
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: ReadOnly, Calculated
Type of the transaction.
The value is based on the chargebackCl field value.
Added On:  07/25/18
SQL Column:  PROVIDER_RESPONSE_MESSAGE
Java Field:  providerResponseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  09/20/18
SQL Column:  CASE_NUMBER
Java Field:  caseNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  03/14/19
SQL Column:  FILE_STORE_CODE
Java Field:  fileStoreCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes: