FND Design Data [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: TableOSM.AS_SALES_LEAD_CONTACTS
Primary Key: AS_SALES_LEAD_CONTACTS_PK
  1. ColumnLEAD_CONTACT_ID
Primary Key: AS_SALES_LEAD_CONTACTS_UK
  1. ColumnSALES_LEAD_ID
  2. ColumnCONTACT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_SALES_LEAD_CONTACTS FK Joins to TableAS_SALES_LEADS AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID
AS_SALES_LEAD_CONTACTS FK Joins to TableAS_SALES_LEADS AS_SALES_LEAD_CONTACTS.SALES_LEAD_ID
AS_SALES_LEAD_CONTACTS FK Joins to Table% AS_SALES_LEAD_CONTACTS.CONTACT_ID
AS_SALES_LEAD_CONTACTS FK Joins to TableHZ_CONTACT_POINTS AS_SALES_LEAD_CONTACTS.PHONE_ID
AS_SALES_LEAD_CONTACTS FK Joins to TableHZ_PARTIES AS_SALES_LEAD_CONTACTS.CUSTOMER_ID
AS_SALES_LEAD_CONTACTS FK Joins to TableHZ_PARTY_SITES AS_SALES_LEAD_CONTACTS.ADDRESS_ID