GM_SALE_SRCH_VW

(SQL View)
 Index Back

Sales People


SELECT A.SETID , A.SUPPORT_TEAM_MBR , A.EFF_STATUS , A.TEAM_MEMBER_TYPE , A.LANGUAGE_CD , A.REGION_CD , A.EMPLID , A.COMM_BKS , A.COMM_SHP , A.COMM_INV , A.COMM_CASH , A.VENDOR_ID , A.NAME1 , A.EXT_EMAIL_ADDR FROM PS_MEMBER_PERSON A , PS_MEMBER_TYPE_TBL B WHERE A.TEAM_MEMBER_TYPE = B.TEAM_MEMBER_TYPE AND A.SETID = B.SETID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_MEMBER_TYPE_TBL B1 WHERE B1.SETID = B.SETID AND B1.TEAM_MEMBER_TYPE = B.TEAM_MEMBER_TYPE AND B1.EFFDT <= %CurrentDateIn AND B1.EFF_STATUS = 'A') AND B.SALES_PERSON = 'Y'

  • Related Language Record: GM_PROP_LNGVW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 GM_PROP_CONTACT Character(8) VARCHAR2(8) NOT NULL Proposal Contact
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 SALES_AGENT_TYP_CD Character(6) VARCHAR2(6) NOT NULL Sales Agent Type Code
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPTIONS.LANGUAGE_CD

    6 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 COMM_BKS Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Bookings
    9 COMM_SHP Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Shipping
    10 COMM_INV Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Invoice
    11 COMM_CASH Number(7,2) DECIMAL(6,2) NOT NULL Commission Payable at Cash Rec
    12 VEN_SUPP_ID Character(10) VARCHAR2(10) NOT NULL Supplier/Supplier X-REF
    13 GM_CUST_NM Character(40) VARCHAR2(40) NOT NULL Name
    14 EXT_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Electronic Mail Address