View Name:bus_org_subscription
View Number:6048
Group:Morder
Description:Used to get all the bus_org(site_part) that belong to the bus_org. Used in assigned_services_account.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_bus_org_subscription
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
rol_objidbus_prt_roleobjidCon_sp_role internal record number 3 (UNIQUE)
sp_objidsite_partobjidSite_part internal record number 
statussite_partpart_statusSite Configuration installed part status. This is a user-defined popup with default name PART_STATUS 
instance_namesite_partinstance_nameDefault is the concatination of part name, part number, and part revision. May be customized 
bus_org_objidbus_orgobjidContact internal record number 
bus_org_namebus_orgnameContact's first name 
org_idbus_orgorg_idContact's last name 
org_statusbus_orgstatusContact's last name 
rootbus_orgbus_nodeContact's last name 
org_typebus_orgtypeContact's last name 
role_namebus_prt_rolerole_nameName of the role 
level_to_partsite_partlevel_to_partRelative installation hierarchy level to a part 
quantitysite_partquantityRelative installation hierarchy level to a part 

Joins:

Join FromJoin To
(bus_prt_role).bprt_role2site_part(site_part).part2bus_prt_role
(bus_prt_role).bus_prt_role2bus_org(bus_org).bus_org2bus_prt_role
My Recent Objects
bus_org_subscription      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user