CUST_SLDSHP1_VW

(SQL View)
 Index Back

Valid Ship To for Sold To - OM

112601 yb r-ftourn-pu9js phone,city,state,potal are alternat search keys 090110 VS 2012369001 Modified view to pick up correct address seq.

SELECT A.SETID ,A.CUST_ID ,A.SHIP_TO_CUST_ID ,A.SLDTO_PRIORITY_NBR ,B.NAME1 ,B.NAME2 ,B.ADDRESS_SEQ_NUM ,B.CNTCT_SEQ_SHIP ,C.PHONE ,C.CITY ,C.STATE ,C.POSTAL FROM PS_CUST_SHIPTO A , PS_CUSTOMER B , PS_CUST_ADDRESS C WHERE A.SETID = B.SETID AND A.SHIP_TO_CUST_ID = B.CUST_ID AND B.SETID = C.SETID AND B.CUST_ID = C.CUST_ID AND B.CUST_STATUS IN ('A','T','I') AND B.EXP_PENDING = 'N' AND %EffdtCheck(cust_address,C,%currentdatein) AND C.eff_status='A'

  • Related Language Record: CUST_SLDSHP_LNG

    • # 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 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    3 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    4 SLDTO_PRIORITY_NBR Number(4,0) SMALLINT NOT NULL Sold To Priority
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    7 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To
    8 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To
    9 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    10 CITY Character(30) VARCHAR2(30) NOT NULL City
    11 STATE Character(6) VARCHAR2(6) NOT NULL State
    12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal