Terminal Order Transaction UML

Added On: 09/25/15

SQL Table: TERMINAL_ORDER_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TerminalOrderTransaction

Entity that represents terminal order transaction information.

Available Fields:

Batch FK
Cancelled Date
Completed Date
Create Date

Id
Merchant Account Code
Order Status CL
Processed Date

Provider Order Code
Response Message
Shipping Date
Sub Batch FK

Terminal Order FK
Tracking Number

Batch FK

Added On: 09/25/15

SQL Column: BATCH_FK

Java Field: batch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Batch

Attributes:

Reference to the entity that represents a group of batch transactions which must be settled together.

Cancelled Date

Added On: 09/25/15

SQL Column: CANCELLED_DATE

Java Field: cancelledDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the terminal order transaction was cancelled.

Completed Date

Added On: 09/25/15

SQL Column: COMPLETED_DATE

Java Field: completedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the terminal order transaction was completed.

Create Date

Added On: 09/25/15

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Added On: 09/25/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: 09/25/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: 10/06/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 values of statuses of the terminal order.

Processed Date

Added On: 09/25/15

SQL Column: PROCESSED_DATE

Java Field: processedDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the transaction was processed.

Provider Order Code

Added On: 10/10/15

SQL Column: PROVIDER_ORDER_CODE

Java Field: providerOrderCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Code of the provider order in the system.

Response Message

Added On: 10/06/15

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(200)

Java Type: String

Attributes:

Gateway generated response message.

Shipping Date

Added On: 10/06/15

SQL Column: SHIPPING_DATE

Java Field: shippingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the order is shipped.

Sub Batch FK

Added On: 09/25/15

SQL Column: SUB_BATCH_FK

Java Field: subBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Sub Batch

Attributes:

Reference to the entity that represents a sub-group of transactions within batch or retail cycle.

Terminal Order FK

Added On: 09/25/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.

Tracking Number

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