Table Name:	terr_defn
Table Number:	5003
Group:	Sales Mgr
Description:	Holds descriptions of a territory. Reserved; future
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_terr_defn

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
city	CHAR	varchar		30			City definition for territory
comments	CHAR	varchar		255			Comments about the territory
country	CHAR	varchar		40			Country definition for territory
description	CHAR	varchar		255			Description of the territory
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
exclude	LONG	tinyint				DIRECT	Is the definition an exclusion from the territory; i.e., 0=no, 1=yes
industry_type	CHAR	varchar		30			Industry definition for territory
objid	LONG	int	3			DIRECT	Internal record number
product_fam	CHAR	varchar		50			Product families covered by the territory
state	CHAR	varchar		30			State definition for territory
zipcode	CHAR	varchar		20			Zip or other postal code definition for territory

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
terr_defn2territory	MTO	territory	territory2terr_defn	Related territory

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

terr_defn

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user