Table Name:	N_Competitors
Table Number:	5408
Group:	Configuration
Description:	Contains the defined competitors in the system. The ClearConfigurator user can select from this list of competitors those that are submitting rival bids to the client. This information is then part of the job header
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_N_Competitors

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
N_EffectiveDate	CLK_TIME	datetime				ALLOW_NULL	The first date on which the information should be used
N_ExpirationDate	CLK_TIME	datetime				ALLOW_NULL	Last date when the information should be used
N_ModificationDate	CLK_TIME	datetime				ALLOW_NULL	Date and time when the information was last modified
N_Name	CHAR	varchar		50		ALLOW_NULL	The name of the competitor
objid	LONG	int	3			DIRECT	Internal record number

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
n_compet2N_Functions	OTM	N_Functions	n_functn2N_Competitors	Functions for the competitor				function_for	N_ItemTypeId	N_ItemId
n_compet2N_Properties	OTM	N_Properties	n_propts2N_Competitors	Properties for the competitor				extension_of	N_ItemTypeId	N_ItemId
n_compet2NRW_RuleEventInfo	OTM	NRW_RuleEventInfo	nrw_ruleevnt2N_Competitors	Rule event information for the competitor				event_on	N_ItemTypeId	N_ItemId
n_compet2NRW_RuleInstances	OTM	NRW_RuleInstances	nrw_ruleinst2N_Competitors	Rule instance information for the competitor				ruleinst_for	N_ItemTypeId	N_ItemId

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I5408	N_Name	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

N_Competitors

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user