SCR_VNDRID_VW1

(SQL View)
 Index Back

Supplier Chg Request Selection


SELECT a.setid , a.vendor_id , c.sup_ob_template_id , a.vendor_name_short , a.name1 , a.name2 ,a.LAST_MODIFIED_DATE , c.fms_oprid , c.scr_id , c.scr_status ,c.last_seq_num , c.fms_lastupddttm , %DatePart(c.FMS_LASTUPDDTTM) FROM ps_scr_vnduser1_vw a , PS_VENDOR_CONTROL b , ps_scr_header c WHERE a.setid = b.setid AND a.setid = c.setid AND a.vendor_id = c.vendor_id AND C.scr_status IN ('S','M','P', 'I','C','B')

  • Related Language Record: VNDR_NHS_ID_LVW

    • # 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: SP_SETVC_NONVW

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
    4 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    7 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    9 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
    10 SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Approved
    B=Request Editor More Info..
    B=Request Editor More Info..
    C=Pending Editor Review
    C=Pending Editor Review
    E=Update Error
    I=Integrity Error
    M=Request Additional Information
    P=Pending Approval
    R=Rejected
    S=Save for Later
    U=Database Updated
    W=Withdrawn
    11 LAST_SEQ_NUM Number(5,0) INTEGER NOT NULL Last Sequence Number
    12 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    13 DATE1 Date(10) DATE Date