CUST_SHPINV_VW

(SQL View)
 Index Back

Ship To Cust Opt view - IM


SELECT a.setid , a.cust_id , a.name1 FROM ps_customer a , PS_CUST_SHIPTO_OPT b WHERE a.setid=b.setid AND a.cust_id = b.cust_id AND %EffdtCheck(cust_shipto_opt,b,%CurrentDateIn) AND b.EFF_STATUS='A'

  • Related Language Record: CUST_SHPINV_LNG

  • Parent record: CUSTOMER

    • # 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 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1