VENDOR_LKP_TYPE

(SQL View)
 Index Back

Supplier Types View for Supp L


SELECT A.SETID , A.VENDOR_ID , A.VENDOR_TYPE , B.XLATLONGNAME FROM PS_VENDOR_TYPE A , PSXLATITEM B WHERE B.FIELDNAME = 'VENDOR_TYPE' AND B.FIELDVALUE = A.VENDOR_TYPE

  • Related Language Record: VENDOR_LKTYP_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VENDOR_TYPE Character(3) VARCHAR2(3) NOT NULL Vendor Type
    ADV=Ads
    CNS=Consultant
    CNT=Contractor
    ENT=Entertain
    FRG=Foreign
    GVT=Government
    MNR=Minority
    PR=PR
    TRD=Tradesman
    TRN=Transport
    TRV=Travel
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name