CUST_CNTCT_VW

(SQL View)
 Index Back

All Contact Customers

Date Init. Issue # Description 020502 JJM R-TNUGRO-SC9UG Created record

SELECT DISTINCT CC.CUSTOMER_SETID , CC.CUST_ID , CST.NAME1 FROM PS_CONTACT_CUST CC , PS_CUSTOMER CST WHERE CC.CUSTOMER_SETID = CST.SETID AND CC.CUST_ID = CST.CUST_ID AND CST.CUST_STATUS IN ('A','I')

  • Related Language Record: CUST_CNTCT_LNG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CUST_ID_CNTCT Character(15) VARCHAR2(15) NOT NULL Customer ID
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1