Lead Case

Added On: 08/16/12

SQL Table: LEAD_CASE

Module: UniSell

Type: Entity Status: Active

Java Class: LeadCase

Represents a sales opportunity for a lead

Available Fields:

Case CL
Case Objective Code
Case Result Code
Case State Code
Close Date
Contact Method Code
Contract FK
Create Date
Creator Code

Id
Last Action FK
Last Owner Change Date
Last State Change Date
Lead Fk
Lead Source Code
Lead Source Details
Membership Fk
Merchant Account Code

Next Activity FK
Next Scheduled Activity FK
Owner Code
Owner Number
Prospector Code
Referring Customer Account Code
Referring Lead Fk
Store Number
Visibility CL

Case CL

Added On: 08/24/12

SQL Column: CASE_CL

Java Field: caseCL

Status: Active

SQL Type: varchar(1)

Java Type: String

References Case Classifier

Attributes: Required

Type of the case

Case Objective Code

Added On: 08/16/12

SQL Column: CASE_OBJECTIVE_CODE

Java Field: caseObjectiveCode

Status: Active

SQL Type: varchar(2)

Java Type: String

References Case Objective Code

Attributes:

Objective of the case (e.g. membership, tanning, personal training).

Case Result Code

Added On: 08/27/12

SQL Column: CASE_RESULT_CODE

Java Field: caseResultCode

Status: Active

SQL Type: varchar(10)

Java Type: String

References Case Result Code

Attributes:

Result/outcome of the case.

Case State Code

Added On: 08/24/12

SQL Column: CASE_STATE_CODE

Java Field: caseStateCode

Status: Active

SQL Type: varchar(10)

Java Type: String

References Case State Code

Attributes: Required

Current state of the case.

Close Date

Added On: 08/27/12

SQL Column: CLOSE_DATE

Java Field: closeDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the case was closed.

Contact Method Code

Added On: 08/16/12

SQL Column: CONTACT_METHOD_CODE

Java Field: contactMethodCode

Status: Active

SQL Type: varchar(2)

Java Type: String

References Contact Method Code

Attributes:

Method the lead contacted with company.

Contract FK

Added On: 08/27/12

SQL Column: CONTRACT_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Contract

Attributes:

Reference to a contract sold as part of the case

Create Date

Added On: 08/16/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Creator Code

Added On: 08/25/12

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

References User

Attributes: Required

Reference to a user who created the case.

Added On: 08/16/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.

Last Action FK

Added On: 08/25/12

SQL Column: LAST_ACTION_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Action

Attributes:

Last action associated with the case

Last Owner Change Date

Added On: 08/25/12

SQL Column: LAST_OWNER_CHANGE_DATE

Java Field: lastOwnerChangeDate

Status: Active

SQL Type: date

Java Type: Date

Attributes:

Date when the current case owner was last assigned.

Last State Change Date

Added On: 08/25/12

SQL Column: LAST_STATE_CHANGE_DATE

Java Field: lastStateChangeDate

Status: Active

SQL Type: date

Java Type: Date

Attributes: Required

Date when the case's state was changed for the last time. Age of automated actions is counted off this date.

Lead Fk

Added On: 09/14/12

SQL Column: LEAD_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Lead

Attributes:

Lead for which this case is opened.

Lead Source Code

Added On: 08/16/12

SQL Column: LEAD_SOURCE_CODE

Java Field: leadSourceCode

Status: Active

SQL Type: varchar(2)

Java Type: String

References Lead Source Code

Attributes:

The source from which the lead found out about the case.

Lead Source Details

Added On: 08/16/12

SQL Column: LEAD_SOURCE_DETAILS

Java Field: leadSourceDetails

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Specific details related to the lead's source.

Membership Fk

Added On: 08/16/12

SQL Column: MEMBERSHIP_FK

Java Field: membershipFk

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Membership

Attributes:

Membership the lead is interested in.

Merchant Account Code

Added On: 08/16/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.

Next Activity FK

Added On: 08/25/12

SQL Column: NEXT_ACTIVITY_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Activity

Attributes:

Next scheduled activity in the case

Next Scheduled Activity FK

Added On: 08/27/12

SQL Column: NEXT_SCHEDULED_ACTIVITY_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Scheduled Activity

Attributes:

Next scheduled contact for the case.

Owner Code

Added On: 08/25/12

SQL Column: OWNER_CODE

Java Field: ownerCode

Status: Active

SQL Type: varchar(60)

Java Type: String

References User

Attributes: Required

Reference to a user who currently owns and who is responsible for the case.

Owner Number

Added On: 08/07/13

SQL Column: OWNER_NUMBER

Java Field: ownerNumber

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Prospector Code

Added On: 02/12/14

SQL Column: PROSPECTOR_CODE

Java Field: prospectorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Referring Customer Account Code

Added On: 08/16/12

SQL Column: REFERRING_CUSTOMER_ACCOUNT_CODE

Java Field: referringCustomerAccountCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Unique identifier of the customer that referred this lead.

Referring Lead Fk

Added On: 08/16/12

SQL Column: REFERRING_LEAD_FK

Java Field: referringLeadFk

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Lead

Attributes:

Lead that referred this lead.

Store Number

Added On: 08/07/13

SQL Column: STORE_NUMBER

Java Field: storeNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Visibility CL

Added On: 08/25/12

SQL Column: VISIBILITY_CL

Java Field: visibilityCl

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes: Default:A

Visibility policy of the case.