PROCESS_INSTANCE0=Best Fit
1=Reoptimize
2=No Calculation
DP_FCITEMS_AET(SQL Table) |
Index Back |
|---|---|
DP_FCITEMS_AETThe subrecords contain the following arrays SUBREC_INT = Tracking Signals SUBREC_CHAR = Security Group SUBREC_NBR = Profile Factors |
| # | 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_FCITEMCAPTION | Character(40) | VARCHAR2(40) NOT NULL | DP_FCITEMCAPTION |
| 6 | DP_HISTDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_HISTDEMANDPDS |
| 7 | DP_EFFDEMANDPDS | Number(3,0) | SMALLINT NOT NULL | DP_EFFDEMANDPDS |
| 8 | DP_CALCULATIONTYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_CALCULATIONTYPE
0=Best Fit 1=Reoptimize 2=No Calculation |
| 9 | DP_BASEUOM | Character(3) | VARCHAR2(3) NOT NULL | DP_BASEUOM |
| 10 | DP_WEIGHT | Number(13,2) | DECIMAL(12,2) NOT NULL | DP_WEIGHT |
| 11 | DP_WEIGHTUOM | Character(3) | VARCHAR2(3) NOT NULL | DP_WEIGHTUOM |
| 12 | DP_VOLUME | Number(13,2) | DECIMAL(12,2) NOT NULL | DP_VOLUME |
| 13 | DP_VOLUMEUOM | Character(3) | VARCHAR2(3) NOT NULL | DP_VOLUMEUOM |
| 14 | DP_STANDARDCOST | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_STANDARDCOST |
| 15 | DP_STANDARDPRICE | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_STANDARDPRICE |
| 16 | DP_AVGPRICE | Number(15,4) | DECIMAL(14,4) NOT NULL | DP_AVGPRICE |
| 17 | DP_PERIODCREATED | Number(2,0) | SMALLINT NOT NULL | DP_PERIODCREATED |
| 18 | DP_YEARCREATED | Number(4,0) | SMALLINT NOT NULL | DP_YEARCREATED |
| 19 | DP_ROUNDDECIMALS | Signed Number(3,0) | DECIMAL(2) NOT NULL | DP_ROUNDDECIMALS |
| 20 | DP_DATESTAMP | DateTime(26) | TIMESTAMP | DP_DATESTAMP |