BUYER_TBL_VW

(SQL View)
 Index Back

Master PO Buyer Table View

This record is created to be used as the Update/Display Search Record for BUYER_TBL component.

SELECT A.BUYER_ID , A.ACTIVE_FLG , A.PO_STATUS , A.SHIPTO_SETID , A.SHIPTO_ID , A.SUBSTITUTE_BUYER , 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 WHERE A. ACTIVE_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
2 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Y/N Table Edit

Default Value: Y

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 SUBSTITUTE_BUYER Character(30) VARCHAR2(30) NOT NULL Substitute Buyer

Prompt Table: BUYER_SUBS_VW

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: LOC_LOCSET_VW

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: ORGN_ORGNSET_VW

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: DEPT_DEPTSET_VW

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

Y/N Table Edit

Default Value: Y