CS_PUR_VNDR_VW

(SQL View)
 Index Back

SCMT Purchasing - supplier vie

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

SELECT K.CS_DOC_ID , H.BUSINESS_UNIT ,H.PO_ID ,H.VENDOR_SETID ,H.VENDOR_ID ,H.PO_STATUS ,H.PO_DT , V.NAME1 , V.NAME2 FROM PS_CS_DOC_PUR_KEYS K , PS_PO_HDR H , PS_VENDOR V WHERE K.BUSINESS_UNIT = H.BUSINESS_UNIT AND K.PO_ID = H.PO_ID AND V.SETID = H.VENDOR_SETID AND V.VENDOR_ID = H.VENDOR_ID

  • Related Language Record: CS_PUR_VNDRLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    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 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
    A=Approved
    C=Complete
    D=Dispatched
    DA=Denied
    I=Initial
    LD=Line Denied
    O=Open
    PA=Pending Approval/Approved
    PX=Pending Cancel
    X=Canceled
    7 PO_DT Date(10) DATE Date
    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    9 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2