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_LEAD_CONTACTS_ALL

Product:	AS - Sales Foundation
Description:	Contains contacts linked to sales opportunities
Implementation/DBA Data:	OSM.AS_LEAD_CONTACTS_ALL

Primary Key: AS_LEAD_CONTACTS_ALL_PK

LEAD_CONTACT_ID

Primary Key: AS_LEAD_CONTACTS_PK

LEAD_CONTACT_ID

Primary Key: AS_LEAD_CONTACTS_UK

CONTACT_ID
LEAD_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_LEAD_CONTACTS_ALL	AS_LEADS_ALL	AS_LEAD_CONTACTS_ALL.LEAD_ID
AS_LEAD_CONTACTS_ALL	HZ_PARTIES	AS_LEAD_CONTACTS_ALL.CONTACT_PARTY_ID
AS_LEAD_CONTACTS_ALL	HZ_PARTY_SITES	AS_LEAD_CONTACTS_ALL.ADDRESS_ID
AS_LEAD_CONTACTS_ALL	HZ_PARTIES	AS_LEAD_CONTACTS_ALL.CUSTOMER_ID
AS_LEAD_CONTACTS_ALL	HZ_CONTACT_POINTS	AS_LEAD_CONTACTS_ALL.PHONE_ID
AS_LEAD_CONTACTS_ALL	HZ_ORG_CONTACTS	AS_LEAD_CONTACTS_ALL.CONTACT_ID
AS_LEAD_CONTACTS_ALL	AS_LEADS_ALL	AS_LEAD_CONTACTS_ALL.LEAD_ID
AS_LEAD_CONTACTS_ALL	RA_PHONES	AS_LEAD_CONTACTS_ALL.PHONE_ID
AS_LEAD_CONTACTS_ALL	%	AS_LEAD_CONTACTS_ALL.CONTACT_ID