CNTRCT_SRCH1

(SQL View)
 Index Back

Contract Search Record

Contract Search Record with Contract type

SELECT DISTINCT a.SETID , a.CNTRCT_ID , a.VERSION_NBR , a.VERSION_STATUS , c.CNTRCT_STYLE_NAME , a.CNTRCT_STYLE , a.CNTRCT_PROC_OPT , a.VENDOR_SETID , a.VENDOR_ID , b.VENDOR_NAME_SHORT , b.NAME1 , a.CNTRCT_EXPIRE_DT , a.CNTRCT_STATUS , a.MSTR_CNTRCT_ID , a.DESCR FROM PS_CNTRCT_HDR a LEFT OUTER JOIN PS_CNTRCT_STYLE c ON a.cntrct_style = c.cntrct_style , PS_VENDOR b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id

  • Related Language Record: CNTRCT_SCH1_LNG

    • # 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 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Default Value: 1

    4 VERSION_STATUS Character(1) VARCHAR2(1) NOT NULL Contract version status
    C=Current
    D=Draft
    H=History

    Default Value: C

    5 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Contract Style

    Prompt Table: CNT_STYLNM_DVW

    6 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    7 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
    8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Default Value: VNDRSHRT_SET_VW.VENDOR_ID

    Prompt Table: VENDOR_SET_VW

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

    Prompt Table: VNDR_SHRT_VWC

    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

    Prompt Table: VENDOR_N4_VW_LG

    12 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    13 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

    14 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID

    Prompt Table: CNTRCT_MSTR

    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description