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.

Available Fields:

Aggregate Transaction FK
Amount
Assessments Fee Amount
Bank Date
Callback Date
Case Number
Charge Transaction FK
Chargeback CL
Custom Field
Deposit Date
Fee Amount

File Store Code
Flat Fee Amount
Id
Interchange Fee Amount
Interchange Flat Fee
Interchange Percentage Fee
Interchange Rate Name
Is Aggregate Transaction
Merchant Account Code
Original Chargeback Transaction FK
Processing Fee Amount

Processor Fee Amount
Provider Date
Provider Reference Number
Provider Response Code
Provider Response Message
Provider Transaction Id
Response Code
Response Date
Response Message
Sequence Number
Submission FK

Transaction CL
Transaction Type

Aggregate Transaction FK

Added On: 11/13/13

SQL Column: AGGREGATE_TRANSACTION_FK

Java Field: aggregateTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Chargeback Transaction

Attributes:

Reference to the entity that represents aggregate transaction information.

Amount

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.

Assessments Fee Amount

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.

Bank Date

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.

Callback Date

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.

Case Number

Added On: 09/20/18

SQL Column: CASE_NUMBER

Java Field: caseNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Charge Transaction FK

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.

Chargeback CL

Added On: 02/13/12

SQL Column: CHARGEBACK_CL

Java Field: chargebackCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Chargeback Classifier

Attributes:

Represents the type of chargeback.

Custom Field

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.

Deposit Date

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.

Fee Amount

Added On: 05/22/24

SQL Column: FEE_AMOUNT

Java Field: feeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

File Store Code

Added On: 03/14/19

SQL Column: FILE_STORE_CODE

Java Field: fileStoreCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Flat Fee Amount

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: 02/13/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required

Identifier of the object used for references; auto-incremented integer value.

Interchange Fee Amount

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.

Interchange Flat Fee

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.

Interchange Percentage Fee

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.

Interchange Rate Name

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.

Is Aggregate Transaction

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.

Merchant Account Code

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.

Original Chargeback Transaction FK

Added On: 04/04/14

SQL Column: ORIGINAL_CHARGEBACK_TRANSACTION_FK

Java Field: originalChargebackTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Chargeback Transaction

Attributes:

Reference to the entity that represents original chargeback transaction.

Processing Fee Amount

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.

Processor Fee Amount

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.

Provider Date

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.

Provider Reference Number

Added On: 02/18/21

SQL Column: PROVIDER_REFERENCE_NUMBER

Java Field: providerReferenceNumber

Status: Active

SQL Type: varchar

Java Type: String

Attributes: Transient

Provider Response Code

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.

Provider Response Message

Added On: 07/25/18

SQL Column: PROVIDER_RESPONSE_MESSAGE

Java Field: providerResponseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Provider Transaction Id

Added On: 02/18/21

SQL Column: PROVIDER_TRANSACTION_ID

Java Field: providerTransactionId

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes: Transient

Response Code

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.

Response Date

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.

Response Message

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.

Sequence Number

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.

Submission FK

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.

Transaction CL

Added On: 02/13/12

SQL Column: TRANSACTION_CL

Java Field: transactionCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Submission Classifier

Attributes:

Represents the type of selected transaction processing mode.

Transaction Type

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.