RS_CUSTNAME_VW1

(SQL View)
Index Back

SRS Customer Name View

Ths View is used to provide a prompt by Customer Name for the SRS report request panels. Having this prompt allows users to search by Customer Name, instead of requiring the user to know the Customer Number

SELECT A.SETID , A.CUST_ID , A.NAME1 , A.NAME2 , A.NAME3 , A.NAMESHORT FROM PS_CUSTOMER A

  • Related Language Record: RS_CUSTNAME_VL1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    5 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
    6 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name