SCR_LOC_ATT_VW

(SQL View)
 Index Back

Supplier Location Attachemnt

This view will select the current effective date row to display to the user for editing.

SELECT a.setid ,a.vendor_id ,a.vndr_loc ,a.scm_attach_id ,a.att_version ,a.show_approval ,b.ATTACH_DESCR ,b.SERVER_ID ,b.SERVER_TYPE ,b.SERVER_PATH ,b.ATTACHSYSFILENAME ,b.ATTACHUSERFILE ,%subrec(FMS_WHO_SBR, a) , 'N' FROM PS_AP_VNDR_LOC_ATT a , PS_PV_ATTACHMENTS b WHERE a.scm_attach_id = b.scm_attach_id AND a.att_version = b.att_version AND 1=2

  • Parent record: SCR_LOC_SCRL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    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 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
    6 SHOW_APPROVAL Character(1) VARCHAR2(1) NOT NULL Flag for whether something should be shown to the approver
    7 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
    8 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID
    9 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
    10 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.
    11 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    12 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    13 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    14 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    15 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    16 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    17 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact

    Y/N Table Edit

    Default Value: N