objid | loc_rol_itm | objid | Rollup item internal record number | 3 (UNIQUE) |
path_type | loc_rol_itm | path_type | Parent/Child path type, 0=directly related, 1=indirectly related | |
rollup_objid | rollup | objid | Rollup internal record number | |
rollup_name | rollup | name | Name of the rollup | |
rollup_type | rollup | rollup_type | Contraints on the rollup, i.e., 1=only single parent allowed, 2=multiple parents allowed, 3=duplicate indirect children allowed | |
usage_type | rollup | use_type | Used 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_objid | parent(inv_locatn) | objid | Parent location internal record number | |
parent_name | parent(inv_locatn) | location_name | Name of the parent location | |
parent_active | parent(inv_locatn) | active | Status of the parent location | |
child_objid | child(inv_locatn) | objid | Child location internal record number | |
child_name | child(inv_locatn) | location_name | Name of the child location | |
child_active | child(inv_locatn) | active | Status of the child location | |
depth | loc_rol_itm | depth | Depth 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) | |