SCN_HDR_SLD_VW

(SQL View)
 Index Back

Sales Cntrct by SoldTo Vw

Date Init. Issue # Description 040103 JJM 58069000 Created table for prompting

SELECT DISTINCT D.BUSINESS_UNIT , C.SOLD_TO_CUST_ID , E.NAME1 FROM PS_SET_CNTRL_REC SC , PS_SCON_HDR A , PS_SCON_LINE B , PS_SCON_CUST_CGRP C , PS_SCON_PROD_PGRP D , PS_CUSTOMER E WHERE A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND B.SETID = C.SETID AND B.CNTRCT_ID = C.CNTRCT_ID AND C.SETID = D.SETID AND C.CNTRCT_ID = D.CNTRCT_ID AND B.LINE_NBR = D.LINE_NBR AND A.SCON_STATUS = 'A' AND B.UNIT_OF_MEASURE <> ' ' AND SC.RECNAME = 'CUSTOMER' AND SC.SETCNTRLVALUE = D.BUSINESS_UNIT AND E.SETID = SC.SETID AND E.CUST_ID = C.SOLD_TO_CUST_ID AND E.CUST_STATUS IN ('A','I')

  • Related Language Record: SCN_HDRCSTV_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

    Prompt Table: SP_BU_OM_NONVW

    2 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: CUST_SLD_VW

    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1