PO_PRICEUPD_PRM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	ASOFDATE_C	Date(10)	DATE	As Of Date
4	ASOFDATE_P	Character(1)	VARCHAR2(1) NOT NULL	AS OF DATE N=Date Range Y=As of Date Default Value: N
5	ASOFDATE_R	Character(1)	VARCHAR2(1) NOT NULL	AS OF DATE N=No Y=Date Range Default Value: N
6	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code Prompt Table: ITM_CAT_SET_VW
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Prompt Table: SP_SETID_NONVW
8	DATE_FROM	Date(10)	DATE	Date From
9	DATE_TO	Date(10)	DATE	Date To
10	VENDOR_ALL	Character(1)	VARCHAR2(1) NOT NULL	Supplier Select Option N=No S=Supplier Setid Y=All Suppliers Default Value: N
11	VENDOR_S	Character(1)	VARCHAR2(1) NOT NULL	Supplier Select Option N=No Y=Specific Supplier Default Value: N
12	INV_ITEM_LIST_OPT	Character(1)	VARCHAR2(1) NOT NULL	Item List Option A=All Items C=Category F=Item Family G=Item Group R=Range of Items S=Single Item
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: PO_BU_ITM_IN_VW
14	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
15	ITEM_OPT1_LABEL	Character(1)	VARCHAR2(1) NOT NULL	Range of Items
16	ITEM_OPT2_LABEL	Character(1)	VARCHAR2(1) NOT NULL	Specific Item
17	FROM_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID Prompt Table: PO_BU_ITM_IN_VW
18	TO_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	To Item ID Prompt Table: PO_BU_ITM_IN_VW
19	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VNDR_VNDSET_VW