View Name:contact_web
View Number:5463
Group:Web Support
Description:Used for form Setup Web Users (780)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontact_roleobjidContact_role internal record number 3 (UNIQUE)
con_objidcontactobjidContact internal record number 
web_objidweb_userobjidWeb User internal record number 
loc_objidsiteobjidSite internal record number 
addr_objidaddressobjidAddress internal record number 
cty_objidcountryobjidCountry internal record number 
first_namecontactfirst_nameContact first name 15
last_namecontactlast_nameContact last name 14
phonecontactphoneContact phone number which includes area code, number, and extension 
primary_sitecontact_roleprimary_siteIndicates whether the related site is where the contact is located; i.e., 0=false, 1=true, default=0 
sitesitenameName of the site 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
country_codecountrycodeCountry code used in telephone numbers for that country 
statuscontactstatusStatus of contact; i.e., active/inactive/obsolete 
loginweb_userlogin_nameWeb User login name 
passwordweb_userpasswordWeb User password 
web_statusweb_userstatusStatus of web user 
user_keyweb_useruser_keySystem generated key value to locate WebSupport user 
passwd_chgweb_userpasswd_chgDate/Time password was last changed 

Joins:

Join FromJoin To
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
(contact_role).contact_role2contact(contact).contact2contact_role
(contact_role).contact_role2site(site).site2contact_role
OUTER (web_user).web_user2contact(contact).contact2web_user
My Recent Objects
contact_web