PROD_GRP_VAT_VW

(SQL View)
 Index Back

All Products groups for VAT


SELECT a.setid , a.product_group , a.descr , a.global_flag FROM PS_PROD_GROUP_TBL a WHERE a.prod_grp_type = 'VAT' AND %EffdtCheck(prod_group_tbl b, a, %CurrentDateIn) AND a.eff_status = 'A'

  • Related Language Record: PROD_GPVATV_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROD_GRP_SETID Character(5) VARCHAR2(5) NOT NULL Product Group SetID
    2 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global

    Y/N Table Edit

    Default Value: N