WorldPay Auth Retail Transaction UML
Added On: 06/14/13
Module: UniCharge
Type: Entity
Status: Active
Java Class: WorldPayAuthRetailTransaction
Added On: 03/22/16
SQL Column: BIT127
Java Field: bit127
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit14
Status: Active
SQL Type:
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit35
Status: Active
SQL Type:
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit45
Status: Active
SQL Type:
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit48
Status: Active
SQL Type:
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit52
Status: Active
SQL Type:
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit55Request
Status: Active
SQL Type:
Java Type: String
Added On: 06/17/16
SQL Column:
Java Field: bit55Response
Status: Active
SQL Type:
Java Type: String
Added On: 06/14/13
SQL Column: BIT11
Java Field: bit11
Status: Active
SQL Type: varchar(6)
Java Type: String
This number is echoed in response messages to assist in matching to requests. It is not expected that the same STAN (System Trace Audit Number) be used in any subsequent reversal advice.
Added On: 06/14/13
SQL Column: BIT12
Java Field: bit12
Status: Active
SQL Type: varchar(6)
Java Type: String
The local transaction time. Formatted as HHMMSS where HH is 2-digit hour, MM - 2-digit minutes, and SS - 2-digit seconds.
Added On: 06/14/13
SQL Column:
Java Field: bit121
Status: Active
SQL Type:
Java Type: String
The Summary Data Identifiers pertain to Purchase card, PINIess debit, and petroleum transactions.
Added On: 06/14/13
SQL Column: BIT122
Java Field: bit122
Status: Active
SQL Type: varchar(999)
Java Type: String
This field carries the Line Item details required for Petroleum, Level III Purchase/Commercial card qualification and used in conjunction with the Summary Data.
Added On: 06/17/13
SQL Column: BIT13
Java Field: bit13
Status: Active
SQL Type: varchar(6)
Java Type: String
The local transaction date.
Formatted as YYMMDD, where YY is 2-digit year, MM - 2-digit month, and DD - 2-digit day.
Added On: 06/14/13
SQL Column: BIT15_SETTLEMENT_DATE
Java Field: bit15SettlementDate
Status: Active
SQL Type: varchar(4)
Java Type: String
Required for all 0500 requests and returned in financial responces.
MMDD.
Added On: 06/14/13
SQL Column: BIT18
Java Field: bit18
Status: Active
SQL Type: varchar(4)
Java Type: String
Identifies the merchant's Standart Industrial Classification (SIC) code and associated market type.
Added On: 06/17/16
SQL Column:
Java Field: bit2
Status: Active
SQL Type:
Java Type: String
Added On: 06/14/13
SQL Column: BIT22
Java Field: bit22
Status: Active
SQL Type: varchar(3)
Java Type: String
Defines the conditions under which the card account number/PAN is entered and the terminal PIN capabilities. Field is mandatory for all entry modes.
Added On: 06/14/13
SQL Column: BIT3
Java Field: bit3
Status: Active
SQL Type: varchar(6)
Java Type: String
Describes the type of transaction and the accounts it affects.
Added On: 06/14/13
SQL Column: BIT37
Java Field: bit37
Status: Active
SQL Type: varchar(12)
Java Type: String
A unique transaction reference created at the POS device.
Added On: 06/14/13
SQL Column: BIT38
Java Field: bit38
Status: Active
SQL Type: varchar(6)
Java Type: String
The authorization reference returned by the card issuer (or in case of delegated authorization, by the acquirer).
Added On: 06/14/13
SQL Column: BIT38_AUTHORIZATION_IDENTIFICATION_RESPONSE
Java Field: bit38AuthorizationIdentificationResponse
Status: Active
SQL Type: varchar(6)
Java Type: String
Authorization reference returned by the card issuer (or in case of delegated authorization, by the acquirer).
Added On: 03/23/16
SQL Column: BIT39
Java Field: bit39
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 06/14/13
SQL Column: BIT39_WORLD_PAY_RESPONSE_DATA
Java Field: bit39WorldPayResponseData
Status: Active
SQL Type: varchar(3)
Java Type: String
Defines the disposition of a previous message or an action taken as a result of receipt of a previous message.
Added On: 06/14/13
SQL Column: BIT4
Java Field: bit4
Status: Active
SQL Type: varchar(12)
Java Type: String
The full requested amount for authorization/capture.
Added On: 06/17/13
SQL Column: BIT4_APPROVED_AMOUNT
Java Field: bit4ApprovedAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
The full requested approved amount for authorization/capture.
Added On: 06/14/13
SQL Column: BIT40
Java Field: bit40
Status: Active
SQL Type: varchar(10)
Java Type: String
Defines and qualifies the transaction originated from the POS device.
Added On: 06/14/13
SQL Column: BIT42
Java Field: bit42
Status: Active
SQL Type: varchar(24)
Java Type: String
Indicates which merchant originated the transaction.
Assigned by WorldPay.
Added On: 06/14/13
SQL Column: BIT44_RESPONSE_DATA
Java Field: bit44ResponseData
Status: Active
SQL Type: varchar(25)
Java Type: String
This field is used for WorldPay rejection reason and response literal.
Added On: 06/14/13
SQL Column: BIT48_ADDRESS_VERIFICATION_RESULT
Java Field: bit48AddressVerificationResult
Status: Active
SQL Type: varchar(1)
Java Type: String
Contains the AVS verification response code which is returned in the Authorization Request Response message when the AVS functionality is used during transaction processing.
Added On: 06/14/13
SQL Column: BIT48_AMERICAN_EXPRESS_RESPONSE_DATA
Java Field: bit48AmericanExpressResponseData
Status: Active
SQL Type: varchar(15)
Java Type: String
This subelement is for the financial network code and banknet reference number.
Added On: 06/14/13
SQL Column: BIT48_AUTHENTICATION_VERIFICATION_VALUE_RESULT_CODE
Java Field: bit48AuthenticationVerificationValueResultCode
Status: Active
SQL Type: varchar(3)
Java Type: String
MasterCard UCAF/AAV or Visa CAVV results, left justified and space filled.
Added On: 06/14/13
SQL Column: BIT48_CARD_VERIFICATION_RESULT
Java Field: bit48CardVerificationResult
Status: Active
SQL Type: varchar(1)
Java Type: String
Field return when CVV/CVC2/CVV2/CID is sent for a transaction.
Added On: 06/14/13
SQL Column: BIT48_COMMERCIAL_CARD_RESPONSE
Java Field: bit48CommercialCardResponse
Status: Active
SQL Type: varchar(1)
Java Type: String
This subelement is sent in response to the type of purchase card transactions.
Added On: 06/14/13
SQL Column: BIT48_CREDIT_RESPONSE_DATA
Java Field: bit48CreditResponseData
Status: Active
SQL Type: varchar(2)
Java Type: String
This subelement is sent in response to certain credit card transactions, including Visa and MasterCard.
Added On: 06/14/13
SQL Column: BIT48_MASTER_CARD_RESPONSE_DATA
Java Field: bit48MasterCardResponseData
Status: Active
SQL Type: varchar(13)
Java Type: String
This subelement is for the financial network code and banknet reference number.
Added On: 06/14/13
SQL Column: BIT48_PREPAID_CARD_DATA
Java Field: bit48PrepaidCardData
Status: Active
SQL Type: varchar(16)
Java Type: String
This subelement is for the Prepaid Card ID and password.
Added On: 06/14/13
SQL Column: BIT48_VISA_RESPONSE_DATA
Java Field: bit48VisaResponseData
Status: Active
SQL Type: varchar(19)
Java Type: String
This subelement is for reference number and validation code for approved transactions.
Added On: 06/14/13
SQL Column: BIT54
Java Field: bit54
Status: Active
SQL Type: varchar(120)
Java Type: String
This field is included only for purchases with cash back account balances and reversals.
Added On: 06/17/13
SQL Column: BIT54_ADDITIONAL_AMOUNTS
Java Field: bit54AdditionalAmounts
Status: Active
SQL Type: varchar(120)
Java Type: String
Included only for purchases with cash back account balances and reversals.
Added On: 06/17/13
SQL Column: BIT54_BALANCE
Java Field: bit54Balance
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 06/17/13
SQL Column: BIT54_CASHBACK_AMOUNT
Java Field: bit54CashbackAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
The subelement for the amount type.
The requested/approved amount in the Request/Response messages.
Added On: 06/17/13
SQL Column: BIT54_PARTIAL_APPROVED_AMOUNT
Java Field: bit54PartialApprovedAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
The subelement for the amount type.
Added On: 06/17/13
SQL Column: BIT54_TIP_AMOUNT
Java Field: bit54TipAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 06/14/13
SQL Column: BIT59
Java Field: bit59
Status: Active
SQL Type: varchar(100)
Java Type: String
Free form. This information is returned in all approval responces.
Added On: 06/14/13
SQL Column: BIT59_WORLD_RETRIEVAL_DATA
Java Field: bit59WorldRetrievalData
Status: Active
SQL Type: varchar(100)
Java Type: String
Free Form. This element is returned in all approved transactions and approved financial responses.
Added On: 06/14/13
SQL Column: BIT60
Java Field: bit60
Status: Active
SQL Type: varchar(3)
Java Type: String
This data element and its subelements identify the reason for a reversal or an advice.
Added On: 06/14/13
SQL Column: BIT60_REASON_CODE
Java Field: bit60ReasonCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Identify the reason for a reversal or an advice.
Added On: 06/14/13
SQL Column: BIT61
Java Field: bit61
Status: Active
SQL Type: varchar(26)
Java Type: String
Element, that is used as Point of Service (POS) Data in WorldPay.
Added On: 06/14/13
SQL Column: BIT62_DEBIT_EBT_NETWORK_RESPONSE_DATA
Java Field: bit62DebitEbtNetworkResponseData
Status: Active
SQL Type: varchar(15)
Java Type: String
This field only be returned for Debit and EBT transactions that are approved or denied by the network.
Added On: 06/14/13
SQL Column: BIT7
Java Field: bit7
Status: Active
SQL Type: varchar(10)
Java Type: String
Represents the time and date that the transaction is transmitted from the payment switch, gateway, or POS device.
Added On: 06/14/13
SQL Column: BIT90
Java Field: bit90
Status: Active
SQL Type: varchar(42)
Java Type: String
Required in reversal messages to assist acquirer and issuer in matching it to the original message.
Added On: 06/14/13
SQL Column: BIT95
Java Field: bit95
Status: Active
SQL Type: varchar(42)
Java Type: String
Used for reversal advices only, and may be more or less than the original transaction amount.
Added On: 06/14/13
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: 06/14/13
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: 06/14/13
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: 06/14/13
SQL Column: MESSAGE_TYPE
Java Field: messageType
Status: Active
SQL Type: varchar(4)
Java Type: String
The 4 digit numeric field classifying the high level function of the message.
Added On: 06/14/13
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.