AP_DM_VNDR_VW

(SQL View)
Index Back

Supplier View


SELECT SETID , VENDOR_ID , VENDOR_NAME_SHORT , NAME1 FROM PS_VENDOR WHERE EXISTS ( SELECT 'X' FROM PS_VENDOR_PAY WHERE PS_VENDOR_PAY.SETID = PS_VENDOR.SETID AND PS_VENDOR_PAY.VENDOR_ID = PS_VENDOR.VENDOR_ID AND PS_VENDOR_PAY.ALLOW_DEBIT_MEMO = 'Y')

# 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 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1