Table Name:	site
Table Number:	52
Group:	Customer Mgr
Description:	A facility or location where business activities occur and parts are located
Flags:
Baseline/Custom:	Baseline

select * from table_site

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
alert_ind	LONG	tinyint				DIRECT	When set to 1, indicates there is an alert related to the site	Search (3)
appl_type	CHAR	varchar		40			Type of application site uses an installed part for; used in service interuption report. From user-defined pop up with default name PRIMARY_USE
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
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
contr_login	CHAR	varchar		80			Reserved; not used	Search (1)
contr_passwd	CHAR	varchar		80			Reserved; not used	Search (1)
cut_date	CLK_TIME	datetime					Date/time when site started use of the installed part; used in service interuption report
depot	CHAR	varchar		80			Reserved; not used	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
district	CHAR	varchar		80			District to which the site belongs	Search (16)
external_id	CHAR	varchar		80			Reserved; not used
fax	CHAR	varchar		20			Main fax number	Search (2)
industry_type	CHAR	varchar		40			Type of industry the site is in. This is a user-defined popup with name INDUSTRY_TYPE
is_default	LONG	int	22		0	DIRECT	Determines if site is default site
is_support	LONG	int				DIRECT	Reserved; not used
logistics_type	LONG	int				DIRECT	Reserved; not used
mdbk	CHAR	varchar	25	80			Reserved; not used	Search (1)
name	CHAR	varchar		80			Name of the site	Search (86)
notes	CHAR	varchar		255			Site notes used with special consideration flag	Search (3)
objid	LONG	int	3			DIRECT	Internal record number	Search (85)
phone	CHAR	varchar		20			Main phone number	Search (2)
region	CHAR	varchar		80			Region to which the site belongs	Search (17)
ship_via	CHAR	varchar		80			Default means of shipment for the site. This is from a Clarify-defined popup list with default name SHIP_VIA	Search (2)
site_id	CHAR	varchar		80			Unique site number assigned according to auto-numbering definition	Search (71)
site_type	CHAR	varchar		4			Mnemonic representation of the integer site type field	Search (14)
spec_consid	LONG	int				DIRECT	Check box which, when checked, specifies that site information is to be displayed automatically when new case is created	Search (3)
state_code	LONG	int	26			DIRECT	Reserved; not used
state_value	CHAR	varchar	27	20			Reserved; not used
status	LONG	int			0	DIRECT	Status of site; i.e., 0=active, 1=inactive, 2=obsolete, default=0	Search (14)
type	LONG	int			1	DIRECT	Site type; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR	Search (15)
update_stamp	CLK_TIME	datetime	46			ALLOW_NULL	Date/time of last update to the site
x_marked_by	LONG	int				USER_DEFINED	Which user (objid) marked this alias?
x_no_alias	LONG	int				USER_DEFINED	If set to 1, this site cannot become an alias. If set to 0 (default), it can.	Search (1)
x_objid_master	LONG	int				USER_DEFINED	Objid of master site for this site. Indicates that this site is an alias for the master site.	Search (1)
x_res1	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (13)
x_res2	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (13)
x_res3	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (13)
x_res4	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (13)
x_res5	CHAR	varchar		20		USER_DEFINED	Restriction field	Search (13)

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
cust_loc2acd_call	OTM	acd_call	acd_call_site2site	Related ACD calls; phone calls from a site
cust_loc2act_entry	OTM	act_entry	act_entry2site	Related activity log entries for the site
cust_primaddr2address	MTO	address	primary_addr2site	Site primary address			Search (42)
cust_billaddr2address	MTO	address	bill_addr2site	Site billing address			Search (1)
cust_shipaddr2address	MTO	address	ship_addr2site	Site shipping address			Search (1)
site2alert	OTM	alert	alert2site	Alerts for the site
site2ana_score	OTM	ana_score	ana_score2site	Score for a site				score_for	key_type	key_objid
site2ana_score_a	OTM	ana_score_a	ana_score_a2site	Score for a site				score_for	key_type	key_objid
site2ana_score_b	OTM	ana_score_b	ana_score_b2site	Score for a site				score_for	key_type	key_objid
site2asaf_result	OTOF	asaf_result	asaf_result2site	Reserved; option
site2biz_cal_hdr	OTM	biz_cal_hdr	biz_cal_hdr2site	Business calendars related to the site
primary_site2blg_argmnt	OTM	blg_argmnt	primary_blg_argmnt2site	Primary billing arrangement of a site
report_site2bug	MTO	bug	bug_reporter2site	Reserved; not used
primary2bus_org	MTO	bus_org	primary_org2site	Organization which owns the site	REQUIRED		Search (10)
primary_site2bus_org	OTOF	bus_org	primary2site	Organization' primary site
site2bus_site_role	OTM	bus_site_role	bus_site_role2site	Associated business organizations for the site
site2c_site_role	OTM	c_site_role	c_site_role2site	Related contract item roles for the site
seller2case	OTM	case	case_distr2site	Cases for which the site is a reseller
cust_loc2case	OTM	case	case_reporter2site	Cases reported from the site
site2cc_contact	MTM	contact	contact_cc2site	Contacts who will be automatically CC-ed on email logs for cases and subcases for this site.	USER_DEFINED	mtm_contact50_ site66
site2contact_role	OTM	contact_role	contact_role2site	Contract roles for the site
quoted_at2contr_itm	OTM	contr_itm	quoted_at2site	Contract or quote items which are quoted at the site
covered_by2contr_itm	OTM	contr_itm	covered_by2site	For site service coverage, contract or quote items which cover the site
bill_site2contr_schedule	OTM	contr_schedule	bill_to2site	Contract schedules for which the site is billed
ship_site2contr_schedule	OTM	contr_schedule	ship_to2site	Contract schedules which the site is the ship-to site
cust_loc2contract	MTM	contract	contract2site	Contracts related to the site. Valid only for Contract Manager		mtm_site5_ contract0
site2demand_hdr	OTM	demand_hdr	open_reqst2site	Related inventory requests destined for the site
bill_site2demand_hdr	OTM	demand_hdr	bill_reqst2site	Related inventory requests billed to the site
site_attch2doc_inst	OTM	doc_inst	doc_inst2site	Documents related to the site
site2e_addr	OTM	e_addr	eaddr2site	Electronic addresses for the site
support_off2employee	OTM	employee	supp_person_off2site	Employees for whom the site is the home office
site_support2employee	MTO	employee	supp_person2site	Primary support person for the site			Search (1)
site_altsupp2employee	MTO	employee	altsupp_person2site	Alternate support person for the site
site2exc_sit_role	OTM	exc_sit_role	exc_sit_role2site	Exchange roles for the site
site2exch_protocol	MTO	exch_protocol	exch_protocol2site	Exchange protocols used for the site
partner2exchange	OTM	exchange	partner2site	Related service exchanges
site2fc_license_key	OTM	fc_license_key	fc_license_key2site		USER_DEFINED
site2interact	OTM	interact	interact2site	Interactions for this site	USER_DEFINED
site2inv_locatn	OTM	inv_locatn	inv_locatn2site	Reserved; not used
site2inv_role	OTM	inv_role	inv_role2site	Inventory location role for the site
site2notes_log	OTM	notes_log	site_notes2site		USER_DEFINED
site2order_action	OTM	order_action	order_action2site	Order action which will install a part at the site
site2order_shipping	OTM	order_shipping	order_shipping2site	Order shipped to a site
site2part_num	OTM	part_num	part_num2site	Generic parts for which the site is the OEM. Reserved; future
site2per_site_role	OTM	per_site_role	per_site_role2site	Person roles for the site
cust_loc2phone	OTM	phone	phone2site	Modems related to the site
site2price_prog	OTM	price_prog	price_prog2site	Price programs owned by the site
h_prd_lst2productbin	OTM	productbin	prdbin2site	Site configuration product bins at the site
prd_lst2productbin	OTM	productbin	direct_prdbin2site	Top-level product bins at the site
site2quick_quote	OTM	quick_quote	q_quote2site	Quick quotes for the site
site2scr_run	OTM	scr_run	scr_run2site	Script runs initiated by the site
carrier2ship_parts	OTM	ship_parts	carrier2vendor	Shipments carried by the vendor
site2shp_sit_role	OTM	shp_sit_role	shp_role2site	Ship_parts roles for the site
site2sit_csc_role	OTM	sit_csc_role	csc_role2site	Contract schedule roles for the site
site2sit_prt_role	OTM	sit_prt_role	prt_role2site	Site_part roles for the site
parent_site2site	OTM	site	child_site2site	Sites which report to the current site
child_site2site	MTO	site	parent_site2site	Parent site of the site			Search (3)
site_suppoff2site	OTM	site	support_office2site	Sites for which the current site is the support office
support_office2site	MTO	site	site_suppoff2site	Support office site of the site
alias2site	MTO	site	site2alias		USER_DEFINED
site2alias	OTM	site	alias2site		USER_DEFINED
site2site_addr_role	OTM	site_addr_role	site_addr_role2site	Additional addresses for the site
site2site_ba_role	OTM	site_ba_role	site_ba_role2site	Billing arrangement roles for a site
site2all_site_part	OTM	site_part	all_site_part2site	All parts installed or located at the site
customer2site_part	OTM	site_part	site_part2site	Related installed parts; viewable from site configuration manager form or installed parts forms. The relation is only to the top level installed part of a configuration
site2trans_record	OTM	trans_record	trans_record2site	Related extract data for the site
site2vendor_part	OTM	vendor_part	vendor_part2site	Roles played by the site for vendor parts
site2workgroup	OTM	workgroup	workgroup2site	Related workgroup (if used - workgroup may not be site related)	USER_DEFINED

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
id_index	site_id	UNIQUE
alias_s_index	alias2site

Indexes (Defined in Database):

Index Name	Fields	Additional Information
alias_s_index	alias2site	nonclustered located on PRIMARY
id_index	site_id	nonclustered, unique located on PRIMARY
ind_child_site2site	child_site2site, objid	nonclustered, unique located on PRIMARY
ind_cust_primaddr2address	cust_primaddr2address	nonclustered located on PRIMARY
ind_is_default	is_default, objid	nonclustered, unique located on PRIMARY
ind_site_name	name	nonclustered located on PRIMARY
ind_type	type, objid	nonclustered, unique located on PRIMARY
ind_update_stamp	update_stamp, objid	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
p2bo0052	primary2bus_org, objid	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
3	ship_sum	condition, demand_dtl, gbst_elm, ship_dtl, ship_parts, site
55	empl_user	address, country, employee, site, user
56	wipelm_case	case, condition, gbst_elm, site, user, wipbin, workaround
57	wipelm_subcase	condition, gbst_elm, site, subcase, user, wipbin
59	queelm_case	case, condition, gbst_elm, queue, site, user, workaround
60	queelm_subcase	condition, gbst_elm, queue, site, subcase, user
71	tr_filter_view	address, case, country, site, trans_record
88	site_view	address, bus_org, country, site
104	contr_to_cont	contact, contract, site
106	alert2objects	alert, contact, contract, site, user
107	loc_to_sub	address, site
113	slv_contct	address, country, employee, site
116	cls_case_view	case, condition, contact, employee, site, user, wipbin
148	extactcase	case, condition, contact, gbst_elm, site
149	intactcase	case, condition, employee, gbst_elm, site
166	cls_sub_view	case, condition, contact, employee, site, subcase, user, wipbin
167	cls_dfe_view	case, condition, contact, disptchfe, employee, site, user, wipbin
186	acd_case_view	case, site, user
188	location_alst	act_entry, gbst_elm, site, user
189	v_cls_case	case, condition, contact, site
190	v_cls_subc	case, condition, contact, site, subcase
191	v_cls_dfe	case, condition, contact, disptchfe, site
208	qry_case_view	case, condition, contact, gbst_elm, site, user
248	qry_subcase_view	condition, contact, gbst_elm, site, subcase, user
254	acct_team	bus_empl_role, bus_org, employee, site, user
289	rol_contct	address, bus_org, contact, contact_role, country, site, time_zone
293	site_svc_appt	appointment, gbst_elm, schedule, site, site_part
297	asaf_user_site	asaf_result, site, user
298	empl_view	employee, site, user
303	cas_secure	case, contact, contact_role, site
304	addrsitepmhpml	address, mod_level, part_num, site, site_part
342	get_child_site	address, site
396	appt_empl_user	address, employee, site, user
397	sit_prt_view	inv_bin, inv_locatn, inv_role, mod_level, part_inst, part_num, site
407	locatn_view	address, inv_locatn, inv_role, site
4608	interact_site	contact, interact, site
4612	pr_hdr_site	demand_hdr, site
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
4623	fc_acct_site_view	address, bus_org, bus_site_role, country, site
4631	fc_cm_contact	contact, contact_role, contract, site
4632	fc_cm_site	contract, site
4650	fc_user_case_view	case, condition, contact, employee, gbst_elm, queue, site, user, wipbin, workaround
4651	fc_user_subcase_view	case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
5031	acct_site_view	address, bus_site_role, country, site
5063	contr_sp_chk	condition, contr_itm, contr_schedule, contract, mod_level, site, site_part
5064	sched_sit_rol	contr_schedule, sit_csc_role, site
5065	contract_itm_lst	contr_itm, contr_schedule, mod_level, part_num, price_inst, purchase_ord, site, site_part
5066	c_schedule_view	contr_schedule, contract, price_prog, site
5074	qq_con_site	contact, contact_role, quick_quote, site
5097	c_install_part	mod_level, part_num, site, site_part
5098	bus_site_ind	bus_org, bus_site_role, industry, site
5100	svc_part_view	mod_level, part_num, sit_prt_role, site, site_part
5109	ccn_bill_view	bus_org, condition, contr_schedule, contract, currency, site, user
5143	sp_role_sp	address, mod_level, part_num, prt_prt_role, site, site_part
5144	victimcase	case, condition, contact, gbst_elm, site
5145	supercasev	case, condition, contact, gbst_elm, site
5170	qry_scasev	case, contact, gbst_elm, site, user
5177	countlocbin	count_setup, inv_bin, inv_locatn, inv_role, site
5182	site_svc_itm	condition, contr_itm, contr_schedule, contract, site
5193	contrconsite	address, contact, contact_role, contract, country, site
5194	demand_site	demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, site
5199	exch_site_v	exchange, site
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
5276	view_vpt	mod_level, part_num, site, vendor_part
5277	view_vpt_price	mod_level, price_inst, price_prog, price_qty, site, vendor_part
5279	container_v	inv_bin, inv_locatn, inv_role, site
5291	site2case_view	case, site, wipbin
5298	spart_site_srole	sit_prt_role, site, site_part
5331	v_inv_locatn	inv_locatn, inv_role, site
5338	case_display	case, condition, contact, gbst_elm, site
5340	sfaacctsite	address, bus_org, bus_site_role, country, site
5374	cnt_weblst	address, contact, contact_role, country, site, web_user
5375	cnt_lst	address, contact, contact_role, country, site
5462	wap_case_info	address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
5463	contact_web	address, contact, contact_role, country, site, web_user
5475	role_contact	address, bus_org, contact, contact_role, country, site
5482	acct_sites_view	address, bus_org, bus_site_role, country, site
5550	site_view_zone	address, bus_org, country, site, time_zone
5647	site_view2	address, bus_org, country, site
5651	svc_part_view2	mod_level, part_num, site, site_part
5652	addrsitepmhpml2	mod_level, part_num, site, site_part
5680	case_list	case, condition, contact, gbst_elm, site, user
5685	cm_contact	contact, contact_role, contract, 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
5728	bus_org_ext_vw	bus_org, bus_org_extern, site
5731	vw_case_billing	blg_argmnt, case, condition, contact, fin_accnt, gbst_elm, pay_channel, site
5734	vw_addrsitepmhpml	address, mod_level, part_num, site, site_part
5737	sit_rol_contact	bus_org, contact, contact_role, site
5738	sp_rol_site_rol_contact	con_sp_role, contact, contact_role, site, site_part
5739	case_overview	address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround
5740	case_more_info	address, case, condition, contact, country, gbst_elm, queue, site, user, wipbin
5743	busorg_bussite_vw	bus_org, bus_org_extern, bus_site_role, site
5745	sitepart_address_vw	address, site, site_part, site_part_extern
5747	prmry_busorg_site_addr	address, bus_org, bus_org_extern, country, site, state_prov
5795	site_contact_view	address, contact, contact_role, country, site
5796	order_shipping_view	address, contact, contract, country, order_action, order_shipping, site
5828	bar_rel_prim_addr_v	address, blg_argmnt, bus_org, country, e_addr, fin_accnt, site, state_prov, time_zone
5835	sr_blg_argmnt_view	blg_argmnt, site, site_ba_role
5850	fc_rol_contct	address, bus_org, contact, contact_role, country, rollup, site
6017	schdl_tracker_sub_v1	address, appointment, employee, hgsl2hgse, site, user
6018	schdl_tracker_sub_v2	address, case, disptchfe, employee, hgsl2hgse, queue, site, user, wipbin
6019	schdl_tracker_sub_v3	address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6020	schdl_tracker_sub_v4	address, disptchfe, employee, hgsl2hgse, queue, site, user
6021	schdl_tracker_sub_v5	address, disptchfe, employee, hgsl2hgse, queue, site, user
6022	schdl_tracker_sub_v6	address, appointment, employee, hgsl2hgse, site, user
6052	v_cls_subc2	contact, site, subcase
6055	order_shipping_vw	address, contract, country, order_action, order_shipping, site
6066	contr_itm_lst_vw	contr_itm, contr_schedule, contract, currency, mod_level, part_num, price_inst, purchase_ord, site, site_part
6070	contact_list	address, contact, contact_role, country, site
6073	rol_contct_v	bus_org, contact, contact_role, site

My Recent Objects

site

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