Table Name:	bus_opp_role
Table Number:	5006
Group:	Sales Mgr
Description:	Gives roles which opportunities and business organizations play for one another
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_bus_opp_role

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
active	LONG	tinyint				DIRECT	Indicates whether the role is active; i.e., 0=inactive, 1=active	Search (4)
amount	DECIMAL	decimal (19,4)				CURRENCY	Currency amount the bus_org is trying to close in this opportunity	Search (3)
close_date	CLK_TIME	datetime					Attempted close date for the opportunity by the bus_org	Search (3)
comments	CHAR	varchar		255			Comments about the role	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
drop_date	CLK_TIME	datetime					Date on which the bus_org dropped out of the opportunity	Search (3)
drop_reason	CHAR	varchar		255			Reason the bus_org left the opportunity	Search (3)
focus_type	LONG	smallint				DIRECT	Object type ID of the role-player; i.e., 173=an business organizations's role, 5000=an opportunity's role	Search (4)
objid	LONG	int	3			DIRECT	Internal record number	Search (7)
products	CHAR	varchar		80			Products this bus_org is trying to sell in this opportunity	Search (3)
role_name	CHAR	varchar		80			Name of the role	Search (7)
role_type	LONG	smallint				DIRECT	Type of role for opportunity; i.e., 0=partner, 1=competitor	Search (6)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
bus_role2bus_org	MTO	bus_org	bus_org2bus_opp_role	The related business organization			Search (6)
bus_opp_role2mod_level	MTM	mod_level	mod_level2bus_opp_role	Part revisions for the opportunity		mtm_mod_level49_ bus_opp_role3	Search (2)
bus_role2opp_data	OTM	opp_data	opp_data2bus_opp_role	Responses to questions about the business organization's participation in the opportunity
opp_role2opportunity	MTO	opportunity	opp2bus_opp_role	The related opportunity			Search (6)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
bus_opp_role_ind	opp_role2opportunity:bus_role2bus_org:role_name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
bus_opp_role_ind	opp_role2opportunity, bus_role2bus_org, role_name	nonclustered, unique located on PRIMARY
ind_bus_role2bus_org	bus_role2bus_org, opp_role2opportunity, role_name	nonclustered located on PRIMARY
ind_opp_role2opportunity	opp_role2opportunity, bus_role2bus_org, role_name	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
4622	fc_acct_opp_view	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5093	busopprl_view	bus_opp_role, bus_org, opportunity
5103	bus_opp_view	bus_opp_role, bus_org, opportunity
5341	sfa_opp_v	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5479	bus_part_view	bus_opp_role, bus_org, mod_level, part_num
5480	opp_part_view	bus_opp_role, mod_level, opportunity, part_num
5486	sfa_busopp_v	bus_opp_role, bus_org, opportunity

My Recent Objects

bus_opp_role

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user