View Name:acct_sites_view
View Number:5482
Group:Customer Mgr
Description:Opportunities site detail for accounts. Used by account_loc_list.jsp and location_search_results.jsp and 16130 form
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 
acct_objidbus_orgobjidBus_org internal record number 
acct_namebus_orgnameName of the account 
acct_org_idbus_orgorg_idUser-specified ID number of the account 
acct_phonebus_orgphoneMain phone number of the account 
acct_web_sitebus_orgweb_site The URL of the main web page of the account  
acct_size_emplbus_orgsize_emplEstimated number of employees in the account 
acct_typebus_orgtypeBusiness type; e.g., competitor, prospect, customer. This is a user-defined pop up with default name Company Type 
acct_revn_rangebus_orgrevn_rangeRevenue range of the account. This is a user-defined popup with default name Company Revenue 
acct_faxbus_orgfaxMain fax number of the account 
acct_stock_symbus_orgstock_symStock symbol of the account 
acct_statusbus_orgstatusStatus of account; i.e., 0=active, 1=inactive, 2=obsolete, default=0 
acct_business_descbus_orgbusiness_descDescribes the purpose of the account or the business it is in 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameName of the site 
site_typesitetypeSite type; i.e., 1=CUST, 2=INTR, 3=RSEL, 4=INDV 
addressaddressaddressPrimary address of the site 
cityaddresscityCity where the site is located 
stateaddressstateState where the site is located 
country_codecountrycodeCountry code of the country where the site is located 
site_typestsitesite_typeMnemonic representation of the integer site type field 
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_role2bus_org(bus_org).bus_org2bus_site_role
(bus_site_role).bus_site_role2site(site).site2bus_site_role
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
acct_sites_view