Paypal Auth Retail Transaction UML
Added On: 09/14/21
Module: UniCharge
Type: Entity
Status: Active
Java Class: PaypalAuthRetailTransaction
Added On: 09/14/21
SQL Column: AMOUNT_CURRENCY_CODE
Java Field: amountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: AMOUNT_VALUE
Java Field: amountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_AMOUNT_CURRENCY_CODE
Java Field: authorizationAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_AMOUNT_VALUE
Java Field: authorizationAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_AVS_CODE
Java Field: authorizationAvsCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_CREATE_TIME
Java Field: authorizationCreateTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_CUSTOM_ID
Java Field: authorizationCustomId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_CVV_CODE
Java Field: authorizationCvvCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_EXPIRATION_TIME
Java Field: authorizationExpirationTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_ID
Java Field: authorizationId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_INVOICE_ID
Java Field: authorizationInvoiceId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_PAYMENT_ADVICE_CODE
Java Field: authorizationPaymentAdviceCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_REASON
Java Field: authorizationReason
Status: Active
SQL Type: varchar(43)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_RESPONSE_CODE
Java Field: authorizationResponseCode
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_STATUS
Java Field: authorizationStatus
Status: Active
SQL Type: varchar(18)
Java Type: String
Added On: 09/14/21
SQL Column: AUTHORIZATION_UPDATE_TIME
Java Field: authorizationUpdateTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_AMOUNT_CURRENCY_CODE
Java Field: captureAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_AMOUNT_VALUE
Java Field: captureAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_AVS_CODE
Java Field: captureAvsCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_CREATE_TIME
Java Field: captureCreateTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_CUSTOM_ID
Java Field: captureCustomId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_CVV_CODE
Java Field: captureCvvCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_FINAL_CAPTURE
Java Field: captureFinalCapture
Status: Active
SQL Type: varchar(5)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_GROSS_AMOUNT_CURRENCY_CODE
Java Field: captureGrossAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_GROSS_AMOUNT_VALUE
Java Field: captureGrossAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_ID
Java Field: captureId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_INVOICE_ID
Java Field: captureInvoiceId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_NET_AMOUNT_CURRENCY_CODE
Java Field: captureNetAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_NET_AMOUNT_VALUE
Java Field: captureNetAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_PAYMENT_ADVICE_CODE
Java Field: capturePaymentAdviceCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_PAYPAL_FEE_CURRENCY_CODE
Java Field: capturePaypalFeeCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_PAYPAL_FEE_VALUE
Java Field: capturePaypalFeeValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_REASON
Java Field: captureReason
Status: Active
SQL Type: varchar(43)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_RESPONSE_CODE
Java Field: captureResponseCode
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_STATUS
Java Field: captureStatus
Status: Active
SQL Type: varchar(18)
Java Type: String
Added On: 09/14/21
SQL Column: CAPTURE_UPDATE_TIME
Java Field: captureUpdateTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: CHARGE_TRANSACTION_FK
Java Field: chargeTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Added On: 09/14/21
SQL Column: CREATE_TIME
Java Field: createTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR
Java Field: error
Status: Active
SQL Type: varchar(100)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR_DESCRIPTION
Java Field: errorDescription
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR_DETAIL_DESCRIPTION
Java Field: errorDetailDescription
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR_DETAIL_FIELD
Java Field: errorDetailField
Status: Active
SQL Type: varchar(100)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR_DETAIL_ISSUE
Java Field: errorDetailIssue
Status: Active
SQL Type: varchar(100)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR_DETAIL_LOCATION
Java Field: errorDetailLocation
Status: Active
SQL Type: varchar(100)
Java Type: String
Added On: 09/14/21
SQL Column: ERROR_DETAIL_VALUE
Java Field: errorDetailValue
Status: Active
SQL Type: varchar(100)
Java Type: String
Added On: 09/17/21
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: 09/14/21
SQL Column: INTENT
Java Field: intent
Status: Active
SQL Type: varchar(9)
Java Type: String
Added On: 09/14/21
SQL Column: INVOICE_ID
Java Field: invoiceId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/17/21
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.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe 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: 09/14/21
SQL Column: ORDER_ID
Java Field: orderId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: PATH_ACTION
Java Field: pathAction
Status: Active
SQL Type: varchar(9)
Java Type: String
Added On: 09/14/21
SQL Column: PATH_AUTHORIZATION_ID
Java Field: pathAuthorizationId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: PATH_CAPTURE_ID
Java Field: pathCaptureId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: PATH_ORDER_ID
Java Field: pathOrderId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: PATH_REFUND_ID
Java Field: pathRefundId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: PAYEE_EMAIL_ADDRESS
Java Field: payeeEmailAddress
Status: Active
SQL Type: varchar(254)
Java Type: String
Added On: 09/14/21
SQL Column: PAYEE_MERCHANT_ID
Java Field: payeeMerchantId
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ADDRESS_AREA1
Java Field: payerAddressArea1
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ADDRESS_AREA2
Java Field: payerAddressArea2
Status: Active
SQL Type: varchar(120)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ADDRESS_COUNTRY_CODE
Java Field: payerAddressCountryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ADDRESS_LINE1
Java Field: payerAddressLine1
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ADDRESS_LINE2
Java Field: payerAddressLine2
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ADDRESS_POSTAL_CODE
Java Field: payerAddressPostalCode
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_BIRTH_DATE
Java Field: payerBirthDate
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_EMAIL_ADDRESS
Java Field: payerEmailAddress
Status: Active
SQL Type: varchar(254)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_GIVEN_NAME
Java Field: payerGivenName
Status: Active
SQL Type: varchar(140)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_ID
Java Field: payerId
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_PHONE_NUMBER
Java Field: payerPhoneNumber
Status: Active
SQL Type: varchar(14)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_SURNAME
Java Field: payerSurname
Status: Active
SQL Type: varchar(140)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_TAX_ID
Java Field: payerTaxId
Status: Active
SQL Type: varchar(14)
Java Type: String
Added On: 09/14/21
SQL Column: PAYER_TAX_ID_TYPE
Java Field: payerTaxIdType
Status: Active
SQL Type: varchar(7)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BILLING_ADDRESS_AREA1
Java Field: paymentSourceCardBillingAddressArea1
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BILLING_ADDRESS_AREA2
Java Field: paymentSourceCardBillingAddressArea2
Status: Active
SQL Type: varchar(120)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BILLING_ADDRESS_COUNTRY_CODE
Java Field: paymentSourceCardBillingAddressCountryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BILLING_ADDRESS_LINE1
Java Field: paymentSourceCardBillingAddressLine1
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BILLING_ADDRESS_LINE2
Java Field: paymentSourceCardBillingAddressLine2
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BILLING_ADDRESS_POSTAL_CODE
Java Field: paymentSourceCardBillingAddressPostalCode
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_BRAND
Java Field: paymentSourceCardBrand
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_LAST_DIGITS
Java Field: paymentSourceCardLastDigits
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_NAME
Java Field: paymentSourceCardName
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: PAYMENT_SOURCE_CARD_TYPE
Java Field: paymentSourceCardType
Status: Active
SQL Type: varchar(7)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_AMOUNT_CURRENCY_CODE
Java Field: purchaseAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_AMOUNT_VALUE
Java Field: purchaseAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_CUSTOM_ID
Java Field: purchaseCustomId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_DESCRIPTION
Java Field: purchaseDescription
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_ID
Java Field: purchaseId
Status: Active
SQL Type: varchar(19)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_INVOICE_ID
Java Field: purchaseInvoiceId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: PURCHASE_SOFT_DESCRIPTOR
Java Field: purchaseSoftDescriptor
Status: Active
SQL Type: varchar(22)
Java Type: String
Added On: 09/14/21
SQL Column: REFERENCE_ID
Java Field: referenceId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_AMOUNT_CURRENCY_CODE
Java Field: refundAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_AMOUNT_VALUE
Java Field: refundAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_CREATE_TIME
Java Field: refundCreateTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_GROSS_AMOUNT_CURRENCY_CODE
Java Field: refundGrossAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_GROSS_AMOUNT_VALUE
Java Field: refundGrossAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_ID
Java Field: refundId
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_INVOICE_ID
Java Field: refundInvoiceId
Status: Active
SQL Type: varchar(127)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_NET_AMOUNT_CURRENCY_CODE
Java Field: refundNetAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_NET_AMOUNT_VALUE
Java Field: refundNetAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_NOTE_TO_PAYER
Java Field: refundNoteToPayer
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_PAYPAL_FEE_CURRENCY_CODE
Java Field: refundPaypalFeeCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_PAYPAL_FEE_VALUE
Java Field: refundPaypalFeeValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_REASON
Java Field: refundReason
Status: Active
SQL Type: varchar(43)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_STATUS
Java Field: refundStatus
Status: Active
SQL Type: varchar(18)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_TOTAL_REFUNDED_AMOUNT_CURRENCY_CODE
Java Field: refundTotalRefundedAmountCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_TOTAL_REFUNDED_AMOUNT_VALUE
Java Field: refundTotalRefundedAmountValue
Status: Active
SQL Type: varchar(32)
Java Type: String
Added On: 09/14/21
SQL Column: REFUND_UPDATE_TIME
Java Field: refundUpdateTime
Status: Active
SQL Type: varchar(64)
Java Type: String
Added On: 09/14/21
SQL Column: RETAIL_TRANSACTION_CYCLE_FK
Java Field: retailTransactionCycle
Status: Active
SQL Type: bigint(20)
Java Type: Long
Added On: 09/14/21
SQL Column: SHIPPING_ADDRESS_AREA1
Java Field: shippingAddressArea1
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: SHIPPING_ADDRESS_AREA2
Java Field: shippingAddressArea2
Status: Active
SQL Type: varchar(120)
Java Type: String
Added On: 09/14/21
SQL Column: SHIPPING_ADDRESS_COUNTRY_CODE
Java Field: shippingAddressCountryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 09/14/21
SQL Column: SHIPPING_ADDRESS_LINE1
Java Field: shippingAddressLine1
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: SHIPPING_ADDRESS_LINE2
Java Field: shippingAddressLine2
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: SHIPPING_ADDRESS_POSTAL_CODE
Java Field: shippingAddressPostalCode
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 09/14/21
SQL Column: SHIPPING_NAME
Java Field: shippingName
Status: Active
SQL Type: varchar(300)
Java Type: String
Added On: 09/14/21
SQL Column: SOFT_DESCRIPTOR
Java Field: softDescriptor
Status: Active
SQL Type: varchar(22)
Java Type: String
Added On: 09/14/21
SQL Column: STATUS
Java Field: status
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 09/14/21
SQL Column: UPDATE_TIME
Java Field: updateTime
Status: Active
SQL Type: varchar(64)
Java Type: String