CNTRCT_HD_FS_VW

(SQL View)
 Index Back

Contract Search record

PO0025 - Master Contract Fluid

SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.CNTRCT_STYLE , A.VERSION_STATUS , A.BUYER_ID , C.OPRDEFNDESC , B.VENDOR_NAME_SHORT , A.CNTRCT_PROC_OPT , B.NAME1 , A.LAST_DTTM_UPDATE , %DatePart(A.LAST_DTTM_UPDATE) , A.CNTRCT_STATUS , A.DESCR , A.VENDOR_SETID , A.VENDOR_ID , a.cntrct_expire_dt , D.CNTRCT_STYLE_NAME FROM PS_CNTRCT_HDR A LEFT OUTER JOIN PSOPRDEFN C ON A.BUYER_ID = C.OPRID , PS_VENDOR B , PS_CNTRCT_STYLE D WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_PROC_OPT IN ('GRPS', 'GRPM', 'SPP') AND D.CNTRCT_STYLE = A.CNTRCT_STYLE

  • Related Language Record: CNT_HD_FS_LG_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: SP_SETCNT_NONVW

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

    Prompt Table: CNTRCT_ID_F_VW

    3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Prompt Table: CNT_VER_FL_VW

    4 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style

    Default Value: OPR_DEF_TBL_PM.CNTRCT_STYLE

    Prompt Table: CNTRCT_STYLE_VW

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

    Default Value: C

    6 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: ADMIN_ALL_VW

    7 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    9 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: GRPS

    10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    11 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 LAST_DATE_WORKED Date(10) DATE Last Date Worked
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Prompt Table: CNT_DSR_F_VW

    15 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    16 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_SET_VW

    17 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    18 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Contract Style