Activities

Columns

Name Type Length Precision Scale References In Description
access_level VARCHAR2 10 Access level
activity_id NUMBER 39 0 Activity ID
assigned_to_id NUMBER 39 0 Assigned to ID
case_id NUMBER 39 0 Case ID
contact_id NUMBER 39 0 Contact ID
date_0 TIMESTAMP Date (GMT)
date_completed TIMESTAMP Date completed (GMT)
date_created TIMESTAMP Date created (GMT) holds the date created information for all activities except "note" type.
date_last_modified TIMESTAMP Date last modified (GMT)
entity_id NUMBER 39 0 Entity ID
memo VARCHAR2 4000 Memo. Long messages may be truncated. If you need a longer message, try joining the Message column from the Message table.
opportunity_id NUMBER 39 0 Opportunity ID
owner_id NUMBER 39 0 Owner ID
status VARCHAR2 12 Status
title VARCHAR2 457 Title
type_0 VARCHAR2 8 Activity type