View Name:acct_site_view
View Number:5031
Group:Customer Mgr
Description:Used by Account Edit (Form 8500, 8521), Sites (8501), Contacts (8502), Contracts (8503), Account Team (8504), Cases (8506), Quick View (8507), Quotes, (8525), Opportunities Site Detail Tab for Accounts (11660) and others
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidbus_site_roleobjidbus_site_role internal record number 3 (UNIQUE)
role_namebus_site_rolerole_nameThe name of the role 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameSite name 
site_typesitetypeSite type 
addressaddressaddressSite address 
cityaddresscitySite city 
stateaddressstateSite state 
country_codecountrycodeSite country code 
site_typestsitesite_typeSite type string 
statussitestatusStatus of site; i.e., active, inactive, obsolete 
site_statussitesite_idUsed for display of site status. Must be replaced with active/inactive/obsolete in display 
site_objidsiteobjidSite internal record number 
address_objidaddressobjidAddress internal record number 
country_objidcountryobjidCountry internal record number 
countrycountrynameName of the country 
zipcodeaddresszipcodeThe zip or other postal code for the specified address 
address_2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 

Joins:

Join FromJoin To
(bus_site_role).bus_site_role2site(site).site2bus_site_role
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
acct_site_view