Sedra Fraud Transaction UML

Added On: 11/27/23

SQL Table: SEDRA_FRAUD_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: SedraFraudTransaction

Available Fields:

Card Number
Charge Transaction
Http Host
Id
Merchant Account Code
Password
Receiver Account Reference Number

Receiver Customer Reference Number
Response Reason Of Rejection
Response Request Id
Response Request Status
Response Request Status Description
Response Trnx Id
System Name

Token
Transaction Amount
Transaction Country Code
Transaction Currency Code
Transaction Date
Transaction Id
User Name

Card Number

Added On: 11/27/23

SQL Column: CARD_NUMBER

Java Field: cardNumber

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Charge Transaction

Added On: 11/27/23

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Http Host

Added On: 11/27/23

SQL Column: HTTP_HOST

Java Field: httpHost

Status: Active

SQL Type: varchar(160)

Java Type: String

Attributes: Transient

Added On: 11/27/23

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.

Merchant Account Code

Added On: 11/27/23

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.\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.

Password

Added On: 11/27/23

SQL Column: PASSWORD

Java Field: password

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes: Transient

Receiver Account Reference Number

Added On: 11/27/23

SQL Column: RECEIVER_ACCOUNT_REFERENCE_NUMBER

Java Field: receiverAccountReferenceNumber

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Receiver Customer Reference Number

Added On: 11/27/23

SQL Column: RECEIVER_CUSTOMER_REFERENCE_NUMBER

Java Field: receiverCustomerReferenceNumber

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Response Reason Of Rejection

Added On: 11/27/23

SQL Column: RESPONSE_REASON_OF_REJECTION

Java Field: responseReasonOfRejection

Status: Active

SQL Type: varchar(125)

Java Type: String

Attributes:

Response Request Id

Added On: 11/27/23

SQL Column: RESPONSE_REQUEST_ID

Java Field: responseRequestId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Response Request Status

Added On: 11/27/23

SQL Column: RESPONSE_REQUEST_STATUS

Java Field: responseRequestStatus

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Response Request Status Description

Added On: 11/27/23

SQL Column: RESPONSE_REQUEST_STATUS_DESCRIPTION

Java Field: responseRequestStatusDescription

Status: Active

SQL Type: varchar(125)

Java Type: String

Attributes:

Response Trnx Id

Added On: 11/27/23

SQL Column: RESPONSE_TRNX_ID

Java Field: responseTrnxId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

System Name

Added On: 11/27/23

SQL Column: SYSTEM_NAME

Java Field: systemName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Token

Added On: 11/27/23

SQL Column: TOKEN

Java Field: token

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes: Transient

Transaction Amount

Added On: 11/27/23

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Transaction Country Code

Added On: 11/27/23

SQL Column: TRANSACTION_COUNTRY_CODE

Java Field: transactionCountryCode

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Transaction Currency Code

Added On: 11/27/23

SQL Column: TRANSACTION_CURRENCY_CODE

Java Field: transactionCurrencyCode

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Transaction Date

Added On: 11/27/23

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Transaction Id

Added On: 11/27/23

SQL Column: TRANSACTION_ID

Java Field: transactionId

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

User Name

Added On: 11/27/23

SQL Column: USER_NAME

Java Field: userName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes: Transient