Table Name:	recv_parts
Table Number:	40
Group:	Logistics
Description:	Records the receipt of a shipment
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_recv_parts

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
proper_package	LONG	int			0	DIRECT	Indicates possible packaging problem with the received part; i.e., 1=yes, 0=no
receipt_type	LONG	int			0	DIRECT	Reserved; future	Search (1)
recv_carrier	CHAR	varchar		40			Site name of the carrier who transported the part
recv_notes	CHAR	varchar	2	255			Notes recorded at receipt time
route_problem	LONG	int			0	DIRECT	Reserved; future
route_testing	LONG	int			0	DIRECT	Indicates part routed to testing facility; i.e., 1=yes, 0=no
ship_damage	LONG	int			0	DIRECT	Indicates possible damage to the shipped part; i.e., 1=yes, 0=no
waybill	CHAR	varchar		40			Waybill number of the shipment with which part was received

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
recv_parts2part_info	MTO	mod_level	part_info2recv_parts	Reserved; not used
received2part_trans	OTOF	part_trans	recv_trans2recv_parts	Part received transaction for the receive parts
fulfilled2part_trans	OTOF	part_trans	fulf_trans2recv_parts	Part fulfilled transaction for the receive parts

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_recv_parts2part_info	recv_parts2part_info	nonclustered 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

My Recent Objects

recv_parts

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user