PL_MM_PO_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	STEP	Number(2,0)	SMALLINT NOT NULL	Step
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
9	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
10	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
11	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
12	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
13	PLAN_RELEASE_DTTM	DateTime(26)	TIMESTAMP	Plan Release Date Time
14	PLAN_DUE_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Planning Due Date/Time
15	REMAINING_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	08/16/01 JNW (CN#PL900-1.0): Added
16	FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Frozen Flag B=Both N=No Y=Yes Y/N Table Edit
17	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
18	CANCEL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cancel Status A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled
19	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
20	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Prompt Table: PRCSRUNCNTL