CC First Data Compass Batch                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  02/13/12 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  CcFirstDataCompassBatch 
                    
        
        
     
    
        
            
                
                    Entity that represents a batch of transactions as it is defined in FirstData Compass' batch processing specification.                
             
         
     
        
        
                    
                        
                Added On:  02/13/12
                SQL Column:  BATCH_RECORD_COUNT
                Java Field:  batchRecordCount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total number of records in the batch up to, but NOT including, the Batch Totals Record.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CREATION_DATE
                Java Field:  creationDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the record was created.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  CUSTOMER_SERVICE_PHONE_NUMBER
                Java Field:  customerServicePhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field must contain the customer-service telephone number.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  FILE_RECORD_COUNT
                Java Field:  fileRecordCount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Number of transactions included in a batch.                        
                     
                 
             
                    
                        
                Added On:  12/13/17
                SQL Column:  MERCHANT_CATEGORY_CODE
                Java Field:  merchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  12/13/17
                SQL Column:  MERCHANT_CITY
                Java Field:  merchantCity
             
            
                Status:  Active
                SQL Type:  varchar(21)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/27/15
                SQL Column:  MERCHANT_COUNTRY_CODE
                Java Field:  merchantCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant country code where the transaction took place.                        
                     
                 
             
                    
                        
                Added On:  12/13/17
                SQL Column:  MERCHANT_ID
                Java Field:  merchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_NAME
                Java Field:  merchantName
             
            
                Status:  Active
                SQL Type:  varchar(22)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Assigned and provided to merchant by First Data.                        
                     
                 
             
                    
                        
                Added On:  02/27/15
                SQL Column:  MERCHANT_POSTAL_CODE
                Java Field:  merchantPostalCode
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant Zip/Postal code where the transaction took place.                        
                     
                 
             
                    
                        
                Added On:  02/27/15
                SQL Column:  MERCHANT_REGION
                Java Field:  merchantRegion
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant State/Province where the transaction took place.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  MERCHANT_SPACE
                Java Field:  merchantSpace
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        File identifier supplied by a merchant that is returned in response file.                        
                     
                 
             
                    
                        
                Added On:  02/27/15
                SQL Column:  MERCHANT_STREET
                Java Field:  merchantStreet
             
            
                Status:  Active
                SQL Type:  varchar(38)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant street address where the transaction took place.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ORDER_COUNT
                Java Field:  orderCount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total number of orders within a batch.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PID
                Java Field:  pid
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Presenter’s ID is assigned by First Data. The PID is a number assigned to the location that physically sends the data file (Presenter).                        
                     
                 
             
                    
                        
                Added On:  07/07/16
                SQL Column:  
                Java Field:  pidPassword
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Password assigned to PID. Assigned by the processor.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  REFUNDS_AMOUNT
                Java Field:  refundsAmount
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Amount of credits in a batch.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SALES_AMOUNT
                Java Field:  salesAmount
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Amount of sale transactions in a batch.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SID
                Java Field:  sid
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Specific identifier. Assigned by the processor.                        
                     
                 
             
                    
                        
                Added On:  07/07/16
                SQL Column:  
                Java Field:  sidPassword
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Password assigned to SID. Assigned by the processor.                        
                     
                 
             
                    
                        
                Added On:  03/30/14
                SQL Column:  TOKEN_TYPE
                Java Field:  tokenType
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token type value. Assigned by the processor.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TOTAL_AMOUNT
                Java Field:  totalAmount
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of transactions within a batch.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TPP_ID
                Java Field:  tppId
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Third Party Processor ID - The TPP ID is mandatory on all Authorization requests submitted by Third Parties who have been issued one by First Data. If you were assigned a Third Party Processor ID, you are required to send this additional format record. If you were not assigned a Third Party Processor ID, this record should not be sent.                        
                     
                 
             
                    
                        
                Added On:  03/30/18
                SQL Column:  UNIQUE_FILE_ID
                Java Field:  uniqueFileId
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String