Transaction


Added On:  02/13/12 
SQL Table:  TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Hidden 
Java Class:  Transaction 
Base entity for a financial transaction handled by the system.
Added On:  02/13/12
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Total amount of the transaction.

When partial authorizations are done, amount represents required amount, which may or may not be available.
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/13/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required, CreateOnly
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:  02/13/12
SQL Column:  PROVIDER_RESPONSE_CODE
Java Field:  providerResponseCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Original (unmapped) response code provided by the Provider that processed this transaction.
Generally, the value should be used internally and should not be exposed outside the system.
Added On:  02/13/12
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response code for the transaction.

All possible response codes are defined in Reprocessing Profile.
The value is produced from the Provider specific response code, which is returned after a transaction is processed with the Provider.
Added On:  02/13/12
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Response message that corresponds to the response code for this transaction.

Response message includes Provider's response message as well as standard system message associated with this specific response code.
Added On:  02/13/12
SQL Column:  TRANSACTION_STATUS_CL
Java Field:  transactionStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes: Required
Current status of the transaction.