Table Name:	part_auth
Table Number:	229
Group:	Logistics
Description:	Records authorized stockage levels for inventory parts
Flags:
Baseline/Custom:	Baseline

select * from table_part_auth

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
abc_cd_cls	CHAR	varchar		8			Calculated ABC classification code for cycle counting part instances	Search (2)
active	LONG	smallint			1	DIRECT	Indicates whether the current part authorization is active; i.e., 0=inactive, 1=active, default=1	Search (1)
active_cc_ind	LONG	tinyint			0	DIRECT	Indicates whether this PSL is active for Cycle Counting; i.e., 0=no, 1=yes, default=0	Search (2)
allocate_exch	LONG	int				DIRECT	Reserved; future	Search (1)
allocate_other	LONG	int				DIRECT	Reserved; future	Search (1)
allocate_repln	LONG	int				DIRECT	Reserved; future	Search (1)
average_usage	DECIMAL	decimal (19,4)				CURRENCY	Part usage for authorized parts included in a cycle count profile. Reserved; future	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
hard_exchlimit	LONG	tinyint				DIRECT	Reserved; future	Search (1)
hard_repllimit	LONG	tinyint				DIRECT	Reserved; future	Search (1)
hard_salelimit	LONG	tinyint				DIRECT	Reserved; future	Search (1)
last_calc_val	DECIMAL	decimal (19,4)				CURRENCY	Last calculated valuation for the Cycle Count part	Search (1)
last_cycle_ct	CLK_TIME	datetime					Date and time of last cycle count	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (5)
opn_ord_qty	LONG	int				DIRECT	Total quantity of the part currently on order for the bin	Search (3)
part_avg_usage	CHAR	varchar		8			Reserved; future
part_bad_qoh	LONG	int				DIRECT	Stores the cumulative part bad quantity on hand for the part/location/bin	Search (3)
part_good_qoh	LONG	int				DIRECT	Stores the cumulative part good quantity on hand for the part/location/bin	Search (3)
part_last_pi	CLK_TIME	datetime					Reserved; future
part_maximum	LONG	int				DIRECT	Maximum stock level for the part in the bin/location	Search (2)
part_minimum	LONG	int				DIRECT	Minimum stock level for the part in the bin/location	Search (2)
part_pi_tag_no	CHAR	varchar		8			Reserved; future
part_rol	LONG	int				DIRECT	Number of parts in stock at which or below a replenishment order is generated to increase the number of parts to the maximum stocking level	Search (3)
part_roq	LONG	int				DIRECT	The quantity of parts ordered when a replenishment order is generated	Search (3)
part_serv_lev	CHAR	varchar		8			Reserved; future
primary_ind	LONG	tinyint			0	DIRECT	Indicates whether the related bin is the primary bin for the related part revision within the bin's inventory location; i.e., 0=no, 1=yes, default=0	Search (1)
pt_last_cycle	CLK_TIME	datetime					Reserved; future
pt_turn_ratio	CHAR	varchar		8			Reserved; obsolete
reorder_qty	LONG	int				DIRECT	Reserved; not used
repl_queue	CHAR	varchar		24			Title of the queue to which demands generated via auto-replenishment will be dispatched	Search (2)
times_cc_ct	LONG	int				DIRECT	Times this part has been scheduled for a its current Cycle Count	Search (1)
turn_ratio	DECIMAL	decimal (19,4)					Turn ratio for authorized parts included in a cycle count profile	Search (2)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
part_auth2auth_stats	OTM	auth_stats	auth_stats2part_auth	Cycle count detail for the part_auth
part_auth2count_setup	MTO	count_setup	setup2part_auth	Scheduled cycle count profile which the part_auth participates in
part_auth2cycle_count	MTO	cycle_count	ccount2part_auth	Related cycle count		Search (2)
part_auth2demand_hdr	MTM	demand_hdr	autorepl2part_auth	Headers containing an outstanding auto-replenishment demand for the current parts authorization	mtm_demand_hdr9_ part_auth2
part_auth2inv_bin	MTO	inv_bin	inv_bin2part_auth	Inventory bin for the authorization		Search (5)
primary2inv_locatn	MTO	inv_locatn	primary2part_auth	Designates the related inventory bin as the primary bin for the part_auth's related mod_level at the related inventory location
n_auth_parts2part_mod	MTO	mod_level	n_part_info2part_auth	Part revision being authorized		Search (5)
part_auth2rollup	MTO	rollup	cyc_rollup2part_auth	In Zone Management designates the part_auth and related inv_bin which is primary for the entire zone rollup

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_n_auth_parts2part_mod	n_auth_parts2part_mod, part_auth2inv_bin	nonclustered located on PRIMARY
ind_part_auth2count_setup	part_auth2count_setup	nonclustered located on PRIMARY
ind_part_auth2cycle_count	part_auth2cycle_count	nonclustered located on PRIMARY
ind_part_auth2rollup	part_auth2rollup, objid	nonclustered, unique located on PRIMARY
ind_primary2inv_locatn	primary2inv_locatn, objid	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
pa2ib0229	part_auth2inv_bin, n_auth_parts2part_mod, part_auth2cycle_count	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
73	prt_inv_auth	inv_bin, mod_level, part_auth, 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
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

My Recent Objects

part_auth

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