| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Publish Name
|
| 2 |
DP_PUBLISH_DATE |
Date(10) |
DATE NOT NULL |
DP_PUBLISH_DATE
|
| 3 |
DP_ITEMCODE |
Character(18) |
VARCHAR2(18) NOT NULL |
DP_ITEMCODE
|
| 4 |
DP_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
DP_LOCATION
|
| 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_PUBLISHUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_PUBLISHUOM
|
| 8 |
DP_CONVFACTOR |
Number(17,6) |
DECIMAL(16,6) NOT NULL |
DP_CONVFACTOR
|
| 9 |
DP_STDUOMCONVFACT |
Number(17,6) |
DECIMAL(16,6) NOT NULL |
DP_STDUOMCONVFACT
|
| 10 |
DP_LEADTIME |
Number(4,0) |
SMALLINT NOT NULL |
DP_LEADTIME
|
| 11 |
DP_LEADTIMEUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_LEADTIMEUOM
Default Value: DAY
Prompt Table:
UNITS_TBL
|
| 12 |
DP_WEIGHT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_WEIGHT
|
| 13 |
DP_WEIGHTUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_WEIGHTUOM
|
| 14 |
DP_VOLUME |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_VOLUME
|
| 15 |
DP_VOLUMEUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_VOLUMEUOM
|
| 16 |
DP_INHERITCONTROLS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_INHERITCONTROLS
Y/N Table Edit
Default Value: Y
|
| 17 |
DP_RUNOUTDATE |
Date(10) |
DATE |
DP_RUNOUTDATE
|
| 18 |
DP_SAFETYSTOCK |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_SAFETYSTOCK
|
| 19 |
DP_REORDERPOINT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_REORDERPOINT
|
| 20 |
DP_ORDERQUANTITY |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERQUANTITY
|
| 21 |
DP_MINIMUM |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MINIMUM
|
| 22 |
DP_MAXIMUM |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_MAXIMUM
|
| 23 |
DP_AVGINVENTORY |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_AVGINVENTORY
|
| 24 |
DP_SERVICEFILL |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SERVICEFILL
|
| 25 |
DP_TURNRATE |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_TURNRATE
|
| 26 |
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
|
| 27 |
DP_OQARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQARGUMENT
|
| 28 |
DP_OQLIMITMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_OQLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity
Default Value: 0
|
| 29 |
DP_OQLOWERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQLOWERLIMIT
|
| 30 |
DP_OQUPPERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQUPPERLIMIT
|
| 31 |
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
|
| 32 |
DP_SSARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSARGUMENT
|
| 33 |
DP_SSLIMITMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_SSLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity
Default Value: 0
|
| 34 |
DP_SSLOWERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSLOWERLIMIT
|
| 35 |
DP_SSUPPERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSUPPERLIMIT
|
| 36 |
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
|
| 37 |
DP_ROPARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_ROPARGUMENT
|
| 38 |
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
|
| 39 |
DP_MINARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_MINARGUMENT
|
| 40 |
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
|
| 41 |
DP_MAXARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_MAXARGUMENT
|
| 42 |
DP_ORDERCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERCOST
|
| 43 |
DP_CARRYINGCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_CARRYINGCOST
|
| 44 |
DP_STANDARDPRICE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_STANDARDPRICE
|
| 45 |
DP_STANDARDCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_STANDARDCOST
|
| 46 |
DP_ANNUALCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ANNUALCOST
|
| 47 |
DP_ANNUALINVEST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ANNUALINVEST
|
| 48 |
DP_ORDERMULT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERMULT
|
| 49 |
DP_STATICCALCFLG |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_STATICCALCFLG
0=Period Number
1=Periods to Average
Default Value: 1
|
| 50 |
DP_STATICCALCARG |
Number(2,0) |
SMALLINT NOT NULL |
DP_STATICCALCARG
|
| 51 |
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
|
| 52 |
DP_HISTMAXLTUSAGE |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_HISTMAXLTUSAGE
|
| 53 |
DP_FCPERIODS |
Number(4,0) |
SMALLINT NOT NULL |
DP_FCPERIODS
|
| 54 |
DP_FCSTDDEV |
Number(22,2) |
DECIMAL(21,2) NOT NULL |
DP_FCSTDDEV
|
| 55 |
DP_SIMFCSTDDEV |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SIMFCSTDDEV
|
| 56 |
DP_EFFDEMANDPDS |
Number(3,0) |
SMALLINT NOT NULL |
DP_EFFDEMANDPDS
|
| 57 |
DP_EXPLODEDITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_EXPLODEDITEM
Y/N Table Edit
|
| 58 |
DP_ORDERCOUNT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_ORDERCOUNT
|
| 59 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table:
DP_UTILIZ_CD_VW
|
| 60 |
UTILIZ_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count
|
| 61 |
DP_UD01 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD01
|
| 62 |
DP_UD02 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD02
|
| 63 |
DP_UD03 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD03
|
| 64 |
DP_UD04 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD04
|
| 65 |
DP_UD05 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD05
|
| 66 |
DP_UD06 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD06
|
| 67 |
DP_UD07 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD07
|
| 68 |
DP_UD08 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD08
|
| 69 |
DP_UD09 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD09
|
| 70 |
DP_UD10 |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_UD10
|
| 71 |
DP_UD11 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD11
|
| 72 |
DP_UD12 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD12
|
| 73 |
DP_UD13 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD13
|
| 74 |
DP_UD14 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD14
|
| 75 |
DP_UD15 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD15
|
| 76 |
DP_UD16 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD16
|
| 77 |
DP_UD17 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD17
|
| 78 |
DP_UD18 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD18
|
| 79 |
DP_UD19 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD19
|
| 80 |
DP_UD20 |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_UD20
|
| 81 |
DP_UD21 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD21
|
| 82 |
DP_UD22 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD22
|
| 83 |
DP_UD23 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD23
|
| 84 |
DP_UD24 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD24
|
| 85 |
DP_UD25 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD25
|
| 86 |
DP_UD26 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD26
|
| 87 |
DP_UD27 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD27
|
| 88 |
DP_UD28 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD28
|
| 89 |
DP_UD29 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD29
|
| 90 |
DP_UD30 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD30
|
| 91 |
DP_UD31 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD31
|
| 92 |
DP_UD32 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD32
|
| 93 |
DP_UD33 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD33
|
| 94 |
DP_UD34 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD34
|
| 95 |
DP_UD35 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD35
|
| 96 |
DP_UD36 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD36
|
| 97 |
DP_UD37 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD37
|
| 98 |
DP_UD38 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD38
|
| 99 |
DP_UD39 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD39
|
| 100 |
DP_UD40 |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_UD40
|
| 101 |
DP_UD41 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD41
|
| 102 |
DP_UD42 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD42
|
| 103 |
DP_UD43 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD43
|
| 104 |
DP_UD44 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD44
|
| 105 |
DP_UD45 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD45
|
| 106 |
DP_UD46 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD46
|
| 107 |
DP_UD47 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD47
|
| 108 |
DP_UD48 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD48
|
| 109 |
DP_UD49 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD49
|
| 110 |
DP_UD50 |
Number(21,4) |
DECIMAL(20,4) NOT NULL |
DP_UD50
|
| 111 |
CONSIGNED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Consigned Flag
|
| 112 |
COST_ELEMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cost Element
|
| 113 |
COST_GROUP_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Standard Cost Group
|
| 114 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 115 |
EXCESS_INVENTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Excess Inventory
N=None
R=Repair
S=Score
|
| 116 |
INV_STOCK_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Stock Type
|
| 117 |
ITM_STATUS_FUTURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
|
| 118 |
NO_REPLENISH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Not Included In Replenishment
|
| 119 |
REPLENISH_CLASS |
Character(4) |
VARCHAR2(4) NOT NULL |
Replenish Class
|
| 120 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 121 |
RELATED_ITEM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Related Item
|
| 122 |
SOURCE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
|
| 123 |
USE_UP_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Up Quantity On Hand
|
| 124 |
QTY_AVAILABLE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Available
|
| 125 |
HISTORICAL_LEAD |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Historic Lead
|
| 126 |
SHELF_LIFE |
Number(4,0) |
SMALLINT NOT NULL |
Shelf Life (Days)
|
| 127 |
INV_ITEM_COLOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Item Color
|
| 128 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 129 |
INV_ITEM_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Item Type
|
| 130 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 131 |
ITEM_FIELD_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 132 |
ITEM_FIELD_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 133 |
ITEM_FIELD_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 134 |
ITEM_FIELD_C1_D |
Character(1) |
VARCHAR2(1) NOT NULL |
User-defined item field - Character 1
|
| 135 |
ITEM_FIELD_C10_A |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 136 |
ITEM_FIELD_C10_B |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 137 |
ITEM_FIELD_C10_C |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 138 |
ITEM_FIELD_C10_D |
Character(10) |
VARCHAR2(10) NOT NULL |
User-defined item field - Character 10
|
| 139 |
ITEM_FIELD_C2 |
Character(2) |
VARCHAR2(2) NOT NULL |
User-defined item field - Character 2
|
| 140 |
ITEM_FIELD_C30_A |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 141 |
ITEM_FIELD_C30_B |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 142 |
ITEM_FIELD_C30_C |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 143 |
ITEM_FIELD_C30_D |
Character(30) |
VARCHAR2(30) NOT NULL |
User-defined item field - Character 30
|
| 144 |
ITEM_FIELD_C4 |
Character(4) |
VARCHAR2(4) NOT NULL |
User-defined item field - Character 4
|
| 145 |
ITEM_FIELD_C6 |
Character(6) |
VARCHAR2(6) NOT NULL |
User-defined item field - Character 6
|
| 146 |
ITEM_FIELD_C8 |
Character(8) |
VARCHAR2(8) NOT NULL |
User-defined item field - Character 8
|