WM_WO_PO_MR

#	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	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
5	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
6	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No.
7	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
8	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
9	QTY_REQUIRED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Work Order quantity required base
10	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
11	QTY_PEGGED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	06/16/04 EGS: Created.
12	QTY_DS_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Distributed Quantity
13	QTY_LN_RETRN_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Std Returned Qty
14	MATERIAL_READY_CD	Character(2)	VARCHAR2(2) NOT NULL	Material Ready Code 10=Ready 20=Not Ready 30=Undetermined
15	PEG_EXCEPTION	Character(1)	VARCHAR2(1) NOT NULL	Pegging Exception
16	PAST_DUE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Past Due Flag
17	REQ_NULL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Null Date Requisition Flag
18	MR_REASON_CD	Character(2)	VARCHAR2(2) NOT NULL	Not Ready Reason Code 10=Ready 20=Negative Available 30=Late Supply 40=Past Due Supply 50=Undefined Due Date 60=No Quantity Available 70=Insufficient QTY Available 75=Insufficient Peg Quantity 80=Not Pegged 90=Multiple Reasons
19	REASON_CNT	Number(3,0)	SMALLINT NOT NULL	Reason Count