DP_INT_FCITEMS

(SQL Table)
Index Back

External Forecast Items Stage

This table is used as an intermediate table for loading ForecastItems from external (nonPS) sources.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_IMPORTSPEC Character(20) VARCHAR2(20) NOT NULL Specification used for running imports
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_SEQNUMBER Number(10,0) DECIMAL(10) NOT NULL MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
6 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION
7 DP_CONTROLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CONTROLGROUP
8 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
9 DP_BASEUOM Character(3) VARCHAR2(3) NOT NULL DP_BASEUOM

Prompt Table: UNITS_TBL

10 DP_WEIGHTUOM Character(3) VARCHAR2(3) NOT NULL DP_WEIGHTUOM

Prompt Table: UNITS_TBL

11 DP_WEIGHT Number(13,2) DECIMAL(12,2) NOT NULL DP_WEIGHT
12 DP_VOLUMEUOM Character(3) VARCHAR2(3) NOT NULL DP_VOLUMEUOM

Prompt Table: UNITS_TBL

13 DP_VOLUME Number(13,2) DECIMAL(12,2) NOT NULL DP_VOLUME
14 DP_NEXTLEVELUOM Character(3) VARCHAR2(3) NOT NULL DP_NEXTLEVELUOM

Prompt Table: UNITS_TBL

15 DP_NEXTLEVELCONV Number(13,2) DECIMAL(12,2) NOT NULL DP_NEXTLEVELCONV
16 DP_STANDARDCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDCOST
17 DP_STANDARDPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDPRICE
18 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type
19 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count
20 DP_FORECASTANALYST Character(20) VARCHAR2(20) NOT NULL DP_FORECASTANALYST
21 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
22 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION
23 DP_UD01 Character(30) VARCHAR2(30) NOT NULL DP_UD01
24 DP_UD02 Character(30) VARCHAR2(30) NOT NULL DP_UD02
25 DP_UD03 Character(30) VARCHAR2(30) NOT NULL DP_UD03
26 DP_UD04 Character(30) VARCHAR2(30) NOT NULL DP_UD04
27 DP_UD05 Character(30) VARCHAR2(30) NOT NULL DP_UD05
28 DP_UD06 Character(30) VARCHAR2(30) NOT NULL DP_UD06
29 DP_UD07 Character(30) VARCHAR2(30) NOT NULL DP_UD07
30 DP_UD08 Character(30) VARCHAR2(30) NOT NULL DP_UD08
31 DP_UD09 Character(30) VARCHAR2(30) NOT NULL DP_UD09
32 DP_UD10 Character(30) VARCHAR2(30) NOT NULL DP_UD10
33 DP_UD11 Character(20) VARCHAR2(20) NOT NULL DP_UD11
34 DP_UD12 Character(20) VARCHAR2(20) NOT NULL DP_UD12
35 DP_UD13 Character(20) VARCHAR2(20) NOT NULL DP_UD13
36 DP_UD14 Character(20) VARCHAR2(20) NOT NULL DP_UD14
37 DP_UD15 Character(20) VARCHAR2(20) NOT NULL DP_UD15
38 DP_UD16 Character(20) VARCHAR2(20) NOT NULL DP_UD16
39 DP_UD17 Character(20) VARCHAR2(20) NOT NULL DP_UD17
40 DP_UD18 Character(20) VARCHAR2(20) NOT NULL DP_UD18
41 DP_UD19 Character(20) VARCHAR2(20) NOT NULL DP_UD19
42 DP_UD20 Character(20) VARCHAR2(20) NOT NULL DP_UD20
43 DP_UD21 Character(10) VARCHAR2(10) NOT NULL DP_UD21
44 DP_UD22 Character(10) VARCHAR2(10) NOT NULL DP_UD22
45 DP_UD23 Character(10) VARCHAR2(10) NOT NULL DP_UD23
46 DP_UD24 Character(10) VARCHAR2(10) NOT NULL DP_UD24
47 DP_UD25 Character(10) VARCHAR2(10) NOT NULL DP_UD25
48 DP_UD26 Character(10) VARCHAR2(10) NOT NULL DP_UD26
49 DP_UD27 Character(10) VARCHAR2(10) NOT NULL DP_UD27
50 DP_UD28 Character(10) VARCHAR2(10) NOT NULL DP_UD28
51 DP_UD29 Character(10) VARCHAR2(10) NOT NULL DP_UD29
52 DP_UD30 Character(10) VARCHAR2(10) NOT NULL DP_UD30
53 DP_UD31 Character(10) VARCHAR2(10) NOT NULL DP_UD31
54 DP_UD32 Character(10) VARCHAR2(10) NOT NULL DP_UD32
55 DP_UD33 Character(10) VARCHAR2(10) NOT NULL DP_UD33
56 DP_UD34 Character(10) VARCHAR2(10) NOT NULL DP_UD34
57 DP_UD35 Character(10) VARCHAR2(10) NOT NULL DP_UD35
58 DP_UD36 Character(10) VARCHAR2(10) NOT NULL DP_UD36
59 DP_UD37 Character(10) VARCHAR2(10) NOT NULL DP_UD37
60 DP_UD38 Character(10) VARCHAR2(10) NOT NULL DP_UD38
61 DP_UD39 Character(10) VARCHAR2(10) NOT NULL DP_UD39
62 DP_UD40 Character(10) VARCHAR2(10) NOT NULL DP_UD40
63 DP_UD41 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD41
64 DP_UD42 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD42
65 DP_UD43 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD43
66 DP_UD44 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD44
67 DP_UD45 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD45
68 DP_UD46 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD46
69 DP_UD47 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD47
70 DP_UD48 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD48
71 DP_UD49 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD49
72 DP_UD50 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD50
73 DP_TRANSDATE Date(10) DATE DP_TRANSDATE
74 DP_TRANSFERREDBY Character(20) VARCHAR2(20) NOT NULL DP_TRANSFERREDBY
75 DP_ERRORMESSAGE Character(254) VARCHAR2(254) NOT NULL DP_ERRORMESSAGE
76 DP_UPDATESTATUS Signed Number(2,0) DECIMAL(1) NOT NULL 0 = Not processed 1 = Processed 2 = Partially Processed -1 = Errored
77 DP_DELETEDATA Character(1) VARCHAR2(1) NOT NULL DP_DELETEDATA

Y/N Table Edit

Default Value: N