| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 3 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 4 |
DP_CONFIGVIEW |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
|
| 5 |
DP_ROLLPRICECOST |
Character(1) |
VARCHAR2(1) NOT NULL |
Roll Forward Period Price/Cost
Y/N Table Edit
Default Value: N
|
| 6 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 7 |
OPRID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 8 |
RUN_CNTL_ID2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 9 |
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.
|
| 10 |
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
|
| 11 |
CALC_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Used during Change Order batch processing
BA=Basic
PR=Price Change
VC=VAT Other Change
VS=VAT Shipto Change
|
| 12 |
ROWS_RETRIEVED |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Rows Retrieved
|
| 13 |
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
|
| 14 |
MAX_ROW |
Number(9,0) |
DECIMAL(9) NOT NULL |
Max Number of Rows
|
| 15 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 16 |
PERIOD_OFFSET |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Override Period
|
| 17 |
DP_FCVIEWLOCK |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_FCVIEWLOCK
0=Not Locked
1=Update Lock
2=View Locked
|
| 18 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 19 |
SEQ_NBR2 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
|
| 20 |
DP_ADJHIST_SEQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
DP_ADJHIST_SEQ
|
| 21 |
DP_WRKQUE_SEQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
DP_WRKQUE_SEQ
|
| 22 |
DP_FCSTARTPERIOD |
Number(3,0) |
SMALLINT NOT NULL |
DP_FCSTARTPERIOD
|
| 23 |
DP_FCSTARTYEAR |
Number(4,0) |
SMALLINT NOT NULL |
DP_FCSTARTYEAR
|
| 24 |
DP_PDSPERYEAR |
Number(2,0) |
SMALLINT NOT NULL |
DP_PDSPERYEAR
Default Value: 0
|
| 25 |
DP_CONFIGHISTPDS |
Number(3,0) |
SMALLINT NOT NULL |
DP_CONFIGHISTPDS
Default Value: 36
|
| 26 |
DP_CONFIGFUTUREPDS |
Number(3,0) |
SMALLINT NOT NULL |
DP_CONFIGFUTUREPDS
Default Value: 24
|
| 27 |
DP_PRICEPERIODS |
Number(2,0) |
SMALLINT NOT NULL |
DP_PRICEPERIODS
Default Value: 3
|
| 28 |
DP_PECALCULATIONCD |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_PECALCULATIONCD
|
| 29 |
DP_CALCCODE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CALCCODE
|
| 30 |
DP_CALENDARID |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CALENDARID
|
| 31 |
DP_TIMEPERIODCODE |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_TIMEPERIODCODE
|
| 32 |
DP_UPDATEPCSTATIC |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_UPDATEPCSTATIC
Y/N Table Edit
Default Value: N
|
| 33 |
DP_VARIANCELAWPDS |
Number(3,0) |
SMALLINT NOT NULL |
DP_VARIANCELAWPDS
Default Value: 2
|
| 34 |
DP_CONFIGEVALPDS |
Number(3,0) |
SMALLINT NOT NULL |
DP_CONFIGEVALPDS
Default Value: 2
|
| 35 |
DP_SUPPRESSFCCALCS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_SUPPRESSFCCALCS
Y/N Table Edit
Default Value: N
|
| 36 |
DP_MAPEADJUPDREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEADJUPDREQ
Y/N Table Edit
Default Value: N
|
| 37 |
DP_MAPEEVADJUPDREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEEVADJUPDREQ
Y/N Table Edit
Default Value: N
|
| 38 |
DP_MAPEEVPROUPDREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEEVPROUPDREQ
Y/N Table Edit
Default Value: N
|
| 39 |
DP_MAPEEVSTAUPDREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEEVSTAUPDREQ
Y/N Table Edit
Default Value: N
|
| 40 |
DP_MAPEPROUPDREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPEPROUPDREQ
Y/N Table Edit
Default Value: N
|
| 41 |
DP_MAPESTATUPDREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_MAPESTATUPDREQ
Y/N Table Edit
Default Value: N
|
| 42 |
DP_MAPEPERIODS |
Number(2,0) |
SMALLINT NOT NULL |
DP_MAPEPERIODS
Default Value: 6
|
| 43 |
DP_CONFIGLEVEL |
Number(2,0) |
SMALLINT NOT NULL |
DP_CONFIGLEVEL
|
| 44 |
DP_FORECASTITEM |
Character(120) |
VARCHAR2(120) NOT NULL |
DP_FORECASTITEM
|
| 45 |
START_PERIOD |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Start Period
|
| 46 |
START_YEAR |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Start Year
|
| 47 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 48 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 49 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|