RECV_LABEL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
5	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
6	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	DISTRIB_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Sequence
9	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
10	COSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction E=Error; Cannot process N=Transaction is Not Costed P=Qualified for Purging X=Transaction Won't be Costed Y=Transaction is Costed
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
14	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
15	LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
16	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
17	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
18	QTY_MOVED_INV	Number(16,4)	DECIMAL(15,4) NOT NULL	Received Base
19	RECEIPT_DT	Date(10)	DATE	Received Date
20	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y
21	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
22	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
23	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label