DP_PL_ITEM_ATTR
(SQL Table) |
Index Back |
|---|
Planning Item Attributes
3/3/97 TUM (CN# PL601-1.2) Created new record.
10/1/97 JNW (CN#PL750-DI-JWEBB-6)
Added Fields:
1. mfg_lead_time_flag
2. mfg_leadtimef
3. mfg_leadtimev
4. mfg_ltratef
5. mfg_ltratev
10/28/97 (CN#DI-RGNANASE-16)
Removed Cols:
1. PUR_PLAN_LOSS
2. TRANSFER_PLAN_LOSS
Added Cols:
1. PURCHASE_YIELD
2. TRANSFER_YIELD
10/30/97 (CN# DI-RGANASE-16)
Removed the required option from the col CONS_RATE_UNIT
Added default to the col ORDER_METHOD
Changed Save Edit Code for col pp_itm to set pp_make_supply = 'Y'
Added FieldEdit Code for col pp_itm
11/05/97 (CN# DI-RGNANASE-16)
REMOVED COL MFG_PLAN_LOSS AND ADDED COL
MANUFACU_YIELD
ADDED PEOPLECODE(SAVE EDIT) to purchasing/transfer/manufac yield fields
12/19/97 DI-GPENN-64 Removed Col Plan_family_item
01/02/98 DI-GPENN-64 Added col pl_agg_dmd_flag
02/23/98 jolvera-eb5hc set defalut value of mfg_lead_time_flag to 'Y'
added field change/save edit to mfg_lead_time_flag.
03/04/98 jolvera-eb5hc added save edit and modified field change for
mfg_lead_time_flag
7/15/99 lee CN#MG800-4.0 keep fields gray for planning items in pp_itm.fieldchange and ep_itm.fieldchange.
8/1/99 jnw (cn#sf800-7.0) added field pl_prio_family
08/03/99 MACN(CN#MG800.-4.0) Moved the fields mfg_leadtime_f, mfg_leadtime_v, mfg_ltratef, mfg_ltratev to BU_ITEMS_INV. Also modified SEdit in mfg_leadtime_flag.
08/03/99 EGS (CN#PL800-8) Added field USE_SHIPTO_LOC.
08/11/99 MACN (CN#PL800-9.0) Added a new field PL_FIXED_PERIOD.
10/13/99 jnw (cn#mg800-12) added pl_item_expl
02/02/00 EGS (CN#PL800-Phoenix) Added PLANNED_BY field.
02/16/00 EGS (CN#PL800-Phoenix) Added fields CAP_FENCE_OFF and EP_LEAD_TIME_FLAG.
04/10/00 EGS (CN#PL800-Phoenix) Deleted fields MPS_FLAG, EP_ITEM, PP_ITM, EP_TRANSFER_SUPPLY, EP_PURCHASE_SUPPLY, EP_MAKE_SUPPLY, PP_TRANSFER_SUPPLY, PP_PURCHASE_SUPPLY, PP_MAKE_SUPPLY, NET_CHANGE_EP, NET_CHANGE_PP, ORDER_METHOD
04/19/00 EGS (CN#PL800-Phoenix) Added FCST_FULFILL_SIZE.
09/07/01 EGS (CN#PL900-1): Added EARLY_FENCE.
10/12/01 EGS (CN#PL900-1): Added MSR_CONSUMP.
10/18/01 EGS (CN#PL900-1): Moved PL_SEARCH_DEPTH and MANUAL_MAINT from PL_SRC_TMPL_HDR to this table.
08/26/02 EGS (CN#PL880-1): Removed EXCESS_REPAIR, SAFETY_REPAIR, EP_LEAD_TIME_FLAG, ITM_CONS_TYPE,
ITM_CONS_RATE, CONS_RATE_UNIT, ITM_REL_TYPE, ITM_REL_RATE, REL_RATE_UNIT.
09/30/02 EGS (CN#PL880-1): Added EXTRA_CONSUMP |
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Publish Name
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 3 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
BU_ITEMS_INV
|
| 4 |
RESCH_OUT_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule Out Factor [days]
|
| 5 |
RESCH_IN_FACTOR |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Reschedule In Factor [days]
|
| 6 |
DEMAND_FENCE_OF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Demand Time Fence [days]
|
| 7 |
PLAN_FENCE_OFF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Planning Time Fence [days]
|
| 8 |
PLAN_HORIZON |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Action Message Cutoff [days]
Default Value: 999
|
| 9 |
TRANSFER_MIN_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/26/02: Added label PL_TRANS_MIN_ORDER
|
| 10 |
TRANSFER_MAX_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Order Qty to Max Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/26/02: Added label PL_TRANS_MAX_ORDER
|
| 11 |
TRANS_ORD_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
Default Value: 1
|
| 12 |
TRANSFER_ORD_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 13 |
PUR_MIN_ORDER |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Ord Qty to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PUR_MIN_ORDER2
|
| 14 |
PUR_MAX_ORDER |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PUR_MAX_ORDER2
|
| 15 |
PUR_ORDER_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
Default Value: 1
|
| 16 |
PUR_ORDER_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 17 |
MFG_MOD_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Order Modifier UOM
|
| 18 |
MFG_MIN_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Order to Min Order Qty.
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PL_MIN_ORDER
|
| 19 |
MFG_MAX_ORDER |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
KPN 08/23/02: Added label PL_MAX_ORDER
|
| 20 |
MFG_ORDER_MULTIPLE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4
Default Value: 1
|
| 21 |
MFG_ORDER_MOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Modifier
Y/N Table Edit
Default Value: N
|
| 22 |
MFG_LEAD_TIME_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
08/04/99 MACN (CN#MG800-4.0) Converted from Y/N field to translate field.
N=Based on Routings
Y=Based on Lead Times
Default Value: N
|
| 23 |
SAFETY_LEVEL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Safety Stock Level
|
| 24 |
EXCESS_LEVEL |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Excess Stock Level
|
| 25 |
AUTO_APPROVE_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Approve Message
Y/N Table Edit
|
| 26 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 27 |
PUR_PERIOD_ORDER |
Number(5,0) |
INTEGER NOT NULL |
Consolidation Period
|
| 28 |
PUR_ORDER_RATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Purchase Period Order Rate
DY=Day
HR=Hour
Default Value: HR
|
| 29 |
PURCHASE_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Purchase Yield
Default Value: 100
|
| 30 |
TRANSFER_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Transfer Yield
Default Value: 100
|
| 31 |
SALES_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Consumption
Y/N Table Edit
Default Value: N
|
| 32 |
PROD_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Production Consumption
Y/N Table Edit
Default Value: N
|
| 33 |
TRANS_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Consumption
Y/N Table Edit
Default Value: N
|
| 34 |
MSR_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
10/12/01 EGS (CN#PL900-1): Added
Y/N Table Edit
Default Value: N
|
| 35 |
EXTRA_CONSUMP |
Character(1) |
VARCHAR2(1) NOT NULL |
09/30/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 36 |
MANUFAC_YIELD |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
CN#PL800-18.0 MACN 11/02/99 - Changed short description from Manu Yield to Mfg Yield.
Default Value: 100
|
| 37 |
PL_AGG_DMD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Aggregate Demand
Default Value: N
|
| 38 |
RELEASED_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Released Order
|
| 39 |
FIRMED_ORDER |
Number(3,0) |
SMALLINT NOT NULL |
Firmed Order
|
| 40 |
PL_PRIO_FAMILY |
Character(10) |
VARCHAR2(10) NOT NULL |
Demand Priority Family
|
| 41 |
USE_SHIPTO_LOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Ship To Locations
Y/N Table Edit
Default Value: N
|
| 42 |
PL_FIXED_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Fixed Period (days)
|
| 43 |
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
|
| 44 |
PL_ITEM_EXPL |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/1/99 (cn# mg800-12) created field
Y/N Table Edit
Default Value: N
|
| 45 |
PL_PROJ_USE_DT |
Date(10) |
DATE |
11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
|
| 46 |
PLANNED_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
Default Value: 3
|
| 47 |
CAP_FENCE_OFF |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Capacity Fence
|
| 48 |
FCST_FULFILL_SIZE |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
Forecast Fulfillment Size
|
| 49 |
FCST_ADJ_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/28/02 EBN (CN#PL900-1.0): Added.
1=No Adjustment
2=Allocate to Next Bucket
3=Allocate to Last Bucket
4=Allocate Evenly Across Buckets
5=Allocate Using Calendar Weight
Default Value: 1
|
| 50 |
EARLY_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Early Fence
|
| 51 |
GBL_EARLY_FENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
09/07/01 EGS (CN#PL900-1): Added.
Y/N Table Edit
Default Value: Y
|
| 52 |
PL_SEARCH_DEPTH |
Number(2,0) |
SMALLINT NOT NULL |
Search Depth
Default Value: 1
|
| 53 |
MANUAL_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Manually Maintained
Y/N Table Edit
Default Value: N
|
| 54 |
SPOT_BUY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
10/24/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 55 |
DP_POLICYSET |
Character(10) |
VARCHAR2(10) NOT NULL |
DP_POLICYSET
|
| 56 |
DP_POLICYCONTROL |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_POLICYCONTROL
|
| 57 |
DP_PUBLISH_DATE |
Date(10) |
DATE |
DP_PUBLISH_DATE
|