View Name:get_child_site
View Number:342
Group:Customer Mgr
Description:Contains information on a child site
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidloc_parent(site)objidParent site internal record number 
sub_objidloc_child(site)objidChild site internal record number 3 (UNIQUE)
cloc_idloc_child(site)site_idChild site ID number assigned according to auto-numbering definition 
cnameloc_child(site)nameChild site name 
caddressaddressaddressChild line 1 of address which includes street number, street name, office, building, or suite number, etc 

Joins:

Join FromJoin To
loc_child(site).child_site2siteloc_parent(site).parent_site2site
loc_child(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
get_child_site