Case Reminder Code


Added On:  08/24/12 
SQL Table:  CASE_REMINDER_CODE 
Module:  UniSell 
Type:  Entity  Status:  Active 
Java Class:  CaseReminderCode 
Possible reminders associated with a case objective.
Added On:  08/24/12
SQL Column:  CASE_OBJECTIVE_CODE
Java Field:  caseObjectiveCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
References Case Objective Code
Attributes: Required, Min Length:2
Reference to a case objective for which this reminder is defined.
Added On:  08/24/12
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Unique code identifying the reminder with a case objective
Added On:  08/24/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  08/24/12
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:  08/24/12
SQL Column:  IS_ACTIVE
Java Field:  isActive
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Integer
Attributes: Default:1
Indicates whether the record is currently active.
Added On:  08/24/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required, CreateOnly
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:  08/24/12
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name (description) of the code, defining its meaning