BUYER_VW (SQL View)	Index Back
Buyer View Buyer View

BUYER_VW

(SQL View)

Buyer View

SELECT A.BUYER_ID ,B.OPRDEFNDESC ,A.PHONE ,B.EMAILID ,D.AUC_IMAGE_PATH ,C.AUC_IMAGE_NAME ,C.DESCR100 FROM PS_BUYER_TBL A ,PSOPRDEFN B ,PS_AUC_IMAGE_NAME C ,PS_AUC_IMAGE_PATH D WHERE A.BUYER_ID=B.OPRID AND A.BUYER_ID=C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
Prompt Table: PO_OPRDEFN_VW

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

3 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

5 AUC_IMAGE_PATH Character(70) VARCHAR2(70) NOT NULL Image Path

6 AUC_IMAGE_NAME Character(50) VARCHAR2(50) NOT NULL Image Name

7 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer Prompt Table: PO_OPRDEFN_VW
2	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user
3	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
4	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
5	AUC_IMAGE_PATH	Character(70)	VARCHAR2(70) NOT NULL	Image Path
6	AUC_IMAGE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Image Name
7	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description