Table Name:fr_agr_con_role
Table Number:5772
Group:Morder
Description:Gives roles which contacts and framework agreement play for one another
Flags: 
Baseline/Custom:Baseline
select * from table_fr_agr_con_role
Keyboard shortcuts available
Fields:

(double-click a column header to select column text)

Field Name
Common Type
Database Type
Generic Field ID
Array Size
Default
Flags
Comment
Field Used in Views
activeLONGsmallint   DIRECT Indicates whether the role is currently being used; i.e., 0=inactive, 1=active  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
focus_typeLONGsmallint   DIRECT Object type ID of the role-player; i.e., 15=an installed part's role, 173=a business organization's role  
is_primaryLONGtinyint  0 DIRECT Indicates primary contact for agreement. 1=is primary contact, 0=non primary contact;Default=0 Search (1)
last_updateCLK_TIMEdatetime46   Date time of last update  
objidLONGint3  DIRECT Internal record number Search (1)
role_nameCHARvarchar 80  Name of the role Search (1)
Relations:
Relation
Type
Target Object
Inverse Relation
Comment
Flags
MTM Table
Used in Views
fr_agr_con_role2contactMTOcontactcontact2fr_agr_con_roleThe related contact   Search (1)
fr_agr_con_role2fr_agrmntMTOfr_agrmntfr_agrmnt2fr_agr_con_roleThe related framework agreement   Search (1)
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
I5772fr_agr_con_role2fr_agrmnt:fr_agr_con_role2contact:role_nameUNIQUE 
Indexes (Defined in Database):
Index Name
Fields
Additional Information
fcr2c5772fr_agr_con_role2contact, role_name, fr_agr_con_role2fr_agrmntnonclustered located on PRIMARY
I5772fr_agr_con_role2fr_agrmnt, fr_agr_con_role2contact, role_namenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
rn5772_1role_name, fr_agr_con_role2fr_agrmnt, fr_agr_con_role2contactnonclustered located on PRIMARY
rn5772_2role_name, fr_agr_con_role2contact, fr_agr_con_role2fr_agrmntnonclustered located on PRIMARY
Referenced in Views:
View ID
View Name
Tables
5785agr_con_v contact, fr_agr_con_role, fr_agrmnt
My Recent Objects
fr_agr_con_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user