Table Name:	N_Packages
Table Number:	5416
Group:	Configuration
Description:	A group of options that can be added to a product as a single selection and priced as one option
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_N_Packages

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_Description	CHAR	varchar		50		ALLOW_NULL	Description of the package
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_ListPrice	DECIMAL	decimal (19,4)				ALLOW_NULL, CURRENCY	The list price of the package
N_ModificationDate	CLK_TIME	datetime				ALLOW_NULL	Date and time when the information was last modified
N_PartNumber	CHAR	varchar		50		ALLOW_NULL	The part number of the package
N_PricebookObjid	LONG	int				DIRECT, ALLOW_NULL	Price_prog internal record number
N_PriceQty	LONG	int			1	DIRECT, ALLOW_NULL	The quantity of the priced part being quoted. Default=1
N_PriceQtyContext	LONG	int				DIRECT, ALLOW_NULL	Price_qty context mod_level internal record number
N_TemplateId	LONG	int				DIRECT, ALLOW_NULL	The ID of the template associated with the package. Reserved; obsolete
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_pkg2N_CategoryMembers	OTM	N_CategoryMembers	n_catmems2N_Packages	Category members for the package				member_of	N_ItemTypeId	N_ItemId
n_pkg2N_Functions	OTM	N_Functions	n_functn2N_Packages	Functions for the package				function_for	N_ItemTypeId	N_ItemId
n_pkg2N_PackageMembers	OTM	N_PackageMembers	n_pkgmems2N_Packages	Category members for the package
n_pkg2N_Properties	OTM	N_Properties	n_propts2N_Packages	Properties for the package				extension_of	N_ItemTypeId	N_ItemId
n_pkg2N_Templates	MTO	N_Templates	n_templ2N_Packages	The package's template
n_pkg2NRW_RuleEventInfo	OTM	NRW_RuleEventInfo	nrw_ruleevnt2N_Packages	Rule event information for the package				event_on	N_ItemTypeId	N_ItemId
n_pkg2NRW_RuleInstances	OTM	NRW_RuleInstances	nrw_ruleinst2N_Packages	Rule instance information for the package				ruleinst_for	N_ItemTypeId	N_ItemId

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I5416	N_PartNumber	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
I5416	N_PartNumber	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
p2tm	n_pkg2N_Templates	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

N_Packages

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user