CNTRCT_ADD_F_VW

(SQL View)
 Index Back

Contract Add Search

PO0025 - Master Contract Fluid

SELECT DISTINCT A.CNTRCT_STYLE , A.SETID , A.CNTRCT_ID , C.CNTRCT_STYLE_NAME , A.CNTRCT_PROC_OPT , A.BUYER_ID , A.VERSION_NBR , A.VERSION_STATUS , B.VENDOR_NAME_SHORT , A.CNTRCT_STATUS , A.DESCR , A.VENDOR_SETID , A.VENDOR_ID FROM PS_CNTRCT_HDR A , PS_VENDOR B , PS_CNTRCT_STYLE C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VERSION_STATUS = 'C' AND A.CNTRCT_PROC_OPT IN ('GRPS', 'GRPM', 'SPP') AND A.CNTRCT_STYLE = C.CNTRCT_STYLE

  • Related Language Record: CNT_ADD_F_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style

    Default Value: OPR_DEF_TBL_PM.CNTRCT_STYLE

    Prompt Table: CNT_ADDSTYLE_VW

    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETCNT_NONVW

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

    Default Value: NEXT

    4 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Contract Style
    5 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
    6 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    7 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Default Value: 1

    8 VERSION_STATUS Character(1) VARCHAR2(1) NOT NULL Contract version status
    C=Current
    D=Draft
    H=History
    9 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    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

    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_SET_VW