View Name:site_view2
View Number:5647
Group:Customer Mgr
Description:Used by site_overview.jsp for display of site hierarchy information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidchild(site)objidChild site internal record number 3 (UNIQUE)
site_idchild(site)site_idChild site ID number assigned according to auto-numbering definition 
parent_objidparent(site)objidParent site internal record number 
site_namechild(site)nameName of the child site 
site_typechild(site)typeType of the child site; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR 
addressaddressaddressChild site primary address 
cityaddresscityChild site's city 
stateaddressstateChild site's state 
country_codecountrycodeChild site's country code 
site_typestchild(site)site_typeChild site's type string; i.e., mnemonic representation of the integer site type field 
statuschild(site)statusStatus of child site; i.e., active, inactive, obsolete 
bus_org_objidbus_orgobjidChild site's owning bus_org internal record number 
org_idbus_orgorg_idChild site's owning account's ID number 
org_namebus_orgnameChild site's owning account's name 
org_typebus_orgtypeChild site's owning Business type; e.g., competitor, prospect, customer, etc., from a user-defined pop up 
country_namecountrynameName of the child site's country 
zipcodeaddresszipcodeChild site's zipcode 
country_objidcountryobjidChild sit'e country internal record number 
address_objidaddressobjidChild sit'e address internal record number 
regionchild(site)regionRegion to which the child site belongs 
districtchild(site)districtDistrict to which the child site belongs 
address_2addressaddress_2Line 2 of child site's address which typically includes office, building, or suite number, etc 

Joins:

Join FromJoin To
(address).address2country(country).country2address
child(site).cust_primaddr2address(address).primary_addr2site
child(site).primary2bus_org(bus_org).primary_org2site
child(site).child_site2siteparent(site).parent_site2site
My Recent Objects
site_view2