CNTRCT_SRCH

(SQL View)
 Index Back

Contract Search Record

Contract Search Record

SELECT DISTINCT a.SETID , a.CNTRCT_ID , a.CNTRCT_STYLE , a.CNTRCT_PROC_OPT , c.CNTRCT_STYLE_NAME , a.CNTRCT_TYPE , a.VENDOR_SETID , a.VENDOR_ID , b.VENDOR_NAME_SHORT , a.CNTRCT_STATUS FROM PS_CNTRCT_HDR a , PS_VENDOR b , PS_CNTRCT_STYLE c WHERE a.version_status = 'C' AND a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.cntrct_style = c.cntrct_style AND c.style_status = 'A'

  • Related Language Record: CNTRCT_SRCHLNG2

    • # 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_SETCNT_NONVW

    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Default Value: NEXT

    3 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Style ID

    Prompt Table: CNT_STYPROM_VW

    4 CNTRCT_PROC_OPT Character(4) VARCHAR2(4) NOT NULL Contract Process Option
    AP=Recurring Voucher
    BPO=Release to Single PO Only
    DST=Distributor
    GN=General Contract
    GRPM=Group Multi Supplier
    GRPS=Group Single Supplier
    MFG=Manufacturer
    PADV=Prepaid Voucher w/ Advance PO
    PO=Purchase Order
    PPAY=Prepaid Voucher
    RPOV=Recurring PO Voucher
    SPP=Special Purpose

    Default Value: OPR_DEF_TBL_PM.CNTRCT_PROC_OPT

    5 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Contract Style
    6 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
    AP=Recurring Voucher
    GN=General Contract
    MS=Master Contract
    PO=Purchase Order

    Default Value: GN

    7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VNDRSHRT_SET_VW.VENDOR_ID

    Prompt Table: VENDOR_SET_VW

    9 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

    Prompt Table: VNDRSHRT_SET_VW

    10 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
    A=Approved
    C=Closed
    H=On-Hold
    O=Open
    P=Pre-Approved
    X=Canceled

    Default Value: O