Table Name:	bus_org
Table Number:	173
Group:	Sales Mgr
Description:	A business entity which has roles and responsibilities that need to be tracked
Flags:
Baseline/Custom:	Baseline

select * from table_bus_org

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
alt_name	CHAR	varchar		80			An alternate name for the organization
alt_url	CHAR	varchar		255			Alternate URL for the account. Reserved; future
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
blg_cust_type	CHAR	varchar		20		ALLOW_NULL	Customer billing type - as apears in the billing system	Search (2)
blg_enabled_ind	LONG	smallint			0	DIRECT, ALLOW_NULL	Indicates billing is enabled; 0=Not enabled, 1=enabled; Default=0	Search (2)
blg_evt_gen_sts	LONG	int			0	DIRECT, ALLOW_NULL	Billing event status;0=No event necessary or event already sent, 1=create event pending, 2=update event pending;Default=0
bus_node	LONG	tinyint			0	DIRECT, ALLOW_NULL	Indicates whether the bus_org is a Customer or Organizational Unit ; i.e. 0=Organizational Unit, 1=Customer	Search (4)
business_desc	CHAR	varchar		255			Describes the purpose of the organization or the business it is in	Search (3)
collectn_sts	CHAR	varchar		20		ALLOW_NULL	Collection status for a customer
comments	CHAR	varchar		255			Additional comments about the organization
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
e_mail	CHAR	varchar		80			Primary e-mail address of the organization
fax	CHAR	varchar		20			Main fax number of the organization	Search (3)
fed_tax_id	CHAR	varchar		40			Account's federal tax idenfification number
is_competitor	LONG	tinyint			0	DIRECT, ALLOW_NULL	Indicates whether the bus_org is a competitor; i.e., 0=No, 1=Yes	Search (1)
is_partner	LONG	tinyint			0	DIRECT, ALLOW_NULL	Indicates whether the bus_org is a partner; i.e., 0=No, 1=Yes	Search (1)
loc_type	CHAR	varchar		80			Location type; e.g., headquarters, subsidiary, etc. This is a user-defined pop up
name	CHAR	varchar	2	80			Name of the organization	Search (61)
objid	LONG	int	3			DIRECT	Internal record number	Search (74)
org_id	CHAR	varchar		40			User-specified ID number of the organization	Search (40)
ownership	CHAR	varchar		40			Type of ownership. This is a user-defined popup with default name Company Ownership
phone	CHAR	varchar		20			Main phone number of the organization	Search (5)
product	CHAR	varchar		255			A high-level description of the products that the business organization sells
revn_range	CHAR	varchar		40			Revenue range of the bus_org. This is a user-defined popup with default name Company Revenue	Search (4)
sales_tax_id	CHAR	varchar		40			Account's sales tax idenfification number
size_empl	CHAR	varchar		40			Estimated number of employees in the organization	Search (3)
size_revn	LONG	int				DIRECT	Estimated company revenue
standards	CHAR	varchar		25			Standards the business organization adheres to; e.g., ISO 9000
status	LONG	tinyint			0	DIRECT	Status of bus_org; i.e., 0=active, 1=inactive, 2=obsolete, default=0	Search (4)
stock_sym	CHAR	varchar		10			Stock symbol	Search (1)
struct_type	LONG	tinyint			0	DIRECT	The scope of the account; i.e., 0=business to business account, 1=business to consumer account, default=0.
tax_exempt	CHAR	varchar		25			Reserved not used; see account
tax_exempt_start_dt	CLK_TIME	datetime				ALLOW_NULL	Date Tax exemption is started
type	CHAR	varchar		40			Business type; e.g., competitor, prospect, customer. This is a user-defined pop up with default name Company Type	Search (16)
update_stamp	CLK_TIME	datetime	46			ALLOW_NULL	Date/time of last update to the bus_org
web_site	CHAR	varchar		255			The URL of the main web page of the organization	Search (6)
year_end	CHAR	varchar		25			Fiscal year end
year_start	CHAR	varchar		25			Fiscal year start

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
							Exclusive Set Relations
bus_org2account	OTOF	account	account2bus_org	For business organizations which are also accounts, the related account object. Reserved; obsolete
bus_primary2address	MTO	address	bus_primary2bus_org	Primary address of the business organization. Reserved; not used. Gets addresses from related sites
bus_org2alert	OTM	alert	alert2bus_org	Alerts on the bus_org
bus_org2ana_score	OTM	ana_score	ana_score2bus_org	Score for an organization			score_for	key_type	key_objid
bus_org2ana_score_a	OTM	ana_score_a	ana_score_a2bus_org	Score for an organization			score_for	key_type	key_objid
bus_org2ana_score_b	OTM	ana_score_b	ana_score_b2bus_org	Score for an organization			score_for	key_type	key_objid
primary2blg_argmnt	OTOP	blg_argmnt	primary_ba2bus_org	Primary billing arrangement of the customer		Search (1)
parent2blg_argmnt	OTM	blg_argmnt	ba_parent2bus_org	Related parent billing arrangement
child2blg_argmnt	OTM	blg_argmnt	ba_child2bus_org	Related child billing arrangement
bus_org2bus_addr_role	OTM	bus_addr_role	bus_addr_role2bus_org	Addresses for the business organization. Reserved; future
role_for2bus_bus_role	OTM	bus_bus_role	role_for2bus_org	Roles received from other business organizations. Not used; available for custom use
player2bus_bus_role	OTM	bus_bus_role	player2bus_org	Roles played for other business organizations. Not used; available for custom use
org2bus_empl_role	OTM	bus_empl_role	bus_empl_role2bus_org	Employee roles for the business organization. Reserved; obsolete. Replaced by usr_bus_role
bus_org2bus_led_role	OTM	bus_led_role	bus_led_role2bus_org	Lead roles involving a bus_org
org2bus_lsc_role	OTM	bus_lsc_role	bus_lsc2bus_org	Lead source roles for the account
bus_org2bus_opp_role	OTM	bus_opp_role	bus_role2bus_org	Opportunity roles for the business organization
bus_org2bus_org_extern	OTM	bus_org_extern	bus_org_extern2bus_org	External system key related to bus_org
bus_org2bus_per_role	OTM	bus_per_role	bus_per_role2bus_org	Roles received from other business organizations. Reserved; obsolete
bus_org2bus_prf_role	OTM	bus_prf_role	bu_pf_role2bus_org	Price factor roles for the account
bus_org2bus_prt_role	OTM	bus_prt_role	bus_prt_role2bus_org	Installed part roles for the business organization. Reserved; not used
parent2bus_rol_itm	OTM	bus_rol_itm	parent2bus_org	Related parent rollup items
child2bus_rol_itm	OTM	bus_rol_itm	child2bus_org	Related child rollup items
bus_org2bus_site_role	OTM	bus_site_role	bus_site_role2bus_org	Site roles for the business organization
buyer2contract	OTM	contract	sell_to2bus_org	Deals for which the bus_org is the buyer
bus_org2ct_bus_role	OTM	ct_bus_role	ct_bus_role2bus_org	Contact roles for the business organization
org_attach2doc_inst	OTM	doc_inst	doc_inst2bus_org	Attachments to the bus_org
bus_org2e_addr	OTM	e_addr	eaddr2bus_org	Electronic addresses for the business organization
parent2fin_accnt	OTM	fin_accnt	fa_parent2bus_org	Related parent financial account
child2fin_accnt	OTM	fin_accnt	fa_child2bus_org	Related child financial account
bus_org2fr_agr_bus_role	OTM	fr_agr_bus_role	fr_agr_bus_role2bus_org	Framework agreement roles for customer (bus_org)
bus_org2frcst_itm	OTM	frcst_itm	item2bus_org	Forecast detail for the account. Reserved future
bus_org2frcst_target	OTM	frcst_target	frcst2bus_org	Forecast target for the account. Reserved; future
bus_industry2industry	MTM	industry	bus_industry2bus_org	Industries in which the business organization operates	mtm_bus_org13_ industry0
bus_org2intrxn	OTM	intrxn	intrxn2bus_org	Interaction created for an organization (account)
bus_org2lit_ship_req	OTM	lit_ship_req	lit_ship_req2bus_org	Related sales literature shipments
bus_org2opp_analysis	OTM	opp_analysis	analysis2bus_org	Related opportunity analyses
bus_org2order_action	OTM	order_action	order_action2bus_org	Order action for an organization (account)
bus_org2org_ter_role	OTM	org_ter_role	org_ter_role2bus_org	Sales territory roles for the business organization. Reserved; future
parent2pay_channel	OTM	pay_channel	pc_parent2bus_org	Related parent pay channel
child2pay_channel	OTM	pay_channel	pc_child2bus_org	Related child pay channel
bus_org2pay_means	OTM	pay_means	pay_means2bus_org	Payment means belonging to the bus_org
bus_org2pp_bucket	OTM	pp_bucket	pp_bucket2bus_org	Pre-paid bucket belongs to an organization
primary2pp_bucket	OTOP	pp_bucket	primary_ppb2bus_org	Primary pre-paid bucket belongs to an organization
defaultbus2price_prog	MTO	price_prog	defaultbus2bus_org	The default price book for the account
bus_org2req_to_extern	OTM	req_to_extern	req_to_extern2bus_org	Request can be related to a bus_org
dflt_blg_hrchy2rollup	MTO	rollup	dflt_blg_hrchy2bus_org	This will enable us to retrieve all accounts associated with a hierarchy and use that as a filter for other objects of interest		Search (2)
bus_org2scr_run	OTM	scr_run	scr_run2bus_org	Script runs initiated by the business organization
primary_org2site	OTM	site	primary2bus_org	Sites for which the organization is the owner
primary2site	OTOP	site	primary_site2bus_org	Primary site for the organization		Search (4)
receiver_org2task	OTM	task	task_for2bus_org	Tasks performed for the business organization
prospect2territory	MTO	territory	prospect2bus_org	Territory to which the organization is assigned
bus_org2user_touch	OTM	user_touch	user_touch2bus_org	Last user touches for the account			touched_by	source_type	source_lowid
bus_org2usr_bus_role	OTM	usr_bus_role	usr_bus_role2bus_org	User roles for the account

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
bus_org_index	org_id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
bus_org_index	org_id	nonclustered, unique located on PRIMARY
ind_name	name	nonclustered located on PRIMARY
ind_prospect2territory	prospect2territory	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
p2ba0173	primary2blg_argmnt	nonclustered located on PRIMARY
p2s0173	primary2site	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
88	site_view	address, bus_org, country, site
254	acct_team	bus_empl_role, bus_org, employee, site, user
289	rol_contct	address, bus_org, contact, contact_role, country, site, time_zone
4615	fc_case_view	bus_org, bus_site_role, case, condition, contact, gbst_elm, site, user
4616	fc_contract_view	bus_org, bus_site_role, contract, site
4618	fc_site_part_view	bus_org, bus_site_role, mod_level, part_num, site, site_part
4619	fc_bug_view	bug, bus_org, bus_site_role, case, gbst_elm, mod_level, part_num, probdesc, site, workaround
4620	fc_acct_ind_view	bus_org, industry
4621	fc_acct_task_view	bus_org, condition, gbst_elm, task, user
4622	fc_acct_opp_view	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
4623	fc_acct_site_view	address, bus_org, bus_site_role, country, site
4627	fc_quote_view	bus_org, contact, contract, currency, gbst_elm, user
5050	qry_ccn_hdr_view	bus_org, condition, contact, contract, gbst_elm, user
5077	task_con	bus_org, condition, contact, gbst_elm, opportunity, task, user
5093	busopprl_view	bus_opp_role, bus_org, opportunity
5098	bus_site_ind	bus_org, bus_site_role, industry, site
5103	bus_opp_view	bus_opp_role, bus_org, opportunity
5109	ccn_bill_view	bus_org, condition, contr_schedule, contract, currency, site, user
5162	busorg_quote_v	bus_org, contract
5168	oppanly_v	bus_org, opp_analysis, opportunity
5217	ccc_rundsply	bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5322	bus_lsc_view	bus_lsc_role, bus_org, lead_source
5340	sfaacctsite	address, bus_org, bus_site_role, country, site
5341	sfa_opp_v	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5343	sfa_quote_v	bus_org, contact, contract, currency, gbst_elm, user
5344	sfa_frcst_v	bus_org, currency, frcst_itm, opportunity, territory, user
5347	sfa_target	bus_org, currency, frcst_target, gbst_elm, territory, user
5348	sfa_acct_tm	bus_org, contact, employee, user, usr_bus_role
5352	sfa_bus_rol	bus_org, bus_rol_itm, rollup
5359	sfa_tsk_mto_v	bus_org, contact, lead, lit_req, opportunity, task
5460	ctct_web_acct_vw	bus_org, contact, ct_bus_role, web_user
5475	role_contact	address, bus_org, contact, contact_role, country, site
5478	sales_quote_v	bus_org, condition, contact, contract, currency, gbst_elm, opportunity, user
5479	bus_part_view	bus_opp_role, bus_org, mod_level, part_num
5482	acct_sites_view	address, bus_org, bus_site_role, country, site
5486	sfa_busopp_v	bus_opp_role, bus_org, opportunity
5487	sfa_busled_v	bus_led_role, bus_org, lead
5550	site_view_zone	address, bus_org, country, site, time_zone
5647	site_view2	address, bus_org, country, site
5690	site_view_more	address, bus_org, country, site, time_zone
5707	sfa_site_dtl_vw	address, bus_org, bus_site_role, country, site, time_zone
5713	busorg_site_addr_vw	address, bus_org, bus_org_extern, country, site, state_prov
5714	blg_argmnt_addr_vw	addr_ba_role, address, blg_argmnt, bus_org, bus_org_extern, country, state_prov
5723	vw_pbus_org_fin_accnt	bus_org, fin_accnt, fin_accnt_extern
5724	vw_bus_org_fin_accnt	bus_org, fin_accnt, fin_accnt_extern
5725	vw_pbus_org_blg_argmnt	blg_argmnt, blg_argmnt_extern, bus_org
5726	vw_bus_org_blg_argmnt	blg_argmnt, blg_argmnt_extern, bus_org
5727	vw_bi_bus_rol	bus_org, bus_rol_itm, rollup
5728	bus_org_ext_vw	bus_org, bus_org_extern, site
5729	bus_org_hrc_vw	bus_org, bus_org_extern, bus_rol_itm, rollup
5730	vw_bus_org_pay_chnl	bus_org, pay_channel, pay_chnl_extern
5736	vw_pbus_org_pay_chnl	bus_org, pay_channel, pay_chnl_extern
5737	sit_rol_contact	bus_org, contact, contact_role, site
5743	busorg_bussite_vw	bus_org, bus_org_extern, bus_site_role, site
5747	prmry_busorg_site_addr	address, bus_org, bus_org_extern, country, site, state_prov
5783	order_list_v	bus_org, condition, contact, contract, gbst_elm
5786	agr_bus_v	bus_org, fr_agr_bus_role, fr_agrmnt
5809	fr_agreement_details_v	bus_org, fr_agr_bus_role, fr_agrmnt, user
5818	con_ba_role_view	blg_argmnt, bus_org, con_blg_argmnt_role, contact
5819	ba_bi_role_view	ba_bi_role, billable_itm, blg_argmnt, bus_org, site_part
5827	bar_busorg_fa_pm_eaddr_v	blg_argmnt, bus_org, e_addr, fin_accnt, pay_means
5828	bar_rel_prim_addr_v	address, blg_argmnt, bus_org, country, e_addr, fin_accnt, site, state_prov, time_zone
5836	bus_org_blg_rel_items	bus_org
5838	req_to_extern_view	blg_argmnt, bus_org, fin_accnt, pay_means, pp_bucket, rechrg_instrn, req_to_extern
5849	account_interaction	bus_org, channel_inst, contact, intrxn, medium
5850	fc_rol_contct	address, bus_org, contact, contact_role, country, rollup, site
5851	account_work	bus_org
5852	edr_cntct_acct	bus_org, contact, e_addr
5859	interaction_overview	bus_org, channel, contact, intrxn, medium
5871	sp_bus_con_view	bus_org, con_sp_role, contact, site_part
5955	search_intrxn	bus_org, contact, intrxn, medium, topic
6030	cont_subs_for_sim	bus_org, bus_site_role, con_sp_role, contact, site_part
6031	sp_orders_v	bus_org, condition, contact, contract, gbst_elm, order_action, order_line, site_part
6048	bus_org_subscription	bus_org, bus_prt_role, site_part
6071	bus_org_view	bus_org, rollup
6073	rol_contct_v	bus_org, contact, contact_role, site

My Recent Objects

bus_org

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