View Name:edr_cntct_acct
View Number:5852
Group:eRespone
Description:For the Billing Manage to search for an Electronic Address (e_addr) by account ID & name, contact first & last name. Used eRM\common\eaddr_list_single_select.jsp JSP page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objide_addrobjidE_addr internal record number 3 (UNIQUE)
e_nume_addre_numFull electonic address number; e.g., phone number including country code (if needed) and area code, email number, pager number. This is the addressable number 
typee_addre_typeType of electronic address; i.e., 0=reserved, 1=e-mail, 2=phone, 3=fax, 4-9999 (Reserved) 
acct_objidbus_orgobjidbus_org internal record number 
acct_namebus_orgnameName of the organization 
acct_idbus_orgorg_idUser-specified ID number of the organization 
cntct_objidcontactobjidcontact internal record number 
cntct_first_namecontactfirst_nameContact's first name 
cntct_last_namecontactlast_nameContact's last name 

Joins:

Join FromJoin To
(e_addr).eaddr2bus_orgOUTER (bus_org).bus_org2e_addr
(e_addr).eaddr2contactOUTER (contact).contact2e_addr
My Recent Objects
edr_cntct_acct