PL_MM_RPT_STEPS

(SQL Table)
Index Back

PL Mass Maintenance Step Rpt

01/15/03 NRA (CN#PL880-1.0): Added to maintain reporting header information for Mass Maintenance steps

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Prompt Table: PRCSRUNCNTL

4 STEP Number(2,0) SMALLINT NOT NULL Step
5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
6 PL_MAINT_ACTIVITY Character(2) VARCHAR2(2) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
01=Freeze
02=Unfreeze
03=Include Quantity
04=Exclude Quantity
05=Freeze Substitutes
06=Unfreeze Substitutes
07=Approve
08=Unapprove
09=Consume Forecast
10=Unconsume Forecast
11=Cancel
12=Uncancel
21=Set Demand Priority
22=Set Order Status
31=Reschedule Forward
32=Reschedule Backward
33=Consolidate/Reschedule Fwd
34=Consolidate/Reschedule Bkwd
41=Change Sourcing Option
7 PL_XACTION_TYPE Character(4) VARCHAR2(4) NOT NULL 11/15/02 NRA - Created for Set Value actions

Prompt Table: PL_XACTION_TBL

8 DATE_DAYS_SLCT_FLG Character(1) VARCHAR2(1) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
T=Date
Y=Days Offset
9 TARGET_DATE DateTime(26) TIMESTAMP 12/10/02 NRA (CN#PL880-1): Defined
10 TARGET_DAY Signed Number(4,0) DECIMAL(3) NOT NULL TARGET_DAY
11 TO_PRIORITY_RANK Number(3,0) SMALLINT NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
12 TO_ORDER_STATUS Character(2) VARCHAR2(2) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
05=Planned
15=Firmed
90=Cancelled
13 TO_INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
C=Cancelled
O=Open
14 TO_BOM_CODE Number(2,0) SMALLINT NOT NULL anna 06/30- changing the name as per Lori's code review 11/24/99 LAJ...Changed short name from Bcode to BOM. Removed leading blank on long name.
15 TO_RTG_CODE Number(2,0) SMALLINT NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
16 TO_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_PI_VNDSET_VW

17 TO_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL New Supplier ID

Prompt Table: PL_PI_VNDID_VW

18 TO_VNDR_LOC Character(10) VARCHAR2(10) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_PI_VNDLOC_VW

19 TO_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_PI_BU_IN_VW

20 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
21 BU_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
LIKE=LIKE

Prompt Table: PL_OPER_T_VW

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

Prompt Table: PL_PI_BU_IN_VW

23 ITM_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

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

Prompt Table: %EDITTABLE2

25 PLANNER_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

26 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

Prompt Table: PL_PI_PLNR_VW

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

Default Value: B

28 BUYER_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

29 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: PL_PI_BUYER_VW

30 GROUP_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

31 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: PL_PI_ITMGRP_VW

32 PL_DISTRIB_PLAN Character(1) VARCHAR2(1) NOT NULL Distribution Plan

Y/N Table Edit

Default Value: Y

33 PL_MASTER_PLAN Character(1) VARCHAR2(1) NOT NULL Master Plan

Y/N Table Edit

Default Value: Y

34 PL_MATERIAL_PLAN Character(1) VARCHAR2(1) NOT NULL Material Plan

Y/N Table Edit

Default Value: Y

35 FAMILY_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

36 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

Prompt Table: %EDITTABLE4

37 CATEGORY_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

38 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
39 UTILIZ_CD_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

40 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: PL_PI_UTILIZ_VW

41 CONFIG_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

42 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: %EDITTABLE5

43 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
44 PL_MAKE_SOURCE Character(1) VARCHAR2(1) NOT NULL 12/09/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

45 PL_BUY_SOURCE Character(1) VARCHAR2(1) NOT NULL 12/09/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

46 PL_PLANNING_SOURCE Character(1) VARCHAR2(1) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Y/N Table Edit

Default Value: Y

47 APPLIES_TO_BU Character(1) VARCHAR2(1) NOT NULL Applies to BU
D=Destination Unit
S=Source Unit

Default Value: D

48 ORDER_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

49 ORDER_ID Character(25) VARCHAR2(25) NOT NULL Order ID
50 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Prompt Table: PL_ORD_HEADER

51 BU_OPRTN2 Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

52 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
53 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
54 SETID_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

55 SETID Character(5) VARCHAR2(5) NOT NULL SetID
56 START_DT_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
BTW=BETWEEN

Prompt Table: PL_OPER_D_VW

57 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
58 PLN_START_DT_TO DateTime(26) TIMESTAMP 12/10/02 NRA (CN#PL880-1): Defined
59 END_DT_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_D_VW

60 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
61 PLN_END_DT_TO DateTime(26) TIMESTAMP 12/10/02 NRA (CN#PL880-1): Defined
62 START_FROM_DAY Signed Number(4,0) DECIMAL(3) NOT NULL START_FROM_DAY
63 START_TO_DAY Signed Number(4,0) DECIMAL(3) NOT NULL START_TO_DAY
64 END_FROM_DAY Signed Number(4,0) DECIMAL(3) NOT NULL END_FROM_DAY
65 END_TO_DAY Signed Number(4,0) DECIMAL(3) NOT NULL END_TO_DAY
66 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
67 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown

Default Value: PR

68 PRODAREA_OPRTN Character(4) VARCHAR2(4) NOT NULL PRODAREA_OPRTN

Prompt Table: PL_OPER_T_VW

69 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
70 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
71 BOM_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_N_VW

72 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
73 RTG_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_N_VW

74 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
75 PRIORITY_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_N_VW

76 PRIORITY_RANK Number(3,0) SMALLINT NOT NULL Priority rank value of demand prioritization rule
77 PL_FAMILY_FORECAST Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Added 12/10/02 NRA (CN#PL880-1): Defined xlats 'Yes, No, and Both'
B=Both
N=No
Y=Yes

Default Value: B

78 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Default Value: B

79 INCL_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Include Quantity
B=Both
N=No
Y=Yes

Default Value: B

80 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes

Default Value: B

81 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes

Default Value: B

82 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled

Default Value: 05

83 VNDR_SETID_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

84 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: PL_PI_VNDSET_VW

85 VENDOR_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

86 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: PL_PI_VNDID_VW

87 VNDR_LOC_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

88 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: PL_PI_VNDLOC_VW

89 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received

Default Value: O

90 SOURCE_BU_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

91 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

Prompt Table: PL_PI_BU_IN_VW

92 SHIP_TYPE_OPRTN Character(4) VARCHAR2(4) NOT NULL SHIP_TYPE_OPRTN

Prompt Table: PL_OPER_T_VW

93 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
94 CONSUME_FCST Character(1) VARCHAR2(1) NOT NULL 09/11/02 EGS (CN#PL880-1): Added.
B=Both
N=No
Y=Yes

Default Value: B

95 SHIPPED_FLAG Character(1) VARCHAR2(1) NOT NULL Shipped
B=Both
N=No
Y=Yes

Default Value: B

96 RESERVED_FLAG Character(1) VARCHAR2(1) NOT NULL Reserved Flag
B=Both
N=No
Y=Yes

Default Value: B

97 CANCEL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel PO
B=Both
N=No
Y=Yes

Default Value: B

98 PRODUCT_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

99 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
100 CUSTOMER_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

101 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
102 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled

Default Value: O

103 SHIP_ID_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_T_VW

104 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
105 SUCCESS_OPRTN Character(3) VARCHAR2(3) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

Prompt Table: PL_OPER_N_VW

106 SUCCESS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Success Percent