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.                
             
         
     
        
        
                    
                        
                Added On:  03/30/15
                SQL Column:  ACQUIRER_REFERENCE_NUMBER
                Java Field:  acquirerReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(23)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
                
                    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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  01/03/17
                SQL Column:  MERCHANT_NUMBER
                Java Field:  merchantNumber
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                    
                        
                Added On:  03/30/15
                SQL Column:  RECORD_NUMBER1
                Java Field:  recordNumber1
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        User defined data field #4.