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

Product:	JTF - CRM Foundation
Description:	Intersection table where a subscription is attached to one or more templates.
Implementation/DBA Data:	JTF.JTF_UM_SUBSCRIPTION_TMPL

Primary Key: JTF_UM_SUBSCRIPTION_TMPL_PK

SUBSCRIPTION_ID
TEMPLATE_ID
EFFECTIVE_START_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_UM_SUBSCRIPTION_TMPL		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_TMPL.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_TMPL		JTF_UM_TEMPLATES_B	JTF_UM_SUBSCRIPTION_TMPL.TEMPLATE_ID