Notification Transaction UML

Added On:  12/16/19 

SQL Table:  NOTIFICATION_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  NotificationTransaction 

Available Fields:

• Attempt Count
• Cc Email
• Context
• Context Object Code
• Context Object Name
• Context Object Ref Code
• Create Date
• Due Date
• Email Template
• Exception Event Id
• From Email

• Id
• Job Message Fk
• Locale Cl
• Medium Cl
• Merchant Account Code
• Notification Code
• Notification Transaction Content
• Notification Webhook Fk
• Object Alias
• Owner Cl
• Owner Code

• Phone
• Portfolio Code
• Processed Date
• Reply To Email
• Report Key
• Reseller Code
• Response Message
• Retail Transaction Cycle
• Status Cl
• Subject Content
• Template Code

• To Email

Attempt Count

Added On:  10/06/22

SQL Column:  ATTEMPT_COUNT

Java Field:  attemptCount

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Number of times notification delivery was attempted.

Cc Email

Added On:  12/16/19

SQL Column:  CC_EMAIL

Java Field:  ccEmail

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Context

Added On:  12/16/19

SQL Column:  CONTEXT

Java Field:  context

Status:  Active

SQL Type:  longblob

Java Type:  Object

Attributes: Transient

Context Object Code

Added On:  12/16/19

SQL Column:  CONTEXT_OBJECT_CODE

Java Field:  contextObjectCode

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Context Object Name

Added On:  12/16/19

SQL Column:  CONTEXT_OBJECT_NAME

Java Field:  contextObjectName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Context Object Ref Code

Added On:  10/04/23

SQL Column:  CONTEXT_OBJECT_REF_CODE

Java Field:  contextObjectRefCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Create Date

Added On:  12/16/19

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Due Date

Added On:  10/06/22

SQL Column:  DUE_DATE

Java Field:  dueDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Date when the notification is expected to be sent.

Email Template

Added On:  12/16/19

SQL Column:  EMAIL_TEMPLATE_FK

Java Field:  emailTemplate

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Email Template

Attributes:

Exception Event Id

Added On:  10/06/22

SQL Column:  EXCEPTION_EVENT_ID

Java Field:  exceptionEventId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

From Email

Added On:  12/16/19

SQL Column:  FROM_EMAIL

Java Field:  fromEmail

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Id

Added On:  12/16/19

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes:

Job Message Fk

Added On:  04/10/24

SQL Column:  JOB_MESSAGE_FK

Java Field:  jobMessage

Status:  Active

SQL Type:  bigint(20)

Java Type:  Object

References Job Message

Attributes:

Locale Cl

Added On:  12/16/19

SQL Column:  LOCALE_CL

Java Field:  localeCl

Status:  Active

SQL Type:  varchar(5)

Java Type:  Object

References Locale Classifier

Attributes:

Medium Cl

Added On:  03/10/22

SQL Column:  MEDIUM_CL

Java Field:  mediumCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Medium Classifier

Attributes:

Merchant Account Code

Added On:  12/16/19

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Notification Code

Added On:  12/16/19

SQL Column:  NOTIFICATION_CODE

Java Field:  notificationCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Notification Transaction Content

Added On:  12/16/19

SQL Column:  NOTIFICATION_TRANSACTION_CONTENT_FK

Java Field:  notificationTransactionContent

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Notification Transaction Content

Attributes:

Notification Webhook Fk

Added On:  10/06/22

SQL Column:  NOTIFICATION_WEBHOOK_FK

Java Field:  notificationWebhook

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Notification Webhook

Attributes:

Reference to Webhook receiving the notification.

Object Alias

Added On:  12/16/19

SQL Column:  OBJECT_ALIAS

Java Field:  objectAlias

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Owner Cl

Added On:  12/16/19

SQL Column:  OWNER_CL

Java Field:  ownerCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  Object

References User Classifier

Attributes:

Owner Code

Added On:  12/16/19

SQL Column:  OWNER_CODE

Java Field:  ownerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Phone

Added On:  03/10/22

SQL Column:  PHONE

Java Field:  phone

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Portfolio Code

Added On:  12/16/19

SQL Column:  PORTFOLIO_CODE

Java Field:  portfolioCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Processed Date

Added On:  12/16/19

SQL Column:  PROCESSED_DATE

Java Field:  processedDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Reply To Email

Added On:  11/25/22

SQL Column:  REPLY_TO_EMAIL

Java Field:  replyToEmail

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Report Key

Added On:  12/16/19

SQL Column:  REPORT_KEY

Java Field:  reportKey

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Reseller Code

Added On:  12/16/19

SQL Column:  RESELLER_CODE

Java Field:  resellerCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Response Message

Added On:  12/16/19

SQL Column:  RESPONSE_MESSAGE

Java Field:  responseMessage

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

Retail Transaction Cycle

Added On:  03/10/22

SQL Column:  RETAIL_TRANSACTION_CYCLE_FK

Java Field:  retailTransactionCycle

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Retail Transaction Cycle

Attributes:

Status Cl

Added On:  12/16/19

SQL Column:  STATUS_CL

Java Field:  statusCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  Object

References Notification Status Classifier

Attributes:

Subject Content

Added On:  12/16/19

SQL Column:  SUBJECT_CONTENT

Java Field:  subjectContent

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Template Code

Added On:  12/16/19

SQL Column:  TEMPLATE_CODE

Java Field:  templateCode

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

To Email

Added On:  12/16/19

SQL Column:  TO_EMAIL

Java Field:  toEmail

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes: