Table Name:	doc_inst
Table Number:	143
Group:	Workflow Mgr
Description:	Defines instance of a document. It may be an attachment to a CR, case, contract, dianostic hint, site, part, subcase, or solution. It may be a publication
Flags:
Baseline/Custom:	Baseline

select * from table_doc_inst

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
deleted	LONG	int			0	DIRECT	Indicates if document has been deleted. Reserved; future	Search (2)
description	CHAR	varchar		255			The description of the document	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
keywords	CHAR	varchar		255			Keywords for the document; used with FTS	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (7)
title	CHAR	varchar		40			Document title	Search (7)
x_table	CHAR	varchar		64		USER_DEFINED	Attachment Table
x_table_objid	LONG	int				USER_DEFINED	Row (objid) in the attached table

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	Used in Views
doc_inst2act_entry	OTM	act_entry	act_entry2doc_inst	Activity logs related to the document. Reserved; future
doc_inst2bug	MTO	bug	bug_attach2doc_inst	Change request related to the document		Search (1)
doc_inst2bus_org	MTO	bus_org	org_attach2doc_inst	Account using the document
doc_inst2campaign	MTO	campaign	campaign2doc_inst	Campaign using the document
doc_inst2case	MTO	case	case_attch2doc_inst	Case related to the document		Search (1)
doc_inst2communication	MTO	communication	cmcn2doc_inst	Communication having the attachment
doc_inst2contact	MTO	contact	contact2doc_inst	Contact having the attachment. Reserved; future
doc_inst2contract	MTO	contract	contract_attch2doc_inst	Contract related to the document		Search (1)
doc_inst2demand_dtl	MTO	demand_dtl	demand_dtl2doc_inst		USER_DEFINED
doc_inst2demand_hdr	MTO	demand_hdr	hdr_attach2doc_inst	Part request header using the document
doc_info2diag_hint	MTO	diag_hint	hint_attch2doc_inst	Diagnostic hint related to the document. Reserved; not used
attach_info2doc_path	MTO	doc_path	doc_locate2doc_inst	File path which is used to access the document		Search (7)
doc_inst2eco_dtl	MTO	eco_dtl	eco_dtl2doc_inst	ECO details using the document
doc_inst2eco_hdr	MTO	eco_hdr	eco_hdr2doc_inst	ECO using the document
doc_inst2email_log	MTO	email_log	email_log2doc_inst	Email having the attachment
doc_inst2fr_agrmnt	MTO	fr_agrmnt	fr_agrmnt2doc_inst	Framework agreement having the attachment
doc_inst2interact	MTO	interact	interact2doc_inst	Interaction using the document
doc_inst2lead	MTO	lead	lead2doc_inst	Lead having the attachment
doc_inst2lit_req	MTO	lit_req	lit_req2doc_inst	Literature request templates using the document
doc_inst2lit_ship_req	MTO	lit_ship_req	lit_ship_req2doc_inst	Shipment containing the document
doc_inst2mod_level	MTO	mod_level	part_attach2doc_inst	Part revision using the document
doc_inst2offering	MTO	offering	offering2doc_inst	Offering having the attachment
doc_inst2opportunity	MTO	opportunity	opp2doc_inst	Opportunity having the attachment
doc_inst2site	MTO	site	site_attch2doc_inst	Site which is related to the document
doc_inst2site_part	MTO	site_part	site_part2doc_inst	Installed part which is related to the document
doc_inst2subcase	MTO	subcase	subcase_attch2doc_inst	Subcase which is related to the document		Search (1)
doc_inst2task	MTO	task	task2doc_inst		USER_DEFINED
doc_inst2template	MTO	template	tmplt2doc_inst	Template having the attachment
attachment2workaround	MTO	workaround	wa_attch2doc_inst	Workaround which is related to the document		Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
new_id_ind	x_table_objid

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ai2dp0143	attach_info2doc_path	nonclustered located on PRIMARY
ind_attachment2workaround	attachment2workaround, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2bug	doc_inst2bug, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2case	doc_inst2case, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2communication	doc_inst2communication, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2contact	doc_inst2contact, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2contract	doc_inst2contract, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2eco_dtl	doc_inst2eco_dtl, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2eco_hdr	doc_inst2eco_hdr, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2email_log	doc_inst2email_log, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2lead	doc_inst2lead, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2lit_req	doc_inst2lit_req, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2lit_ship_req	doc_inst2lit_ship_req, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2opportunity	doc_inst2opportunity, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2site	doc_inst2site, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2subcase	doc_inst2subcase, objid	nonclustered, unique located on PRIMARY
ind_doc_inst2template	doc_inst2template, objid	nonclustered, unique located on PRIMARY
new_id_ind	x_table_objid	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
367	case_attch	case, doc_inst, doc_path
368	subc_attch	doc_inst, doc_path, subcase
369	bug_attch	bug, doc_inst, doc_path
370	pd_attch	doc_inst, doc_path, probdesc, workaround
5354	sfa_attch_v	doc_inst, doc_path
5483	sfa_attch_view	doc_inst, doc_path
5687	contr_attch	contract, doc_inst, doc_path

My Recent Objects

doc_inst

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog