Table Name:usr_ter_role
Table Number:5219
Group:Sales Mgr
Description:Roles played by users and territories for one another
Flags: 
Baseline/Custom:Baseline
select * from table_usr_ter_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., 20=a user's role for a territory, 5002=a territory's role for a user  
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
owner2frcst_itmOTMfrcst_itmitm_owner2usr_ter_roleItems forecasted by the usr in the territory role. Reserved    
owner2frcst_targetOTMfrcst_targettrgt_owner2usr_ter_roleQuota for the user in the territory role. Reserved    
user_role2territoryMTOterritoryterr2usr_ter_roleRelated sales territory   Search (1)
usr_ter_role2userMTOuseruser2usr_ter_roleRelated user   Search (1)
Indexes: (Defined in Clarify Schema)
Index Name
Fields
Flags
usrter_role_induser_role2territory:usr_ter_role2user:role_nameUNIQUE 
Indexes (Defined in Database):
Index Name
Fields
Additional Information
ind_usr_ter_role2userusr_ter_role2user, user_role2territory, role_namenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
usrter_role_induser_role2territory, usr_ter_role2user, role_namenonclustered, unique located on PRIMARY
Referenced in Views:
View ID
View Name
Tables
5349sfa_terr_tm contact, employee, territory, user, usr_ter_role
My Recent Objects
usr_ter_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user