Activity

Added On: 08/25/12

SQL Table: ACTIVITY

Module: UniSell

Type: Entity Status: Active

Java Class: Activity

A scheduled activity associated with a lead.

Available Fields:

Action FK
Activity CL
Activity Reason Code
Create Date
Creator Code

Description
Due Date
Duration
Id
Last Status Change Date

Lead Case FK
Lead FK
Merchant Account Code
Notes
Owner Code

Rescheduling Attempt Count
Status CL

Action FK

Added On: 08/25/12

SQL Column: ACTION_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Action

Attributes:

Reference to action performed as an outcome of this activity.

Activity CL

Added On: 08/25/12

SQL Column: ACTIVITY_CL

Java Field: activityCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Activity Classifier

Attributes: Required

Represents the type of activity to be performed.

Activity Reason Code

Added On: 08/25/12

SQL Column: ACTIVITY_REASON_CODE

Java Field: activityReasonCode

Status: Active

SQL Type: varchar(2)

Java Type: String

References Activity Reason Code

Attributes:

For appointments only: reason for the appointment

Create Date

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

Reference to a user that created this activity

Description

Added On: 08/25/12

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(1024)

Java Type: String

Attributes:

Description of the task

Due Date

Added On: 08/25/12

SQL Column: DUE_DATE

Java Field: dueDate

Status: Active

SQL Type: date

Java Type: Date

Attributes:

Date when the activity is due.

Duration

Added On: 08/25/12

SQL Column: DURATION

Java Field: duration

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

For appointments only: duration of the appointment in minutes

Added On: 08/25/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 Status Change Date

Added On: 08/25/12

SQL Column: LAST_STATUS_CHANGE_DATE

Java Field: lastStatusChangeDate

Status: Active

SQL Type: date

Java Type: Date

Attributes: Required

Date when task status was changed last time.

Lead Case FK

Added On: 08/25/12

SQL Column: LEAD_CASE_FK

Java Field: leadCase

Status: Active

SQL Type: bigint(20)

Java Type:

References Lead Case

Attributes:

Reference to the case that the activity belongs to.

Lead FK

Added On: 08/25/12

SQL Column: LEAD_FK

Java Field: lead

Status: Active

SQL Type: bigint(20)

Java Type:

References Lead

Attributes: Required

Reference to a lead that this activity is associated with.

Merchant Account Code

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

Notes

Added On: 08/25/12

SQL Column: NOTES

Java Field: notes

Status: Active

SQL Type: varchar(1024)

Java Type: String

Attributes:

Activity related notes.

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 activity.

Rescheduling Attempt Count

Added On: 08/25/12

SQL Column: RESCHEDULING_ATTEMPT_COUNT

Java Field: reschedulingAttemptCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Number of times this activity has been rescheduled. Every rescheduling attempt increments the value by 1.

Status CL

Added On: 08/25/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Activity Status Classifier

Attributes: Required

Current status of the activity