Amex Inquiry Transaction UML


Added On:  07/22/13 
SQL Table:  AMEX_INQUIRY_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  AmexInquiryTransaction 
Available Fields:
Added On:  07/22/13
SQL Column:  AIRLINE_TICKET_NUMBER
Java Field:  airlineTicketNumber
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  06/29/16
SQL Column:  AMEX_CHARGEBACK_BATCH_FK
Java Field:  amexChargebackBatch
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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
Attributes:
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
Attributes:
Added On:  07/22/13
SQL Column:  AMEX_PROCESS_DATE
Java Field:  amexProcessDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  ASSURED_RESERVATION
Java Field:  assuredReservation
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  CANCEL_ZONE
Java Field:  cancelZone
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  CARD_CANC_NUMBER
Java Field:  cardCancNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  CARD_DEPOSIT
Java Field:  cardDeposit
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  
Java Field:  cardmemberAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  07/26/13
SQL Column:  CARDMEMBER_ACCOUNT_NUMBER_ENCODED
Java Field:  cardmemberAccountNumberEncoded
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  07/26/13
SQL Column:  CARDMEMBER_ACCOUNT_NUMBER_LAST4
Java Field:  cardmemberAccountNumberLast4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_CITY_STATE
Java Field:  cardmemberCityState
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_FIRST_NAME1
Java Field:  cardmemberFirstName1
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_LAST_NAME1
Java Field:  cardmemberLastName1
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_MIDDLE_NAME1
Java Field:  cardmemberMiddleName1
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_NAME1
Java Field:  cardmemberName1
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_NAME2
Java Field:  cardmemberName2
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_ORIG_FIRST_NAME
Java Field:  cardmemberOrigFirstName
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_ORIG_LAST_NAME
Java Field:  cardmemberOrigLastName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_ORIG_MIDDLE_NAME
Java Field:  cardmemberOrigMiddleName
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_ORIGINAL_NAME
Java Field:  cardmemberOriginalName
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  
Java Field:  cardmemberOriginalNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  07/26/13
SQL Column:  CARDMEMBER_ORIGINAL_NUMBER_ENCODED
Java Field:  cardmemberOriginalNumberEncoded
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  07/26/13
SQL Column:  CARDMEMBER_ORIGINAL_NUMBER_LAST4
Java Field:  cardmemberOriginalNumberLast4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CARDMEMBER_ZIP
Java Field:  cardmemberZip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  CASE_TYPE
Java Field:  caseType
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
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
Attributes:
Added On:  08/13/13
SQL Column:  CHARGEBACK_CASE_ACTIVITY_FK
Java Field:  chargebackCaseActivity
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Transient
Added On:  07/23/13
SQL Column:  CREDIT_RECEIPT_NUMBER
Java Field:  creditReceiptNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  CREDIT_REQUESTED
Java Field:  creditRequested
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  DATE_ACTION_TAKEN
Java Field:  dateActionTaken
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  DATE_OF_CHARGE
Java Field:  dateOfCharge
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  DISPUTED_AMOUNT
Java Field:  disputedAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  DOLLAR_AMOUNT
Java Field:  dollarAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  FOLIO_REF_NUMBER
Java Field:  folioRefNumber
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  FOLLOWUP_REASON_CODE
Java Field:  followupReasonCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  FOREIGN_AMOUNT
Java Field:  foreignAmount
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
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
Attributes:
Added On:  07/23/13
SQL Column:  IND_REF_NUMBER
Java Field:  indRefNumber
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  INQUIRY_ACTION_NUMBER
Java Field:  inquiryActionNumber
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  INQUIRY_ACTION_RESOLUTION_CODE
Java Field:  inquiryActionResolutionCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  INQUIRY_CASE_NUMBER
Java Field:  inquiryCaseNumber
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_MARK
Java Field:  inquiryMark
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  INQUIRY_NOTE1
Java Field:  inquiryNote1
Status:  Active
SQL Type:  varchar(66)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_NOTE2
Java Field:  inquiryNote2
Status:  Active
SQL Type:  varchar(78)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_NOTE3
Java Field:  inquiryNote3
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_NOTE4
Java Field:  inquiryNote4
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_NOTE5
Java Field:  inquiryNote5
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_NOTE6
Java Field:  inquiryNote6
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  INQUIRY_NOTE7
Java Field:  inquiryNote7
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  INQUIRY_REASON_CODE
Java Field:  inquiryReasonCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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
Attributes:
Added On:  07/22/13
SQL Column:  LOCATION_NUMBER
Java Field:  locationNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  LTA_FIELD_DATE
Java Field:  ltaFieldDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  MERCHANDISE_RETURNED
Java Field:  merchandiseReturned
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  MERCHANDISE_TYPE
Java Field:  merchandiseType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
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
Attributes:
Added On:  07/23/13
SQL Column:  PASSENGER_FIRST_NAME
Java Field:  passengerFirstName
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  PASSENGER_LAST_NAME
Java Field:  passengerLastName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  PASSENGER_MIDDLE_NAME
Java Field:  passengerMiddleName
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  PASSENGER_NAME
Java Field:  passengerName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  REFERENCE_NUMBER
Java Field:  referenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RENTAL_AGREEMENT_NEEDED
Java Field:  rentalAgreementNeeded
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RENTAL_AGREEMENT_NUMBER
Java Field:  rentalAgreementNumber
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  REPLACEMENT_REQUESTED
Java Field:  replacementRequested
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RES_CANCELLED
Java Field:  resCancelled
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RES_CANCELLED_DATE
Java Field:  resCancelledDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RES_CANCELLED_TIME
Java Field:  resCancelledTime
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RESERVATION_LOCATION
Java Field:  reservationLocation
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RESERVATION_MADE_FOR
Java Field:  reservationMadeFor
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RESERVATION_MADE_ON
Java Field:  reservationMadeOn
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  RESPONSE_EXPLANATION1
Java Field:  responseExplanation1
Status:  Active
SQL Type:  varchar(132)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  RESPONSE_EXPLANATION2
Java Field:  responseExplanation2
Status:  Active
SQL Type:  varchar(253)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  RESPONSE_EXPLANATION3
Java Field:  responseExplanation3
Status:  Active
SQL Type:  varchar(59)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURN_DATE
Java Field:  returnDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURN_TO_NAME
Java Field:  returnToName
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURN_TO_STREET
Java Field:  returnToStreet
Status:  Active
SQL Type:  varchar(17)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURNED_DATE
Java Field:  returnedDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURNED_HOW
Java Field:  returnedHow
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURNED_NAME
Java Field:  returnedName
Status:  Active
SQL Type:  varchar(24)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  RETURNED_REASON
Java Field:  returnedReason
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  SE_NUMBER
Java Field:  seNumber
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  SE_PROCESS_DATE
Java Field:  seProcessDate
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  SE_REPLY_BY_DATE
Java Field:  seReplyByDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  SE_TRACKING
Java Field:  seTracking
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  SEQUENCE_INDICATOR
Java Field:  sequenceIndicator
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  SERVICE_AGENT_MERCHANT_ID
Java Field:  serviceAgentMerchantId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  SOC_INVOICE_NUMBER
Java Field:  socInvoiceNumber
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  STORE_CREDIT_RECEIVED
Java Field:  storeCreditReceived
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  SUPPORT_SENT
Java Field:  supportSent
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  07/22/13
SQL Column:  SUPPORT_TO_FOLLOW
Java Field:  supportToFollow
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  09/21/13
SQL Column:  TRIUMPH_AREA
Java Field:  triumphArea
Status:  Active
SQL Type:  varchar(47)
Java Type:  String
Attributes:
Added On:  07/23/13
SQL Column:  TRIUMPH_SEQUENCE_NUMBER
Java Field:  triumphSequenceNumber
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes: