RFQ_VNDR_VW

(SQL View)
Index Back

Quote Group/Supplier Table


SELECT SETID , RFQ_VNDR_GROUP , VENDOR_SETID , VENDOR_ID , VNDR_LOC FROM PS_RFQ_VNDR_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 RFQ_VNDR_GROUP Character(10) VARCHAR2(10) NOT NULL Quote Group ID

Prompt Table: RFQ_VNDR_GROUP

3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_VW

5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VENDOR_LOC_VW
Set Control Field: VENDOR_SETID