| # |
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_POLICYCONTROL |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_POLICYCONTROL
|
| 3 |
DP_CAPTION |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_CAPTION
|
| 4 |
DP_OQARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQARGUMENT
|
| 5 |
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
|
| 6 |
DP_OQLIMITMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_OQLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity
Default Value: 0
|
| 7 |
DP_OQLOWERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQLOWERLIMIT
|
| 8 |
DP_OQUPPERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_OQUPPERLIMIT
|
| 9 |
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
|
| 10 |
DP_SSARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSARGUMENT
|
| 11 |
DP_SSLIMITMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_SSLIMITMETHOD
0=None
1=Days Supply
2=Fixed Quantity
Default Value: 0
|
| 12 |
DP_SSLOWERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSLOWERLIMIT
|
| 13 |
DP_SSUPPERLIMIT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_SSUPPERLIMIT
|
| 14 |
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
|
| 15 |
DP_ROPARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_ROPARGUMENT
|
| 16 |
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
|
| 17 |
DP_MINARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_MINARGUMENT
|
| 18 |
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
|
| 19 |
DP_MAXARGUMENT |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
DP_MAXARGUMENT
|
| 20 |
DP_LEADTIME |
Number(4,0) |
SMALLINT NOT NULL |
DP_LEADTIME
Default Value: 1
|
| 21 |
DP_LEADTIMEUOM |
Character(3) |
VARCHAR2(3) NOT NULL |
DP_LEADTIMEUOM
Default Value: DAY
Prompt Table:
UNITS_TBL
|
| 22 |
DP_ORDERCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERCOST
Default Value: 0
|
| 23 |
DP_CARRYINGCOST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_CARRYINGCOST
Default Value: 0
|
| 24 |
DP_ORDERMULT |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
DP_ORDERMULT
|
| 25 |
DP_STATICCALCFLG |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_STATICCALCFLG
0=Period Number
1=Periods to Average
Default Value: 1
|
| 26 |
DP_STATICCALCARG |
Number(2,0) |
SMALLINT NOT NULL |
DP_STATICCALCARG
Default Value: 1
|
| 27 |
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
|
| 28 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table:
DP_UTILIZCD_VW
|
| 29 |
UTILIZ_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Group
CYCL=Cycle Count
|