PROD_CALIAS_VW

(SQL View)
Index Back

Cust Prod alias by product


select sc.setid, ca.product_id, ca.setid, ca.cust_id, ca.product_alias, ca.descr from ps_set_cntrl_rec sc, PS_PROD_CUST_ALIAS ca where sc.setcntrlvalue = ca.setid and sc.recname = 'PROD_ITEM'

  • Related Language Record: PRD_CALIAS_VLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
    4 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.

    Prompt Table: CUSTOMER

    5 PRODUCT_ALIAS Character(18) VARCHAR2(18) NOT NULL Product Alias
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description