PL_BU_ITEMSDEL

(SQL Table)
Index Back

PL Items Delete Table

10/29/01 EGS (CN#PL900-1): Added.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

Prompt Table: SP_PRBINS_NONVW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: PL_PI_BU_IN_VW

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

Prompt Table: PL_PI_BU_ITM_VW

4 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
B=Both
N=No
Y=Yes

Y/N Table Edit

5 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes

Y/N Table Edit

6 PHANTOM_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Phantom Item

Y/N Table Edit

7 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
8 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
9 ROUND_RULE Character(1) VARCHAR2(1) NOT NULL Rounding Rule
D=Round Down
N=Natural Round
U=Round Up
10 PL_ITEM_PREC Number(3,0) SMALLINT NOT NULL 10/08/01 EGS (CN#PL900-1): Added.
11 PLANNED_BY Character(1) VARCHAR2(1) NOT NULL Planned By
1=Distribution Planning
2=Master Planning
3=Material Planning
4=Not Planned
12 DEMAND_FENCE_DATE Date(10) DATE 08/16/01 EGS (CN#PL900-1.0): Added
13 FCST_PRI_RANK Number(3,0) SMALLINT NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
14 SAFETY_PRI_RANK Number(3,0) SMALLINT NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
15 SALES_CONSUMP Character(1) VARCHAR2(1) NOT NULL Sales Consumption

Y/N Table Edit

Default Value: N

16 PROD_CONSUMP Character(1) VARCHAR2(1) NOT NULL Production Consumption

Y/N Table Edit

Default Value: N

17 TRANS_CONSUMP Character(1) VARCHAR2(1) NOT NULL Transfer Consumption

Y/N Table Edit

Default Value: N

18 MSR_CONSUMP Character(1) VARCHAR2(1) NOT NULL 10/12/01 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

19 EXTRA_CONSUMP Character(1) VARCHAR2(1) NOT NULL 09/30/02 EGS (CN#PL880-1): Added

Y/N Table Edit

Default Value: N

20 PL_AGG_DMD_FLAG Character(1) VARCHAR2(1) NOT NULL Aggregate Demand

Y/N Table Edit

21 PL_ITEM_EXPL Character(1) VARCHAR2(1) NOT NULL jnw 10/1/99 (cn# mg800-12) created field
22 FCST_FULFILL_SIZE Number(12,4) DECIMAL(11,4) NOT NULL Forecast Fulfillment Size
23 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
24 PL_FIXED_PERIOD Number(3,0) SMALLINT NOT NULL Fixed Period (days)
25 ITEM_EARLY_DATE Date(10) DATE 08/16/01 EGS (CN#PL900-1.0): Added
26 PL_SEARCH_DEPTH Number(2,0) SMALLINT NOT NULL Search Depth
27 PL_SHIFT_DAYS Number(3,0) SMALLINT NOT NULL Reschedule Early Limit
28 LOW_LEVEL_CD Number(3,0) SMALLINT NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
29 INV_QTY_DTTM DateTime(26) TIMESTAMP 08/16/01 EGS (CN#PL900-1.0): Added
30 INV_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
31 QTY_AVAIL Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Available
32 QTY_RESERVED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Reserved
33 STAGED_INF_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
34 STAGED_ITEM_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
35 QUAR_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
36 SHIP_NOT_DEPL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
37 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
38 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
39 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
40 PHASE_OUT Character(1) VARCHAR2(1) NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added

Y/N Table Edit

41 ITM_STATUS_EFFDT Date(10) DATE Item Status Date
42 PL_PROJ_USE_DT Date(10) DATE 11/04/02 JC (CN#PL880-1): Added USEUP_DATE label
43 PL_PROJ_USE_QOH Signed Number(17,4) DECIMAL(15,4) NOT NULL 11/03/02 JC (CN#PL880-1): Added QOH_USEUP label 12/18/02 EGS (CN#PL880-1): Changed to 11.4.
44 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
45 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
46 NET_CHANGE_QOH Character(1) VARCHAR2(1) NOT NULL 02/11/02 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

47 LOT_FOR_LOT_FLG Character(1) VARCHAR2(1) NOT NULL 05/06/02 EGS (CN#PL900-1): Added
48 DP_WEIGHTPROFILE Character(20) VARCHAR2(20) NOT NULL DP_WEIGHTPROFILE
49 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
CYCL=Cycle Count
50 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type
51 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
52 PL_UNIT_COST Signed Number(19,4) DECIMAL(17,4) NOT NULL 09/27/02 EGS (CN#PL880-1): Changed to 13.4
53 SPOT_BUY_FLG Character(1) VARCHAR2(1) NOT NULL 10/24/02 EGS (CN#PL880-1): Added

Y/N Table Edit

Default Value: N

54 AOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Order Qty
55 PL_RESCHEDULE_TOL Number(3,0) SMALLINT NOT NULL Reschedule Tolerance(In days)

Default Value: 0

56 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference