PO_PRICEUPD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	FROM_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID
3	TO_ITEMID	Character(18)	VARCHAR2(18) NOT NULL	To Item ID
4	ASOFDATE_C	Date(10)	DATE	As Of Date
5	ASOFDATE_P	Character(1)	VARCHAR2(1) NOT NULL	AS OF DATE N=Date Range Y=As of Date
6	ASOFDATE_R	Character(1)	VARCHAR2(1) NOT NULL	AS OF DATE N=No Y=Date Range
7	CATEGORY_CD	Character(18)	VARCHAR2(18) NOT NULL	Category Code Prompt Table: %EDITTABLE26
8	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
9	DATE_FROM	Date(10)	DATE	Date From
10	DATE_TO	Date(10)	DATE	Date To
11	VENDOR_ALL	Character(1)	VARCHAR2(1) NOT NULL	Supplier Select Option N=No S=Supplier Setid Y=All Suppliers Default Value: N
12	VENDOR_S	Character(1)	VARCHAR2(1) NOT NULL	Supplier Select Option N=No Y=Specific Supplier Default Value: N
13	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
14	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDIT_ITEM_ID
15	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
16	PRICE_VNDR	Number(16,5)	DECIMAL(15,5) NOT NULL	Vendor Price
17	PRICE_CHANGE	Character(1)	VARCHAR2(1) NOT NULL	Update Standard Price
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
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
21	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID