Table Name:con_csc_role
Table Number:5059
Group:Sales Mgr
Description:Roles played by contacts and contract schedules for one another
Flags: 
Baseline/Custom:Baseline
select * from table_con_csc_role
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
access_idCHARvarchar 40  ID authorizing access to the contract/schedule for the role Search (2)
activeLONGsmallint   DIRECT Indicates whether the role is currently being used; i.e., 0=inactive, 1=active Search (2)
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
focus_typeLONGsmallint   DIRECT Object type ID of the role-player; i.e., 45=a contact's role, 5051=a contract schedule's role Search (1)
objidLONGint3  DIRECT Internal record number Search (2)
role_nameCHARvarchar 80  Name of the role Search (2)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
csc_role2contactMTOcontactcontact2con_csc_roleContact for the role   Search (2)
con_role2contr_scheduleMTOcontr_scheduleschedule2con_csc_roleContract schedule for the role   Search (2)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
conscc_role_indcsc_role2contact:con_role2contr_schedule:role_nameUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
conscc_role_indcsc_role2contact, con_role2contr_schedule, role_namenonclustered, unique located on PRIMARY
ind_access_id_con_csc_roleaccess_idnonclustered located on PRIMARY
ind_con_role2contr_schedulecon_role2contr_schedule, csc_role2contact, role_namenonclustered located on PRIMARY
ind_csc_role2contactcsc_role2contact, con_role2contr_schedule, role_namenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
My Recent Objects
con_csc_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user