eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AS_SALES_LEAD_CONTACTS

Product:	AS - Sales Foundation
Description:	Holds contact information for the Lead. Records can be deleted.
Implementation/DBA Data:	OSM.AS_SALES_LEAD_CONTACTS

Primary Key: AS_SALES_LEAD_CONTACTS_PK

LEAD_CONTACT_ID

Primary Key: AS_SALES_LEAD_CONTACTS_UK

SALES_LEAD_ID
CONTACT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_SALES_LEAD_CONTACTS	AS_SALES_LEADS	AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID
AS_SALES_LEAD_CONTACTS	AS_SALES_LEADS	AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID
AS_SALES_LEAD_CONTACTS	%	AS_SALES_LEAD_CONTACTS.CONTACT_ID
AS_SALES_LEAD_CONTACTS	HZ_CONTACT_POINTS	AS_SALES_LEAD_CONTACTS.PHONE_ID
AS_SALES_LEAD_CONTACTS	HZ_PARTIES	AS_SALES_LEAD_CONTACTS.CUSTOMER_ID
AS_SALES_LEAD_CONTACTS	HZ_PARTY_SITES	AS_SALES_LEAD_CONTACTS.ADDRESS_ID