Authorize Net Auth Retail Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  11/24/12 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  AuthorizeNetAuthRetailTransaction 
                    
        
        
     
    
        
        
                    
                        
                Added On:  11/24/12
                SQL Column:  ALLOW_PARTIAL_AUTH
                Java Field:  allowPartialAuth
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates whether partial authorization is supported. Default is 'N'. Valid values = 'Y' or 'N'.                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  AMOUNT
                Java Field:  amount
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  APPROVED_AMOUNT
                Java Field:  approvedAmount
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Amount actually used. The merchant must tender the difference between the requested amount and the approved amount.                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  AUTH_CODE
                Java Field:  authCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The authCode element specifies the authorization code from the associated Authorization or Sale transaction.                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  AVS_RESULT_CODE
                Java Field:  avsResultCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Address verification result code.                         
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  BALANCE_ON_CARD
                Java Field:  balanceOnCard
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_ADDRESS
                Java Field:  billToAddress
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_CITY
                Java Field:  billToCity
             
            
                Status:  Active
                SQL Type:  varchar(40)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_COMPANY
                Java Field:  billToCompany
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_FIRST_NAME
                Java Field:  billToFirstName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_LAST_NAME
                Java Field:  billToLastName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_PHONE_NUMBER
                Java Field:  billToPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_STATE
                Java Field:  billToState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  BILL_TO_ZIP
                Java Field:  billToZip
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  cardCode
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  cardNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time financial transaction.                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  CUSTOMER_ID
                Java Field:  customerId
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  CVV_RESULT_CODE
                Java Field:  cvvResultCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  DESCRIPTION
                Java Field:  description
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  DUTY_AMOUNT
                Java Field:  dutyAmount
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  expirationDate
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                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:  11/24/12
                SQL Column:  INVOICE_NUMBER
                Java Field:  invoiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  12/06/12
                SQL Column:  IS_CARD_PRESENT
                Java Field:  isCardPresent
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                    
                        
                Added On:  11/24/12
                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:  11/24/12
                SQL Column:  MESSAGE_CODE
                Java Field:  messageCode
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  MESSAGE_TEXT
                Java Field:  messageText
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  name
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  PO_NUMBER
                Java Field:  poNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  RECURRING_BILLING
                Java Field:  recurringBilling
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  refId
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  RESULT_CODE
                Java Field:  resultCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
                Java Field:  retailTransactionCycle
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents a group of real-time transactions which must be settled together.                        
                     
                 
             
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_ADDRESS
                Java Field:  shipToAddress
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_CITY
                Java Field:  shipToCity
             
            
                Status:  Active
                SQL Type:  varchar(40)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_COMPANY
                Java Field:  shipToCompany
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_FIRST_NAME
                Java Field:  shipToFirstName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_LAST_NAME
                Java Field:  shipToLastName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_STATE
                Java Field:  shipToState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SHIP_TO_ZIP
                Java Field:  shipToZip
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  SPLIT_TENDER_ID
                Java Field:  splitTenderId
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  TAX_AMOUNT
                Java Field:  taxAmount
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  TAX_EXEMPT
                Java Field:  taxExempt
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  TEST_REQUEST
                Java Field:  testRequest
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  track1
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  track2
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  TRANS_ID
                Java Field:  transId
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/09/16
                SQL Column:  
                Java Field:  transactionKey
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/24/12
                SQL Column:  TRANSACTION_TYPE
                Java Field:  transactionType
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String