Moneris ISO Auth Retail Transaction UML
Added On: 11/04/15
Module: UniCharge
Type: Entity
Status: Deleted
Java Class: MonerisIsoAuthRetailTransaction
Added On: 11/04/15
SQL Column: BIT03
Java Field: bit03
Status: Active
SQL Type: varchar(6)
Java Type: String
Processing code.
Code used in conjunction with the message type to define the transaction being sent from the POS to the host.
Added On: 11/04/15
SQL Column: BIT04
Java Field: bit04
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/19/15
SQL Column: BIT04_RESPONSE
Java Field: bit04Response
Status: Active
SQL Type: varchar(12)
Java Type: String
Amount of the transaction response field.
Added On: 11/04/15
SQL Column: BIT07
Java Field: bit07
Status: Active
SQL Type: varchar(10)
Java Type: String
Actual date and time of the transmission.
Added On: 11/04/15
SQL Column: BIT104_RESPONSE
Java Field: bit104Response
Status: Active
SQL Type: varchar(6)
Java Type: String
Added On: 11/04/15
SQL Column: BIT11
Java Field: bit11
Status: Active
SQL Type: varchar(6)
Java Type: String
System-generated number provided by the merchant, the System Trace Number uniquely identifies a transaction and is also considered the debit “receipt” number.
Added On: 11/04/15
SQL Column: BIT114
Java Field: bit114
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 11/04/15
SQL Column: BIT116
Java Field: bit116
Status: Active
SQL Type: varchar(5)
Java Type: String
Added On: 11/18/15
SQL Column: BIT116_RESPONSE
Java Field: bit116Response
Status: Active
SQL Type: varchar(5)
Java Type: String
Added On: 11/04/15
SQL Column: BIT117
Java Field: bit117
Status: Active
SQL Type: varchar(78)
Java Type: String
Added On: 11/04/15
SQL Column: BIT118
Java Field: bit118
Status: Active
SQL Type: varchar(78)
Java Type: String
Added On: 11/04/15
SQL Column: BIT119
Java Field: bit119
Status: Active
SQL Type: varchar(9)
Java Type: String
Added On: 11/04/15
SQL Column: BIT12
Java Field: bit12
Status: Active
SQL Type: varchar(6)
Java Type: String
Transaction Local Time.
Actual local time when the transaction was created.
Added On: 11/19/15
SQL Column: BIT122_BANK_DATE
Java Field: bit122BankDate
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 11/04/15
SQL Column: BIT122_RESPONSE
Java Field: bit122Response
Status: Active
SQL Type: varchar(18)
Java Type: String
Added On: 11/19/15
SQL Column: BIT122_TRANSACTION_ID
Java Field: bit122TransactionId
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 11/04/15
SQL Column: BIT123
Java Field: bit123
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/04/15
SQL Column: BIT124
Java Field: bit124
Status: Active
SQL Type: varchar(11)
Java Type: String
Added On: 11/04/15
SQL Column: BIT126
Java Field: bit126
Status: Active
SQL Type: varchar(19)
Java Type: String
Added On: 11/04/15
SQL Column: BIT127
Java Field: bit127
Status: Active
SQL Type: varchar(9)
Java Type: String
Added On: 11/04/15
SQL Column: BIT13
Java Field: bit13
Status: Active
SQL Type: varchar(4)
Java Type: String
Transaction Local Date.
Actual local date when the transaction was created.
Added On: 11/04/15
SQL Column: BIT17_RESPONSE
Java Field: bit17Response
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 11/04/15
SQL Column: BIT22
Java Field: bit22
Status: Active
SQL Type: varchar(3)
Java Type: String
Specifies how the Primary Account Number was entered into the terminal. The code is comprised of the POS Entry Mode Value and the PIN Capability.
Added On: 11/04/15
SQL Column:
Java Field: bit35
Status: Active
SQL Type:
Java Type: String
Track 2 data.
Contains the information encoded from a valid Track 2 magnetic stripe read. It includes information such as the Primary Account Number and Expiration Date. Entire Track Data must be forwarded intact (excludes Start Sentinel, End Sentinel and Longitudinal Redundancy Check).
Added On: 11/04/15
SQL Column: BIT37
Java Field: bit37
Status: Active
SQL Type: varchar(12)
Java Type: String
Retrieval Reference Number.
Authorization only — For Credit and debit transactions (excluding Canadian Debit) the retrieval reference number can be any value based on the merchant’s choosing (e.g. sequential tracking of transactions, fixed value etc.).
Authorization with capture — For Credit and debit transactions (excluding Canadian Debit), this is a unique 12-byte reference number assigned to a transaction by the merchant and returned in the response message. The retrieval reference number should increment from …..001 to ….999 and should not be reset on a daily basis until it reaches ….999.
Capture Only – For Credit card transactions the retrieval reference number must be the same value that was submitted in the original authorization request.
Canadian Debit — The POS terminal at the merchant’s location generates the retrieval reference number and includes it in the transaction request. The host echoes the value back in the response. The terminal must ensure that the number is unique. The following formula is used to create the reference number.
Reversals — In a 0400 (Debit/Credit) reversal request message, the retrieval reference number does not have to match the original 0100 (Credit) and 0200 (Debit) request. This is applicable to all transaction type (Credit, Debit inclusive of Canadian Debit). For Host Draft Capture, RRN submitted at the time of authorization should match the RRN submitted in the reversal for Auth and Capture transactions.
Added On: 11/18/15
SQL Column: BIT37_RESPONSE
Java Field: bit37Response
Status: Active
SQL Type: varchar(12)
Java Type: String
Retrieval reference number response.
Added On: 11/04/15
SQL Column: BIT38
Java Field: bit38
Status: Active
SQL Type: varchar(6)
Java Type: String
Authorization Identification Response.
The Authorization ID Response is the approval code assigned by the association, issuing bank, or Debit/EBT network.
Added On: 11/18/15
SQL Column: BIT38_RESPONSE
Java Field: bit38Response
Status: Active
SQL Type: varchar(6)
Java Type: String
Authorization Identification Response.
The Authorization ID Response is the approval code assigned by the association, issuing bank, or Debit/EBT network.
Added On: 11/04/15
SQL Column: BIT39_RESPONSE
Java Field: bit39Response
Status: Active
SQL Type: varchar(2)
Java Type: String
The host response to a message to indicate the status of the transaction.
Added On: 11/04/15
SQL Column: BIT41
Java Field: bit41
Status: Active
SQL Type: varchar(8)
Java Type: String
Terminal ID.
Contains a code that identifies a merchant terminal.
Added On: 11/04/15
SQL Column: BIT42
Java Field: bit42
Status: Active
SQL Type: varchar(15)
Java Type: String
Merchant ID.
Contains a code assigned to a merchant location.
Added On: 11/04/15
SQL Column: BIT44
Java Field: bit44
Status: Active
SQL Type: varchar(3)
Java Type: String
Additional response data.
Added On: 11/04/15
SQL Column:
Java Field: bit45
Status: Active
SQL Type:
Java Type: String
Track 1 data.
Contains the information encoded from a valid Track 1 magnetic stripe read, excluding the Start Sentinel, End Sentinel, and Longitudinal Record Check (LRC). It includes information such as the Primary Account Number and Expiration Date. Entire Track Data must be forwarded intact.
Added On: 11/04/15
SQL Column: BIT46
Java Field: bit46
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 11/04/15
SQL Column: BIT48
Java Field: bit48
Status: Active
SQL Type: varchar(51)
Java Type: String
Private use data element.
Added On: 11/18/15
SQL Column: BIT48_RESPONSE_CODE
Java Field: bit48ResponseCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Response code to the Bit 48 field.
Added On: 11/04/15
SQL Column:
Java Field: bit52
Status: Active
SQL Type:
Java Type: String
Added On: 11/04/15
SQL Column:
Java Field: bit53Response
Status: Active
SQL Type:
Java Type: String
Added On: 11/04/15
SQL Column: BIT54
Java Field: bit54
Status: Active
SQL Type: varchar(49)
Java Type: String
Additional amounts.
Contains amounts associated with the transaction.
Added On: 11/04/15
SQL Column: BIT54_RESPONSE
Java Field: bit54Response
Status: Active
SQL Type: varchar(83)
Java Type: String
Added On: 11/04/15
SQL Column: BIT55
Java Field: bit55
Status: Active
SQL Type: varchar(519)
Java Type: String
ICC Data is a series of “Tag/Length/Value” combination for ICC card processing. The length of the field is the length of all data that follows the length (total length of field 55 minus 3). All information that follows the 3 digit BCD length of Field 55 should be considered binary data.
Added On: 11/04/15
SQL Column: BIT55_RESPONSE
Java Field: bit55Response
Status: Active
SQL Type: varchar(519)
Java Type: String
Added On: 11/04/15
SQL Column: BIT56
Java Field: bit56
Status: Active
SQL Type: varchar(9)
Java Type: String
Added On: 11/19/15
SQL Column: BIT56_RESPONSE
Java Field: bit56Response
Status: Active
SQL Type: varchar(5)
Java Type: String
Added On: 11/04/15
SQL Column: BIT57
Java Field: bit57
Status: Active
SQL Type: varchar(35)
Java Type: String
Added On: 11/19/15
SQL Column: BIT57_RESPONSE
Java Field: bit57Response
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 11/04/15
SQL Column: BIT58
Java Field: bit58
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 11/04/15
SQL Column: BIT58_RESPONSE
Java Field: bit58Response
Status: Active
SQL Type: varchar(39)
Java Type: String
Added On: 11/04/15
SQL Column: BIT60
Java Field: bit60
Status: Active
SQL Type: varchar(10)
Java Type: String
Additional POS information.
Comprised of the POS Type (first four bits) and the POS Capability (last four bits) data elements. The POS Type describes the general category of terminal used for the transaction. POS Capability describes the data entry methods available at the POS location.
Added On: 11/04/15
SQL Column: BIT61_RESPONSE
Java Field: bit61Response
Status: Active
SQL Type: varchar(31)
Java Type: String
Added On: 11/04/15
SQL Column: BIT63
Java Field: bit63
Status: Active
SQL Type: varchar(4)
Java Type: String
Private use data element.
Added On: 11/04/15
SQL Column: BIT64
Java Field: bit64
Status: Active
SQL Type: varchar(16)
Java Type: String
Added On: 11/04/15
SQL Column: BIT91
Java Field: bit91
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/04/15
SQL Column: BIT95
Java Field: bit95
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/04/15
SQL Column: CHARGE_TRANSACTION_FK
Java Field: chargeTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents real-time financial transaction.
Added On: 11/04/15
SQL Column: DPC_NUMBER
Java Field: dpcNumber
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 11/04/15
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Attributes:
Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On: 11/04/15
SQL Column: MERCHANT_ACCOUNT_CODE
Java Field: merchantAccountCode
Status: Active
SQL Type: int(11)
Java Type: Integer
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: 11/04/15
SQL Column: MESSAGE_TYPE
Java Field: messageType
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 11/04/15
SQL Column: RETAIL_TRANSACTION_CYCLE_FK
Java Field: retailTransactionCycle
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents a group of real-time transactions which must be settled together.