View Name:sfa_site_dtl_vw
View Number:5707
Group:Sales
Description:Selects site details. Used by site_list.jsp and site_list_sigle_sel.jsp
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidbus_site_roleobjidBus_site_role internal record number 3 (UNIQUE)
site_objidsiteobjidSite internal record number 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
site_namesitenameName of the site 
site_typesitetypeSite type; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR 
phonesitephoneMain phone number 
faxsitefaxMain fax number 
ship_viasiteship_viaDefault means of shipment for the site. This is from a Clarify-defined popup list with default name SHIP_VIA 
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
(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
(address).address2time_zone(time_zone).time_zone2address
My Recent Objects
sfa_site_dtl_vw