View Name:loc_rollup_v
View Number:5290
Group:ClearLogistics
Description:Displays location hierarchies. Used by Inventory Location Rollup form (8431)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidloc_rol_itmobjidRollup item internal record number 3 (UNIQUE)
path_typeloc_rol_itmpath_typeParent/Child path type, 0=directly related, 1=indirectly related 
rollup_objidrollupobjidRollup internal record number 
rollup_namerollupnameName of the rollup 
rollup_typerolluprollup_typeContraints on the rollup, i.e., 1=only single parent allowed, 2=multiple parents allowed, 3=duplicate indirect children allowed 
usage_typerollupuse_typeUsed within focus_type to signal how a rollup on a particular object is used by the application; e.g., for inventory locations (228) 1=Counting for inventory counts, 2=physical - for zone management, 3=reporting for reporting operational metrics 
parent_objidparent(inv_locatn)objidParent location internal record number 
parent_nameparent(inv_locatn)location_nameName of the parent location 
parent_activeparent(inv_locatn)activeStatus of the parent location 
child_objidchild(inv_locatn)objidChild location internal record number 
child_namechild(inv_locatn)location_nameName of the child location 
child_activechild(inv_locatn)activeStatus of the child location 
depthloc_rol_itmdepthDepth of the item from the top-level item; e.g., 0=top-level item, 1=item that reports directly to top level item, etc., default=-1 (unknown) 

Joins:

Join FromJoin To
(loc_rol_itm).parent2inv_locatnparent(inv_locatn).parent2loc_rol_itm
(loc_rol_itm).child2inv_locatnchild(inv_locatn).child2loc_rol_itm
(loc_rol_itm).loc_itm2rollup(rollup).rollup2loc_rol_itm
My Recent Objects
loc_rollup_v