CUSTGP_SCON_VW3

(SQL View)
 Index Back

Customer Buy Agrmt NG Grp Vw

View for determining which Contract Customer Group the customer belongs. Date Init. Issue # Description 01/03/01 JJM R-SGATIG-ZV65C Created view and changed SQL to not select global customer groups. Used as prompt table for CUST_CGRP_LNK.CUSTOMER_GROUP 04/11/01 JJM R-JMESER-8N9EZ Added effdt logic

SELECT A.SETID , A.CUSTOMER_GROUP , A.EFFDT , A.DESCR , A.EFF_STATUS , A.DESCRSHORT , A.GLOBAL_FLAG FROM PS_CUST_GROUP_TBL A WHERE CUST_GRP_TYPE = 'SCON' AND GLOBAL_FLAG = 'N' AND %EffdtCheck(cust_group_tbl,A,%CurrentDateIn) AND A.EFF_STATUS='A'

  • Related Language Record: CUSTGP_SCONLVW3

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

    Prompt Table: SP_SETID_NONVW

    2 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 GLOBAL_FLAG Character(1) VARCHAR2(1) NOT NULL Global

    Y/N Table Edit