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: AMS_SOURCE_CODES

Product:	AMS - Marketing
Description:	This table records the source codes for all objects in the system.
Implementation/DBA Data:	AMS.AMS_SOURCE_CODES

Primary Key: AMS_SOURCE_CODES_PK

SOURCE_CODE_ID

Primary Key: AMS_SOURCE_CODES_UK1

SOURCE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AS_LEADS_ALL	AMS_SOURCE_CODES	AS_LEADS_ALL.SOURCE_PROMOTION_ID
AS_LEAD_LINES_ALL	AMS_SOURCE_CODES	AS_LEAD_LINES_ALL.SOURCE_PROMOTION_ID
AS_SALES_LEAD_LINES	AMS_SOURCE_CODES	AS_SALES_LEAD_LINES.SOURCE_PROMOTION_ID
JTF_IH_ACTIVITIES	AMS_SOURCE_CODES	JTF_IH_ACTIVITIES.SOURCE_CODE_ID
JTF_IH_CAMPAIGNS_RESULTS	AMS_SOURCE_CODES	JTF_IH_CAMPAIGNS_RESULTS.SOURCE_CODE_ID
JTF_IH_CAMPAIGN_RESULT_REASONS	AMS_SOURCE_CODES	JTF_IH_CAMPAIGN_RESULT_REASONS.SOURCE_CODE_ID
JTF_IH_INTERACTIONS_CAMPAIGNS	AMS_SOURCE_CODES	JTF_IH_INTERACTIONS_CAMPAIGNS.SOURCE_CODE_ID
JTF_IH_INTERACTIONS	AMS_SOURCE_CODES	JTF_IH_INTERACTIONS.SOURCE_CODE_ID
JTF_IH_OUTCOMES_CAMPAIGNS	AMS_SOURCE_CODES	JTF_IH_OUTCOMES_CAMPAIGNS.SOURCE_CODE_ID
JTF_IH_WRAP_UPS	AMS_SOURCE_CODES	JTF_IH_WRAP_UPS.SOURCE_CODE_ID
JTF_IH_WRAP_UPS	AMS_SOURCE_CODES	JTF_IH_WRAP_UPS.SOURCE_CODE