BUYER_SSRC_VW

(SQL View)
 Index Back

Buyer view

Buyer view used in Alt sources of Supply This view shows the active buyers on master PO Buyer Table.

SELECT A.BUYER_ID ,B.OPRDEFNDESC , A.PO_STATUS , A.SHIPTO_SETID , A.SHIPTO_ID , A.LOCATION_SETID , A.LOCATION , A.PHONE , A.FAX , A.ORIGIN_PO_SETID , A.ORIGIN , A.DEPTID_SETID , A.DEPTID , A.OVERRIDE_SUGG_VNDR FROM PS_BUYER_TBL A ,PSOPRDEFN B WHERE A.BUYER_ID = B.OPRID AND A. ACTIVE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: ROLEXLATOPR_VW

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
3 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

Default Value: O

4 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIP_SHIPSET_VW

6 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOC_LOCSET_VW

8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
9 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
10 ORIGIN_PO_SETID Character(5) VARCHAR2(5) NOT NULL PO Origin Setid

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

11 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Prompt Table: ORGN_ORGNSET_VW

12 DEPTID_SETID Character(5) VARCHAR2(5) NOT NULL Department SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_DEPTSET_VW

14 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor

Default Value: Y