View Name:site_view_zone
View Number:5550
Group:Customer Mgr
Description:Selects site details. Used by forms Serviced Sites (8419), Contract <ID> (731), Contract Details (732), Contract Svc (777 and Promote Lead (11601)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsiteobjidSite internal record number 3 (UNIQUE)
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameSite name 
site_typesitetypeSite type; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR 
addressaddressaddressLine 1 of site address which includes street number, street name, office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
stateaddressstate The state for the specified address 
country_codecountrycodeCountry code used in telephone numbers for that country 
site_typestsitesite_typeMnemonic representation of the integer site type field 
statussitestatusStatus of site; i.e., 0=active, 1=inactive, 2=obsolete, default=0 
bus_org_objidbus_orgobjidBus Org internal record number 
org_idbus_orgorg_idUser-specified ID number of the organization 
org_namebus_orgnameName of the organization 
org_typebus_orgtypeBusiness type; e.g., competitor, prospect, customer, etc., from a user-defined pop up 
country_namecountrynameName of the site's country 
zipcodeaddresszipcodeThe zip or other postal code for the specified site address 
country_objidcountryobjidCountry internal record number 
address_objidaddressobjidAddress internal record number 
regionsiteregionRegion to which the site belongs 
districtsitedistrictDistrict to which the site belongs 
address_2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 
time_zone_objidtime_zoneobjidTime Zone internal record number 
time_zone_nametime_zonenameTime Zone name 

Joins:

Join FromJoin To
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
(site).primary2bus_org(bus_org).primary_org2site
(address).address2time_zone(time_zone).time_zone2address
My Recent Objects
site_view_zone