View Name:fc_acct_site_view
View Number:4623
Group:Sales Mgr
Description:Account, site and address information used on form Console-Sales (12000)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Custom

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 
account_idbus_orgorg_idAccount ID number 
account_namebus_orgnameAccount name 
account_typebus_orgtypeAccount type 
account_phonebus_orgphoneMain account phone number 
account_faxbus_orgfaxMain account fax number 
account_descbus_orgbusiness_descAccount description 
account_websitebus_orgweb_siteThe URL of the main web page of the organization 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameSite name 
site_typesitetypeMnemonic representation of the integer site type field 
addressaddressaddressSite's primaryaddress 
zipcodeaddresszipcodeSite's primaryaddress zipcode 
cityaddresscitySite's primary address city 
stateaddressstateSite's primary address state 
country_codecountrycodeSite's primary address country code 
site_typestsitesite_typeSite Translation of the site type 
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 
account_objidbus_orgobjidAccount internal record number 

Joins:

Join FromJoin To
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
(bus_site_role).bus_site_role2site(site).site2bus_site_role
(bus_site_role).bus_site_role2bus_org(bus_org).bus_org2bus_site_role
My Recent Objects
fc_acct_site_view