DP_IPFLDSE11_VW

(SQL View)
 Index Back

IP selection for Mass Maint.

Date Initials Reference # Description 102607 MP F-MILIZ-85E75_IPP New Functionality/View This is a clone of view DP_IPFLDSEL4_VW without publish fields and items period fields. This was the easiest way to get the fields needed in the selection criteria. The other way imply to create a new field which result in having to change other routines. SELECT DP_POLICYSET ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE FROM PS_DP_POLFLD_SELS WHERE DP_AVAILON_PUBIP = 'Y' AND DP_FIELDID NOT IN('DP_AVGINVENTORY_P','DP_ENDDATE','DP_MAXIMUM_P','DP_MINIMUM_P','DP_ORDERQUANTITY_P','DP_POLICYSET','DP_PUBLISHUOM','DP_REORDERPOINT_P','DP_SAFETYSTOCK_P', 'DP_SERVICEFILL_P','DP_STARTDATE','DP_TURNRATE_P')

SELECT DP_POLICYSET ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE FROM PS_DP_POLFLD_SELS WHERE DP_AVAILON_PUBIP = 'Y' AND DP_FIELDID NOT IN('DP_AVGINVENTORY_P','DP_ENDDATE','DP_MAXIMUM_P','DP_MINIMUM_P','DP_ORDERQUANTITY_P','DP_POLICYSET','DP_PUBLISHUOM','DP_REORDERPOINT_P','DP_SAFETYSTOCK_P', 'DP_SERVICEFILL_P','DP_STARTDATE','DP_TURNRATE_P')

  • Related Language Record: DP_IPFLD11_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
    2 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID
    3 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
    4 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date