LPB Medoro Auth Retail Transaction UML


Added On:  08/17/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  LpbMedoroAuthRetailTransaction 
LPB Medoro specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, LPB Medoro specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  08/17/15
SQL Column:  ACTION
Java Field:  action
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Authorization action code.
Added On:  08/17/15
SQL Column:  AUTO_DEPOSIT
Java Field:  autoDeposit
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Identifies that capture takes place immediately (a sale in one transaction). If not specified, it will be set to sale-auth.
True in case of SMS, false in case of DMS. If this element is not included in XML, by default its value is set to “true”.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_ADDRESS
Java Field:  billingAddressAddress
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Address where bill or invoice would be sent.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_CITY
Java Field:  billingAddressCity
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
City associated with the billing address.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_COUNTRY
Java Field:  billingAddressCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code associated with the billing address.
Country in ISO 3166-1 alpha 3 format.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_EMAIL
Java Field:  billingAddressEmail
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Email address associated with the billing address.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_NAME
Java Field:  billingAddressName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Name of a person who will receive bill or invoice.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_PHONE
Java Field:  billingAddressPhone
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Phone number associated with the billing address.
Added On:  08/17/15
SQL Column:  BILLING_ADDRESS_POST_INDEX
Java Field:  billingAddressPostIndex
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
ZIP (or postal code) associated with the billing address.
Added On:  08/17/15
SQL Column:  
Java Field:  cardCsc
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The CSC code of the card.
Added On:  08/17/15
SQL Column:  
Java Field:  cardExpiry
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The expiry date of the card.
Added On:  08/17/15
SQL Column:  CARD_NAME
Java Field:  cardName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Should be included only in case a cardholder wants to use credit card data from previously registered token. On payment form cardholder would have to confirm the masked credit card data instead of entering it manually.
Added On:  08/17/15
SQL Column:  
Java Field:  cardNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Credit card or bank account number.
Added On:  08/17/15
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:  08/17/15
SQL Column:  DEPOSIT_AMOUNT
Java Field:  depositAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount that would be transferred to merchant’s account. Hold from remaining funds would be removed immediately. Deposit amount should be smaller than payment amount and larger than 0, written in minor currency units. In case it is not included in XML, full payment amount would be transferred.
Added On:  08/17/15
SQL Column:  DESCRIPTOR
Java Field:  descriptor
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Dynamic descriptor appearing on cardholder’s credit card statement for the transaction. Is allowed to be included in XML only when dynamic descriptor feature is enabled.
Added On:  08/17/15
SQL Column:  ERROR_CODE
Java Field:  errorCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
A code that identifies encountered system error.
Added On:  08/17/15
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Description of encountered error, e.g. incorrect data, encryption/decryption error.
Added On:  08/17/15
SQL Column:  GATEWAY_KEY
Java Field:  gatewayKey
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the gateway key file.
Added On:  08/17/15
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:  08/17/15
SQL Column:  KEY_INDEX
Java Field:  keyIndex
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Index of merchant’s RSA public key used for data encryption of the payment in progress.
Added On:  08/17/15
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:  08/17/15
SQL Column:  MERCHANT_INTERFACE
Java Field:  merchantInterface
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
A unique code provided by LPB system to a merchant for identification purpose.
Added On:  08/17/15
SQL Column:  MERCHANT_KEY
Java Field:  merchantKey
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the merchant key file.
Added On:  08/17/15
SQL Column:  MODE
Java Field:  mode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of payment processing mode.
Added On:  08/17/15
SQL Column:  ORDER_AMOUNT
Java Field:  orderAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Payment amount in minor currency units.
Added On:  08/17/15
SQL Column:  ORDER_CURRENCY
Java Field:  orderCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Order payment currency.
Added On:  08/17/15
SQL Column:  ORDER_DESCRIPTION
Java Field:  orderDescription
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Order description that will be shown on Payment Form.
Added On:  08/17/15
SQL Column:  ORDER_ID
Java Field:  orderId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Unique code for order identification.
Added On:  08/26/15
SQL Column:  
Java Field:  paRes
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Cardholder’s authentication request.
Added On:  08/17/15
SQL Column:  PAYMENT_ID
Java Field:  paymentId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Identification number of the payment.
Added On:  08/17/15
SQL Column:  REMOTE_ADDRESS
Java Field:  remoteAddress
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
IPv4 address (dotted-decimal notation).
Added On:  08/26/15
SQL Column:  
Java Field:  responseAcsPaReq
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Response for payment authentication request. Returns after the first enrollment with response ACS URL.
Added On:  08/26/15
SQL Column:  
Java Field:  responseAcsPaRes
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Response for a payment authentication response received from cardholder’s card issuer ACS.
Added On:  08/26/15
SQL Column:  
Java Field:  responseAcsUrl
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Cardholder’s card issuer bank’s ACS web address where cardholder was sent for 3D Secure authentication.
Added On:  08/17/15
SQL Column:  RESPONSE_ACTION_CODE
Java Field:  responseActionCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Response authorization action code, ISO 8583 field 39.
Added On:  08/17/15
SQL Column:  RESPONSE_APPROVAL_CODE
Java Field:  responseApprovalCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Response approval code, ISO 8583 field 38.
Added On:  08/25/15
SQL Column:  RESPONSE_CAVV
Java Field:  responseCavv
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Cardholder’s authentication verification value retrieved in response to a request.
Added On:  08/17/15
SQL Column:  RESPONSE_DESCRIPTION
Java Field:  responseDescription
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
A response containing order description.
Added On:  08/25/15
SQL Column:  RESPONSE_ECI
Java Field:  responseEci
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Electronic commerce indicator response.
Added On:  08/25/15
SQL Column:  RESPONSE_ENROLLED
Java Field:  responseEnrolled
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Status on whether cardholder’s credit card is enrolled in 3D Secure or not, retrieved in response to a request.
Added On:  08/25/15
SQL Column:  RESPONSE_MESSAGE_ID
Java Field:  responseMessageId
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Response message identification number.
Added On:  08/17/15
SQL Column:  RESPONSE_PAYMENT_ID
Java Field:  responsePaymentId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Unique code for payment identification retrieved in response to a request.
Added On:  08/17/15
SQL Column:  RESPONSE_PAYMENT_LAST_DATE
Java Field:  responsePaymentLastDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Date and time (in EET – Eastern European Time) when payment was last updated, retrieved in response to a request.
Added On:  08/17/15
SQL Column:  RESPONSE_PAYMENT_START_DATE
Java Field:  responsePaymentStartDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Date and time (in EET – Eastern European Time) when payment was initiated, retrieved in response to a request.
Added On:  08/17/15
SQL Column:  RESPONSE_PAYMENT_STATE
Java Field:  responsePaymentState
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Number of payment processing state that payment is currently in, retrieved in response to a request.
Added On:  08/25/15
SQL Column:  RESPONSE_STATUS
Java Field:  responseStatus
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Status on whether cardholder passed 3D Secure authentication, retrieved in response to a request.
Added On:  08/25/15
SQL Column:  RESPONSE_TRANSACTION_DATE
Java Field:  responseTransactionDate
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Transaction date retrieved in response to a request.
Added On:  08/25/15
SQL Column:  RESPONSE_XID
Java Field:  responseXid
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Transaction identification number retrieved in response to a request.
Added On:  08/17/15
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:  08/17/15
SQL Column:  REVERSAL_AMOUNT
Java Field:  reversalAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Identifies amount that would be returned to cardholder’s account. Reversal amount should be less than payment amount and more than 0, written in minor currency units. If it is not included, full payment amount would be returned. Can be included in XML if payment is in payment processing state Deposited or Processed.