Amex Chargeback Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  07/15/13 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  AmexChargebackTransaction 
                    
        
        
     
    
        
            
                
                    Represents chargeback transaction as it is defined in Amex's chargeback specification.                
             
         
     
        
        
                    
                        
                Added On:  09/20/13
                SQL Column:  ADJ_NUMBER_AREA
                Java Field:  adjNumberArea
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  AIRLINE_TKT_NUM
                Java Field:  airlineTktNum
             
            
                Status:  Active
                SQL Type:  varchar(14)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  AL_SEQUENCE_NUMBER
                Java Field:  alSequenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/06/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_DISPUTE_BATCH_FK
                Java Field:  amexChargebackDisputeBatch
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents Amex chargeback dispute batch file information.                        
                     
                 
             
                    
                        
                Added On:  07/15/13
                SQL Column:  AMEX_ID
                Java Field:  amexId
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  ASSURED_RESERVATION
                Java Field:  assuredReservation
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  BILLED_AMOUNT
                Java Field:  billedAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CANC_DATE
                Java Field:  cancDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CANC_NUM
                Java Field:  cancNum
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CANCEL_ZONE
                Java Field:  cancelZone
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CARD_DEPOSIT
                Java Field:  cardDeposit
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CASE_TYPE
                Java Field:  caseType
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Distinguishes the type of case: 
“1” – First Chargeback/Reversal 
“2” – Second Chargeback/Reversal Case.                        
                     
                 
             
                    
                        
                Added On:  07/15/13
                SQL Column:  CB_ADJUSTMENT_NUMBER
                Java Field:  cbAdjustmentNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CB_AMOUNT
                Java Field:  cbAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CB_REAS_CODE
                Java Field:  cbReasCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CB_REFERENCE_CODE
                Java Field:  cbReferenceCode
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CB_RESOLUTION_ADJ_NUMBER
                Java Field:  cbResolutionAdjNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/21/13
                SQL Column:  CHARGEBACK_CASE_ACTIVITY_DISPUTE_FK
                Java Field:  chargebackCaseActivityDispute
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents chargeback case activity dispute information.                        
                     
                 
             
                    
                        
                Added On:  08/16/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:  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:  07/22/13
                SQL Column:  CM_ACCT_NUMB_ENCODED
                Java Field:  cmAcctNumbEncoded
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/26/13
                SQL Column:  CM_ACCT_NUMB_LAST4
                Java Field:  cmAcctNumbLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ADDR1
                Java Field:  cmAddr1
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ADDR2
                Java Field:  cmAddr2
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_CITY_STATE
                Java Field:  cmCityState
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_FIRST_NAME1
                Java Field:  cmFirstName1
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_LAST_NAME1
                Java Field:  cmLastName1
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_MIDDLE_NAME1
                Java Field:  cmMiddleName1
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_NAME1
                Java Field:  cmName1
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_NAME2
                Java Field:  cmName2
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/06/16
                SQL Column:  
                Java Field:  cmNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/22/13
                SQL Column:  CM_ORIG_ACCT_NUM_ENCODED
                Java Field:  cmOrigAcctNumEncoded
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/26/13
                SQL Column:  CM_ORIG_ACCT_NUM_LAST4
                Java Field:  cmOrigAcctNumLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ORIG_FIRST_NAME
                Java Field:  cmOrigFirstName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ORIG_LAST_NAME
                Java Field:  cmOrigLastName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ORIG_MIDDLE_NAME
                Java Field:  cmOrigMiddleName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ORIG_NAME
                Java Field:  cmOrigName
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CM_ZIP
                Java Field:  cmZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CREDIT_RECEIPT_NUMBER
                Java Field:  creditReceiptNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CURRENCY
                Java Field:  currency
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CURRENT_ACTION_NUMBER
                Java Field:  currentActionNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  CURRENT_CASE_NUMBER
                Java Field:  currentCaseNumber
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA1
                Java Field:  data1
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA10
                Java Field:  data10
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA11
                Java Field:  data11
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA12
                Java Field:  data12
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA2
                Java Field:  data2
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA3
                Java Field:  data3
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA4
                Java Field:  data4
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA5
                Java Field:  data5
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA6
                Java Field:  data6
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA7
                Java Field:  data7
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA8
                Java Field:  data8
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATA9
                Java Field:  data9
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATE_OF_ADJUSTMENT
                Java Field:  dateOfAdjustment
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DATE_OF_CHARGE
                Java Field:  dateOfCharge
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/20/13
                SQL Column:  DISPUTE_AMOUNT
                Java Field:  disputeAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/20/13
                SQL Column:  DISPUTE_CODE
                Java Field:  disputeCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/20/13
                SQL Column:  DISPUTE_TEXT_AREA
                Java Field:  disputeTextArea
             
            
                Status:  Active
                SQL Type:  varchar(437)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  DISPUTES_TO_SYSTEM
                Java Field:  disputesToSystem
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FINCAP_BATCH_INVOICE_DT
                Java Field:  fincapBatchInvoiceDt
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FINCAP_BATCH_NUMBER
                Java Field:  fincapBatchNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FINCAP_FILE_SEQ_NUM
                Java Field:  fincapFileSeqNum
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FINCAP_TRACKING_ID
                Java Field:  fincapTrackingId
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FOLIO_REF
                Java Field:  folioRef
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FOREIGN_AMT
                Java Field:  foreignAmt
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  FROM_SYSTEM
                Java Field:  fromSystem
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/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/22/13
                SQL Column:  IND_FORM_CODE
                Java Field:  indFormCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  IND_REF_NUMBER
                Java Field:  indRefNumber
             
            
                Status:  Active
                SQL Type:  varchar(30)
                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/15/13
                SQL Column:  LABEL1
                Java Field:  label1
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL10
                Java Field:  label10
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL11
                Java Field:  label11
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL12
                Java Field:  label12
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL2
                Java Field:  label2
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL3
                Java Field:  label3
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL4
                Java Field:  label4
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL5
                Java Field:  label5
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL6
                Java Field:  label6
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL7
                Java Field:  label7
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL8
                Java Field:  label8
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LABEL9
                Java Field:  label9
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LOC_NUMB
                Java Field:  locNumb
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  LOC_REF_NUMBER
                Java Field:  locRefNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  MERCH_ORDER_DATE
                Java Field:  merchOrderDate
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  MERCH_ORDER_NUM
                Java Field:  merchOrderNum
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/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/15/13
                SQL Column:  MERCHANTDISE_RETURNED
                Java Field:  merchantdiseReturned
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  MERCHANTDISE_TYPE
                Java Field:  merchantdiseType
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE1
                Java Field:  note1
             
            
                Status:  Active
                SQL Type:  varchar(66)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE2
                Java Field:  note2
             
            
                Status:  Active
                SQL Type:  varchar(78)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE3
                Java Field:  note3
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE4
                Java Field:  note4
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE5
                Java Field:  note5
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE6
                Java Field:  note6
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  NOTE7
                Java Field:  note7
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  PASSENGER_FIRST_NAME
                Java Field:  passengerFirstName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  PASSENGER_LAST_NAME
                Java Field:  passengerLastName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  PASSENGER_MIDDLE_NAME
                Java Field:  passengerMiddleName
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  PASSENGER_NAME
                Java Field:  passengerName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  PREVIOUS_ACTION_NUMBER
                Java Field:  previousActionNumber
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  PREVIOUS_CASE_NUMBER
                Java Field:  previousCaseNumber
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  REJECT_TO_SYSTEM
                Java Field:  rejectToSystem
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RENTAL_AGREEMENT_NUMBER
                Java Field:  rentalAgreementNumber
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RES_CANCELLED
                Java Field:  resCancelled
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RES_CANCELLED_DATE
                Java Field:  resCancelledDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RESERVATION_LOCATION
                Java Field:  reservationLocation
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RESERVATION_MADE_FOR
                Java Field:  reservationMadeFor
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RESERVATION_MADE_ON
                Java Field:  reservationMadeOn
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RESOLUTION
                Java Field:  resolution
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURN_DATE
                Java Field:  returnDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURN_TO_NAME
                Java Field:  returnToName
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURN_TO_STREET
                Java Field:  returnToStreet
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURNED_DATE
                Java Field:  returnedDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURNED_HOW
                Java Field:  returnedHow
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURNED_NAME
                Java Field:  returnedName
             
            
                Status:  Active
                SQL Type:  varchar(24)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  RETURNED_REASON
                Java Field:  returnedReason
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  ROC_INVOICE_NUMBER
                Java Field:  rocInvoiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  SE_NUMB
                Java Field:  seNumb
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  SE_PROCESS_DATE
                Java Field:  seProcessDate
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  SOC_AMOUNT
                Java Field:  socAmount
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  SOC_INVOICE_NUMBER
                Java Field:  socInvoiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  STORE_CREDIT_RECEIVED
                Java Field:  storeCreditReceived
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  SUPP_TO_FOLLOW
                Java Field:  suppToFollow
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  10/30/13
                SQL Column:  SUPPORT_SENT
                Java Field:  supportSent
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  07/15/13
                SQL Column:  TRIUMPH_SEQ_NO
                Java Field:  triumphSeqNo
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/20/13
                SQL Column:  XREF_SE_NUMB
                Java Field:  xrefSeNumb
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String