POS_SRC_DEAL_VW

(SQL View)
 Index Back

POS SOURCE TABLE View

11/7/97 AK - Created. View to prompt for POS_SOURCE_ID on Deal Condition Panel. The view is used because AE,which calulates the value, only checks for POS_SOURCE_ID = "DEAL CHECK"

select SETID ,POS_SOURCE_ID ,DESCR from PS_POS_SOURCE_TBL where POS_SOURCE_ID = 'DEAL CHECK'

  • Related Language Record: POS_SOURCE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description