View Name:contact_list
View Number:6070
Group:Support
Description:Used for contact_list.jsp, no account
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 
loc_objidsiteobjidSite internal record number 
addr_objidaddressobjidAddress internal record number 
country_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 
sitesitenameThe name of the site 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_typesitetypeMnemonic representation of the integer site type field 
site_typestsitesite_typeMnemonic representation of the integer site type field 
role_namecontact_rolerole_nameRole of the contact at the site 
primary_sitecontact_roleprimary_siteIndicates whether the related site is where the contact is located; i.e., 0=false, 1=true, default=0 
country_codecountrycodeCountry code used in telephone numbers for that country 
countrycountrynameName of the specific country 
cityaddresscityThe city for the specified address 
stateaddressstateThe state for the specified address 
statuscontactstatusStatus of contact; i.e., active/inactive/obsolete 
salutationcontactsalutationA form of address; e.g., Mr., Miss, Mrs 

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
My Recent Objects
contact_list