EM_XML_UPLD_VW2

(SQL View)
Index Back

eS - Supplier Attachments

eSettlements Supplier Supplier Attachments

SELECT DISTINCT SETID , VENDOR_ID , VNDR_LOC , OPRID FROM PS_EM_XML_UPLD_VW

  • Parent record: VENDOR_LOC
  • # 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 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).