Chargeback Case UML


Added On:  07/29/12 
SQL Table:  CHARGEBACK_CASE 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ChargebackCase 
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.
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.
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.
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.
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.
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.
Added On:  07/29/12
SQL Column:  PROCESSOR_MERCHANT_NUMBER
Java Field:  processorMerchantNumber
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/29/12
SQL Column:  ACTIVITY_CL
Java Field:  activityCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of the chargeback life-cycle activity.
Added On:  07/29/12
SQL Column:  CYCLE_CL
Java Field:  cycleCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents current point in the overall chargeback life-cycle in which the chargeback currently resides.
Added On:  07/29/12
SQL Column:  PROCESSOR_TRANSACTION_CODE
Java Field:  processorTransactionCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  07/29/12
SQL Column:  MERCHANT_TRANSACTION_CODE
Java Field:  merchantTransactionCode
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/29/12
SQL Column:  ORDER_CODE
Java Field:  orderCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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.
Added On:  07/29/12
SQL Column:  BANK_CARD_CL
Java Field:  bankCardCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Represents the type of the card or alternate payment type used in the chargeback.
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.
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.
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.
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.
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.
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.
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.
Added On:  07/29/12
SQL Column:  REPRESENTED_CURRENCY
Java Field:  representedCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/29/12
SQL Column:  PRE_ARBITRATION_CURRENCY
Java Field:  preArbitrationCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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.
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.
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.
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:  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.
Added On:  07/29/12
SQL Column:  RETRIEVAL_REQUEST_CL
Java Field:  retrievalRequestCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the type of retrieval request.
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.
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.
Added On:  08/07/12
SQL Column:  CURRENT_QUEUE_CL
Java Field:  currentQueueCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Represents the queue in which the chargeback currently resides.
Added On:  08/07/12
SQL Column:  CHARGEBACK_TRANSACTION_FK
Java Field:  chargebackTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
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.
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.
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.
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.
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.
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.
Added On:  07/29/13
SQL Column:  OWNER_CODE
Java Field:  ownerCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
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.
Added On:  08/14/13
SQL Column:  REFERENCE_DATA
Java Field:  referenceData
Status:  Active
SQL Type:  varchar(2048)
Java Type:  String
Attributes:
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.
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.
Added On:  08/19/13
SQL Column:  SETTLEMENT_DATE
Java Field:  settlementDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  08/20/13
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Current state of the chargeback.
Added On:  09/27/13
SQL Column:  CASE_GROUP
Java Field:  caseGroup
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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.
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.
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.