DP_FCDATA_AET

(SQL Table)
Index Back

Sub table to Forecast Items

This sub table contains the following clips: Actual Demand Demand Value Adjusted Demand Adjusted Demand Reason Demand Comment Stat Forecast Prorated Forecast Adjusted Forecast Forecast Adustment Forecast Adjustment Reason Forecast Comment Summary Forecast Eval Stat Forecast Eval Adj Forecast Eval Prorated Forecast Resultant Adjustment Resultant Reason

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
3 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
4 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
5 DP_FCST_YEAR Number(4,0) SMALLINT NOT NULL Forecast Year
6 DP_FCST_PERIOD Number(3,0) SMALLINT NOT NULL DP_FCST_PERIOD
7 DP_CALCYEARPERIOD Number(6,0) INTEGER NOT NULL DP_CALCYEARPERIOD
8 DP_DATESTAMP DateTime(26) TIMESTAMP DP_DATESTAMP
9 DP_ACTUALDEMAND Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_ACTUALDEMAND
10 DP_DEMANDVALUE Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_DEMANDVALUE
11 DP_ADJDEMAND Signed Number(16,4) DECIMAL(14,4) NOT NULL Adjusted Demand
12 DP_DMD_PROCESS_ACT Character(1) VARCHAR2(1) NOT NULL DP_DMD_PROCESS_ACT
0=Not Adjusted
1=Direct
13 DP_DMD_COMMENT Character(50) VARCHAR2(50) NOT NULL DP_DMD_COMMENT
14 DP_STATFORECAST Number(15,4) DECIMAL(14,4) NOT NULL DP_STATFORECAST
15 DP_PROFORECAST Number(15,4) DECIMAL(14,4) NOT NULL DP_PROFORECAST
16 DP_ADJFORECAST Number(15,4) DECIMAL(14,4) NOT NULL DP_ADJFORECAST
17 DP_FORECASTADJ Number(15,4) DECIMAL(14,4) NOT NULL DP_FORECASTADJ
18 DP_FC_PROCESS_ACT Character(1) VARCHAR2(1) NOT NULL DP_FC_PROCESS_ACT
0=Not Adjusted/Prorated
1=Not Adjusted/Not Prorated
2=Direct/Prorated
3=Direct/Not Prorated
4=Promoted/Prorated
5=Promoted/Not Prorated
6=Event/Prorated
7=Event/Not Prorated
19 DP_FC_COMMENT Character(50) VARCHAR2(50) NOT NULL DP_FC_COMMENT
20 DP_SUMMFORECAST Number(15,4) DECIMAL(14,4) NOT NULL DP_SUMMFORECAST
21 DP_EVALSTATFORE Number(15,4) DECIMAL(14,4) NOT NULL DP_EVALSTATFORE
22 DP_EVALADJFORE Number(15,4) DECIMAL(14,4) NOT NULL DP_EVALADJFORE
23 DP_EVALPRORFORE Number(15,4) DECIMAL(14,4) NOT NULL DP_EVALPRORFORE
24 DP_RESULTANTADJ Number(15,4) DECIMAL(14,4) NOT NULL DP_RESULTANTADJ
25 DP_RES_PROCESS_ACT Character(1) VARCHAR2(1) NOT NULL DP_RES_PROCESS_ACT
0=Not Adjusted/Prorated
1=Not Adjusted/Not Prorated
2=Direct/Prorated
3=Direct/Not Prorated
4=Promoted/Prorated
5=Promoted/Not Prorated
6=Event/Prorated
7=Event/Not Prorated

Default Value: 0

26 DP_PERIODPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_PERIODPRICE
27 DP_PERIODCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_PERIODCOST
28 DP_PERIODAVGPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_PERIODAVGPRICE
29 DP_MAPEADJ Number(15,4) DECIMAL(14,4) NOT NULL DP_MAPEADJ
30 DP_MAPEPROR Number(15,4) DECIMAL(14,4) NOT NULL DP_MAPEPROR
31 DP_MAPESTAT Number(15,4) DECIMAL(14,4) NOT NULL DP_MAPESTAT
32 DP_MAPEEVALADJ Number(15,4) DECIMAL(14,4) NOT NULL DP_MAPEEVALADJ
33 DP_MAPEEVALPROR Number(15,4) DECIMAL(14,4) NOT NULL DP_MAPEEVALPROR
34 DP_MAPEEVALSTAT Number(15,4) DECIMAL(14,4) NOT NULL DP_MAPEEVALSTAT
35 DP_USERDATA01 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA01
36 DP_USERDATA02 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA02
37 DP_USERDATA03 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA03
38 DP_USERDATA04 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA04
39 DP_USERDATA05 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA05
40 DP_USERDATA06 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA06
41 DP_USERDATA07 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_USERDATA07
42 DP_USERDATA08 Character(30) VARCHAR2(30) NOT NULL DP_USERDATA08
43 DP_USERDATA09 Character(30) VARCHAR2(30) NOT NULL DP_USERDATA09
44 DP_USERDATA10 Date(10) DATE DP_USERDATA10
45 DP_FORECAST01 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST01
46 DP_FORECAST02 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST02
47 DP_FORECAST03 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST03
48 DP_FORECAST04 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST04
49 DP_FORECAST05 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST05
50 DP_FORECAST06 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST06
51 DP_FORECAST07 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST07
52 DP_FORECAST08 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST08
53 DP_FORECAST09 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST09
54 DP_FORECAST10 Signed Number(16,4) DECIMAL(14,4) NOT NULL DP_FORECAST10
55 DP_ACTDEMAUDIT Character(1) VARCHAR2(1) NOT NULL DP_ACTDEMAUDIT

Y/N Table Edit

56 DP_ADJDEMAUDIT Character(1) VARCHAR2(1) NOT NULL DP_ADJDEMAUDIT

Y/N Table Edit

57 DP_ADJFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_ADJFOREAUDIT

Y/N Table Edit

58 DP_EVADJFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_EVADJFOREAUDIT

Y/N Table Edit

59 DP_EVPROFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_EVPROFOREAUDIT

Y/N Table Edit

60 DP_EVSTATFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_EVSTATFOREAUDIT

Y/N Table Edit

61 DP_FOREADJAUDIT Character(1) VARCHAR2(1) NOT NULL DP_FOREADJAUDIT

Y/N Table Edit

62 DP_FORECAST01AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST01AUDIT

Y/N Table Edit

63 DP_FORECAST02AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST02AUDIT

Y/N Table Edit

64 DP_FORECAST03AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST03AUDIT

Y/N Table Edit

65 DP_FORECAST04AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST04AUDIT

Y/N Table Edit

66 DP_FORECAST05AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST05AUDIT

Y/N Table Edit

67 DP_FORECAST06AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST06AUDIT

Y/N Table Edit

68 DP_FORECAST07AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST07AUDIT

Y/N Table Edit

69 DP_FORECAST08AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST08AUDIT

Y/N Table Edit

70 DP_FORECAST09AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST09AUDIT

Y/N Table Edit

71 DP_FORECAST10AUDIT Character(1) VARCHAR2(1) NOT NULL DP_FORECAST10AUDIT

Y/N Table Edit

72 DP_MAPEADJAUDIT Character(1) VARCHAR2(1) NOT NULL DP_MAPEADJAUDIT

Y/N Table Edit

73 DP_MAPEEVADJAUDIT Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVADJAUDIT

Y/N Table Edit

74 DP_MAPEEVPRORAUDIT Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVPRORAUDIT

Y/N Table Edit

75 DP_MAPEEVSTATAUDIT Character(1) VARCHAR2(1) NOT NULL DP_MAPEEVSTATAUDIT

Y/N Table Edit

76 DP_MAPEPRORAUDIT Character(1) VARCHAR2(1) NOT NULL DP_MAPEPRORAUDIT

Y/N Table Edit

77 DP_MAPESTATAUDIT Character(1) VARCHAR2(1) NOT NULL DP_MAPESTATAUDIT

Y/N Table Edit

78 DP_PROFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_PROFOREAUDIT

Y/N Table Edit

79 DP_RESULTADJAUDIT Character(1) VARCHAR2(1) NOT NULL DP_RESULTADJAUDIT

Y/N Table Edit

80 DP_STATFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_STATFOREAUDIT

Y/N Table Edit

81 DP_SUMMFOREAUDIT Character(1) VARCHAR2(1) NOT NULL DP_SUMMFOREAUDIT

Y/N Table Edit

82 DP_USERDATA01AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA01AUDIT

Y/N Table Edit

83 DP_USERDATA02AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA02AUDIT

Y/N Table Edit

84 DP_USERDATA03AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA03AUDIT

Y/N Table Edit

85 DP_USERDATA04AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA04AUDIT

Y/N Table Edit

86 DP_USERDATA05AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA05AUDIT

Y/N Table Edit

87 DP_USERDATA06AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA06AUDIT

Y/N Table Edit

88 DP_USERDATA07AUDIT Character(1) VARCHAR2(1) NOT NULL DP_USERDATA07AUDIT

Y/N Table Edit