EM_XML_ATT_VW

(SQL View)
 Index Back

eS - Supplier Attachments

eSettlements Supplier Supplier Attachments

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.SCM_ATTACH_ID , B.SERVER_ID , B.SERVER_TYPE , B.SERVER_PATH , B.ATTACHSYSFILENAME , B.ATTACHUSERFILE , A.FMS_OPRID , A.FMS_DTTM_STAMP FROM PS_EM_XML_ATT A , PS_PV_ATTACHMENTS B WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID

  • 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 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
    5 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID
    6 SERVER_TYPE Character(1) VARCHAR2(1) NOT NULL One of type ftp or DB, marks each registered attachment server.
    D=Database server
    F=FTP server
    U=URL Server
    7 SERVER_PATH Character(254) VARCHAR2(254) NOT NULL For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
    8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    10 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    11 EM_XML_UPLD_DTTM DateTime(26) TIMESTAMP Upload DateTime