Table: JTF_LOC_TYPES_B

Product:	JTF - CRM Foundation
Description:	Stores location types, like CITY and STATE.
Implementation/DBA Data:	JTF.JTF_LOC_TYPES_B

Primary Key: JTF_LOCATION_TYPES_B_UK1

1. LOCATION_TYPE_CODE

Primary Key: JTF_LOC_TYPES_B_PK

1. LOCATION_TYPE_ID

Primary Key: JTF_LOC_TYPES_B_UK1

1. LOCATION_TYPE_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_ACT_GEO_AREAS		JTF_LOC_TYPES_B	AMS_ACT_GEO_AREAS.GEO_AREA_TYPE_CODE
JTF_LOC_AREAS_B		JTF_LOC_TYPES_B	JTF_LOC_AREAS_B.LOCATION_TYPE_CODE
JTF_LOC_HIERARCHIES_B		JTF_LOC_TYPES_B	JTF_LOC_HIERARCHIES_B.LOCATION_TYPE_CODE
JTF_LOC_TYPES_TL		JTF_LOC_TYPES_B	JTF_LOC_TYPES_TL.LOCATION_TYPE_ID