CNT_DST_BU_VW

(SQL View)
 Index Back

BU Prompt View for Markup

PO002, BU prompt on markup detail page of Manufacturer Contract

SELECT c.setid , c.cntrct_id , a.business_unit , b.descr FROM PS_BUS_UNIT_TBL_PM a , ps_bus_unit_tbl_fs b , ps_cnt_ctrl_type c WHERE a.business_unit = b.business_unit AND a.business_unit = c.business_unit AND c.control_type = 'BU'

  • Related Language Record: CNT_DST_BU_LANG

    • # 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description