| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DP_SPECS_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_SPECS_ID
|
| 2 |
DP_CAPTION |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_CAPTION
|
| 3 |
DP_DDH_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_BI
Y/N Table Edit
Default Value: N
|
| 4 |
DP_DDH_SO |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_SO
Y/N Table Edit
Default Value: N
|
| 5 |
DP_DDH_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_IN
Y/N Table Edit
Default Value: N
|
| 6 |
DP_DDH_OM |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_OM
Y/N Table Edit
Default Value: N
|
| 7 |
DP_DDH_PL |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_PL
Y/N Table Edit
Default Value: N
|
| 8 |
DP_DDH_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_PR
Y/N Table Edit
Default Value: N
|
| 9 |
DP_DDH_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_DDH_TR
Y/N Table Edit
Default Value: N
|
| 10 |
DP_CREATEFCITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Forecast Items flag used by Updater
Y/N Table Edit
Default Value: Y
|
| 11 |
DP_DHLOADER_UOM |
Character(1) |
VARCHAR2(1) NOT NULL |
Demand Loader Unit Of Measure options
0=Transaction UOM
1=Standard Inventory UOM
Default Value: 1
|
| 12 |
DP_ACCUMULATEDMD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_ACCUMULATEDMD
Y/N Table Edit
Default Value: Y
|
| 13 |
DP_RESETPERCENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_RESETPERCENT
|
| 14 |
DP_SPEC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_SPEC_STATUS
A=Active
N=New
Default Value: N
|
| 15 |
DP_FCST_KIT_SPEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Kit Option
N=Components
Y=Product Kits
Default Value: N
|
| 16 |
MAPID |
Character(3) |
VARCHAR2(3) NOT NULL |
Map ID
Prompt Table:
FINT_FLDMAP_HD
|
| 17 |
DP_UPDATEDBY |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UPDATEDBY
|
| 18 |
DP_DATEUPDATED |
DateTime(26) |
TIMESTAMP |
DP_DATEUPDATED
|
| 19 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 20 |
DP_CALENDARID |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CALENDARID
Prompt Table:
DP_CALENDARS
|
| 21 |
DP_WEIGHTPROFILE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_WEIGHTPROFILE
Prompt Table:
DP_WTPROFILES
|
| 22 |
FINT_DELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used for Demantra Integration XML file delimiter
+=+
-=-
.=.
/=/
\=\
|=|
Default Value: |
|
| 23 |
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
|
| 24 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 25 |
START_TIME |
Time(15) |
TIMESTAMP |
Start of Shift
|
| 26 |
END_TIME |
Time(15) |
TIMESTAMP |
End of Shift
|