CNT_CHI_REL_VW

(SQL View)
Index Back

Contract Search for PO's

11/15/2015 JOHAN PO0025 - Master contract fluid

SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.CNTRCT_STYLE , S.CNTRCT_STYLE_NAME , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.CNTRCT_STATUS , A.DESCR , A.CNTRCT_BEGIN_DT , A.CNTRCT_EXPIRE_DT , A.CNTRCT_PROC_OPT , A.AMT_CNTRCT_MAX FROM PS_CNTRCT_HDR A , PS_VENDOR B , PS_CNTRCT_STYLE S WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_STYLE = S.CNTRCT_STYLE AND A.VERSION_STATUS = 'C'

  • Related Language Record: CNT_CHI_REL_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID_CHILD Character(25) VARCHAR2(25) NOT NULL Contract ID To
    3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
    4 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    5 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Contract Style
    6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    7 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

    Prompt Table: VENDOR_PO_NMVW2

    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    9 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

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    12 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    13 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
    14 AMT_CNTRCT_MAX Number(27,3) DECIMAL(26,3) NOT NULL Maximum Amount of Contract.