WV_PE_USER_DEF (SQL Table)	Index Back
Supplier Portal - Defaults 02/12/01 RSX CN#WV802-3.0: Original Creation

WV_PE_USER_DEF

(SQL Table)

Supplier Portal - Defaults

02/12/01 RSX CN#WV802-3.0: Original Creation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WV_PE_PGLT_COMP Character(2) VARCHAR2(2) NOT NULL Pagelet Component
01=Recent Purchase Orders
02=On-Time Performance
03=Quantity Performance
04=Quality Performance
05=Recently Dispatched Schedules
06=Remaining Quantity Balances
07=Recent RFQs
08=Recent ASNs
09=PO/Receipt Qty Performance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR

5 MAX_ROWS Number(3,0) SMALLINT NOT NULL Maximum Rows retrieved

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WV_PE_PGLT_COMP	Character(2)	VARCHAR2(2) NOT NULL	Pagelet Component 01=Recent Purchase Orders 02=On-Time Performance 03=Quantity Performance 04=Quality Performance 05=Recently Dispatched Schedules 06=Remaining Quantity Balances 07=Recent RFQs 08=Recent ASNs 09=PO/Receipt Qty Performance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR
5	MAX_ROWS	Number(3,0)	SMALLINT NOT NULL	Maximum Rows retrieved