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:

(double-click a column header to select column text)

View Field Name
Table Name
Field Name
Comment
Generic Field Id
addressaddressaddressSite address 
address_2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 
address_objidaddressobjidAddress internal record number 
cityaddresscitySite city 
countrycountrynameName of the country 
country_codecountrycodeSite country code 
country_objidcountryobjidCountry internal record number 
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_objidsiteobjidSite internal record number 
site_statussitesite_idUsed for display of site status. Must be replaced with active/inactive/obsolete in display 
site_typesitetypeSite type 
site_typestsitesite_typeSite type string 
stateaddressstateSite state 
statussitestatusStatus of site; i.e., active, inactive, obsolete 
zipcodeaddresszipcodeThe zip or other postal code for the specified address 

Joins:

Join From
Join 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