View Name:loc_to_sub
View Number:107
Group:Customer Mgr
Description:Contains site information for parent/child sites. Used by forms Site <name> 717, Site Contracts (718), Site Contracts, Site More Info (719)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidloc_parent(site)objidParent site internal record number 3 (UNIQUE)
sub_objidloc_child(site)objidChild site internal record number 
ploc_idloc_parent(site)site_idParent site ID number assigned according to auto-numbering definition 
pnameloc_parent(site)nameParent site name 
paddressparent_addr(address)addressParent site line 1 of address which includes street number, street name, office, building, or suite number, etc 
cloc_idloc_child(site)site_idChild site ID number assigned according to auto-numbering definition. Parent site ID number assigned according to auto-numbering definition 
cnameloc_child(site)nameChild site name 
caddresschild_addr(address)addressChild site line 1 of address which includes street number, street name, office, building, or suite number, etc 
caddress_objidchild_addr(address)objidChild_addr internal record number 
paddress_objidparent_addr(address)objidParent_addr internal record number 

Joins:

Join FromJoin To
loc_child(site).child_site2siteloc_parent(site).parent_site2site
loc_child(site).cust_primaddr2addresschild_addr(address).primary_addr2site
loc_parent(site).cust_primaddr2addressparent_addr(address).primary_addr2site
My Recent Objects
loc_to_sub