Table Name:	inv_locatn
Table Number:	228
Group:	Logistics
Description:	A physical inventory location or a general ledger account
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_inv_locatn

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
active	LONG	int			1	DIRECT	Indicates whether the inventory location is active; i.e., 0=inactive, 1=active, default=1	Search (3)
d_bad_qty	LONG	smallint			0	DIRECT	Display-only field. Used at run time by views which display bad part quantity information. No data is stored in the field	Search (1)
d_good_qty	LONG	smallint			0	DIRECT	Display-only field. Used at run time by views which display good part quantity information. No data is stored in the field	Search (1)
default_location	LONG	smallint			0	DIRECT	Indicates whether the object is the default inventory location for a site; i.e, 0=not default 1=default
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
gl_acct_no	CHAR	varchar		20			If the object is a physical location, the GL account number. If a GL account, the field is either empty, or contains the parent GL account number	Search (2)
inv_class	LONG	smallint			0	DIRECT	Inventory class; i.e., 0=inventory location, 1=capital GL account, 2=expense GL account	Search (6)
inv_type	LONG	int			0	DIRECT	User-assigned inventory type; defaults to inv_class
loc_serv_level	CHAR	varchar		8			Reserved; future	Search (1)
loc_turn_ratio	CHAR	varchar		8			Reserved; future	Search (1)
location_descr	CHAR	varchar		80			Description of the inventory location or GL account	Search (11)
location_name	CHAR	varchar		40			For physical inventory locations, the name of the location. For GL accounts, the account number	Search (16)
location_type	CHAR	varchar		40			This is a user-defined popup for types of inventory location	Search (3)
objid	LONG	int	3			DIRECT	Internal record number	Search (14)
owner_type	LONG	int			0	DIRECT	Reserved; future
reports_to_loc	CHAR	varchar		20			The name of the parent inventory location. Note: as of CFO99, this field is no longer set by default Clarify code. CFO99 supports multiple rollups	Search (2)
trans_auth	LONG	int			0	DIRECT	States the type of transactions authorized for the inventory location; i.e., 0=All, 1=None, 2=Authorized Parts only. An authorized part is one for which there is a part_auth object	Search (4)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
from_gl2gl_summary	OTM	gl_summary	fm_summary2inv_locatn	Link to FROM GL inventory location
to_gl2gl_summary	OTM	gl_summary	to_summary2inv_locatn	Link to TO GL inventory location
inv_locatn2inv_bin	OTM	inv_bin	inv_bin2inv_locatn	Inventory bins within the inventory location
inv_locatn2parent_loc	MTO	inv_locatn	parent_loc2inv_locatn	For inventory locations, the parent inventory location. Reserved; obsolete-replaced by loc_rol_itm
parent_loc2inv_locatn	OTM	inv_locatn	inv_locatn2parent_loc	Inventory locations belonging to the current location. Reserved; obsolete-replaced by loc_rol_itm
gl_locatn2parent_gl	MTO	inv_locatn	parent_gl2gl_locatn	For locations or GL accounts, its related GL account
parent_gl2gl_locatn	OTM	inv_locatn	gl_locatn2parent_gl	For locations or GLs, the subordinate location or GL
locatn2inv_role	OTM	inv_role	inv_role2inv_locatn	Site roles for the inventory location
parent2loc_rol_itm	OTM	loc_rol_itm	parent2inv_locatn	Related parent rollup items
child2loc_rol_itm	OTM	loc_rol_itm	child2inv_locatn	Related child rollup items
primary2part_auth	OTM	part_auth	primary2inv_locatn	If present, this designates the primary part_auth (and related inv_bin) for a mod_level at the inventory location
inv_locatn2site	MTO	site	site2inv_locatn	Reserved; not used. Replaced by relation to inv_role

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
name_index	location_name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_gl_acct_no	gl_acct_no	nonclustered located on PRIMARY
ind_inv_class	inv_class, location_type	nonclustered located on PRIMARY
name_index	location_name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
23	recv_sum	demand_dtl, demand_hdr, inv_bin, inv_locatn, mod_level, part_inst, part_num, part_trans, recv_parts
62	locs_view	inv_bin, inv_locatn, mod_level, part_inst, part_num
72	gl_sum_view	gl_sum_log, gl_summary, inv_locatn
240	parts_view	inv_bin, inv_locatn, mod_level, part_inst, part_num
241	prt_at_loc	inv_bin, inv_locatn, mod_level, part_auth, part_num
242	pn_at_loc	inv_bin, inv_locatn, mod_level, part_auth, part_num
280	prtins_view	inv_bin, inv_locatn, mod_level, part_inst, part_num
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
408	locbin_view	inv_bin, inv_locatn, inv_role
5177	countlocbin	count_setup, inv_bin, inv_locatn, inv_role, site
5279	container_v	inv_bin, inv_locatn, inv_role, site
5290	loc_rollup_v	inv_locatn, loc_rol_itm, rollup
5304	ccprt_at_loc	cycle_count, inv_bin, inv_locatn, mod_level, part_auth, part_num
5318	ccprt_auth_stats	auth_stats, cycle_count, inv_bin, inv_locatn, mod_level, part_auth, part_num
5330	v_part_bin	inv_bin, inv_locatn, mod_level, part_inst, part_num
5331	v_inv_locatn	inv_locatn, inv_role, site

My Recent Objects

inv_locatn

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user