Electronic Payments Auth Retail Transaction UML


Added On:  06/24/14 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ElectronicPaymentsAuthRetailTransaction 
Electronic Payments specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Electronic Payments 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/10/16
SQL Column:  
Java Field:  accountDataSupplementary
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/24/14
SQL Column:  AMOUNT1
Java Field:  amount1
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of transaction.
Varies by transaction type.
Added On:  06/24/14
SQL Column:  AMOUNT1_RESPONSE
Java Field:  amount1Response
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Optional response message from the processor about amount of transaction.
Added On:  06/24/14
SQL Column:  AMOUNT2
Java Field:  amount2
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Card balance after transaction.
Varies by transaction type.
Added On:  06/24/14
SQL Column:  AMOUNT2_RESPONSE
Java Field:  amount2Response
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Optional response message from the processor about card balance after transaction.
Added On:  06/24/14
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:  06/24/14
SQL Column:  DECLINE_REASON
Java Field:  declineReason
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
See table. Refer to the specification.
Added On:  06/24/14
SQL Column:  ENTRY_MODE
Java Field:  entryMode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
0: Other;
1: Magnetic;
2: Manual;
3: Barcode;
4: Contact-less. Optional for G/G0.
Added On:  06/24/14
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:  06/24/14
SQL Column:  INDUSTRY_CODE
Java Field:  industryCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
1: Retail;
2: Restaurant.
Added On:  06/24/14
SQL Column:  LOCATION_ID
Java Field:  locationId
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Location identifier, assigned by processor.

4 digits zero-filled. The current server version accepts any number of
digits here.
Added On:  06/24/14
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:  06/24/14
SQL Column:  MERCHANT_ID
Java Field:  merchantId
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Merchant identifier, assigned by processor.

7 digits zero-filled. The current server version accepts any number of
digits here.
Added On:  06/24/14
SQL Column:  RESULT_CODE
Java Field:  resultCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Contains a numeric bit that indicates one or many result messages.

501: Informational response.
502: Successful transaction.
503: Declined.
Added On:  06/24/14
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:  06/24/14
SQL Column:  TERMINAL_APP_VERSION
Java Field:  terminalAppVersion
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
e.g., 2.6.
Added On:  06/24/14
SQL Column:  TERMINAL_ID
Java Field:  terminalId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Code identifying the balancing features available to the POS from the Host.

15 digits zero-filled. The first 11 digits duplicate the group and store IDs.
Added On:  06/24/14
SQL Column:  TERMINAL_SERIAL_NUMBER
Java Field:  terminalSerialNumber
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Serial number of the terminal.
e.g., 1008078745.
Added On:  06/24/14
SQL Column:  TERMINAL_TYPE
Java Field:  terminalType
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
e.g., O3750, Vx570, N8320, N8400, N8010, N2085.
Added On:  06/24/14
SQL Column:  TEXT
Java Field:  text
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Formatted OK or decline reason message.
Varies by transaction type.
Added On:  06/24/14
SQL Column:  TEXT_RESPONSE
Java Field:  textResponse
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Optional response message from the processor about the transaction status.
Added On:  06/24/14
SQL Column:  TIME_ZONE
Java Field:  timeZone
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
e.g., EST, CST.
Added On:  06/10/16
SQL Column:  
Java Field:  track2Data
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/24/14
SQL Column:  TRACK2_FORMAT_CODE
Java Field:  track2FormatCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
0 or omitted: Formatted by terminal; Nonzero: Raw data.
Added On:  06/24/14
SQL Column:  TRANSACTION_CODE
Java Field:  transactionCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
3 digits zero-filled. The current server version accepts any number of
digits here.
Added On:  06/24/14
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
A six-digit pseudorandom number.

Reserved for future use.