Table Name:inv_role
Table Number:42
Group:Logistics
Description:Role played by an inventory location for a site or by a site for an inventory location
Flags: 
Baseline/Custom:Baseline
select * from table_inv_role
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField 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., 52=a site's role, 228=an inventory location's role  
objidLONGint3  DIRECT Internal record number Search (2)
rankLONGint  0 DIRECT For servicing inventory locations, ranks the order in which locations should be displayed for a given site in the Pick form; e.g., 0=not applicable, 1=first displayed, 2=second displayed, etc., default=0 Search (3)
role_nameCHARvarchar 80  Name of role played by the focus type; e.g., sites default-bad parts inventory location, inventory locations located-at site Search (6)
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
inv_role2inv_locatnMTOinv_locatnlocatn2inv_roleRelated inventory location   Search (6)
inv_role2siteMTOsitesite2inv_roleRelated site   Search (5)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
role_indexrole_name:focus_type:inv_role2inv_locatn:inv_role2siteUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_inv_role2inv_locatninv_role2inv_locatn, inv_role2site, role_namenonclustered located on PRIMARY
ind_inv_role2siteinv_role2site, inv_role2inv_locatn, role_namenonclustered located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
role_indexrole_name, focus_type, inv_role2inv_locatn, inv_role2sitenonclustered, unique located on PRIMARY
My Recent Objects
inv_role      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user