BI_IU_VNDR_VW

(SQL View)
 Index Back

InterUnit suppliers

Used as a prompt table for supplier id on GLBU for interunit billing transactions ICE634084000 - Yang Hsu: Add BI_IU_SUPP_LANG as Related Language Record.

SELECT A.SETID , A.VENDOR_ID , A.VENDOR_NAME_SHORT , A.VNDR_AFFILIATE FROM PS_VENDOR A WHERE A.VENDOR_STATUS = 'A' AND A.INTERUNIT_VNDR_FLG = 'Y'

  • Related Language Record: BI_IU_VNDR_LNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    4 VNDR_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Vendor Affiliate