FND Design Data [Home] [Help]

Table: JTF_UM_USERTYPE_TMPL

Product: JTF - CRM Foundation
Description: Intersection table where a usertype is attached to one or more templates.
Implementation/DBA Data: TableJTF.JTF_UM_USERTYPE_TMPL
Primary Key: JTF_UM_USERTYPE_TMPL_PK
  1. ColumnUSERTYPE_ID
  2. ColumnTEMPLATE_ID
  3. ColumnEFFECTIVE_START_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_UM_USERTYPE_TMPL FK Joins to TableJTF_UM_USERTYPES_B JTF_UM_USERTYPE_TMPL.USERTYPE_ID
JTF_UM_USERTYPE_TMPL FK Joins to TableJTF_UM_TEMPLATES_B JTF_UM_USERTYPE_TMPL.TEMPLATE_ID