Table Name:	industry
Table Number:	5004
Group:	Sales Mgr
Description:	A classification for business organizations that can be used to identify and group similar organizations. Standard Industry Codes (SIC Codes) are a classification system from the U.S. government
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_industry

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
description	CHAR	varchar		255			Description of the industry	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
ind_type	CHAR	varchar		40			Industry type. This is a user-defined popup with default name Sales Industry Type	Search (1)
name	CHAR	varchar	2	80			Name of the industry	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
sic_code	CHAR	varchar		25			Industry (sic) code or equivalent	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
bus_industry2bus_org	MTM	bus_org	bus_industry2industry	Related Business organizations		mtm_bus_org13_ industry0	Search (2)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
ind_name_index	name	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
4620	fc_acct_ind_view	bus_org, industry
5098	bus_site_ind	bus_org, bus_site_role, industry, site

My Recent Objects

industry

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user