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_INTERESTS_ALL

Product:	AS - Sales Foundation
Description:	Stores product interests, customer and opportunity classifications
Implementation/DBA Data:	OSM.AS_INTERESTS_ALL

Primary Key: AS_INTERESTS_ALL_PK

INTEREST_ID

Primary Key: AS_INTERESTS_PK

INTEREST_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_INTERESTS_ALL	HZ_ORG_CONTACTS	AS_INTERESTS_ALL.CONTACT_ID
AS_INTERESTS_ALL	HZ_PARTY_SITES	AS_INTERESTS_ALL.ADDRESS_ID
AS_INTERESTS_ALL	AS_LEADS_ALL	AS_INTERESTS_ALL.LEAD_ID
AS_INTERESTS_ALL	AS_INTEREST_CODES_B	AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID
AS_INTERESTS_ALL	AS_INTEREST_CODES_B	AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID
AS_INTERESTS_ALL	AS_INTEREST_TYPES_B	AS_INTERESTS_ALL.INTEREST_TYPE_ID
AS_INTERESTS_ALL	HZ_PARTIES	AS_INTERESTS_ALL.CUSTOMER_ID
AS_INTERESTS_ALL	%	AS_INTERESTS_ALL.CONTACT_ID
AS_INTERESTS_ALL	RA_CUSTOMERS	AS_INTERESTS_ALL.CUSTOMER_ID
AS_INTERESTS_ALL	RA_ADDRESSES_ALL	AS_INTERESTS_ALL.ADDRESS_ID
AS_INTERESTS_ALL	AS_LEADS_ALL	AS_INTERESTS_ALL.LEAD_ID
AS_INTERESTS_ALL	AS_INTEREST_CODES_ALL	AS_INTERESTS_ALL.PRIMARY_INTEREST_CODE_ID
AS_INTERESTS_ALL	AS_INTEREST_CODES_ALL	AS_INTERESTS_ALL.SECONDARY_INTEREST_CODE_ID
AS_INTERESTS_ALL	AS_INTEREST_TYPES_ALL	AS_INTERESTS_ALL.INTEREST_TYPE_ID