OMPB_SCON1_VW

(SQL View)
 Index Back

Sales Contract Hdr by Sold To


SELECT DISTINCT A.SETID , A.CNTRCT_ID , B.DESCR FROM PS_SCON_CUST_CGRP A , PS_SCON_HDR B WHERE A.SETID=B.SETID AND A.CNTRCT_ID=B.CNTRCT_ID AND B.SCON_STATUS = 'A'

  • Related Language Record: OMPB_SCON1_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description