PL_SRCH_PO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SAVED_SEARCH	Character(30)	VARCHAR2(30) NOT NULL	Saved Search Name
3	BU_GROUP	Character(6)	VARCHAR2(6) NOT NULL	08/16/01 EGS (CN#PL880-1.0): Added Prompt Table: PL_GROUP_IN_VW
4	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code Prompt Table: PL_PO_ITMCAT_VW
5	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: %EDITTABLE4
7	UTILIZ_CD	Character(4)	VARCHAR2(4) NOT NULL	Utilization Type Prompt Table: PL_UTILIZ_VW
8	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code Prompt Table: %EDITTABLE5
9	INV_ITEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Item Group Prompt Table: PL_PO_ITMGRP_VW
10	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE
11	INV_PROD_FAM_CD	Character(10)	VARCHAR2(10) NOT NULL	Family Prompt Table: %EDITTABLE6
12	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: PL_PO_BUYER_VW
13	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Prompt Table: PL_PO_VSETID_VW
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: PL_PO_VID_VW
15	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: PL_PO_VLOC_VW
16	FROM_DT	Date(10)	DATE	From Date Prompt Table: %EDITTABLE2
17	TO_DT	Date(10)	DATE	To Date Prompt Table: %EDITTABLE3
18	FROM_DT1	Date(10)	DATE	From Date Prompt Table: %EDITTABLE7
19	TO_DT1	Date(10)	DATE	To Date Prompt Table: %EDITTABLE8
20	PL_NEW_ORDER	Character(1)	VARCHAR2(1) NOT NULL	Planned Y/N Table Edit Default Value: Y
21	SCHED_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Planning Schedule Change Y/N Table Edit Default Value: N
22	QTY_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Quantity Change Flag for Supply Planning Post Records Y/N Table Edit Default Value: N
23	CANCEL_CHNG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Planning Canceled Y/N Table Edit Default Value: N
24	SCHED_CHNG_OUT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Reschedule Out Y/N Table Edit Default Value: N
25	PL_EXISTING_ORDER	Character(1)	VARCHAR2(1) NOT NULL	Existing Order Y/N Table Edit Default Value: N
26	PL_SEE_SCHED_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Items options 1=Include Schedule Items 2=Exclude Schedule Items 3=Only Show Schedule Items Default Value: 1
27	PL_SEE_STRAT_SRCNG	Character(1)	VARCHAR2(1) NOT NULL	Strategic Sourcing Events 1=Include Planned Events 2=Exclude Planned Events 3=Show Only Planned Events Default Value: 1
28	UNAPPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Unapproved Flag Y/N Table Edit Default Value: Y
29	APPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approved by Auditor D=Denied N=Not Approved Y=Approved Y/N Table Edit Default Value: N
30	EXPEDITE_FLG	Character(1)	VARCHAR2(1) NOT NULL	08/24/98 SCC APRD-R-SCHEW-8L1TB: Selection criteria for Expedirte Orders. Y/N Table Edit Default Value: N
31	CUTOFF_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cutoff Flag Y/N Table Edit Default Value: N
32	ACCEPTED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Accepted Flag Y/N Table Edit Default Value: N
33	PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Plan Processed Flag C=Complete E=Errors N=Initialize P=In Process Y/N Table Edit Default Value: N
34	TOLERANCE_FLG	Character(1)	VARCHAR2(1) NOT NULL	jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label Y/N Table Edit Default Value: Y
35	SPL_STAGED_PO	Character(1)	VARCHAR2(1) NOT NULL	Staged Y/N Table Edit
36	TOLERANCE_FLG2	Character(1)	VARCHAR2(1) NOT NULL	Outside Tolerance Y/N Table Edit Default Value: N
37	PEGGED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Open Pegs Y/N Table Edit Default Value: N
38	UNPEGGED_FLG	Character(1)	VARCHAR2(1) NOT NULL	11/18/2004 NRA : Defined Y/N Table Edit Default Value: N
39	LAST_VIEW_SW	Character(1)	VARCHAR2(1) NOT NULL	Last View used flag. Y/N Table Edit Default Value: N