Terminal Order UML

Added On: 03/12/15

SQL Table: TERMINAL_ORDER

Module: UniCharge

Type: Entity Status: Active

Java Class: TerminalOrder

Represents terminal order and shipment details.

Available Fields:

Acceptance Notification Email FK
Approval Notification Email FK
Cancellation Notification Email FK
Contact Name
Create Date
Creator Code
Delivery Confirmation Date
Delivery Confirmation Host
Email
Fulfillment Center FK
Id
Merchant Account Code

Modification Notification Email FK
Notes
Order Status CL
Payment Arrangement CL
Phone
Processing Date
Response Message
RMA Number
Shipment Notification Email FK
Shipment Number
Shipping City
Shipping Country Code

Shipping Date
Shipping Method FK
Shipping Name
Shipping State
Shipping Street 1
Shipping Street 2
Shipping ZIP Code
Terminal Code
Terminal Order CL
Terminal Order Detail FK
Terminal Support Number
Tracking Number

Acceptance Notification Email FK

Added On: 09/04/15

SQL Column: ACCEPTANCE_NOTIFICATION_EMAIL_FK

Java Field: acceptanceNotificationEmail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Transaction

Attributes:

Reference to the entity that represents email used for order acceptance notifications.

Approval Notification Email FK

Added On: 09/04/15

SQL Column: APPROVAL_NOTIFICATION_EMAIL_FK

Java Field: approvalNotificationEmail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Transaction

Attributes:

Reference to the entity that represents email used for order approval notifications.

Cancellation Notification Email FK

Added On: 09/04/15

SQL Column: CANCELLATION_NOTIFICATION_EMAIL_FK

Java Field: cancellationNotificationEmail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Transaction

Attributes:

Reference to the entity that represents email used for order cancellation notifications.

Contact Name

Added On: 06/18/15

SQL Column: CONTACT_NAME

Java Field: contactName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Contact name of the client that is to receive a terminal for usage.

Create Date

Added On: 05/19/15

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the order is created.

Creator Code

Added On: 05/19/15

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Code of the user that created the order.

Delivery Confirmation Date

Added On: 05/19/15

SQL Column: DELIVERY_CONFIRMATION_DATE

Java Field: deliveryConfirmationDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the order is delivered and confirmed by the user.

Delivery Confirmation Host

Added On: 07/31/15

SQL Column: DELIVERY_CONFIRMATION_HOST

Java Field: deliveryConfirmationHost

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Host tha is used for delivery confirmation.

Added On: 06/18/15

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Email address of the client that made the order.

Fulfillment Center FK

Added On: 05/19/15

SQL Column: FULFILLMENT_CENTER_FK

Java Field: fulfillmentCenter

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Fulfillment Center

Attributes:

Reference to the entity that represents information about the fulfillment center.

Added On: 03/12/15

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: 03/12/15

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.

Modification Notification Email FK

Added On: 09/04/15

SQL Column: MODIFICATION_NOTIFICATION_EMAIL_FK

Java Field: modificationNotificationEmail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Transaction

Attributes:

Reference to the entity that represents email used for order modification notifications.

Notes

Added On: 03/12/15

SQL Column: NOTES

Java Field: notes

Status: Active

SQL Type: varchar(500)

Java Type: String

Attributes:

Any additional information provided by the client.

Order Status CL

Added On: 04/10/15

SQL Column: ORDER_STATUS_CL

Java Field: orderStatusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Terminal Order Status Classifier

Attributes:

Enumeration of possible statuses of the terminal order.

Payment Arrangement CL

Added On: 09/01/15

SQL Column: PAYMENT_ARRANGEMENT_CL

Java Field: paymentArrangementCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Payment Arrangement Classifier

Attributes:

Reference to the entity that represents enumeration of possible payment arrangement types available within the system.

Phone

Added On: 06/18/15

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Phone number of the client that made the order.

Processing Date

Added On: 05/19/15

SQL Column: PROCESSING_DATE

Java Field: processingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the order is processed.

Response Message

Added On: 10/06/15

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Response message generated by the system.

RMA Number

Added On: 03/12/15

SQL Column: RMA_NUMBER

Java Field: rmaNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Number used in case of return or exchange of the order.

Shipment Notification Email FK

Added On: 09/04/15

SQL Column: SHIPMENT_NOTIFICATION_EMAIL_FK

Java Field: shipmentNotificationEmail

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Email Transaction

Attributes:

Reference to the entity that represents email used for order shipment notifications.

Shipment Number

Added On: 03/12/15

SQL Column: SHIPMENT_NUMBER

Java Field: shipmentNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Additional number of the order when it was shipped.

Shipping City

Added On: 03/12/15

SQL Column: SHIPPING_CITY

Java Field: shippingCity

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City name of the user's shipping address for terminal order shipping.

Shipping Country Code

Added On: 03/12/15

SQL Column: SHIPPING_COUNTRY_CODE

Java Field: shippingCountryCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country code of the user's shipping address for terminal order shipping.

Shipping Date

Added On: 05/19/15

SQL Column: SHIPPING_DATE

Java Field: shippingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the order was shipped from the fulfillment center.

Shipping Method FK

Added On: 10/27/15

SQL Column: SHIPPING_METHOD_FK

Java Field: shippingMethod

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Shipping Method

Attributes:

Reference to the entity that represents shipping method used for terminal order delivery.

Shipping Name

Added On: 03/12/15

SQL Column: SHIPPING_NAME

Java Field: shippingName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Name of the person/organization indicated as a merchant to receive the order.

Shipping State

Added On: 03/12/15

SQL Column: SHIPPING_STATE

Java Field: shippingState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State code of the user's shipping address for terminal order shipping.

Shipping Street 1

Added On: 03/12/15

SQL Column: SHIPPING_STREET1

Java Field: shippingStreet1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street name of the user's shipping address for terminal order shipping (line 2).

Shipping Street 2

Added On: 07/31/15

SQL Column: SHIPPING_STREET2

Java Field: shippingStreet2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street name of the user's shipping address for terminal order shipping (line 1).

Shipping ZIP Code

Added On: 03/12/15

SQL Column: SHIPPING_ZIP_CODE

Java Field: shippingZipCode

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

ZIP/Postal code of the user's shipping address for terminal order shipping.

Terminal Code

Added On: 05/19/15

SQL Column: TERMINAL_CODE

Java Field: terminalCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the terminal within the system.

Terminal Order CL

Added On: 07/31/15

SQL Column: TERMINAL_ORDER_CL

Java Field: terminalOrderCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Terminal Order Classifier

Attributes:

Reference to the entity that represents enumeration of possible terminal order types.

Terminal Order Detail FK

Added On: 06/23/16

SQL Column: TERMINAL_ORDER_DETAIL_FK

Java Field: terminalOrderDetails

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Terminal Order Detail

Attributes:

Reference to the entity that stores terminal order details information.

Terminal Support Number

Added On: 10/15/15

SQL Column: TERMINAL_SUPPORT_NUMBER

Java Field: terminalSupportNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Terminal support telephone number for discussing any processing issues.

Tracking Number

Added On: 03/12/15

SQL Column: TRACKING_NUMBER

Java Field: trackingNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Number assigned by the fulfillment center to track the location of the order.