LM_CF_PRODCT_VW

(SQL View)
Index Back

Product Chartfield View

Product Chart Field View

SELECT SETID , LM_PRODUCT , LM_CF_PROD_DESCR , LM_CF_PROD_SDESCR FROM PS_LM_CF_PRODUCT WHERE %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT AND EFF_STATUS = 'A'

  • Related Language Record: LM_PRODCT_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LM_PRODUCT Character(20) VARCHAR2(20) NOT NULL Product Chartfield
    3 LM_CF_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Chart Field description
    4 LM_CF_PROD_SDESCR Character(10) VARCHAR2(10) NOT NULL Product Chart Field Short Description