Napse Vtol Auth Retail Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  02/13/19 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  NapseVtolAuthRetailTransaction 
                    
        
        
     
    
        
        
                    
                        
                Added On:  02/13/19
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  AMOUNT_RESPONSE
                Java Field:  amountResponse
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  AUTHORIZATION_CODE_RESPONSE
                Java Field:  authorizationCodeResponse
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  AUTHORIZATION_MODE_RESPONSE
                Java Field:  authorizationModeResponse
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  BUSINESS_NUMBER
                Java Field:  businessNumber
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CARD_NUMBER
                Java Field:  cardNumber
             
            
                Status:  Active
                SQL Type:  varchar(19)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CARD_TYPE
                Java Field:  cardType
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CHECK_PENDING_STRING
                Java Field:  checkPendingString
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CREDIT_CARD_ISSUER_NAME
                Java Field:  creditCardIssuerName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CURRENCY_POS_CODE
                Java Field:  currencyPosCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CUSTOMER_REF
                Java Field:  customerRef
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  CVC
                Java Field:  cvc
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  DATE_TIME
                Java Field:  dateTime
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  ERROR_DESCRIPTION
                Java Field:  errorDescription
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  EXPIRATION_DATE
                Java Field:  expirationDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  FIELD42
                Java Field:  field42
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  FIELD82
                Java Field:  field82
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  HOST_CODE
                Java Field:  hostCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  HOST_NAME
                Java Field:  hostName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                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:  02/13/19
                SQL Column:  ISO_CODE
                Java Field:  isoCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  LAST_TRX_ID_RESPONSE
                Java Field:  lastTrxIdResponse
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  LOT_NUMBER
                Java Field:  lotNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                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.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe 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:  02/13/19
                SQL Column:  NODE
                Java Field:  node
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  ORIGINAL_TRX_REFERENCE_NUMBER
                Java Field:  originalTrxReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  PAYMENTS
                Java Field:  payments
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  PLAN
                Java Field:  plan
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  POS_INPUT_MODE
                Java Field:  posInputMode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  RESPONSE_MESSAGE
                Java Field:  responseMessage
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
                Java Field:  retailTransactionCycle
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  RRN
                Java Field:  rrn
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  SERIAL_NUMBER
                Java Field:  serialNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  STORE
                Java Field:  store
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  TICKET
                Java Field:  ticket
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  TRX_REFERENCE_NUMBER
                Java Field:  trxReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/19
                SQL Column:  TRX_TYPE
                Java Field:  trxType
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String