CS_CNT_VNDR_VW

(SQL View)
 Index Back

SCMT cntrct - supplier

Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 View to use within SCMT to get the supplier information for a given contract that is tied to a document

SELECT K.CS_DOC_ID , H.SETID ,H.CNTRCT_ID ,H.VENDOR_SETID ,H.VENDOR_ID ,H.CNTRCT_STATUS ,H.CNTRCT_BEGIN_DT ,H.CNTRCT_EXPIRE_DT , V.NAME1 , V.NAME2 FROM PS_CS_DOC_PO_KEYS K , PS_CNTRCT_HDR H , PS_VENDOR V WHERE K.SETID = H.SETID AND K.CNTRCT_ID = H.CNTRCT_ID AND K.VERSION_NBR = H.VERSION_NBR AND V.SETID = H.VENDOR_SETID AND V.VENDOR_ID = H.VENDOR_ID

  • Related Language Record: CS_CNT_VNDRLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_VW

    6 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

    7 CNTRCT_BEGIN_DT Date(10) DATE Contract Begin Date
    8 CNTRCT_EXPIRE_DT Date(10) DATE Expire Date
    9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    10 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2