Chargeback Case UML

Added On: 07/29/12

SQL Table: CHARGEBACK_CASE

Module: UniCharge

Type: Entity Status: Active

Java Class: ChargebackCase

Available Fields:

Activity CL
Aquirer Transaction Code
Authorization Amount
Authorization Currency
Bank Card CL
Bank Issued Date
Card Number Last4
Case CL
Case Code
Case Group
Charge Transaction FK
Chargeback Amount
Chargeback Currency
Chargeback Transaction FK
Chargeback Type
Create Date

Current Queue CL
Customer Account Code
Cycle CL
Fraud Notification Date
Fraud Notification Status
Id
Last Owner Change Date
Last Update Date
Merchant Account Code
Merchant Transaction Code
Order Code
Original Transaction Date
Owner Code
Pre Arbitration Amount
Pre Arbitration Currency
Processor Merchant Number

Processor Received Date
Processor Response Code
Processor Response Message
Processor Transaction Code
Provider CL
Reference Data
Reply By Date
Represented Amount
Represented Currency
Response Code
Response Message
Retrieval Request CL
Settlement Amount
Settlement Currency
Settlement Date
Status CL

Activity CL

Added On: 07/29/12

SQL Column: ACTIVITY_CL

Java Field: activityCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Chargeback Activity Classifier

Attributes:

Represents the type of the chargeback life-cycle activity.

Aquirer Transaction Code

Added On: 07/29/13

SQL Column: AQUIRER_TRANSACTION_CODE

Java Field: aquirerTransactionCode

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Identifier of the chargeback in the acquirer's system.

Authorization Amount

Added On: 02/25/14

SQL Column: AUTHORIZATION_AMOUNT

Java Field: authorizationAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Authorization amount that was settled.

Authorization Currency

Added On: 02/25/14

SQL Column: AUTHORIZATION_CURRENCY

Java Field: authorizationCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of currency that was used for authorization transaction.

Bank Card CL

Added On: 07/29/12

SQL Column: BANK_CARD_CL

Java Field: bankCardCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Bank Card Classifier

Attributes:

Represents the type of the card or alternate payment type used in the chargeback.

Bank Issued Date

Added On: 07/29/12

SQL Column: BANK_ISSUED_DATE

Java Field: bankIssuedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date the issuing bank initiated the chargeback.

Card Number Last4

Added On: 07/29/12

SQL Column: CARD_NUMBER_LAST4

Java Field: cardNumberLast4

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Last 4 digits of the card provided.

Case CL

Added On: 07/29/13

SQL Column: CASE_CL

Java Field: caseCl

Status: Active

SQL Type: varchar(6)

Java Type: String

References Case Classifier

Attributes:

Represents the type of case.

Case Code

Added On: 07/29/12

SQL Column: CASE_CODE

Java Field: caseCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

A unique chargeback ID.

Case Group

Added On: 09/27/13

SQL Column: CASE_GROUP

Java Field: caseGroup

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Charge Transaction FK

Added On: 07/29/12

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 Amount

Added On: 07/29/12

SQL Column: CHARGEBACK_AMOUNT

Java Field: chargebackAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction amount that was charged back.

Chargeback Currency

Added On: 07/29/12

SQL Column: CHARGEBACK_CURRENCY

Java Field: chargebackCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Currency code of the chargeback operation.

Chargeback Transaction FK

Added On: 08/07/12

SQL Column: CHARGEBACK_TRANSACTION_FK

Java Field: chargebackTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Chargeback Transaction

Attributes:

Reference to a chargeback transaction representing either initial chargeback (for credit cards) or ACH return (for bank accounts). If not chargeback/return came in, the field is not set. The field is primarily used to quickly identify transactions that have chargebacks/returns.

Chargeback Type

Added On: 07/29/12

SQL Column: CHARGEBACK_TYPE

Java Field: chargebackType

Status: Active

SQL Type: varchar(7)

Java Type: String

Attributes:

The chargebackType element is a required child of the caseActivity element that defines the chargeback type in terms of Deposit or Refund.

Create Date

Added On: 08/07/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date when the processor received the chargeback.

Current Queue CL

Added On: 08/07/12

SQL Column: CURRENT_QUEUE_CL

Java Field: currentQueueCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Chargeback Queue Classifier

Attributes:

Represents the queue in which the chargeback currently resides.

Customer Account Code

Added On: 08/19/13

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Identifier of the customer that chargeback is associated with.

Cycle CL

Added On: 07/29/12

SQL Column: CYCLE_CL

Java Field: cycleCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Chargeback Cycle Classifier

Attributes:

Represents current point in the overall chargeback life-cycle in which the chargeback currently resides.

Fraud Notification Date

Added On: 07/29/12

SQL Column: FRAUD_NOTIFICATION_DATE

Java Field: fraudNotificationDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the fraud notification was sent to the merchant.

Fraud Notification Status

Added On: 07/29/12

SQL Column: FRAUD_NOTIFICATION_STATUS

Java Field: fraudNotificationStatus

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Current status of the fraud notification sent to the merchant.

Added On: 07/29/12

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.

Last Owner Change Date

Added On: 07/29/13

SQL Column: LAST_OWNER_CHANGE_DATE

Java Field: lastOwnerChangeDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date when current user was assigned as responsible for the case.

Last Update Date

Added On: 07/29/12

SQL Column: LAST_UPDATE_DATE

Java Field: lastUpdateDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date of the last update.

Merchant Account Code

Added On: 07/29/12

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.

Merchant Transaction Code

Added On: 07/29/12

SQL Column: MERCHANT_TRANSACTION_CODE

Java Field: merchantTransactionCode

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Order Code

Added On: 07/29/12

SQL Column: ORDER_CODE

Java Field: orderCode

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Original Transaction Date

Added On: 07/29/12

SQL Column: ORIGINAL_TRANSACTION_DATE

Java Field: originalTransactionDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date of the original transaction.

Owner Code

Added On: 07/29/13

SQL Column: OWNER_CODE

Java Field: ownerCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Pre Arbitration Amount

Added On: 07/29/12

SQL Column: PRE_ARBITRATION_AMOUNT

Java Field: preArbitrationAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction amount that goes into the pre-arbitration.

Pre Arbitration Currency

Added On: 07/29/12

SQL Column: PRE_ARBITRATION_CURRENCY

Java Field: preArbitrationCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Processor Merchant Number

Added On: 07/29/12

SQL Column: PROCESSOR_MERCHANT_NUMBER

Java Field: processorMerchantNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Processor Received Date

Added On: 07/29/12

SQL Column: PROCESSOR_RECEIVED_DATE

Java Field: processorReceivedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date when the processor received the chargeback.

Processor Response Code

Added On: 07/29/12

SQL Column: PROCESSOR_RESPONSE_CODE

Java Field: processorResponseCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Response code received from the processor.

Processor Response Message

Added On: 07/29/12

SQL Column: PROCESSOR_RESPONSE_MESSAGE

Java Field: processorResponseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Response message received from the provider.

Processor Transaction Code

Added On: 07/29/12

SQL Column: PROCESSOR_TRANSACTION_CODE

Java Field: processorTransactionCode

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Provider CL

Added On: 08/14/13

SQL Column: PROVIDER_CL

Java Field: providerCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Represents the selected type of the provider.

Reference Data

Added On: 08/14/13

SQL Column: REFERENCE_DATA

Java Field: referenceData

Status: Active

SQL Type: varchar(2048)

Java Type: String

Attributes:

Reply By Date

Added On: 07/29/12

SQL Column: REPLY_BY_DATE

Java Field: replyByDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

The date prior to which the response has to be given.

Represented Amount

Added On: 07/29/12

SQL Column: REPRESENTED_AMOUNT

Java Field: representedAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction amount that was represented.

Represented Currency

Added On: 07/29/12

SQL Column: REPRESENTED_CURRENCY

Java Field: representedCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Response Code

Added On: 08/07/12

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

A code provided to the merchant by the card issuing bank that indicates the reason for the chargebacked transaction.

Response Message

Added On: 08/07/12

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Response message provided to the merchant by the card issuing bank that explaines the reason for the chargebacked transaction.

Retrieval Request CL

Added On: 07/29/12

SQL Column: RETRIEVAL_REQUEST_CL

Java Field: retrievalRequestCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Retrieval Request Classifier

Attributes:

Represents the type of retrieval request.

Settlement Amount

Added On: 07/29/12

SQL Column: SETTLEMENT_AMOUNT

Java Field: settlementAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction amount that was settled.

Settlement Currency

Added On: 07/29/12

SQL Column: SETTLEMENT_CURRENCY

Java Field: settlementCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Code of currency used for settlement transaction.

Settlement Date

Added On: 08/19/13

SQL Column: SETTLEMENT_DATE

Java Field: settlementDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Status CL

Added On: 08/20/13

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Chargeback Status Classifier

Attributes:

Current state of the chargeback.