BUYER_TBLVW

(SQL View)
 Index Back

BUYER_TBL component Search Rec

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

SELECT A.BUYER_ID , B.OPRDEFNDESC , 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 , A.CC_SECURITY_ID , A.CC_USE_FLAG FROM PS_BUYER_TBL A , PSOPRDEFN B WHERE A.BUYER_ID = B.OPRID (+)

# 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 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Y/N Table Edit

Default Value: Y

4 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

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: SHIP_SHIPSET_VW

7 SUBSTITUTE_BUYER Character(30) VARCHAR2(30) NOT NULL Substitute Buyer

Prompt Table: BUYER_SUBS_VW

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: LOC_LOCSET_VW

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: ORGN_ORGNSET_VW

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: DEPT_DEPTSET_VW

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

Y/N Table Edit

Default Value: Y

17 CC_SECURITY_ID Number(10,0) DECIMAL(10) NOT NULL Procurement Card Number
18 CC_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Use Procurement Card

Y/N Table Edit

Default Value: N