Terminal Order History UML

Added On: 04/10/15

SQL Table: TERMINAL_ORDER_HISTORY

Module: UniCharge

Type: Entity Status: Active

Java Class: TerminalOrderHistory

Represents terminal order history that includes date, user and order status.

Available Fields:

Create Date
Host

Id
Merchant Account Code

Order Status CL
Terminal Code

Terminal Order FK
User Code

Create Date

Added On: 04/10/15

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created.

Host

Added On: 04/10/15

SQL Column: HOST

Java Field: host

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

IP address of the place where the order was created.

Added On: 04/10/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: 04/10/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.

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:

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

Terminal Code

Added On: 04/10/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 FK

Added On: 04/10/15

SQL Column: TERMINAL_ORDER_FK

Java Field: terminalOrder

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Terminal Order

Attributes:

Reference to the entity that represents terminal order and shipment details.

User Code

Added On: 04/10/15

SQL Column: USER_CODE

Java Field: userCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Code of the user within the system.