CNTRCT_DST_SRCH

(SQL View)
 Index Back

Distributor Contract Search

PO002 Distributor Contract. Prompt table for distributor contract on distributor list of Manufacturer Contract.

SELECT DISTINCT A.SETID , A.CNTRCT_ID , A.CNTRCT_STYLE , S.CNTRCT_STYLE_NAME , B.VENDOR_NAME_SHORT , B.NAME1 , A.CNTRCT_STATUS , A.DESCR , A.CNTRCT_BEGIN_DT , A.CNTRCT_EXPIRE_DT 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.CNTRCT_STATUS NOT IN ('C', 'X') AND A.VERSION_STATUS = 'C' AND A.CNTRCT_PROC_OPT = 'DST' AND (A.CNTRCT_EXPIRE_DT IS NULL OR (A.CNTRCT_EXPIRE_DT IS NOT NULL AND A.CNTRCT_EXPIRE_DT >= %CurrentDateIn))

  • Related Language Record: CNT_DST_SRH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID_DST Character(25) VARCHAR2(25) NOT NULL Contract ID To
    3 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    4 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 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

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    10 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date