TSYS Merlin Chargeback Case Transaction UML


Added On:  11/04/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TsysMerlinChargebackCaseTransaction 
Represents information about chargeback case transaction as it is represented in TSYS Merlin specification.
Added On:  11/04/16
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:  11/04/16
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/04/16
SQL Column:  TRAN_CODE
Java Field:  tranCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the transaction assigned by a processor.
Added On:  11/04/16
SQL Column:  CASE_AMOUNT
Java Field:  caseAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount included in chargeback case.
Added On:  11/04/16
SQL Column:  ITEM_TYPE
Java Field:  itemType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the associated item. Possible values are the following: 1 - New Cases: new chargebacks and new reversal cases loaded today. 2 - Fulfilled Retrieval Requests: retrieval cases fulfilled today. 3 - Worked Case Resolved to Other: chargeback or reversal cases resolved to Bank, GL, or Split today. 4 - Worked Case Resolved to Merchant: chargeback or reversal cases resolved to the Merchant today. 5 - Corrected Case: a case that has corrected transaction or merchant data. 6 - New Retrievals: retrieval request cases loaded today. 7 - Second Retrieval Requests: retrieval cases where second request letter sent today. This field may contain more than one record for a given case.
Added On:  11/04/16
SQL Column:  RESOLUTION_TO
Java Field:  resolutionTo
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Institution against which this case was resolved. When a retrieval request is successfully fulfilled, the value is B (Issuing Bank). When a retrieval request is closed due to time frame exceeded, the value is M (Merchant).
Added On:  11/04/16
SQL Column:  DEBIT_CREDIT
Java Field:  debitCredit
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether the transaction is debit or credit.
Added On:  11/04/16
SQL Column:  BIN_ICA
Java Field:  binIca
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
BIN (for Visa) and ICA (for MasterCard) of the issuing bank.
Added On:  11/04/16
SQL Column:  DATE_RESOLVED
Java Field:  dateResolved
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when the retrieval request was fulfilled or when the chargeback case was resolved.
Added On:  11/04/16
SQL Column:  ORIGINAL_REFERENCE_NUMBER
Java Field:  originalReferenceNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Identifier of the record used to cross-reference information between the systems.
Added On:  11/04/16
SQL Column:  FOREIGN_DOMESTIC
Java Field:  foreignDomestic
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether the item is a foreign or domestic retrieval or chargeback. An item is foreign if either the merchant or the card issuer is foreign.
Added On:  11/04/16
SQL Column:  MCC
Java Field:  mcc
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Merchant category code of the business.
Added On:  11/04/16
SQL Column:  AUTH_CODE
Java Field:  authCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Authorization response code generated by the system.
Added On:  11/04/16
SQL Column:  DATE_TRANSACTION
Java Field:  dateTransaction
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when transaction was created.
Added On:  11/04/16
SQL Column:  DATE_POSTED
Java Field:  datePosted
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when chargeback case was posted.
Added On:  11/04/16
SQL Column:  DATE_LOADED
Java Field:  dateLoaded
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when chargeback case was loaded.
Added On:  11/04/16
SQL Column:  CARDHOLDER_ACCOUNT_NUMBER
Java Field:  cardholderAccountNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Account number of the cardholder associated with the record.
Added On:  11/04/16
SQL Column:  DATE_SECOND_REQUEST
Java Field:  dateSecondRequest
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when the second retrieval request was printed to be sent or faxed to the merchant.
Added On:  11/04/16
SQL Column:  ACCOUNT_NUMBER_PREFIX
Java Field:  accountNumberPrefix
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Prefix attached to the account number used for specific identification of the account.
Added On:  11/04/16
SQL Column:  ACCOUNT_NUMBER_SUFFIX
Java Field:  accountNumberSuffix
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Suffix attached to the account number used for specific identification of the account.
Added On:  11/04/16
SQL Column:  DBA_NAME
Java Field:  dbaName
Status:  Active
SQL Type:  varchar(45)
Java Type:  String
Attributes:
DBA name associated with the record.
Added On:  11/04/16
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Street (line 1) of the merchant's mailing address.
Added On:  11/04/16
SQL Column:  ADDRESS2
Java Field:  address2
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Street (line 2) of the merchant's mailing address.
Added On:  11/04/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
City of the merchant's mailing address.
Added On:  11/04/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code of the merchant's mailing address.
Added On:  11/04/16
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
ZIP/postal code of the merchant's mailing address.
Added On:  11/04/16
SQL Column:  ASSOCIATION
Java Field:  association
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Association number assigned to the merchant.
Added On:  11/04/16
SQL Column:  DATE_WAREHOUSE
Java Field:  dateWarehouse
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Date when the file was sent to the data warehouse.
Added On:  11/04/16
SQL Column:  TRANS_ID
Java Field:  transId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Transaction ID assigned within the system.
Added On:  11/04/16
SQL Column:  MERCH_AMOUNT
Java Field:  merchAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount included in chargeback case and assigned to the particular merchant.
Added On:  11/04/16
SQL Column:  CASE_NUMBER
Java Field:  caseNumber
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Code of the chargeback case assigned within the system.
Added On:  11/04/16
SQL Column:  CASE_TYPE
Java Field:  caseType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the chargeback case.
Added On:  11/04/16
SQL Column:  ACQUIRER_REFERENCE_NUMBER
Java Field:  acquirerReferenceNumber
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Secondary identifier of the chargeback case aquirer which can be used to cross-reference records between UniPay and integrated systems.
Added On:  11/04/16
SQL Column:  MERCHANT_NUMBER
Java Field:  merchantNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Merchant number associated with the transaction.
Added On:  11/04/16
SQL Column:  RECORD_TYPE
Java Field:  recordType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Type of the record.
Added On:  11/04/16
SQL Column:  CARD_BRAND
Java Field:  cardBrand
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Card brand code that is assigned to the transaction.
Added On:  11/04/16
SQL Column:  REASON_CODE
Java Field:  reasonCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Reason code generated by the system.
Added On:  11/04/16
SQL Column:  FAMILY_ID
Java Field:  familyId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Indicator of the cases that contain the same Acquirers Reference Number, Card Number, and Case Amount and are assigned to one group.
Added On:  11/09/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 information about the transaction.
Added On:  11/10/16
SQL Column:  REASON_DESC
Java Field:  reasonDesc
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Reason code message generated by the system.
Added On:  11/10/16
SQL Column:  
Java Field:  recordContent
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Content of the record.
Added On:  12/06/16
SQL Column:  GROUP_NUMBER
Java Field:  groupNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code of the group the merchant belongs to.