| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DP_POLICYSET |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_POLICYSET
Prompt Table:
DP_POLICYSETS
|
| 2 |
DP_ITEMCODE |
Character(18) |
VARCHAR2(18) NOT NULL |
DP_ITEMCODE
|
| 3 |
DP_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
DP_LOCATION
|
| 4 |
DP_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_DESCR
|
| 5 |
DP_POLICYCONTROL |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_POLICYCONTROL
Prompt Table:
DP_POLICYCTRLS
|
| 6 |
DP_INVENTORYUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_INVENTORYUOM
Prompt Table:
UNITS_TBL
|
| 7 |
DP_STANDARDUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_STANDARDUOM
|
| 8 |
DP_LEADTIME |
Number(4,0) |
SMALLINT NOT NULL |
DP_LEADTIME
|
| 9 |
DP_LEADTIMEUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_LEADTIMEUOM
Default Value: DAY
Prompt Table:
UNITS_TBL
|
| 10 |
DP_WEIGHT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_WEIGHT
|
| 11 |
DP_WEIGHTUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_WEIGHTUOM
Prompt Table:
UNITS_TBL
|
| 12 |
DP_VOLUME |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_VOLUME
|
| 13 |
DP_VOLUMEUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_VOLUMEUOM
Prompt Table:
UNITS_TBL
|
| 14 |
DP_INHERITCONTROLS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_INHERITCONTROLS
Y/N Table Edit
Default Value: Y
|
| 15 |
DP_RUNOUTDATE |
Date(10) |
DATE |
DP_RUNOUTDATE
|
| 16 |
DP_SAFETYSTOCK |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_SAFETYSTOCK
|
| 17 |
DP_REORDERPOINT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_REORDERPOINT
|
| 18 |
DP_ORDERQUANTITY |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERQUANTITY
|
| 19 |
DP_MINIMUM |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MINIMUM
|
| 20 |
DP_MAXIMUM |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAXIMUM
|
| 21 |
DP_AVGINVENTORY |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_AVGINVENTORY
|
| 22 |
DP_SERVICEFILL |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SERVICEFILL
|
| 23 |
DP_TURNRATE |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_TURNRATE
|
| 24 |
DP_OQMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_OQMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Economic Order Quantity
4=Lot for Lot
Default Value: 0
|
| 25 |
DP_OQARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQARGUMENT
|
| 26 |
DP_OQLIMITMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_OQLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity
Default Value: 0
|
| 27 |
DP_OQLOWERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQLOWERLIMIT
|
| 28 |
DP_OQUPPERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQUPPERLIMIT
|
| 29 |
DP_SSMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_SSMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Percentage Demand Fill
4=% Cycles Without Shortage
5=Maximum Lead Time Usage
Default Value: 0
|
| 30 |
DP_SSARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSARGUMENT
|
| 31 |
DP_SSLIMITMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_SSLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity
Default Value: 0
|
| 32 |
DP_SSLOWERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSLOWERLIMIT
|
| 33 |
DP_SSUPPERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSUPPERLIMIT
|
| 34 |
DP_ROPMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_ROPMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Lead Time Demand
4=Lead Time + Safety Stock
Default Value: 0
|
| 35 |
DP_ROPARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_ROPARGUMENT
|
| 36 |
DP_MINMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
4 & 5 Translate values not used as they were not used in old system
0=None
1=Days Supply
2=Fixed Quantity
3=Safety Stock
Default Value: 0
|
| 37 |
DP_MINARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_MINARGUMENT
|
| 38 |
DP_MAXMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_MAXMETHOD
0=None
1=Days Supply
2=Fixed Quantity
3=Safety Stock + Order Quantity
Default Value: 0
|
| 39 |
DP_MAXARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_MAXARGUMENT
|
| 40 |
DP_ORDERCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERCOST
|
| 41 |
DP_CARRYINGCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_CARRYINGCOST
|
| 42 |
DP_STANDARDPRICE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_STANDARDPRICE
|
| 43 |
DP_STANDARDCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_STANDARDCOST
|
| 44 |
DP_ANNUALCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ANNUALCOST
|
| 45 |
DP_ANNUALINVEST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ANNUALINVEST
|
| 46 |
DP_ORDERMULT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERMULT
|
| 47 |
DP_STATICCALCFLG |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_STATICCALCFLG
0=Period Number
1=Periods to Average
Default Value: 1
|
| 48 |
DP_STATICCALCARG |
Number(2,0) |
SMALLINT NOT NULL |
DP_STATICCALCARG
|
| 49 |
DP_LASTSTATICCHG |
Date(10) |
DATE |
DP_LASTSTATICCHG
|
| 50 |
DP_LASTCALCDATE |
DateTime(26) |
TIMESTAMP |
DP_LASTCALCDATE
|
| 51 |
DP_LASTANNLCOSTUPD |
Date(10) |
DATE |
DP_LASTANNLCOSTUPD
|
| 52 |
DP_MAXLTUSAGEMETH |
Character(4) |
VARCHAR2(4) NOT NULL |
Max LT Usage Method
0=Static
1=Lead Time Daily Usage
2=Lead Time Period Usage
3=Maximum Possible Usage
Default Value: 1
|
| 53 |
DP_HISTMAXLTUSAGE |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_HISTMAXLTUSAGE
|
| 54 |
DP_FCPERIODS |
Number(4,0) |
SMALLINT NOT NULL |
DP_FCPERIODS
|
| 55 |
DP_FCSTDDEV |
Number(22,2) |
DECIMAL(21,2) NOT NULL |
DP_FCSTDDEV
|
| 56 |
DP_SIMFCSTDDEV |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SIMFCSTDDEV
|
| 57 |
DP_EFFDEMANDPDS |
Number(3,0) |
SMALLINT NOT NULL |
DP_EFFDEMANDPDS
|
| 58 |
DP_EXPLODEDITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_EXPLODEDITEM
Y/N Table Edit
|
| 59 |
DP_LOWLEVELCD |
Number(3,0) |
SMALLINT NOT NULL |
DP_LOWLEVELCD
|
| 60 |
DP_ORDERCOUNT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_ORDERCOUNT
|
| 61 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table:
DP_UTILIZ_CD_VW
|
| 62 |
UTILIZ_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count
|
| 63 |
DP_LASTTRANSDATE |
DateTime(26) |
TIMESTAMP |
DP_LASTTRANSDATE
|
| 64 |
DP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Publish Name
|
| 65 |
DP_PUBLISH_DATE |
Date(10) |
DATE |
DP_PUBLISH_DATE
|
| 66 |
DP_CORPSTARTPD |
Number(2,0) |
SMALLINT NOT NULL |
DP_CORPSTARTPD
|
| 67 |
DP_CORPSTARTYR |
Number(4,0) |
SMALLINT NOT NULL |
DP_CORPSTARTYR
|
| 68 |
DP_CORPENDPD |
Number(2,0) |
SMALLINT NOT NULL |
DP_CORPENDPD
|
| 69 |
DP_CORPENDYR |
Number(4,0) |
SMALLINT NOT NULL |
DP_CORPENDYR
|
| 70 |
PRODUCT_KIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Kit
Default Value: N
|
| 71 |
DP_UD01 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD01
|
| 72 |
DP_UD02 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD02
|
| 73 |
DP_UD03 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD03
|
| 74 |
DP_UD04 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD04
|
| 75 |
DP_UD05 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD05
|
| 76 |
DP_UD06 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD06
|
| 77 |
DP_UD07 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD07
|
| 78 |
DP_UD08 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD08
|
| 79 |
DP_UD09 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD09
|
| 80 |
DP_UD10 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD10
|
| 81 |
DP_UD11 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD11
|
| 82 |
DP_UD12 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD12
|
| 83 |
DP_UD13 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD13
|
| 84 |
DP_UD14 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD14
|
| 85 |
DP_UD15 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD15
|
| 86 |
DP_UD16 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD16
|
| 87 |
DP_UD17 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD17
|
| 88 |
DP_UD18 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD18
|
| 89 |
DP_UD19 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD19
|
| 90 |
DP_UD20 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD20
|
| 91 |
DP_UD21 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD21
|
| 92 |
DP_UD22 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD22
|
| 93 |
DP_UD23 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD23
|
| 94 |
DP_UD24 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD24
|
| 95 |
DP_UD25 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD25
|
| 96 |
DP_UD26 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD26
|
| 97 |
DP_UD27 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD27
|
| 98 |
DP_UD28 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD28
|
| 99 |
DP_UD29 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD29
|
| 100 |
DP_UD30 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD30
|
| 101 |
DP_UD31 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD31
|
| 102 |
DP_UD32 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD32
|
| 103 |
DP_UD33 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD33
|
| 104 |
DP_UD34 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD34
|
| 105 |
DP_UD35 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD35
|
| 106 |
DP_UD36 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD36
|
| 107 |
DP_UD37 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD37
|
| 108 |
DP_UD38 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD38
|
| 109 |
DP_UD39 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD39
|
| 110 |
DP_UD40 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD40
|
| 111 |
DP_UD41 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD41
|
| 112 |
DP_UD42 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD42
|
| 113 |
DP_UD43 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD43
|
| 114 |
DP_UD44 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD44
|
| 115 |
DP_UD45 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD45
|
| 116 |
DP_UD46 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD46
|
| 117 |
DP_UD47 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD47
|
| 118 |
DP_UD48 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD48
|
| 119 |
DP_UD49 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD49
|
| 120 |
DP_UD50 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD50
|