Mpgs Auth Retail Transaction UML

Added On:  08/26/21 

SQL Table:  MPGS_AUTH_RETAIL_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  MpgsAuthRetailTransaction 

Available Fields:

• Api Operation
• Api Password
• Api Username
• Authentication 3ds 1pa Res Status
• Authentication 3ds 1ve Res Enrolled
• Authentication 3ds 2protocol Version
• Authentication 3ds 2status Reason Code
• Authentication 3ds 2transaction Status
• Authentication 3ds Acs Eci
• Authentication 3ds Authentication Token
• Authentication 3ds Transaction Id
• Authentication Transaction Id
• Available Balance Funds Amount
• Available Balance Funds Currency
• Billing Address City
• Billing Address Country
• Billing Address Postcode Zip
• Billing Address State Province Code
• Billing Address Street
• Billing Address Street 2
• Browser Payment Redirect Url
• Charge Transaction
• Customer Email
• Customer First Name
• Customer Last Name
• Customer Phone
• Customer Tax Registration Id
• Error Cause
• Error Explanation
• Error Field
• Error Support Code
• Error Validation Type
• Id
• Merchant
• Merchant Account Code
• Order Accept Partial Amount
• Order Amount

• Order Cashback Amount
• Order Currency
• Order Customer Reference
• Order Description
• Order Id
• Order Reference
• Order Statement Descriptor Address City
• Order Statement Descriptor Address Company
• Order Statement Descriptor Address Country
• Order Statement Descriptor Address Postcode Zip
• Order Statement Descriptor Address State Province
• Order Statement Descriptor Address Street
• Order Statement Descriptor Address Street 2
• Order Statement Descriptor Name
• Order Statement Descriptor Phone
• Order Sub Merchant Address City
• Order Sub Merchant Address Company
• Order Sub Merchant Address Country
• Order Sub Merchant Address Postcode Zip
• Order Sub Merchant Address State Province
• Order Sub Merchant Address Street
• Order Sub Merchant Address Street 2
• Order Sub Merchant Bank Industry Code
• Order Sub Merchant Email
• Order Sub Merchant Identifier
• Order Sub Merchant Phone
• Order Sub Merchant Registered Name
• Order Sub Merchant Trading Name
• Order Wallet Provider
• Response Acquirer Code
• Response Acquirer Message
• Response Avs Acquirer Code
• Response Avs Gateway Code
• Response Card Security Code Acquirer Code
• Response Card Security Code Gateway Code
• Response Gateway Code
• Response Order Amount

• Response Order Cashback Amount
• Response Order Creation Time
• Response Order Status
• Response Order Total Authorized Amount
• Response Order Total Captured Amount
• Response Order Total Refunded Amount
• Response Transaction Amount
• Response Transaction Authorization Code
• Response Transaction Receipt
• Response Transaction Type
• Result
• Retail Transaction Cycle
• Shipping Address City
• Shipping Address Country
• Shipping Address Postcode Zip
• Shipping Address State Province Code
• Shipping Address Street
• Shipping Contact First Name
• Shipping Contact Last Name
• Shipping Origin Postcode Zip
• Source Card Device Payment 3 D Secure Eci Indicator
• Source Card Device Payment 3 D Secure Online Payment Cryptogram
• Source Card Device Payment Cryptogram Format
• Source Card Device Payment Payment Token
• Source Card Expiry Month
• Source Card Expiry Year
• Source Card Name On Card
• Source Card Number
• Source Card Security Code
• Source Card Stored On File
• Source Card Track 1
• Source Card Track 2
• Source Type
• Target Transaction Id
• Transaction Amount
• Transaction Currency
• Transaction Id

• Transaction Source

Api Operation

Added On:  08/26/21

SQL Column:  API_OPERATION

Java Field:  apiOperation

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Api Password

Added On:  08/26/21

SQL Column:  API_PASSWORD

Java Field:  apiPassword

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Api Username

Added On:  08/26/21

SQL Column:  API_USERNAME

Java Field:  apiUsername

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Authentication 3ds 1pa Res Status

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS1PA_RES_STATUS

Java Field:  authentication3ds1paResStatus

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Authentication 3ds 1ve Res Enrolled

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS1VE_RES_ENROLLED

Java Field:  authentication3ds1veResEnrolled

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Authentication 3ds 2protocol Version

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS2PROTOCOL_VERSION

Java Field:  authentication3ds2protocolVersion

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Authentication 3ds 2status Reason Code

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS2STATUS_REASON_CODE

Java Field:  authentication3ds2statusReasonCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Authentication 3ds 2transaction Status

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS2TRANSACTION_STATUS

Java Field:  authentication3ds2transactionStatus

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Authentication 3ds Acs Eci

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS_ACS_ECI

Java Field:  authentication3dsAcsEci

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Authentication 3ds Authentication Token

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS_AUTHENTICATION_TOKEN

Java Field:  authentication3dsAuthenticationToken

Status:  Active

SQL Type:  varchar(32)

Java Type:  String

Attributes:

Authentication 3ds Transaction Id

Added On:  08/26/21

SQL Column:  AUTHENTICATION3DS_TRANSACTION_ID

Java Field:  authentication3dsTransactionId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Authentication Transaction Id

Added On:  08/26/21

SQL Column:  AUTHENTICATION_TRANSACTION_ID

Java Field:  authenticationTransactionId

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Available Balance Funds Amount

Added On:  08/26/21

SQL Column:  AVAILABLE_BALANCE_FUNDS_AMOUNT

Java Field:  availableBalanceFundsAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Available Balance Funds Currency

Added On:  08/26/21

SQL Column:  AVAILABLE_BALANCE_FUNDS_CURRENCY

Java Field:  availableBalanceFundsCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Billing Address City

Added On:  08/26/21

SQL Column:  BILLING_ADDRESS_CITY

Java Field:  billingAddressCity

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Billing Address Country

Added On:  08/26/21

SQL Column:  BILLING_ADDRESS_COUNTRY

Java Field:  billingAddressCountry

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Billing Address Postcode Zip

Added On:  08/26/21

SQL Column:  BILLING_ADDRESS_POSTCODE_ZIP

Java Field:  billingAddressPostcodeZip

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Billing Address State Province Code

Added On:  08/26/21

SQL Column:  BILLING_ADDRESS_STATE_PROVINCE_CODE

Java Field:  billingAddressStateProvinceCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Billing Address Street

Added On:  08/26/21

SQL Column:  BILLING_ADDRESS_STREET

Java Field:  billingAddressStreet

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Billing Address Street 2

Added On:  08/26/21

SQL Column:  BILLING_ADDRESS_STREET2

Java Field:  billingAddressStreet2

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Browser Payment Redirect Url

Added On:  08/26/21

SQL Column:  BROWSER_PAYMENT_REDIRECT_URL

Java Field:  browserPaymentRedirectUrl

Status:  Active

SQL Type:  varchar(1024)

Java Type:  String

Attributes:

Charge Transaction

Added On:  08/26/21

SQL Column:  CHARGE_TRANSACTION_FK

Java Field:  chargeTransaction

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Charge Transaction

Attributes:

Customer Email

Added On:  08/26/21

SQL Column:  CUSTOMER_EMAIL

Java Field:  customerEmail

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Customer First Name

Added On:  08/26/21

SQL Column:  CUSTOMER_FIRST_NAME

Java Field:  customerFirstName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Customer Last Name

Added On:  08/26/21

SQL Column:  CUSTOMER_LAST_NAME

Java Field:  customerLastName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Customer Phone

Added On:  08/26/21

SQL Column:  CUSTOMER_PHONE

Java Field:  customerPhone

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Customer Tax Registration Id

Added On:  08/26/21

SQL Column:  CUSTOMER_TAX_REGISTRATION_ID

Java Field:  customerTaxRegistrationId

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Error Cause

Added On:  08/26/21

SQL Column:  ERROR_CAUSE

Java Field:  errorCause

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Error Explanation

Added On:  08/26/21

SQL Column:  ERROR_EXPLANATION

Java Field:  errorExplanation

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Error Field

Added On:  08/26/21

SQL Column:  ERROR_FIELD

Java Field:  errorField

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Error Support Code

Added On:  08/26/21

SQL Column:  ERROR_SUPPORT_CODE

Java Field:  errorSupportCode

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Error Validation Type

Added On:  08/26/21

SQL Column:  ERROR_VALIDATION_TYPE

Java Field:  errorValidationType

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Id

Added On:  08/26/21

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Merchant

Added On:  08/26/21

SQL Column:  MERCHANT

Java Field:  merchant

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Merchant Account Code

Added On:  08/26/21

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Order Accept Partial Amount

Added On:  08/26/21

SQL Column:  ORDER_ACCEPT_PARTIAL_AMOUNT

Java Field:  orderAcceptPartialAmount

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Order Amount

Added On:  08/26/21

SQL Column:  ORDER_AMOUNT

Java Field:  orderAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Order Cashback Amount

Added On:  08/26/21

SQL Column:  ORDER_CASHBACK_AMOUNT

Java Field:  orderCashbackAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Order Currency

Added On:  08/26/21

SQL Column:  ORDER_CURRENCY

Java Field:  orderCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Order Customer Reference

Added On:  08/26/21

SQL Column:  ORDER_CUSTOMER_REFERENCE

Java Field:  orderCustomerReference

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Order Description

Added On:  08/26/21

SQL Column:  ORDER_DESCRIPTION

Java Field:  orderDescription

Status:  Active

SQL Type:  varchar(127)

Java Type:  String

Attributes:

Order Id

Added On:  08/26/21

SQL Column:  ORDER_ID

Java Field:  orderId

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Order Reference

Added On:  08/26/21

SQL Column:  ORDER_REFERENCE

Java Field:  orderReference

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Order Statement Descriptor Address City

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_CITY

Java Field:  orderStatementDescriptorAddressCity

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Statement Descriptor Address Company

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_COMPANY

Java Field:  orderStatementDescriptorAddressCompany

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Statement Descriptor Address Country

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_COUNTRY

Java Field:  orderStatementDescriptorAddressCountry

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Order Statement Descriptor Address Postcode Zip

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_POSTCODE_ZIP

Java Field:  orderStatementDescriptorAddressPostcodeZip

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Order Statement Descriptor Address State Province

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_STATE_PROVINCE

Java Field:  orderStatementDescriptorAddressStateProvince

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Order Statement Descriptor Address Street

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_STREET

Java Field:  orderStatementDescriptorAddressStreet

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Statement Descriptor Address Street 2

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_ADDRESS_STREET2

Java Field:  orderStatementDescriptorAddressStreet2

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Statement Descriptor Name

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_NAME

Java Field:  orderStatementDescriptorName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Statement Descriptor Phone

Added On:  08/26/21

SQL Column:  ORDER_STATEMENT_DESCRIPTOR_PHONE

Java Field:  orderStatementDescriptorPhone

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Order Sub Merchant Address City

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_CITY

Java Field:  orderSubMerchantAddressCity

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Address Company

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_COMPANY

Java Field:  orderSubMerchantAddressCompany

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Address Country

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_COUNTRY

Java Field:  orderSubMerchantAddressCountry

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Order Sub Merchant Address Postcode Zip

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_POSTCODE_ZIP

Java Field:  orderSubMerchantAddressPostcodeZip

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Order Sub Merchant Address State Province

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_STATE_PROVINCE

Java Field:  orderSubMerchantAddressStateProvince

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Order Sub Merchant Address Street

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_STREET

Java Field:  orderSubMerchantAddressStreet

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Address Street 2

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_ADDRESS_STREET2

Java Field:  orderSubMerchantAddressStreet2

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Bank Industry Code

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_BANK_INDUSTRY_CODE

Java Field:  orderSubMerchantBankIndustryCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Order Sub Merchant Email

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_EMAIL

Java Field:  orderSubMerchantEmail

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Identifier

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_IDENTIFIER

Java Field:  orderSubMerchantIdentifier

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Phone

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_PHONE

Java Field:  orderSubMerchantPhone

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Order Sub Merchant Registered Name

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_REGISTERED_NAME

Java Field:  orderSubMerchantRegisteredName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Sub Merchant Trading Name

Added On:  08/26/21

SQL Column:  ORDER_SUB_MERCHANT_TRADING_NAME

Java Field:  orderSubMerchantTradingName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Order Wallet Provider

Added On:  07/18/23

SQL Column:  ORDER_WALLET_PROVIDER

Java Field:  orderWalletProvider

Status:  Active

SQL Type:  varchar(21)

Java Type:  String

Attributes:

Response Acquirer Code

Added On:  08/26/21

SQL Column:  RESPONSE_ACQUIRER_CODE

Java Field:  responseAcquirerCode

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Response Acquirer Message

Added On:  08/26/21

SQL Column:  RESPONSE_ACQUIRER_MESSAGE

Java Field:  responseAcquirerMessage

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Response Avs Acquirer Code

Added On:  08/26/21

SQL Column:  RESPONSE_AVS_ACQUIRER_CODE

Java Field:  responseAvsAcquirerCode

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Response Avs Gateway Code

Added On:  08/26/21

SQL Column:  RESPONSE_AVS_GATEWAY_CODE

Java Field:  responseAvsGatewayCode

Status:  Active

SQL Type:  varchar(27)

Java Type:  String

Attributes:

Response Card Security Code Acquirer Code

Added On:  08/26/21

SQL Column:  RESPONSE_CARD_SECURITY_CODE_ACQUIRER_CODE

Java Field:  responseCardSecurityCodeAcquirerCode

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Response Card Security Code Gateway Code

Added On:  08/26/21

SQL Column:  RESPONSE_CARD_SECURITY_CODE_GATEWAY_CODE

Java Field:  responseCardSecurityCodeGatewayCode

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Response Gateway Code

Added On:  08/26/21

SQL Column:  RESPONSE_GATEWAY_CODE

Java Field:  responseGatewayCode

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Response Order Amount

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_AMOUNT

Java Field:  responseOrderAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Response Order Cashback Amount

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_CASHBACK_AMOUNT

Java Field:  responseOrderCashbackAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Response Order Creation Time

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_CREATION_TIME

Java Field:  responseOrderCreationTime

Status:  Active

SQL Type:  varchar(24)

Java Type:  String

Attributes:

Response Order Status

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_STATUS

Java Field:  responseOrderStatus

Status:  Active

SQL Type:  varchar(27)

Java Type:  String

Attributes:

Response Order Total Authorized Amount

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_TOTAL_AUTHORIZED_AMOUNT

Java Field:  responseOrderTotalAuthorizedAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Response Order Total Captured Amount

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_TOTAL_CAPTURED_AMOUNT

Java Field:  responseOrderTotalCapturedAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Response Order Total Refunded Amount

Added On:  08/26/21

SQL Column:  RESPONSE_ORDER_TOTAL_REFUNDED_AMOUNT

Java Field:  responseOrderTotalRefundedAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Response Transaction Amount

Added On:  08/26/21

SQL Column:  RESPONSE_TRANSACTION_AMOUNT

Java Field:  responseTransactionAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Response Transaction Authorization Code

Added On:  08/26/21

SQL Column:  RESPONSE_TRANSACTION_AUTHORIZATION_CODE

Java Field:  responseTransactionAuthorizationCode

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Response Transaction Receipt

Added On:  09/25/23

SQL Column:  RESPONSE_TRANSACTION_RECEIPT

Java Field:  responseTransactionReceipt

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Response Transaction Type

Added On:  08/26/21

SQL Column:  RESPONSE_TRANSACTION_TYPE

Java Field:  responseTransactionType

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Result

Added On:  08/26/21

SQL Column:  RESULT

Java Field:  result

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Retail Transaction Cycle

Added On:  08/26/21

SQL Column:  RETAIL_TRANSACTION_CYCLE_FK

Java Field:  retailTransactionCycle

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Retail Transaction Cycle

Attributes:

Shipping Address City

Added On:  08/26/21

SQL Column:  SHIPPING_ADDRESS_CITY

Java Field:  shippingAddressCity

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Shipping Address Country

Added On:  08/26/21

SQL Column:  SHIPPING_ADDRESS_COUNTRY

Java Field:  shippingAddressCountry

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Shipping Address Postcode Zip

Added On:  08/26/21

SQL Column:  SHIPPING_ADDRESS_POSTCODE_ZIP

Java Field:  shippingAddressPostcodeZip

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Shipping Address State Province Code

Added On:  08/26/21

SQL Column:  SHIPPING_ADDRESS_STATE_PROVINCE_CODE

Java Field:  shippingAddressStateProvinceCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Shipping Address Street

Added On:  08/26/21

SQL Column:  SHIPPING_ADDRESS_STREET

Java Field:  shippingAddressStreet

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Shipping Contact First Name

Added On:  08/26/21

SQL Column:  SHIPPING_CONTACT_FIRST_NAME

Java Field:  shippingContactFirstName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Shipping Contact Last Name

Added On:  08/26/21

SQL Column:  SHIPPING_CONTACT_LAST_NAME

Java Field:  shippingContactLastName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Shipping Origin Postcode Zip

Added On:  08/26/21

SQL Column:  SHIPPING_ORIGIN_POSTCODE_ZIP

Java Field:  shippingOriginPostcodeZip

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Source Card Device Payment 3 D Secure Eci Indicator

Added On:  08/26/21

SQL Column:  SOURCE_CARD_DEVICE_PAYMENT3_DSECURE_ECI_INDICATOR

Java Field:  sourceCardDevicePayment3DSecureEciIndicator

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Source Card Device Payment 3 D Secure Online Payment Cryptogram

Added On:  08/26/21

SQL Column:  SOURCE_CARD_DEVICE_PAYMENT3_D_SECURE_ONLINE_PAYMENT_CRYPTOGRAM

Java Field:  sourceCardDevicePayment3DSecureOnlinePaymentCryptogram

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Device Payment Cryptogram Format

Added On:  08/26/21

SQL Column:  SOURCE_CARD_DEVICE_PAYMENT_CRYPTOGRAM_FORMAT

Java Field:  sourceCardDevicePaymentCryptogramFormat

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Source Card Device Payment Payment Token

Added On:  08/26/21

SQL Column:  SOURCE_CARD_DEVICE_PAYMENT_PAYMENT_TOKEN

Java Field:  sourceCardDevicePaymentPaymentToken

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Expiry Month

Added On:  08/26/21

SQL Column:  SOURCE_CARD_EXPIRY_MONTH

Java Field:  sourceCardExpiryMonth

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Expiry Year

Added On:  08/26/21

SQL Column:  SOURCE_CARD_EXPIRY_YEAR

Java Field:  sourceCardExpiryYear

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Name On Card

Added On:  08/26/21

SQL Column:  SOURCE_CARD_NAME_ON_CARD

Java Field:  sourceCardNameOnCard

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Number

Added On:  08/26/21

SQL Column:  SOURCE_CARD_NUMBER

Java Field:  sourceCardNumber

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Security Code

Added On:  08/26/21

SQL Column:  SOURCE_CARD_SECURITY_CODE

Java Field:  sourceCardSecurityCode

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Stored On File

Added On:  08/26/21

SQL Column:  SOURCE_CARD_STORED_ON_FILE

Java Field:  sourceCardStoredOnFile

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Source Card Track 1

Added On:  08/26/21

SQL Column:  SOURCE_CARD_TRACK1

Java Field:  sourceCardTrack1

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Card Track 2

Added On:  08/26/21

SQL Column:  SOURCE_CARD_TRACK2

Java Field:  sourceCardTrack2

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Source Type

Added On:  08/26/21

SQL Column:  SOURCE_TYPE

Java Field:  sourceType

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Target Transaction Id

Added On:  08/26/21

SQL Column:  TARGET_TRANSACTION_ID

Java Field:  targetTransactionId

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Transaction Amount

Added On:  08/26/21

SQL Column:  TRANSACTION_AMOUNT

Java Field:  transactionAmount

Status:  Active

SQL Type:  varchar(14)

Java Type:  String

Attributes:

Transaction Currency

Added On:  08/26/21

SQL Column:  TRANSACTION_CURRENCY

Java Field:  transactionCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Transaction Id

Added On:  08/26/21

SQL Column:  TRANSACTION_ID

Java Field:  transactionId

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Transaction Source

Added On:  07/18/23

SQL Column:  TRANSACTION_SOURCE

Java Field:  transactionSource

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes: