BUYER_TBL_FS

(SQL View)
 Index Back

Buyer Table - FS Style


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
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
5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
6 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
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
11 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
12 DEPTID_SETID Character(5) VARCHAR2(5) NOT NULL Department SetID
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 OVERRIDE_SUGG_VNDR Character(1) VARCHAR2(1) NOT NULL Override Suggested Vendor

Default Value: Y