Table: JTF_TERR_ALL

Product:	JTF - CRM Foundation
Description:	Stores the definition of the territories. There are 3 categories of territories, Standard, Escalation and Template. Information stored in this table also includes comment about this territory, effective dates, and what type of territory it
Implementation/DBA Data:	JTF.JTF_TERR_ALL

Primary Key: JTF_TERR_ALL_PK

1. TERR_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_TERR_ALL		JTF_TERR_ALL	JTF_TERR_ALL.PARENT_TERRITORY_ID
JTF_TERR_ALL		JTF_TERR_ALL	JTF_TERR_ALL.TEMPLATE_TERRITORY_ID
JTF_TERR_ALL		JTF_TERR_ALL	JTF_TERR_ALL.ESCALATION_TERRITORY_ID
JTF_TERR_ALL		JTF_TERR_TYPES_ALL	JTF_TERR_ALL.TERRITORY_TYPE_ID
AMS_BASE_SALES_VOL_ALL		JTF_TERR_ALL	AMS_BASE_SALES_VOL_ALL.MRKT_LEVEL_VALUE
AS_TERRITORY_ACCESSES		JTF_TERR_ALL	AS_TERRITORY_ACCESSES.TERRITORY_ID
AS_TERR_RESOURCES_TMP		JTF_TERR_ALL	AS_TERR_RESOURCES_TMP.TERR_ID
CSF_PLAN_TERRS		JTF_TERR_ALL	CSF_PLAN_TERRS.TERR_ID
CSS_DEF_AUDIT_HISTORY_B		JTF_TERR_ALL	CSS_DEF_AUDIT_HISTORY_B.TERRITORY_ID
CSS_DEF_DEFECTS_B		JTF_TERR_ALL	CSS_DEF_DEFECTS_B.TERRITORY_ID
JTF_CHANGED_TERR_ALL		JTF_TERR_ALL	JTF_CHANGED_TERR_ALL.TERR_ID
JTF_EXCEPTIONS_ALL		JTF_TERR_ALL	JTF_EXCEPTIONS_ALL.TERR_ID
JTF_TERR_ALL		JTF_TERR_ALL	JTF_TERR_ALL.PARENT_TERRITORY_ID
JTF_TERR_ALL		JTF_TERR_ALL	JTF_TERR_ALL.TEMPLATE_TERRITORY_ID
JTF_TERR_ALL		JTF_TERR_ALL	JTF_TERR_ALL.ESCALATION_TERRITORY_ID
JTF_TERR_QTYPE_USGS_ALL		JTF_TERR_ALL	JTF_TERR_QTYPE_USGS_ALL.TERR_ID
JTF_TERR_QUAL_ALL		JTF_TERR_ALL	JTF_TERR_QUAL_ALL.TERR_ID
JTF_TERR_RSC_ALL		JTF_TERR_ALL	JTF_TERR_RSC_ALL.TERR_ID
JTF_TERR_USGS_ALL		JTF_TERR_ALL	JTF_TERR_USGS_ALL.TERR_ID
JTF_TTY_TERR_GROUPS		JTF_TERR_ALL	JTF_TTY_TERR_GROUPS.PARENT_TERR_ID
OKR_IP_RELEASES		JTF_TERR_ALL	OKR_IP_RELEASES.TERR_ID