FO_AVE_VND_S_VW

(SQL View)
Index Back

Contrator Search record


SELECT A.SETID , B.VENDOR_ID , C.NAME1 FROM PS_SETID_TBL A , PS_FO_AVE_VNDR_TBL B , PS_VENDOR_VW C WHERE A.SETID = B.SETID AND B.SETID = C.SETID AND B.VENDOR_ID = C.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: SETID_TBL

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

Prompt Table: FO_VND_LOC_S_VW

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