Amex Auth Retail Transaction UML


Added On:  09/21/13 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  AmexAuthRetailTransaction 
American Express specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, American Express specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  06/30/22
SQL Column:  BIT113
Java Field:  bit113
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
Added On:  06/06/16
SQL Column:  
Java Field:  bit14
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date of the card.
Added On:  06/06/16
SQL Column:  
Java Field:  bit2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PAN of the cardholder.
Added On:  06/06/16
SQL Column:  
Java Field:  bit35
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Data that is contained in track 2 data of the card.
Added On:  06/06/16
SQL Column:  
Java Field:  bit45
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Data that is contained in track 1 data of the card.
Added On:  06/06/16
SQL Column:  
Java Field:  bit52
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PIN data associated with the card.
Added On:  06/06/16
SQL Column:  
Java Field:  bit53
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Card identifier code (CID).
Added On:  02/06/18
SQL Column:  BIT55
Java Field:  bit55
Status:  Active
SQL Type:  varchar(256)
Java Type:  String
Attributes:
Added On:  02/06/18
SQL Column:  BIT55_RESPONSE
Java Field:  bit55Response
Status:  Active
SQL Type:  varchar(256)
Java Type:  String
Attributes:
Added On:  06/30/22
SQL Column:  BIT60
Java Field:  bit60
Status:  Active
SQL Type:  varchar(106)
Java Type:  String
Attributes:
Added On:  06/06/16
SQL Column:  
Java Field:  bit61
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
American Express SafeKey that is an industry-standard Authentication method that provides greater security by authenticating the Cardmember during an online purchase and protecting payment card information as it is transmitted via the Internet.
Added On:  02/06/18
SQL Column:  BIT61_AEVV
Java Field:  bit61Aevv
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Added On:  09/24/13
SQL Column:  BIT11
Java Field:  bit11
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Unique trace number that identifies a transaction. Assigned by a merchant.
Added On:  09/24/13
SQL Column:  BIT12
Java Field:  bit12
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Year, month, day and local time when the transaction took place at the card acceptor location.
Added On:  09/24/13
SQL Column:  BIT13
Java Field:  bit13
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Date embossed on the face of the card supported by the processor.
Added On:  09/24/13
SQL Column:  BIT19
Java Field:  bit19
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the merchant's mailing address.
Added On:  09/24/13
SQL Column:  BIT22
Java Field:  bit22
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Code that identifies terminal capability, security data and specific conditions present at the time the transaction occurred at the point of service.
Added On:  09/24/13
SQL Column:  BIT24
Java Field:  bit24
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Function code. Assigned by the processor.
Added On:  09/24/13
SQL Column:  BIT25
Java Field:  bit25
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Reason code of the merchant. Assigned by the processor.
Added On:  09/24/13
SQL Column:  BIT26
Java Field:  bit26
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
MCC code of the merchant.
Added On:  09/24/13
SQL Column:  BIT27
Java Field:  bit27
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Length of the approval code.
Added On:  09/24/13
SQL Column:  BIT3
Java Field:  bit3
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code that indicates the financial service being requested. Assigned by the processor.
Added On:  09/24/13
SQL Column:  BIT31
Java Field:  bit31
Status:  Active
SQL Type:  varchar(48)
Java Type:  String
Attributes:
Reference data associated with the acquirer.
Added On:  09/24/13
SQL Column:  BIT31_ACQUIRED_REFERENCE_DATA
Java Field:  bit31AcquiredReferenceData
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Reference data associated with the acquirer received in response.
Added On:  09/24/13
SQL Column:  BIT32
Java Field:  bit32
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Identification code of the acquiring institution processing the request.
Added On:  09/24/13
SQL Column:  BIT33
Java Field:  bit33
Status:  Active
SQL Type:  varchar(11)
Java Type:  String
Attributes:
Identification code of the forwarding institution.
Added On:  09/24/13
SQL Column:  BIT37
Java Field:  bit37
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Retrieval reference number. Assigned by the processor.
Added On:  09/24/13
SQL Column:  BIT38_APPROVAL_CODE
Java Field:  bit38ApprovalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Approval code generated within the processor's system.
Added On:  09/24/13
SQL Column:  BIT39_ACTION_CODE
Java Field:  bit39ActionCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Action code associated with transaction.
Added On:  09/24/13
SQL Column:  BIT4
Java Field:  bit4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Total transaction amount.
Added On:  09/24/13
SQL Column:  BIT4_AMOUNT
Java Field:  bit4Amount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Total transaction amount received in response.
Added On:  09/24/13
SQL Column:  BIT41
Java Field:  bit41
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Code that identifies a specific terminal at a merchant location.
Added On:  09/24/13
SQL Column:  BIT42
Java Field:  bit42
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Identifier of the merchant in a POS transaction.
Added On:  09/24/13
SQL Column:  BIT43
Java Field:  bit43
Status:  Active
SQL Type:  varchar(99)
Java Type:  String
Attributes:
Name and location of the card acceptor.
Added On:  09/24/13
SQL Column:  BIT44_ADDITIONAL_RESPONSE_DATA
Java Field:  bit44AdditionalResponseData
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Additional data associated with cardholder and included in response.
Added On:  09/24/13
SQL Column:  BIT47
Java Field:  bit47
Status:  Active
SQL Type:  varchar(301)
Java Type:  String
Attributes:
Additional data associated with the cardholder. This data field is used only for transactions where the cardholder is not present.
Added On:  09/24/13
SQL Column:  BIT48
Java Field:  bit48
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Extended payment indicator that consists of the plan type and number of installments. Assigned by the processor.
Added On:  09/24/13
SQL Column:  BIT49
Java Field:  bit49
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used in transaction.
Added On:  09/24/13
SQL Column:  BIT54_ADDITIONAL_AMOUNTS
Java Field:  bit54AdditionalAmounts
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Additional amounts included in processed transaction.
Added On:  09/24/13
SQL Column:  BIT56
Java Field:  bit56
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Added On:  09/24/13
SQL Column:  BIT62_PRIVATE_DATA
Java Field:  bit62PrivateData
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Private data associated with a cardholder received in response.
Added On:  09/24/13
SQL Column:  BIT63
Java Field:  bit63
Status:  Active
SQL Type:  varchar(205)
Java Type:  String
Attributes:
Data that is required to process certain types of Authorization Request (1100) messages, such as American Express Travelers Cheque, and verifications for Cardmember Name, Address, ZIP Code, and Telephone Number.
Added On:  09/24/13
SQL Column:  BIT7
Java Field:  bit7
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
System date and time when a merchant transmits the transaction information to the processor.
Added On:  09/24/13
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  02/06/18
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
Added On:  09/21/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:  02/22/17
SQL Column:  MERCH_NBR
Java Field:  merchNbr
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Merchant number assigned within the system.
Added On:  09/21/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:  09/24/13
SQL Column:  MESSAGE_TYPE_IDENTIFIER
Java Field:  messageTypeIdentifier
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Identifier of the type of the message.
Added On:  02/22/17
SQL Column:  ORIGIN
Java Field:  origin
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Specific identifier of the processor.
Added On:  02/06/18
SQL Column:  REGION
Java Field:  region
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  09/24/13
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  02/22/17
SQL Column:  RT_IND
Java Field:  rtInd
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Specific identifier. Assigned by a processor.