Retail Transaction


Parent:    Charge Transaction
Added On:  02/13/12 
SQL Table:  RETAIL_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Hidden 
Java Class:  RetailTransaction 
Represents real-time financial transaction.
Added On:  02/13/12
SQL Column:  CAPTURE_AMOUNT
Java Field:  captureAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Transaction amount that is to be used for settlement.

In most cases Amount and Capture Amount will match. In cases of partial authorizations as well as in some business scenarios, Capture Amount might be less than the Amount. Capture Amount cannot exceed the value in the Amount field.
Added On:  02/13/12
SQL Column:  CONFIRM
Java Field:  confirm
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Confirm Classifier
Attributes:
Indicates whether transaction is confirmed to be settled (captured) or requested to be voided (non-captured).

The field is used in scenarios when a business process requires initial transaction authorization and a subsequent explicit confirmation of the settlement. In such cases transaction is initially sent as unconfirmed (basically void) and when appropriate is confirmed later before the settlement for the day occurs.

Please see Integration Specification for additional details on capture and void operations.
Added On:  02/14/12
SQL Column:  
Java Field:  cvv2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: CreateOnly, Transient

CVV2 of the card that is used in the transaction.

Note: the field is transient and is not present in the database
Added On:  02/14/12
SQL Column:  
Java Field:  cvv2Indicator
Status:  Active
SQL Type:  
Java Type:  String
Attributes: CreateOnly, Transient
Indicates whether or not CVV2 was supplied.

Possible values:

P - value was supplied
N - value was not supplied
I - value was not supplied because it could not be read
X - value was not supplied because it was not present on the card

Note: the field is transient and is not present in the database
Added On:  02/13/12
SQL Column:  CVV2_RESPONSE_CODE
Java Field:  cvv2ResponseCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Response code supplied by the Provider that processed the transaction based on CVV2 value supplied during transaction authorization.
Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/14/12
SQL Column:  
Java Field:  processorResponse
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Raw parsed response text returned by the Provider for this transaction.

The field is for internal purposes only and should not be exposed to the outside world.
Added On:  02/13/12
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycleFk
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes: Required, CreateOnly
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  02/13/12
SQL Column:  SUB_BATCH_FK
Java Field:  subBatchFk
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Sub Batch
Attributes: Required, CreateOnly
Reference to a sub batch that this transaction belongs to.

See Sub Batch definition for additional information.
Added On:  02/14/12
SQL Column:  
Java Field:  trackData1
Status:  Active
SQL Type:  
Java Type:  String
Attributes: CreateOnly, Transient
For swiped transactions only, this field contains track data of the card that is used in the transaction.

Note: the field is transient and is not present in the database
Added On:  07/29/13
SQL Column:  
Java Field:  trackData2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: CreateOnly, Transient
For swiped transactions only, this field contains track data of the card that is used in the transaction.

Note: the field is transient and is not present in the database
Added On:  02/13/12
SQL Column:  TRANSACTION_INDUSTRY_CL
Java Field:  transactionIndustryCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible industry types assigned to this transaction.

Industry Type dictates processing rules and interchange rate that affect this specific transaction.
Added On:  07/29/13
SQL Column:  
Java Field:  voidAmount
Status:  Active
SQL Type:  
Java Type:  Integer
Attributes: Transient
Added On:  02/13/12
SQL Column:  VOID_DATE
Java Field:  voidDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date and time when void was issued on this transaction.
Added On:  02/13/12
SQL Column:  VOID_TRANSACTION_CODE
Java Field:  voidTransactionCode
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Value from the transaction submitter's system.

It is used to assign submitter's specific void transaction id to the transaction, to cross reference this transaction between two systems.

Usually, the value will contain a reference to an entity representing this void transaction in submitter's front-end system.

In cases when submitter doesn't record void transaction as a separate record with a unique id (but rather as an adjustment to the original transaction), the field will not be used.
Added On:  02/13/12
SQL Column:  VOID_TRANSACTION_MEMO
Java Field:  voidTransactionMemo
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Description of the void transaction, might be coming from the submitter's system or assigned internally. Usually will contain explanation behind the void.