Table Name:	N_Properties
Table Number:	5418
Group:	Configuration
Description:	Holds the extended properties for items in the database. This object would have all the user-defined properties for products, options, option templates, product templates, packages, and attachments
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_N_Properties

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_BooleanValue	LONG	tinyint				DIRECT, ALLOW_NULL	If the property involves a boolean value, the value
N_CurrencyValue	DECIMAL	decimal (19,4)				ALLOW_NULL, CURRENCY	If the property involves a currency value, the value
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_IntegerValue	LONG	int				DIRECT, ALLOW_NULL	If the property involves an integer value, the value
N_ItemId	LONG	int				DIRECT, ALLOW_NULL	The ID of the item that has the property
N_ItemTypeId	LONG	int				DIRECT, ALLOW_NULL	Item type from N_ItemType table. It is used in conjunction with the N_ItemId field to identify to the item to which the property belongs
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 property
N_RealNumberValue	DECIMAL	decimal (19,4)				ALLOW_NULL	If the property involves a decimal value, the value
N_StringValue	CHAR	varchar		50		ALLOW_NULL	If the property involves a string value, the value
N_TimeStampValue	CLK_TIME	datetime				ALLOW_NULL	If the property involves a datetime value, the value
N_Type	LONG	int				DIRECT, ALLOW_NULL	The type of the property
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_propts2N_Attachments	MTO	N_Attachments	n_attach2N_Properties	For a property of an attachment the parent attachment				extension_of	N_ItemTypeId	N_ItemId
n_propts2N_Attribute	MTO	N_Attribute	attr2N_Properties	Attribute defined for the property
value2N_AttributeValue	OTM	N_AttributeValue	value2N_Properties	Attribute values that are defined for the property
n_propts2N_Competitors	MTO	N_Competitors	n_compet2N_Properties	For a property of a competitor the parent competitor				extension_of	N_ItemTypeId	N_ItemId
n_propts2N_Option	MTO	N_Option	n_optn2N_Properties	For a property of an option the parent option				extension_of	N_ItemTypeId	N_ItemId
n_propts2N_Packages	MTO	N_Packages	n_pkg2N_Properties	For a property of a competitor the parent competitor				extension_of	N_ItemTypeId	N_ItemId
n_propts2N_Product	MTO	N_Product	n_prod2N_Properties	For a property of a product the parent product				extension_of	N_ItemTypeId	N_ItemId
n_propts2N_Templates	MTO	N_Templates	n_templ2N_Properties	For a property of a template the parent template				extension_of	N_ItemTypeId	N_ItemId

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I5418	N_ItemId:N_ItemTypeId:N_Name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
I5418	N_ItemId, N_ItemTypeId, N_Name	nonclustered, unique located on PRIMARY
itid	N_ItemTypeId	nonclustered located on PRIMARY
np2na5418	n_propts2N_Attribute	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

N_Properties

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user