FirstData OmniPay Auth Retail Transaction UML


Added On:  07/18/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataOmniPayAuthRetailTransaction 
Represents a specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
Added On:  11/21/16
SQL Column:  
Java Field:  applicationId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identification number of the used application.
Added On:  07/18/16
SQL Column:  BIT11
Java Field:  bit11
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
System trace audit number (STAN) assigned by the originator of a message to identify a transaction.
Added On:  07/18/16
SQL Column:  BIT12
Java Field:  bit12
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Local time at which the transaction takes place at the location of the card accepting device.
Added On:  07/18/16
SQL Column:  BIT13
Java Field:  bit13
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Local month and day on which the transaction takes place at the location of the card accepting device.
Added On:  07/18/16
SQL Column:  BIT14
Java Field:  bit14
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Expiration date of the customer's card.
Added On:  07/18/16
SQL Column:  BIT15
Java Field:  bit15
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Date when the settlement occurred submitted in the request.
Added On:  07/18/16
SQL Column:  BIT15_SETTLEMENT_DATE
Java Field:  bit15SettlementDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Date when the settlement occurred recieved in the response.
Added On:  07/18/16
SQL Column:  BIT18
Java Field:  bit18
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
MCC of the merchant's business.
Added On:  07/18/16
SQL Column:  BIT19
Java Field:  bit19
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country associated with merchant's mailing address, submitted in the request.
Added On:  07/18/16
SQL Column:  BIT19_COUNTRY_CODE
Java Field:  bit19CountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country associated with merchant's mailing address, received in the response.
Added On:  07/18/16
SQL Column:  
Java Field:  bit2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
PAN associated with the customer's card.
Added On:  07/18/16
SQL Column:  BIT22
Java Field:  bit22
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
POS entry mode that indicates how PAN was captured and, where applicable, the PIN entry capabilities of the used terminal.
Added On:  07/18/16
SQL Column:  BIT23
Java Field:  bit23
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Card sequence number used to differentiate cards that have the same PAN.
Added On:  07/18/16
SQL Column:  BIT25
Java Field:  bit25
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Condition code that is used to indicate the condition under which the transaction occurred (cardholder present, cardholder not present, telephone order, etc).
Added On:  07/18/16
SQL Column:  BIT26
Java Field:  bit26
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
PIN capture code required for JCB Online PIN authorization.
Added On:  07/18/16
SQL Column:  BIT3
Java Field:  bit3
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Processing code used to describe the way of how the card was used (purchase, cashback, refund, etc).
Added On:  07/18/16
SQL Column:  BIT32
Java Field:  bit32
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifier of the acquiring institution submitted in the request.
Added On:  07/18/16
SQL Column:  BIT32_ACQUIRING_INSTITUTION_CODE
Java Field:  bit32AcquiringInstitutionCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifier of the acquiring institution received in the response.
Added On:  07/18/16
SQL Column:  
Java Field:  bit35
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Data encoded on Track 2 of the magnetic stripe.
Added On:  07/18/16
SQL Column:  BIT37
Java Field:  bit37
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Retrieval reference number that provides a reference for a card-read transaction, pinpointing it to a specific date and POS terminal.
Added On:  07/21/16
SQL Column:  BIT38
Java Field:  bit38
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Authorisation code that is generated by the card network when an authorisation occurrs.
Added On:  07/18/16
SQL Column:  BIT38_AUTHORISATION_CODE
Java Field:  bit38AuthorisationCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code of the authorization message generated by the processor and received in the response.
Added On:  07/21/16
SQL Column:  BIT39
Java Field:  bit39
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code that is used to define the result of a transaction, the status of a message or some action taken or required.
Added On:  07/18/16
SQL Column:  BIT39_RESPONSE_CODE
Java Field:  bit39ResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the response message generated by the processor and received in the response.
Added On:  07/18/16
SQL Column:  BIT4
Java Field:  bit4
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount of the transaction submitted in the request.
Added On:  07/18/16
SQL Column:  BIT4_TRANSACTION_AMOUNT
Java Field:  bit4TransactionAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Amount in the transaction received in the response.
Added On:  07/18/16
SQL Column:  BIT41
Java Field:  bit41
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Identificator of a particular terminal at the card acceptor’s location.
Added On:  07/18/16
SQL Column:  BIT42
Java Field:  bit42
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Merchant number assigned by the processor.
Added On:  07/18/16
SQL Column:  BIT43
Java Field:  bit43
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Name and location of the merchant.
Added On:  07/18/16
SQL Column:  BIT44
Java Field:  bit44
Status:  Active
SQL Type:  varchar(99)
Java Type:  String
Attributes:
Additional information submitted in the request.
Added On:  07/18/16
SQL Column:  BIT44_ADDITIONAL_RESPONSE_DATA
Java Field:  bit44AdditionalResponseData
Status:  Active
SQL Type:  varchar(99)
Java Type:  String
Attributes:
Additional information received in the response.
Added On:  07/18/16
SQL Column:  BIT44_DINERS_CVV_RESULT_CODE
Java Field:  bit44DinersCvvResultCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Result code of the Diners CVV verification.
Added On:  07/29/16
SQL Column:  BIT44_DINERS_NETWORK_REFERENCE_ID
Java Field:  bit44DinersNetworkReferenceId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Secondary identifier of the Diners network that can be used to cross-reference records between UniPay and integrated systems, received in the response.
Added On:  07/29/16
SQL Column:  BIT44_MC_BANKNET_REFERENCE_NUMBER
Java Field:  bit44McBanknetReferenceNumber
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Secondary identifier of the MasterCard network that can be used to cross-reference records between UniPay and integrated systems, received in the response.
Added On:  07/18/16
SQL Column:  BIT44_MC_CVC2_RESULT_CODE
Java Field:  bit44McCvc2ResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Result code of the MasterCard CVC2 verification.
Added On:  07/18/16
SQL Column:  BIT44_VISA_ADDRESS_VERIFICATION_RESULT_CODE
Java Field:  bit44VisaAddressVerificationResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Address verification code associated with Visa transaction, received in the response.
Added On:  07/18/16
SQL Column:  BIT44_VISA_CVV_RESULT_CODE
Java Field:  bit44VisaCvvResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Result code of the Visa CVV verification.
Added On:  07/18/16
SQL Column:  BIT44_VISA_CVV2_RESULT_CODE
Java Field:  bit44VisaCvv2ResultCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Result code of the Visa CVV2 verification.
Added On:  07/18/16
SQL Column:  
Java Field:  bit45
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Data encoded on Track 1 of the magnetic stripe.
Added On:  07/18/16
SQL Column:  
Java Field:  bit48
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CVC2/CVV2 code associated with customer's card.
Added On:  07/18/16
SQL Column:  BIT49
Java Field:  bit49
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used at the location of the transaction.
Added On:  07/18/16
SQL Column:  
Java Field:  bit53SecurityRelatedControlInformation
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Information needed to perform a PIN translation and any information required to be passed to VISA or MasterCard, received in the response.
Added On:  07/21/16
SQL Column:  BIT54
Java Field:  bit54
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Balance of the merchant submitted in the request.
Added On:  07/18/16
SQL Column:  BIT54_ADDITIONAL_AMOUNTS
Java Field:  bit54AdditionalAmounts
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Any additional amounts included in transaction and received in the response.
Added On:  07/25/16
SQL Column:  BIT54_BALANCE
Java Field:  bit54Balance
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Balance of the merchant received in the response.
Added On:  07/18/16
SQL Column:  
Java Field:  bit55
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Information associated with ICC code, assigned to the merchant and submitted in the request.
Added On:  07/18/16
SQL Column:  
Java Field:  bit55IccData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Information associated with ICC code, assigned to the merchant and received in the response.
Added On:  07/18/16
SQL Column:  BIT60
Java Field:  bit60
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Data that is used to transfer additional information from a host to a terminal or vice versa, submitted in the request.
Added On:  07/18/16
SQL Column:  BIT60_ADDITIONAL_DATA
Java Field:  bit60AdditionalData
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Data that is used to transfer additional information from a host to a terminal or vice versa, received in the response.
Added On:  07/25/16
SQL Column:  BIT60_ADDRESS_VERIFICATION_DATA
Java Field:  bit60AddressVerificationData
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Additional information about address verification response message received in the response.
Added On:  12/21/16
SQL Column:  BIT60_UCAF
Java Field:  bit60Ucaf
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Universal cardholder authentication field associated with MasterCard and received in the response.
Added On:  07/18/16
SQL Column:  BIT61_CUSTOM_DATA
Java Field:  bit61CustomData
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Custom field used for additional information and received in the response.
Added On:  07/18/16
SQL Column:  BIT62
Java Field:  bit62
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Custom field used for additional information about PSP associated with Visa card and submitted in the request.
Added On:  07/18/16
SQL Column:  BIT62_CUSTOM_PAYMENT_SERVICE_DATA
Java Field:  bit62CustomPaymentServiceData
Status:  Active
SQL Type:  varchar(999)
Java Type:  String
Attributes:
Custom field used for additional information about PSP associated with Visa card and received in the response.
Added On:  07/29/16
SQL Column:  BIT62_MARKET_SPECIFIC_DATA_IDENTIFIER
Java Field:  bit62MarketSpecificDataIdentifier
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Specific identifier of the industry assigned by the processor and received in the response.
Added On:  07/29/16
SQL Column:  BIT62_PRODUCT_ID
Java Field:  bit62ProductId
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Identifier of the product assigned by the processor and received in the response.
Added On:  07/29/16
SQL Column:  BIT62_TRANSACTION_IDENTIFIER
Java Field:  bit62TransactionIdentifier
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Identifier of the transaction assigned by the processor and received in the response.
Added On:  07/29/16
SQL Column:  BIT62_VALIDATION_CODE
Java Field:  bit62ValidationCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Validation code of the transaction generated by the processor and received in the response.
Added On:  07/18/16
SQL Column:  BIT63
Java Field:  bit63
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Reversal reason code that indicates the reason for reversing a transaction.
Added On:  07/18/16
SQL Column:  BIT7
Java Field:  bit7
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Transmission date and time set in GMT/UTC.
Added On:  07/18/16
SQL Column:  BIT70
Java Field:  bit70
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Network nanagement code assigned by the processor.
Added On:  07/18/16
SQL Column:  BIT90
Java Field:  bit90
Status:  Active
SQL Type:  varchar(42)
Java Type:  String
Attributes:
Reference data, taken from original authorisation or response messages, used in reversal messages for the purpose of identifying a specific transaction.
Added On:  07/18/16
SQL Column:  BIT95
Java Field:  bit95
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Actual amount of the transaction to be used in place of transaction amount previously given in an authorisation request.
Added On:  07/18/16
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:  11/21/16
SQL Column:  CLIENT_REF
Java Field:  clientRef
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Secondary identifier of the client which can be used to cross-reference records between UniPay and integrated systems.
Added On:  11/21/16
SQL Column:  
Java Field:  datawireId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identifier that represents the original source document reference number.
Added On:  07/18/16
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/18/16
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:  12/09/16
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(22)
Java Type:  String
Attributes:
Identifier of the merchant assigned within the gateway.
Added On:  07/18/16
SQL Column:  MESSAGE_TYPE
Java Field:  messageType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Type of the message generated within the system.
Added On:  07/18/16
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:  11/21/16
SQL Column:  
Java Field:  serviceId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Digital number that represents the specific code of the product/service.
Added On:  12/09/16
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Identifier of the terminal assigned within the gateway.