| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 5 |
OPRID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 6 |
RUN_CNTL_ID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 7 |
PROCESSING_GROUP |
Number(10,0) |
DECIMAL(10) NOT NULL |
A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
|
| 8 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 9 |
DP_DDHUPD_DTTM |
DateTime(26) |
TIMESTAMP |
datetime of last update to demand_history table
|
| 10 |
DP_DDH_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_BI
Y/N Table Edit
Default Value: Y
|
| 11 |
DP_DDH_SO |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_SO
Y/N Table Edit
Default Value: Y
|
| 12 |
DP_DDH_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_IN
Y/N Table Edit
|
| 13 |
DP_DDH_OM |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_OM
Y/N Table Edit
|
| 14 |
DP_DDH_PL |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_PL
Y/N Table Edit
|
| 15 |
DP_DDH_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_PR
Y/N Table Edit
|
| 16 |
DP_DDH_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_TR
Y/N Table Edit
|
| 17 |
DP_DDHUPD_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_DDHUPD_ACTION
|
| 18 |
DP_DDHUPD_DATE |
Date(10) |
DATE |
DP_DDHUPD_DATE
|
| 19 |
DP_DDHUPD_DATE_FR |
Date(10) |
DATE |
DP_DDHUPD_DATE_FR
|
| 20 |
DP_DDHUPD_DATE_TO |
Date(10) |
DATE |
DP_DDHUPD_DATE_TO
|
| 21 |
DP_DDHUPD_ROWS |
Number(7,0) |
INTEGER NOT NULL |
DP_DDHUPD_ROWS
|
| 22 |
DP_FROMDEMANDDATE |
Date(10) |
DATE |
DP_FROMDEMANDDATE
|
| 23 |
DP_TODEMANDDATE |
Date(10) |
DATE |
DP_TODEMANDDATE
|
| 24 |
DP_CUSTOM_FLD_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_CUSTOM_FLD_FROM
B=BU Items Inventory
M=Master Item Table
|
| 25 |
DP_PUBID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
DP_PUBID
|
| 26 |
DP_FCST_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Kit Option
B=Both
N=Components
Y=Product Kits
|
| 27 |
DP_FCST_KIT_SPEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Kit Option
N=Components
Y=Product Kits
|
| 28 |
DP_DDHUPD_LOGTXT |
Character(50) |
VARCHAR2(50) NOT NULL |
DP_DDHUPD_LOGTXT
|
| 29 |
DP_DDH_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Demand data history table - row ID (key)
|
| 30 |
DP_SPECS_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_SPECS_ID
|
| 31 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 32 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 33 |
DP_CREATEFCITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Forecast Items flag used by Updater
Y/N Table Edit
Default Value: N
|
| 34 |
DP_ACCUMULATEDMD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_ACCUMULATEDMD
Y/N Table Edit
Default Value: N
|
| 35 |
DP_DHLOADER_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Demand Loader Unit Of Measure options
0=Transaction UOM
1=Standard Inventory UOM
|
| 36 |
DP_RESETPERCENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_RESETPERCENT
|
| 37 |
DP_CONFIGVIEW |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
|
| 38 |
DP_TRANSACTIONS |
Character(50) |
VARCHAR2(50) NOT NULL |
DP_TRANSACTIONS
|
| 39 |
DP_CONFIGVIEW_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW_1
|
| 40 |
DP_CONFIGVIEW_2 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW_2
|
| 41 |
DP_CONFIGVIEW_3 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW_3
|
| 42 |
DP_CONFIGVIEW_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW_4
|
| 43 |
DP_CONFIGVIEW_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW_5
|
| 44 |
DP_DDHUPD_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
DP_DDHUPD_SOURCE
BI=Billing
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PR=Purchasing Requisition
RT=Material Return
SO=Order Shipments
|
| 45 |
DP_COUNTER |
Number(5,0) |
INTEGER NOT NULL |
DP_COUNTER
|
| 46 |
DP_DDH_EXEC |
Number(3,0) |
SMALLINT NOT NULL |
Process execution flag: 1 = executed by user 0 = executed by recurrence. This field used by demand history processes to determine when the select date windows should be automatically incremented if this is a scheduled process or if the select date windows should be taken directly from the run control table, without manipulation.
|
| 47 |
DP_ADJ_REASON |
Character(8) |
VARCHAR2(8) NOT NULL |
DP_ADJ_REASON
|
| 48 |
DP_ADJ_COMMENT |
Character(50) |
VARCHAR2(50) NOT NULL |
DP_ADJ_COMMENT
|
| 49 |
DP_RETRY_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
DP_RETRY_COUNT
|
| 50 |
DP_PARALLEL_PRCS |
Number(3,0) |
SMALLINT NOT NULL |
Date Initials Reference # Description
03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines
|
| 51 |
DP_JOBS_IN_PRCS |
Number(3,0) |
SMALLINT NOT NULL |
Date Initials Reference # Description
03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines
|
| 52 |
DP_USERDATACODE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_USERDATACODE
|
| 53 |
DBTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
|
| 54 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 55 |
DP_ERRORMESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
DP_ERRORMESSAGE
|
| 56 |
DP_CONCATFCITEM |
Character(254) |
VARCHAR2(254) NOT NULL |
DP_CONCATFCITEM
|
| 57 |
DP_WHERENOBLANK |
Character(254) |
VARCHAR2(254) NOT NULL |
DP_WHERENOBLANK
|
| 58 |
DP_LENGTHCHECK |
Character(254) |
VARCHAR2(254) NOT NULL |
DP_LENGTHCHECK
|
| 59 |
DP_KEYFLDNAMES |
Character(254) |
VARCHAR2(254) NOT NULL |
DP_KEYFLDNAMES
|
| 60 |
DP_WEIGHTPROFILE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_WEIGHTPROFILE
|
| 61 |
MAPID |
Character(3) |
VARCHAR2(3) NOT NULL |
Map ID
|
| 62 |
DP_FCIP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_FCIP_OPTION
I=Item Forecast
P=Product Forecast
|
| 63 |
DP_LIFEDESC |
Long Character |
CLOB |
DP_LIFEDESC
|
| 64 |
DP_CREATEITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_CREATEITEMS
Y/N Table Edit
Default Value: N
|
| 65 |
SALES_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales
Y/N Table Edit
Default Value: Y
|
| 66 |
DP_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
DP_LOCATION
Y/N Table Edit
Default Value: N
|
| 67 |
DP_FILEPATH |
Character(254) |
VARCHAR2(254) NOT NULL |
DP_FILEPATH
|
| 68 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 69 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 70 |
FINT_OUTPUT_XML |
Character(1) |
VARCHAR2(1) NOT NULL |
Export as XML files
Y/N Table Edit
Default Value: N
|
| 71 |
DP_DAILYWEIGHTS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DAILYWEIGHTS
Y/N Table Edit
|
| 72 |
DP_CALENDARID |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CALENDARID
|
| 73 |
FINT_DELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for Demantra Integration XML file delimiter
+=+
-=-
.=.
/=/
\=\
|=|
|
| 74 |
FINT_MASTER_ORG |
Character(5) |
VARCHAR2(5) NOT NULL |
Master Branch for Demantra Integration
|
| 75 |
MG_SHIFT |
Number(2,0) |
SMALLINT NOT NULL |
MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift.
07/23/98 TKI CN#MG800-5.0
Created to replace SHIFT for the database reconcilation project (8.0)
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Default Value: 1
|
| 76 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 77 |
START_TIME |
Time(15) |
TIMESTAMP |
Start of Shift
|
| 78 |
END_TIME |
Time(15) |
TIMESTAMP |
End of Shift
|
| 79 |
DP_SELECT_BTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Fields
|