Vantiv Chargeback Transaction UML


Added On:  03/30/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  VantivChargebackTransaction 
Represents chargeback transaction as it is defined in Vantiv's chargeback specification.
Available Fields:
Added On:  03/30/15
SQL Column:  ACQUIRER_REFERENCE_NUMBER
Java Field:  acquirerReferenceNumber
Status:  Active
SQL Type:  varchar(23)
Java Type:  String
Attributes:
Acquirer reference number assigned by the acquirer at the time of the
original transaction.
Added On:  03/30/15
SQL Column:  ACQUIRER_TERMINAL_ID
Java Field:  acquirerTerminalId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
The terminal ID code of the acquirer.
Added On:  03/30/15
SQL Column:  ADJUSTMENT_REASON_CODE
Java Field:  adjustmentReasonCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
The reason code received from the card issuer.

Reason codes are prefixed with:

  • MasterCard = "M" (M9999)
  • Visa = "V" (V99 )
  • Discover = "D"
  • AmEx = "A"
Added On:  03/30/15
SQL Column:  ADJUSTMENT_TYPE1
Java Field:  adjustmentType1
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of Adjustment Item:

  • DRFT = Credit Card Draft Retrieval
  • PNOT = Chargeback/Pre-Compliance Prenotification
  • CHBK = Chargeback Action Item
  • FEE = Fee record
Added On:  03/30/15
SQL Column:  ADJUSTMENT_TYPE2
Java Field:  adjustmentType2
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of Adjustment Item:

  • DRFT = Credit Card Draft Retrieval
  • PNOT = Chargeback/Pre-Compliance Prenotification
  • CHBK = Chargeback Action Item
  • FEE = Fee record
Added On:  03/31/15
SQL Column:  ADJUSTMENT_TYPE3
Java Field:  adjustmentType3
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of Adjustment Item:

  • DRFT = Credit Card Draft Retrieval
  • PNOT = Chargeback/Pre-Compliance Prenotification
  • CHBK = Chargeback Action Item
  • FEE = Fee record
Added On:  03/31/15
SQL Column:  ADJUSTMENT_TYPE4
Java Field:  adjustmentType4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of Adjustment Item:

  • DRFT = Credit Card Draft Retrieval
  • PNOT = Chargeback/Pre-Compliance Prenotification
  • CHBK = Chargeback Action Item
  • FEE = Fee record
Added On:  01/19/17
SQL Column:  ADJUSTMENT_TYPE5
Java Field:  adjustmentType5
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of the applied adjustment.
Added On:  03/30/15
SQL Column:  AUTHORIZATION_SOURCE
Java Field:  authorizationSource
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This field contains code indicating the source of the authorization code. The received code must be stored and resubmitted in the data capture settlement record.
Added On:  03/31/15
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 realtime transaction.
Added On:  03/30/15
SQL Column:  CHARGEBACK_ACTION_CODE
Java Field:  chargebackActionCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Chargeback action code (See Chargeback action code listing in the specification of the processor).
Added On:  03/30/15
SQL Column:  CHARGEBACK_ACTION_CODE_DATE
Java Field:  chargebackActionCodeDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date chargeback action taken (YYMMDD).
If this is a FEE record type this will be the date the fee was sent or received.
Added On:  03/30/15
SQL Column:  CHARGEBACK_REFERENCE_NUMBER
Java Field:  chargebackReferenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Chargeback reference number received from network.
On draft retrievals, this is the issuer's control number. For American Express and Discover records this will contain the case number.
Added On:  03/30/15
SQL Column:  CHARGEBACK_USAGE_CODE
Java Field:  chargebackUsageCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Chargeback presentation number (1st, 2nd, 3rd) as specified by issuer.
Added On:  03/31/15
SQL Column:  COMMENT_FROM_MERCHANT2
Java Field:  commentFromMerchant2
Status:  Active
SQL Type:  varchar(62)
Java Type:  String
Attributes:
Free form text sent from merchant to MPS.
Added On:  03/30/15
SQL Column:  COMMENT_TO_MERCHANT2
Java Field:  commentToMerchant2
Status:  Active
SQL Type:  varchar(62)
Java Type:  String
Attributes:
Free form text sent from MPS to merchant.
Added On:  03/30/15
SQL Column:  COMMENTS_FROM_ISSUER1
Java Field:  commentsFromIssuer1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Comments sent from issuer.

Reason Code MC 6343 and Visa 27 are IRS Audits of Healthcare Eligible Expenses for transactions processed through an Inventory Information Approval System (IIAS).
Please respond to this request by faxing the applicable substantiating information, which must include the items that were purchased, to the fax number provided in this field.
Added On:  03/30/15
SQL Column:  COMMENTS_TO_ISSUER1
Java Field:  commentsToIssuer1
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Comments sent back to issuer by merchant's financial institution.
Added On:  03/30/15
SQL Column:  DEPARTMENT_NUMBER
Java Field:  departmentNumber
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Department number for original transaction.
Added On:  01/19/17
SQL Column:  DISCRETIONARY_FIELD1
Java Field:  discretionaryField1
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Field for any merchant discretionary information.
Added On:  01/19/17
SQL Column:  DISCRETIONARY_FIELD2
Java Field:  discretionaryField2
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Field for any merchant discretionary information.
Added On:  01/19/17
SQL Column:  DISCRETIONARY_FIELD3
Java Field:  discretionaryField3
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Field for any merchant discretionary information.
Added On:  03/30/15
SQL Column:  DISPUTE_AMOUNT1
Java Field:  disputeAmount1
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount of the dispute in dollars and cents as settled by FTPS $100.99 would look like this '0000010099'.

Note: This could be a partial amount instead of the total original transaction amount.
Added On:  03/30/15
SQL Column:  DISPUTE_AMOUNT2
Java Field:  disputeAmount2
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount of the dispute in dollars and cents as settled by FTPS $100.99 would look like this '0000010099'.

Note: This could be a partial amount instead of the total original transaction amount.
Added On:  03/31/15
SQL Column:  DISPUTE_AMOUNT3
Java Field:  disputeAmount3
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount of the dispute in dollars and cents as settled by FTPS $100.99 would look like this '0000010099'.

Note: This could be a partial amount instead of the total original transaction amount.
Added On:  03/31/15
SQL Column:  DISPUTE_AMOUNT4
Java Field:  disputeAmount4
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount of the dispute in dollars and cents as settled by FTPS $100.99 would look like this '0000010099'.

Note: This could be a partial amount instead of the total original transaction amount.
Added On:  01/19/17
SQL Column:  DISPUTE_AMOUNT5
Java Field:  disputeAmount5
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The amount of the dispute. The value is represented in both dollars and cents.
Added On:  03/30/15
SQL Column:  DOCUMENT_INDICATOR
Java Field:  documentIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Document Indicator Codes:

  • O = Original draft requested
  • C = Copy of draft requested
  • N = No draft requested
Added On:  03/30/15
SQL Column:  DRAFT_ACTION_CODE
Java Field:  draftActionCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Draft Action Codes:

  • E = Electronic Signature Capture
  • F = Facsimile draft
  • S = Draft sent by merchant
  • X = Draft Received by Financial Institution
  • P = Transmission Pending
  • N = Draft not in - still looking for draft
  • M = Draft missing
  • O = Draft previously provided by merchant and on file at MPS
Added On:  03/30/15
SQL Column:  DRAFT_ACTION_CODE_DATE
Java Field:  draftActionCodeDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date draft retrieval action taken (YYMMDD).
Added On:  03/30/15
SQL Column:  ELECTRONIC_COMMERCE
Java Field:  electronicCommerce
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Mail/Phone/Electronic Commerce Indicator.
Added On:  03/30/15
SQL Column:  ENTRY_MODE
Java Field:  entryMode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates if transaction was magnetic stripe read or manually keyed.

Possible values:

  • 00 = Terminal Not Used
  • 01 = Manually Keyed
  • 02 = Magnetic Stripe Read
  • 03 = Bar Code Read
  • 04 = OCR Read
  • 06 = Track 1 Read
  • 90 = Magnetic Stripe Read - PS2000 Code
  • Blanks = Entry Mode Not Known
Added On:  03/30/15
SQL Column:  FEE_AMOUNT
Java Field:  feeAmount
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Amount of the fee.

Note: When adjustment type is ‘FEE ‘ this field has no decimal places (example: ‘150’).
Added On:  03/30/15
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:  03/30/15
SQL Column:  ISSUER_CURRENCY_CODE
Java Field:  issuerCurrencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Currency code for issuer.
If not equal to 840, the original transaction was an international transaction.
Added On:  03/30/15
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:  03/30/15
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Merchant Category Code/SIC code.
Added On:  03/30/15
SQL Column:  MERCHANT_CHAIN_NUMBER
Java Field:  merchantChainNumber
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Merchant chain number from original transaction.
Added On:  02/10/17
SQL Column:  MERCHANT_CHAIN_NUMBER1
Java Field:  merchantChainNumber1
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Specific identifier of the merchant assigned by a processor.
Added On:  02/10/17
SQL Column:  MERCHANT_CHAIN_NUMBER2
Java Field:  merchantChainNumber2
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Specific identifier of the merchant assigned by a processor.
Added On:  03/30/15
SQL Column:  MERCHANT_DIVISION_NUMBER
Java Field:  merchantDivisionNumber
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Merchant division number from original transaction.
Added On:  02/10/17
SQL Column:  MERCHANT_DIVISION_NUMBER1
Java Field:  merchantDivisionNumber1
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Specific identifier of the merchant assigned by a processor.
Added On:  02/10/17
SQL Column:  MERCHANT_DIVISION_NUMBER2
Java Field:  merchantDivisionNumber2
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Specific identifier of the merchant assigned by a processor.
Added On:  03/30/15
SQL Column:  MERCHANT_DRAFT_RETRIEVAL_NUMBER
Java Field:  merchantDraftRetrievalNumber
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Draft Locater Number.
Number used by merchant to locate draft.
Added On:  01/19/17
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Name of the merchant.
Added On:  01/03/17
SQL Column:  MERCHANT_NUMBER
Java Field:  merchantNumber
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Merchant number associated with chargeback transaction.
Added On:  03/31/15
SQL Column:  MERCHANT_RESEARCH_COMMENTS_LINE3
Java Field:  merchantResearchCommentsLine3
Status:  Active
SQL Type:  varchar(240)
Java Type:  String
Attributes:
Draft Retrieval/Chargeback Record Segment.
Added On:  03/31/15
SQL Column:  MERCHANT_RESEARCH_COMMENTS_LINE4
Java Field:  merchantResearchCommentsLine4
Status:  Active
SQL Type:  varchar(240)
Java Type:  String
Attributes:
Draft Retrieval/Chargeback Record Segment.
Added On:  03/30/15
SQL Column:  MERCHANT_STORE_NUMBER
Java Field:  merchantStoreNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Number of store for original transaction.
Added On:  02/10/17
SQL Column:  MERCHANT_STORE_NUMBER1
Java Field:  merchantStoreNumber1
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Specific identifier of the merchant assigned by a processor.
Added On:  02/10/17
SQL Column:  MERCHANT_STORE_NUMBER2
Java Field:  merchantStoreNumber2
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Specific identifier of the merchant assigned by a processor.
Added On:  03/30/15
SQL Column:  NETWORK_ID
Java Field:  networkId
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
ID of the network, which authorized the original transaction.

Credit card networks:

  • VISA - Visa
  • M/C - MasterCard
  • AMEX - American Express
  • DISC - Discover
Added On:  02/10/17
SQL Column:  NETWORK_ID1
Java Field:  networkId1
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Specific identifier of the network.
Added On:  02/10/17
SQL Column:  NETWORK_ID2
Java Field:  networkId2
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Specific identifier of the network.
Added On:  02/10/17
SQL Column:  NETWORK_ID3
Java Field:  networkId3
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Specific identifier of the network.
Added On:  02/10/17
SQL Column:  NETWORK_ID4
Java Field:  networkId4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Specific identifier of the network.
Added On:  01/19/17
SQL Column:  NETWORK_ID5
Java Field:  networkId5
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Identifier of the processor's network.
Added On:  03/30/15
SQL Column:  ORIGINAL_TRANS_DATE
Java Field:  originalTransDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The date of original transaction (YYMMDD).
Added On:  03/30/15
SQL Column:  ORIGINAL_TRANS_TIME
Java Field:  originalTransTime
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
The time of the original transaction (HHMMSS).

Zeroes if not known. SS will be Zero filled.
Added On:  03/30/15
SQL Column:  PREVIOUS_DRAFT_ACTION
Java Field:  previousDraftAction
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Previous draft retrieval action code.
Added On:  03/30/15
SQL Column:  PRIMARY_ACCOUNT_NUMBER
Java Field:  primaryAccountNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Card number (PAN).

If the merchant chooses to have the account numbers truncated - the first 6, and last 4 digits will be visible. The anything in-between will be X'd out.

Example:
  • 123456XXXXXX1234 - for a 16 digit number
  • 123456XXXXX1234 - for a 15 digit number
  • 123456XXXX1234 - for a 14 digit number
Added On:  02/10/17
SQL Column:  PRIMARY_ACCOUNT_NUMBER1
Java Field:  primaryAccountNumber1
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Specific identifier of the account assigned by a processor.
Added On:  02/10/17
SQL Column:  PRIMARY_ACCOUNT_NUMBER2
Java Field:  primaryAccountNumber2
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Specific identifier of the account assigned by a processor.
Added On:  06/10/16
SQL Column:  
Java Field:  recordContent
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Content of the record.
Added On:  03/30/15
SQL Column:  RECORD_NUMBER1
Java Field:  recordNumber1
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
For any single customer transaction that is questioned, this number relates all disputes and subsequent records.

Format for the record number is YDDDSSSSSSOO, where:
  • YDDD =Date item was first received from network
  • SSSSSS = Sequence number in CHARTS
  • OO = Occurrence record number
Added On:  03/30/15
SQL Column:  RECORD_NUMBER2
Java Field:  recordNumber2
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
For any single customer transaction that is questioned, this number relates all disputes and subsequent records.

Format for the record number is YDDDSSSSSSOO, where:
  • YDDD =Date item was first received from network
  • SSSSSS = Sequence number in CHARTS
  • OO = Occurrence record number
Added On:  03/31/15
SQL Column:  RECORD_NUMBER3
Java Field:  recordNumber3
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
For any single customer transaction that is questioned, this number relates all disputes and subsequent records.

Format for the record number is YDDDSSSSSSOO, where:
  • YDDD =Date item was first received from network
  • SSSSSS = Sequence number in CHARTS
  • OO = Occurrence record number
Added On:  03/31/15
SQL Column:  RECORD_NUMBER4
Java Field:  recordNumber4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
For any single customer transaction that is questioned, this number relates all disputes and subsequent records.

Format for the record number is YDDDSSSSSSOO, where:
  • YDDD =Date item was first received from network
  • SSSSSS = Sequence number in CHARTS
  • OO = Occurrence record number
Added On:  01/19/17
SQL Column:  RECORD_NUMBER5
Java Field:  recordNumber5
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Number of the record that relates all disputes and subsequent records.
Added On:  03/30/15
SQL Column:  REGISTER_NUMBER
Java Field:  registerNumber
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Number of register for original transaction.
Added On:  03/30/15
SQL Column:  REPORT_DATE1
Java Field:  reportDate1
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date item was received from network (YYMMDD).
Added On:  03/30/15
SQL Column:  REPORT_DATE2
Java Field:  reportDate2
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date item was received from network (YYMMDD).
Added On:  03/31/15
SQL Column:  REPORT_DATE3
Java Field:  reportDate3
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date item was received from network (YYMMDD).
Added On:  03/31/15
SQL Column:  REPORT_DATE4
Java Field:  reportDate4
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date item was received from network (YYMMDD).
Added On:  01/19/17
SQL Column:  REPORT_DATE5
Java Field:  reportDate5
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Date when the item was received from the network.
Added On:  03/30/15
SQL Column:  SALES_PERSON_NUMBER
Java Field:  salesPersonNumber
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Identification number of sales person for original transaction.
Added On:  01/19/17
SQL Column:  TOTAL_SEGMENTS
Java Field:  totalSegments
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Total number of segments for the draft retrieval/chargeback record.
Added On:  03/30/15
SQL Column:  TRANSACTION_DISPOSITION_QUALIFIER
Java Field:  transactionDispositionQualifier
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Indicates why the activity record was created:

  • 100 = New Item
  • 101 = Delete
  • 102 = Update
Added On:  03/30/15
SQL Column:  TRANSACTION_TYPE1
Java Field:  transactionType1
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the initial transaction:

  • 40 = Credit card draft retrieval
  • 41 = Credit card chargeback of purchase (On a FEE record ‘41’ is a debit to the merchant.)
  • 42 = Credit card chargeback of refund, or this is network reversal of a chargeback (On a FEE record a ‘42’ is a credit to the merchant.)
Added On:  03/30/15
SQL Column:  TRANSACTION_TYPE2
Java Field:  transactionType2
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the initial transaction:

  • 40 = Credit card draft retrieval
  • 41 = Credit card chargeback of purchase (On a FEE record ‘41’ is a debit to the merchant.)
  • 42 = Credit card chargeback of refund, or this is network reversal of a chargeback (On a FEE record a ‘42’ is a credit to the merchant.)
Added On:  03/31/15
SQL Column:  TRANSACTION_TYPE3
Java Field:  transactionType3
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the initial transaction:

  • 40 = Credit card draft retrieval
  • 41 = Credit card chargeback of purchase (On a FEE record ‘41’ is a debit to the merchant.)
  • 42 = Credit card chargeback of refund, or this is network reversal of a chargeback (On a FEE record a ‘42’ is a credit to the merchant.)
Added On:  03/31/15
SQL Column:  TRANSACTION_TYPE4
Java Field:  transactionType4
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of initial transaction:

  • 40 = Credit card draft retrieval
  • 41 = Credit card chargeback of purchase (On a FEE record ‘41’ is a debit to the merchant.)
  • 42 = Credit card chargeback of refund, or this is network reversal of a chargeback (On a FEE record a ‘42’ is a credit to the merchant.)
Added On:  01/19/17
SQL Column:  TRANSACTION_TYPE5
Java Field:  transactionType5
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the credit card transaction.
Added On:  03/30/15
SQL Column:  USER_DATA_FIELD1
Java Field:  userDataField1
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
User defined data field #1.
Added On:  03/30/15
SQL Column:  USER_DATA_FIELD2
Java Field:  userDataField2
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
User defined data field #2.
Added On:  03/30/15
SQL Column:  USER_DATA_FIELD3
Java Field:  userDataField3
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
User defined data field #3.
Added On:  03/30/15
SQL Column:  USER_DATA_FIELD4
Java Field:  userDataField4
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
User defined data field #4.