DP_DEL_FCI_VW

(SQL View)
 Index Back

DP_VIEWFLD_SELS FCINQCH

SELECT DP_CONFIGVIEW ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE ,DP_AVAILON_POLSETS FROM PS_DP_VIEWFLD_SELS WHERE DP_AVAILON_FCINQCH = 'Y'

SELECT DP_CONFIGVIEW ,DP_FIELDID ,DP_CAPTION ,DP_DATATYPE FROM PS_DP_VIEWFLD_SELS WHERE DP_FIELDID LIKE 'DP_%' AND DP_FIELDID NOT LIKE 'DP_%AUDIT' AND DP_FIELDID NOT LIKE 'DP_USERDATA%' AND DP_FIELDID NOT LIKE 'DP_FORECAST0%' AND DP_FIELDID NOT LIKE 'DP_FORECAST10' AND DP_FIELDID <> 'DP_CONFIGVIEW' AND DP_FIELDID NOT IN ('DP_ACTUALDEMAND', 'DP_ADJDEMAND', 'DP_ADJFORECAST','DP_ADJUSTMENTBASIS', 'DP_ASSIGNTO' ,'DP_BOX_AUTOCOEFF' ,'DP_BOX_PARTIALCOEF' ,'DP_BOX_TRANS_METH' ,'DP_COMMENTS' ,'DP_CONFIGFUTUREPDS' ,'DP_CALCYEARPERIOD' ,'DP_CONFIGHISTPDS' ,'DP_CONVFACTOR' ,'DP_DEMANDDATE' ,'DP_DEMANDUOM' ,'DP_DEMANDVALUE' ,'DP_DMD_COMMENT' ,'DP_DMD_PROCESS_ACT' ,'DP_ENDDATE' ,'DP_ENDDATETIME' ,'DP_ERROR_STATUS' ,'DP_EVALADJFORE' ,'DP_EVALPRORFORE' ,'DP_EVALSTATFORE' ,'DP_FC_COMMENT' ,'DP_FC_PROCESS_ACT' ,'DP_FCST_PERIOD' ,'DP_FCST_YEAR' ,'DP_FORECASTADJ' ,'DP_FUNCTIONCODE' ,'DP_IMPORT_SPEC' ,'DP_MAPEADJ' ,'DP_MAPEEVALADJ' ,'DP_MAPEEVALPROR' ,'DP_MAPEEVALSTAT' ,'DP_MAPEPROR' ,'DP_MAPESTAT' ,'DP_MEAN_ERROR' ,'DP_MEANABSERROR' ,'DP_MESSAGENUMBER' ,'DP_NUMPERIODS' ,'DP_PERIOD' ,'DP_PERIODAVGPRICE' ,'DP_PERIODCOST' ,'DP_PERIODPRICE' ,'DP_PREVYEARDEMAND' ,'DP_PRIMARYKEY' ,'DP_PROFORECAST' ,'DP_PUBLISHUOM' ,'DP_RMSE' ,'DP_SEASONALITYTYPE' ,'DP_SEASONFACTOR' ,'DP_SEQNUMBER' ,'DP_STARTDATE' ,'DP_STARTDATETIME' ,'DP_STATFORECAST' ,'DP_STATUSMESSAGE' ,'DP_SYSTEMDATE' ,'DP_TRANSDATE' ,'DP_UPDATESTATUS' ,'DP_URGENCYLEVEL' ,'DP_USERFIELD' ,'DP_USERID' ,'DP_X11_IRREGAVSTAT' ,'DP_X11_IRREGSTAT' ,'DP_X11_TRENDCYCLE' ,'DP_YEAR')

  • Related Language Record: DP_VWFLD9_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
    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