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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  04/10/15
SQL Column:  ORDER_STATUS_CL
Java Field:  orderStatusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible statuses of the terminal order.
Added On:  09/01/15
SQL Column:  PAYMENT_ARRANGEMENT_CL
Java Field:  paymentArrangementCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible payment arrangement types available within the system.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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).
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.
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.
Added On:  07/31/15
SQL Column:  TERMINAL_ORDER_CL
Java Field:  terminalOrderCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible terminal order types.
Added On:  06/23/16
SQL Column:  TERMINAL_ORDER_DETAIL_FK
Java Field:  terminalOrderDetails
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that stores terminal order details information.
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.
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.