PL_ITEM_COPY_VW

(SQL View)
 Index Back

Planning Item Attributes Copy

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. 10/24/02 EGS (CN#PL880-1): Added SPOT_BUY_FLG

SELECT BUSINESS_UNIT , INV_ITEM_ID , RESCH_OUT_FACTOR , RESCH_IN_FACTOR , DEMAND_FENCE_OF , PLAN_FENCE_OFF , PLAN_HORIZON , TRANSFER_MIN_ORDER , TRANSFER_MAX_ORDER , TRANS_ORD_MULTIPLE , TRANSFER_ORD_MOD , PUR_MIN_ORDER , PUR_MAX_ORDER , PUR_ORDER_MULTIPLE , PUR_ORDER_MOD , MFG_MOD_UNIT , MFG_MIN_ORDER , MFG_MAX_ORDER , MFG_ORDER_MULTIPLE , MFG_ORDER_MOD , MFG_LEAD_TIME_FLAG , SAFETY_LEVEL , EXCESS_LEVEL , AUTO_APPROVE_MSG , PLANNER_CD , PURCHASE_YIELD , TRANSFER_YIELD , SALES_CONSUMP , PROD_CONSUMP , TRANS_CONSUMP , MSR_CONSUMP , EXTRA_CONSUMP , PL_AGG_DMD_FLAG , RELEASED_ORDER , FIRMED_ORDER , PL_PRIO_FAMILY , USE_SHIPTO_LOC , PL_FIXED_PERIOD , PL_ITEM_EXPL , PL_PROJ_USE_DT , PLANNED_BY , CAP_FENCE_OFF , FCST_FULFILL_SIZE , FCST_ADJ_ACTION , EARLY_FENCE , GBL_EARLY_FENCE , PL_SEARCH_DEPTH , SPOT_BUY_FLG , DP_UOMGROUP , USE_REGION_VNDR , USE_PUR_ORD_MOD , PL_RESCHEDULE_TOL FROM PS_PL_ITEM_ATTRIB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITEMS_INV

3 RESCH_OUT_FACTOR Number(8,2) DECIMAL(7,2) NOT NULL Reschedule Out Factor [days]
4 RESCH_IN_FACTOR Number(8,2) DECIMAL(7,2) NOT NULL Reschedule In Factor [days]
5 DEMAND_FENCE_OF Signed Number(9,2) DECIMAL(7,2) NOT NULL Demand Time Fence [days]
6 PLAN_FENCE_OFF Signed Number(9,2) DECIMAL(7,2) NOT NULL Planning Time Fence [days]
7 PLAN_HORIZON Signed Number(9,2) DECIMAL(7,2) NOT NULL Action Message Cutoff [days]
8 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
9 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
10 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
11 TRANSFER_ORD_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier

Y/N Table Edit

12 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
13 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
14 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
15 PUR_ORDER_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier

Y/N Table Edit

16 MFG_MOD_UNIT Character(4) VARCHAR2(4) NOT NULL Order Modifier UOM
17 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
18 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
19 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
20 MFG_ORDER_MOD Character(1) VARCHAR2(1) NOT NULL Order Modifier

Y/N Table Edit

21 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

Y/N Table Edit

22 SAFETY_LEVEL Number(16,4) DECIMAL(15,4) NOT NULL Safety Stock Level
23 EXCESS_LEVEL Number(16,4) DECIMAL(15,4) NOT NULL Excess Stock Level
24 AUTO_APPROVE_MSG Character(1) VARCHAR2(1) NOT NULL Auto Approve Message

Y/N Table Edit

25 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
26 PURCHASE_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Purchase Yield
27 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
28 SALES_CONSUMP Character(1) VARCHAR2(1) NOT NULL Sales Consumption
29 PROD_CONSUMP Character(1) VARCHAR2(1) NOT NULL Production Consumption
30 TRANS_CONSUMP Character(1) VARCHAR2(1) NOT NULL Transfer Consumption
31 MSR_CONSUMP Character(1) VARCHAR2(1) NOT NULL 10/12/01 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

32 EXTRA_CONSUMP Character(1) VARCHAR2(1) NOT NULL 09/30/02 EGS (CN#PL880-1): Added
33 PL_AGG_DMD_FLAG Character(1) VARCHAR2(1) NOT NULL Aggregate Demand
34 RELEASED_ORDER Number(3,0) SMALLINT NOT NULL Released Order
35 FIRMED_ORDER Number(3,0) SMALLINT NOT NULL Firmed Order
36 PL_PRIO_FAMILY Character(10) VARCHAR2(10) NOT NULL Demand Priority Family
37 USE_SHIPTO_LOC Character(1) VARCHAR2(1) NOT NULL Use Ship To Locations
38 PL_FIXED_PERIOD Number(3,0) SMALLINT NOT NULL Fixed Period (days)
39 PL_ITEM_EXPL Character(1) VARCHAR2(1) NOT NULL jnw 10/1/99 (cn# mg800-12) created field
40 PL_PROJ_USE_DT Date(10) DATE 11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
41 PLANNED_BY Character(1) VARCHAR2(1) NOT NULL Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
42 CAP_FENCE_OFF Signed Number(6,0) DECIMAL(5) NOT NULL Capacity Fence
43 FCST_FULFILL_SIZE Number(12,4) DECIMAL(11,4) NOT NULL Forecast Fulfillment Size
44 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

45 EARLY_FENCE Signed Number(6,0) DECIMAL(5) NOT NULL Early Fence
46 GBL_EARLY_FENCE Character(1) VARCHAR2(1) NOT NULL 09/07/01 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: Y

47 PL_SEARCH_DEPTH Number(2,0) SMALLINT NOT NULL Search Depth
48 SPOT_BUY_FLG Character(1) VARCHAR2(1) NOT NULL 10/24/02 EGS (CN#PL880-1): Added

Y/N Table Edit

49 DP_UOMGROUP Character(10) VARCHAR2(10) NOT NULL DP_UOMGROUP
50 USE_REGION_VNDR Character(1) VARCHAR2(1) NOT NULL Use Item Supplier By Region
51 USE_PUR_ORD_MOD Character(1) VARCHAR2(1) NOT NULL Use Purchase Order Modifier
52 PL_RESCHEDULE_TOL Number(3,0) SMALLINT NOT NULL Reschedule Tolerance(In days)

Default Value: 0