View Name:cnt_lst
View Number:5375
Group:Web Support
Description:Used for <window_id and names>
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 
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 
sitesitenameThe name of the site 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
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 
statuscontactstatusStatus of contact; i.e., active/inactive/obsolete 

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
cnt_lst