QS_LOT_ID_VW (SQL View)	Index Back
Default Lot ID prompt table RRE- this view is assigned as the default prompt table in the Quality Field Catalog. It is intended to extract lot ids from the master serial id record.

QS_LOT_ID_VW

(SQL View)

Default Lot ID prompt table

RRE- this view is assigned as the default prompt table in the Quality Field Catalog. It is intended to extract lot ids from the master serial id record.

SELECT BUSINESS_UNIT , INV_LOT_ID , DESCR FROM PS_LOT_CONTROL_INV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description