Email Transaction UML

Added On: 01/25/17

SQL Table: EMAIL_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: EmailTransaction

Available Fields:

Attachment Code
Attachment Content Source CL
Balance Phase1
Balance Phase2
Balance Phase3
Balance Phase4
Bcc Email
Billing City
Billing Country Code
Billing State
Billing Street 1
Billing Street 2
Billing ZIP Code
CC Email
Create Date
Customer Account Balance
Customer Account Code
Customer Account Notes
External Reference Code
File Extention

First Billing Date
First Name
From Email
Id
Is Plain Message
Last Name
Late Fee Amount
Merchant Account Code
Merchant Account Name
Merchant Name
Message
Next Billing Date
Note
Payment Option Holder Name
Payment Option Number
Payment Option Type
Payment Plan Amount
Payment Plan Code
Payment Plan Item Description
Reply To Email

Response
Response Code
Retail Transaction Cycle FK
Return Fee Amount
Return Reason
Shipping City
Shipping Country Code
Shipping State
Shipping Street 1
Shipping Street 2
Shipping ZIP Code
Subject
Template Code
Terminal Order FK
To Email
Transaction Amount
Transaction Balance
Transaction Code
Transaction Date
Transaction Due Date

Transaction Type

Attachment Code

Added On: 01/25/17

SQL Column: ATTACHMENT_CODE

Java Field: attachmentCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Attachment Content Source CL

Added On: 01/25/17

SQL Column: ATTACHMENT_CONTENT_SOURCE_CL

Java Field: attachmentContentSourceCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Attachment Content Source Classifier

Attributes:

Balance Phase1

Added On: 01/25/17

SQL Column: BALANCE_PHASE1

Java Field: balancePhase1

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance Phase2

Added On: 01/25/17

SQL Column: BALANCE_PHASE2

Java Field: balancePhase2

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance Phase3

Added On: 01/25/17

SQL Column: BALANCE_PHASE3

Java Field: balancePhase3

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Balance Phase4

Added On: 01/25/17

SQL Column: BALANCE_PHASE4

Java Field: balancePhase4

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Bcc Email

Added On: 01/25/17

SQL Column: BCC_EMAIL

Java Field: bccEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Billing City

Added On: 01/25/17

SQL Column: BILLING_CITY

Java Field: billingCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Billing Country Code

Added On: 01/25/17

SQL Column: BILLING_COUNTRY_CODE

Java Field: billingCountryCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Billing State

Added On: 01/25/17

SQL Column: BILLING_STATE

Java Field: billingState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Billing Street 1

Added On: 01/25/17

SQL Column: BILLING_STREET1

Java Field: billingStreet1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Billing Street 2

Added On: 01/25/17

SQL Column: BILLING_STREET2

Java Field: billingStreet2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Billing ZIP Code

Added On: 01/25/17

SQL Column: BILLING_ZIP_CODE

Java Field: billingZipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

CC Email

Added On: 01/25/17

SQL Column: CC_EMAIL

Java Field: ccEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Create Date

Added On: 01/25/17

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Customer Account Balance

Added On: 01/25/17

SQL Column: CUSTOMER_ACCOUNT_BALANCE

Java Field: customerAccountBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Customer Account Code

Added On: 01/25/17

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Customer Account Notes

Added On: 01/25/17

SQL Column: CUSTOMER_ACCOUNT_NOTES

Java Field: customerAccountNotes

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

External Reference Code

Added On: 01/25/17

SQL Column: EXTERNAL_REFERENCE_CODE

Java Field: externalReferenceCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

File Extention

Added On: 01/25/17

SQL Column: FILE_EXTENTION

Java Field: fileExtention

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

First Billing Date

Added On: 01/25/17

SQL Column: FIRST_BILLING_DATE

Java Field: firstBillingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

First Name

Added On: 01/25/17

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

From Email

Added On: 01/25/17

SQL Column: FROM_EMAIL

Java Field: fromEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 01/25/17

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.

Is Plain Message

Added On: 01/25/17

SQL Column: IS_PLAIN_MESSAGE

Java Field: isPlainMessage

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Last Name

Added On: 01/25/17

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Late Fee Amount

Added On: 01/25/17

SQL Column: LATE_FEE_AMOUNT

Java Field: lateFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Merchant Account Code

Added On: 01/25/17

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.

Merchant Account Name

Added On: 01/25/17

SQL Column: MERCHANT_ACCOUNT_NAME

Java Field: merchantAccountName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Merchant Name

Added On: 01/25/17

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Message

Added On: 01/25/17

SQL Column: MESSAGE

Java Field: message

Status: Active

SQL Type: varchar(12288)

Java Type: String

Attributes:

Next Billing Date

Added On: 01/25/17

SQL Column: NEXT_BILLING_DATE

Java Field: nextBillingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Note

Added On: 01/25/17

SQL Column: NOTE

Java Field: note

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payment Option Holder Name

Added On: 01/25/17

SQL Column: PAYMENT_OPTION_HOLDER_NAME

Java Field: paymentOptionHolderName

Status: Active

SQL Type: varchar(160)

Java Type: String

Attributes:

Payment Option Number

Added On: 01/25/17

SQL Column: PAYMENT_OPTION_NUMBER

Java Field: paymentOptionNumber

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Payment Option Type

Added On: 01/25/17

SQL Column: PAYMENT_OPTION_TYPE

Java Field: paymentOptionType

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Payment Plan Amount

Added On: 01/25/17

SQL Column: PAYMENT_PLAN_AMOUNT

Java Field: paymentPlanAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Payment Plan Code

Added On: 01/25/17

SQL Column: PAYMENT_PLAN_CODE

Java Field: paymentPlanCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Payment Plan Item Description

Added On: 01/25/17

SQL Column: PAYMENT_PLAN_ITEM_DESCRIPTION

Java Field: paymentPlanItemDescription

Status: Active

SQL Type: varchar(255)

Java Type: String

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:

Response

Added On: 01/25/17

SQL Column: RESPONSE

Java Field: response

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Response Code

Added On: 01/25/17

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Retail Transaction Cycle FK

Added On: 01/27/17

SQL Column: RETAIL_TRANSACTION_CYCLE_FK

Java Field: retailTransactionCycle

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Retail Transaction Cycle

Attributes:

Return Fee Amount

Added On: 01/25/17

SQL Column: RETURN_FEE_AMOUNT

Java Field: returnFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Return Reason

Added On: 01/25/17

SQL Column: RETURN_REASON

Java Field: returnReason

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Shipping City

Added On: 01/25/17

SQL Column: SHIPPING_CITY

Java Field: shippingCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Shipping Country Code

Added On: 01/25/17

SQL Column: SHIPPING_COUNTRY_CODE

Java Field: shippingCountryCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Shipping State

Added On: 01/25/17

SQL Column: SHIPPING_STATE

Java Field: shippingState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Shipping Street 1

Added On: 01/25/17

SQL Column: SHIPPING_STREET1

Java Field: shippingStreet1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Shipping Street 2

Added On: 01/25/17

SQL Column: SHIPPING_STREET2

Java Field: shippingStreet2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Shipping ZIP Code

Added On: 01/25/17

SQL Column: SHIPPING_ZIP_CODE

Java Field: shippingZipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Subject

Added On: 01/25/17

SQL Column: SUBJECT

Java Field: subject

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Template Code

Added On: 01/25/17

SQL Column: TEMPLATE_CODE

Java Field: templateCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Terminal Order FK

Added On: 01/27/17

SQL Column: TERMINAL_ORDER_FK

Java Field: terminalOrder

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Terminal Order

Attributes:

To Email

Added On: 01/25/17

SQL Column: TO_EMAIL

Java Field: toEmail

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Transaction Amount

Added On: 01/25/17

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction Balance

Added On: 01/25/17

SQL Column: TRANSACTION_BALANCE

Java Field: transactionBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction Code

Added On: 01/25/17

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Transaction Date

Added On: 01/25/17

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Transaction Due Date

Added On: 01/25/17

SQL Column: TRANSACTION_DUE_DATE

Java Field: transactionDueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Transaction Type

Added On: 01/25/17

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes: