FO_AVE_SRCH

(SQL View)
 Index Back

AVE search record


SELECT a.setid , a.vendor_id , a.vendor_name_short , a.ar_num , a.name1 , a.vendor_status FROM PS_VENDOR a , ps_fo_vend_ave b WHERE a.setid = b.setid AND a.vendor_id = b.vendor_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETVC_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: FO_AVE_VND_S_VW

3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
4 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number

Prompt Table: VNDR_AR_VW

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

Prompt Table: VNDR_NAME1_VW

6 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
A=Approved
D=Denied
E=Unapproved
I=Inactive
X=To Be Archived