Table Name:	prt_domain
Table Number:	331
Group:	Product Mgr
Description:	Determines system-handling rules for parts, which govern; e.g., uniqueness of serial numbers, installation at sites, inclusion in BOM and catalogs
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_prt_domain

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
at_domain	LONG	int				DIRECT	Restricts parts in the domain to be installed only under parts in the domain specified by inc_domain; i.e., 0=no, 1=yes
at_part	LONG	int				DIRECT	Allow parts in the domain to be installed under other parts in the Site Configuration Manager; i.e., 0=no, 1=yes
at_site	LONG	int				DIRECT	Allow parts in the domain to be installed at the top level of the Site Configuration Manager; i.e., 0=no, 1=yes
boms	LONG	int				DIRECT	Allow parts in the domain to be included in BOMs; i.e., 0=no, 1=yes
catalogs	LONG	int				DIRECT	Allow parts in the domain to be included in catalogs; i.e., 0=no, 1=yes
description	CHAR	varchar		255			A description of the domain
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
inc_domain	CHAR	varchar		40			Parts with at_domain=1 can only be installed under parts in the domain in Site Configuration Manager
is_at_bus_org	LONG	tinyint			0	DIRECT, ALLOW_NULL	Indicates group level products, to allow parts in the domain to be related to a bus_org. 1=Yes, 0=No; Default=0
is_service	LONG	int				DIRECT	Indicates the part is a service part, if selected, sit_prt_role will be set when installed; i.e., 0=not a service, 1=a service
literature	LONG	tinyint			0	DIRECT	Indicates whether part is a literature part; 0=no, 1=yes. Marketing collateral is an example of a literature part
name	CHAR	varchar		40			The name of the domain
objid	LONG	int	3			DIRECT	Internal record number
pt_used_bom	LONG	int				DIRECT	During parts used transactions, force part installation to conform to BOM; i.e., 0=no, 1=yes
pt_used_dom	LONG	int				DIRECT	Apply domain rules during parts-used transactions; i.e., 0=no, 1=yes
pt_used_warn	LONG	int				DIRECT	Reserved; not used
serialno	LONG	int				DIRECT	Degree of uniqueness of part serial number; i.e., 0=no serial numbers, tracked only by quantity, 1=unique serial numbers across all part numbers, 2=unique serial numbers only within a part number, 3=serial numbers don't need to be unique
unique_sn	LONG	int				DIRECT	For any given site, serial number must be unique for all part numbers; i.e., 0=no, 1=yes

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
domain2part_num	OTM	part_num	part_num2domain	Parts which belong to the domain
to_domain2domain	MTM	prt_domain	from_domain2domain	Related included domain; builds parent-child relationships between domains; this is the parent		mtm_prt_domain2_ prt_domain1
from_domain2domain	MTM	prt_domain	to_domain2domain	Related included parts; builds parent-child relationships between domains; this is the child		mtm_prt_domain1_ prt_domain2

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
name_index	name	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

prt_domain

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user