Amex Inquiry Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  07/22/13 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  AmexInquiryTransaction 
                    
        
        
     
    
        
        
                    
                        
                Added On:  07/22/13
                SQL Column:  AIRLINE_TICKET_NUMBER
                Java Field:  airlineTicketNumber
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/29/16
                SQL Column:  AMEX_CHARGEBACK_BATCH_FK
                Java Field:  amexChargebackBatch
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents American Express chargeback transaction information.                        
                     
                 
             
                    
                        
                Added On:  06/29/16
                SQL Column:  AMEX_CHARGEBACK_RESPONSE_BATCH_FK
                Java Field:  amexChargebackResponseBatch
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents Amex chargeback response batch file information.                        
                     
                 
             
                    
                        
                Added On:  07/22/13
                SQL Column:  AMEX_ID
                Java Field:  amexId
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  AMEX_PROCESS_DATE
                Java Field:  amexProcessDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  ASSURED_RESERVATION
                Java Field:  assuredReservation
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  CANCEL_ZONE
                Java Field:  cancelZone
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  CARD_CANC_NUMBER
                Java Field:  cardCancNumber
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  CARD_DEPOSIT
                Java Field:  cardDeposit
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  
                Java Field:  cardmemberAccountNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/26/13
                SQL Column:  CARDMEMBER_ACCOUNT_NUMBER_ENCODED
                Java Field:  cardmemberAccountNumberEncoded
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/26/13
                SQL Column:  CARDMEMBER_ACCOUNT_NUMBER_LAST4
                Java Field:  cardmemberAccountNumberLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_CITY_STATE
                Java Field:  cardmemberCityState
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_FIRST_NAME1
                Java Field:  cardmemberFirstName1
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_LAST_NAME1
                Java Field:  cardmemberLastName1
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_MIDDLE_NAME1
                Java Field:  cardmemberMiddleName1
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_NAME1
                Java Field:  cardmemberName1
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_NAME2
                Java Field:  cardmemberName2
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_ORIG_FIRST_NAME
                Java Field:  cardmemberOrigFirstName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_ORIG_LAST_NAME
                Java Field:  cardmemberOrigLastName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_ORIG_MIDDLE_NAME
                Java Field:  cardmemberOrigMiddleName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_ORIGINAL_NAME
                Java Field:  cardmemberOriginalName
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  
                Java Field:  cardmemberOriginalNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/26/13
                SQL Column:  CARDMEMBER_ORIGINAL_NUMBER_ENCODED
                Java Field:  cardmemberOriginalNumberEncoded
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/26/13
                SQL Column:  CARDMEMBER_ORIGINAL_NUMBER_LAST4
                Java Field:  cardmemberOriginalNumberLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CARDMEMBER_ZIP
                Java Field:  cardmemberZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CASE_TYPE
                Java Field:  caseType
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Distinguishes the type of case: 
“1” – First Chargeback/Reversal 
“2” – Second Chargeback/Reversal Case.                        
                     
                 
             
                    
                        
                Added On:  07/23/13
                SQL Column:  CHARGE_AMOUNT
                Java Field:  chargeAmount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/13/13
                SQL Column:  CHARGEBACK_CASE_ACTIVITY_FK
                Java Field:  chargebackCaseActivity
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents chargeback case activity information.                        
                     
                 
             
                    
                        
                Added On:  09/21/13
                SQL Column:  CHARGEBACK_CASE_ACTIVITY_RESPONSE_FK
                Java Field:  chargebackCaseActivityResponse
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents chargeback case activity response information.                        
                     
                 
             
                    
                        
                Added On:  08/05/13
                SQL Column:  CHARGEBACK_TRANSACTION_FK
                Java Field:  chargebackTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to a chargeback transaction representing either initial chargeback (for credit cards) or ACH return (for bank accounts). If not chargeback/return came in, the field is not set. The field is primarily used to quickly identify transactions that have chargebacks/returns.                        
                     
                 
             
                    
                        
                Added On:  06/06/16
                SQL Column:  
                Java Field:  cmNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  CREDIT_RECEIPT_NUMBER
                Java Field:  creditReceiptNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  CREDIT_REQUESTED
                Java Field:  creditRequested
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  DATE_ACTION_TAKEN
                Java Field:  dateActionTaken
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  DATE_OF_CHARGE
                Java Field:  dateOfCharge
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  DISPUTED_AMOUNT
                Java Field:  disputedAmount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  DOLLAR_AMOUNT
                Java Field:  dollarAmount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  FOLIO_REF_NUMBER
                Java Field:  folioRefNumber
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  FOLLOWUP_REASON_CODE
                Java Field:  followupReasonCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  FOREIGN_AMOUNT
                Java Field:  foreignAmount
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                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:  07/23/13
                SQL Column:  IND_FORM_CODE
                Java Field:  indFormCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  IND_REF_NUMBER
                Java Field:  indRefNumber
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  INQUIRY_ACTION_NUMBER
                Java Field:  inquiryActionNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  INQUIRY_ACTION_RESOLUTION_CODE
                Java Field:  inquiryActionResolutionCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  INQUIRY_CASE_NUMBER
                Java Field:  inquiryCaseNumber
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_MARK
                Java Field:  inquiryMark
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  INQUIRY_NOTE1
                Java Field:  inquiryNote1
             
            
                Status:  Active
                SQL Type:  varchar(66)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_NOTE2
                Java Field:  inquiryNote2
             
            
                Status:  Active
                SQL Type:  varchar(78)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_NOTE3
                Java Field:  inquiryNote3
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_NOTE4
                Java Field:  inquiryNote4
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_NOTE5
                Java Field:  inquiryNote5
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_NOTE6
                Java Field:  inquiryNote6
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  INQUIRY_NOTE7
                Java Field:  inquiryNote7
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  INQUIRY_REASON_CODE
                Java Field:  inquiryReasonCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/05/13
                SQL Column:  IS_MAPPED
                Java Field:  isMapped
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                    
                        
                Added On:  07/23/13
                SQL Column:  LOC_REF_NUMBER
                Java Field:  locRefNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  LOCATION_NUMBER
                Java Field:  locationNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  LTA_FIELD_DATE
                Java Field:  ltaFieldDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  MERCHANDISE_RETURNED
                Java Field:  merchandiseReturned
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  MERCHANDISE_TYPE
                Java Field:  merchandiseType
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                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:  07/23/13
                SQL Column:  ORDER_NUMBER
                Java Field:  orderNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  PASSENGER_FIRST_NAME
                Java Field:  passengerFirstName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  PASSENGER_LAST_NAME
                Java Field:  passengerLastName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  PASSENGER_MIDDLE_NAME
                Java Field:  passengerMiddleName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  PASSENGER_NAME
                Java Field:  passengerName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  REFERENCE_NUMBER
                Java Field:  referenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RENTAL_AGREEMENT_NEEDED
                Java Field:  rentalAgreementNeeded
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RENTAL_AGREEMENT_NUMBER
                Java Field:  rentalAgreementNumber
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  REPLACEMENT_REQUESTED
                Java Field:  replacementRequested
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RES_CANCELLED
                Java Field:  resCancelled
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RES_CANCELLED_DATE
                Java Field:  resCancelledDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RES_CANCELLED_TIME
                Java Field:  resCancelledTime
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RESERVATION_LOCATION
                Java Field:  reservationLocation
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RESERVATION_MADE_FOR
                Java Field:  reservationMadeFor
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RESERVATION_MADE_ON
                Java Field:  reservationMadeOn
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  RESPONSE_EXPLANATION1
                Java Field:  responseExplanation1
             
            
                Status:  Active
                SQL Type:  varchar(132)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  RESPONSE_EXPLANATION2
                Java Field:  responseExplanation2
             
            
                Status:  Active
                SQL Type:  varchar(253)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  RESPONSE_EXPLANATION3
                Java Field:  responseExplanation3
             
            
                Status:  Active
                SQL Type:  varchar(59)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURN_DATE
                Java Field:  returnDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURN_TO_NAME
                Java Field:  returnToName
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURN_TO_STREET
                Java Field:  returnToStreet
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURNED_DATE
                Java Field:  returnedDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURNED_HOW
                Java Field:  returnedHow
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURNED_NAME
                Java Field:  returnedName
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  RETURNED_REASON
                Java Field:  returnedReason
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  SE_NUMBER
                Java Field:  seNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  SE_PROCESS_DATE
                Java Field:  seProcessDate
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  SE_REPLY_BY_DATE
                Java Field:  seReplyByDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  SE_TRACKING
                Java Field:  seTracking
             
            
                Status:  Active
                SQL Type:  varchar(40)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  SEQUENCE_INDICATOR
                Java Field:  sequenceIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  SERVICE_AGENT_MERCHANT_ID
                Java Field:  serviceAgentMerchantId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  SOC_INVOICE_NUMBER
                Java Field:  socInvoiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  STORE_CREDIT_RECEIVED
                Java Field:  storeCreditReceived
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  SUPPORT_SENT
                Java Field:  supportSent
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  SUPPORT_TO_FOLLOW
                Java Field:  supportToFollow
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  TRIUMPH_AREA
                Java Field:  triumphArea
             
            
                Status:  Active
                SQL Type:  varchar(47)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/23/13
                SQL Column:  TRIUMPH_SEQUENCE_NUMBER
                Java Field:  triumphSequenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String