Bancomer Auth Retail Transaction UML


Added On:  03/02/17 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  BancomerAuthRetailTransaction 
Entity that represents information about Bancomer real-time transaction.
Added On:  03/02/17
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:  03/02/17
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:  03/02/17
SQL Column:  BIT3
Java Field:  bit3
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Type of the the requested transaction (purchase with credit card, withdrawal of card from savings account, consultation of checking account, etc.).
Added On:  03/02/17
SQL Column:  BIT4
Java Field:  bit4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of the transaction (with cents).
Added On:  03/02/17
SQL Column:  BIT7
Java Field:  bit7
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Date and time of the transmission (in GMT).
Added On:  03/02/17
SQL Column:  BIT11
Java Field:  bit11
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Unique identifier of the message sent between the processor and an internetwork.
Added On:  03/02/17
SQL Column:  BIT12
Java Field:  bit12
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Local time of the transaction.
Added On:  03/02/17
SQL Column:  BIT13
Java Field:  bit13
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Local day of the transaction.
Added On:  03/02/17
SQL Column:  BIT15
Java Field:  bit15
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Day on which the transaction is accounted.
Added On:  03/02/17
SQL Column:  BIT17
Java Field:  bit17
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Day on which the transaction is registered by the acquirer.
Added On:  03/02/17
SQL Column:  BIT22
Java Field:  bit22
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Type of how the card number was entered and the terminal's capacity to accept/request the PIN.
Added On:  03/02/17
SQL Column:  BIT23
Java Field:  bit23
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Card sequence number used to distinguish a card between cards which have the same PAN (Primary Account Number).
Added On:  03/02/17
SQL Column:  BIT25
Java Field:  bit25
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Indicates whether the transaction is an e-commerce transaction.
Added On:  03/02/17
SQL Column:  BIT32
Java Field:  bit32
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Identifier of the processor.
Added On:  03/02/17
SQL Column:  
Java Field:  bit35
Status:  Active
SQL Type:  varchar(37)
Java Type:  String
Attributes: Transient
Information of track 2 stored in the magnetic strip.
Added On:  03/02/17
SQL Column:  BIT37
Java Field:  bit37
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the transaction used to identify all messages relating to an operation.
Added On:  03/02/17
SQL Column:  BIT38
Java Field:  bit38
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code assigned by the issuer/acquirer that identifies the approval of an authorization.
Added On:  03/02/17
SQL Column:  BIT39
Java Field:  bit39
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response code generated by the processor.
Added On:  03/02/17
SQL Column:  BIT41
Java Field:  bit41
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Identifier of the point of purchase Cash Register used in the authorization request.
Added On:  03/02/17
SQL Column:  BIT48
Java Field:  bit48
Status:  Active
SQL Type:  varchar(27)
Java Type:  String
Attributes:
Information about registration of the establishment.
Added On:  03/02/17
SQL Column:  BIT49
Java Field:  bit49
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used in the transaction.
Added On:  03/02/17
SQL Column:  BIT54
Java Field:  bit54
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of the cash advance/cashback (with cents).
Added On:  03/02/17
SQL Column:  
Java Field:  bit55
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes: Transient
Data of EMV Full Grade.
Added On:  03/02/17
SQL Column:  BIT58
Java Field:  bit58
Status:  Active
SQL Type:  varchar(420)
Java Type:  String
Attributes:
Points redemption data that is applied to the entities implementing the Bancomer Loyalty solution.
Added On:  03/02/17
SQL Column:  BIT60
Java Field:  bit60
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Terminal data that includes identifier of the owner, its logical network, time offset, terminal ID.
Added On:  03/02/17
SQL Column:  BIT63
Java Field:  bit63
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Additional POS data.
Added On:  03/02/17
SQL Column:  BIT70
Java Field:  bit70
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code that identifies the action to be taken in relation to the connection between the internetwork and the processor.
Added On:  03/02/17
SQL Column:  BIT90
Java Field:  bit90
Status:  Active
SQL Type:  varchar(42)
Java Type:  String
Attributes:
Fields used in reversals to include information of the original transaction.
Added On:  03/02/17
SQL Column:  BIT37_RETRIEVAL_REFERENCE_NUMBER
Java Field:  bit37RetrievalReferenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the transaction used to identify all messages relating to an operation received in response.
Added On:  03/02/17
SQL Column:  BIT38_AUTHORIZATION_IDENTIFICATION_RESPONSE
Java Field:  bit38AuthorizationIdentificationResponse
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code assigned by the issuer/acquirer that identifies the approval of an authorization received in response.
Added On:  03/03/17
SQL Column:  BIT39_RESPONSE_CODE
Java Field:  bit39ResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response code generated by the processor and received in response.
Added On:  03/03/17
SQL Column:  BIT55_DATA_OF_INTEGRATED_CIRCUIT_CARD
Java Field:  bit55DataOfIntegratedCircuitCard
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Data of EMV Full Grade received in response.
Added On:  03/03/17
SQL Column:  BIT63_POS_ADDITIONAL_DATA
Java Field:  bit63PosAdditionalData
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Additional POS data received in response.
Added On:  03/03/17
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 information about transaction.
Added On:  03/03/17
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 information about retail transaction.
Added On:  03/14/17
SQL Column:  MESSAGE_TYPE
Java Field:  messageType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of the message.
Added On:  03/14/17
SQL Column:  ISO_HEADER
Java Field:  isoHeader
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Contents of the header of the message.
Added On:  03/14/17
SQL Column:  BIT15_SETTLEMENT_DATE
Java Field:  bit15SettlementDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Day on which the transaction is accounted received in response.