PL_MSMNT_STEP

(SQL Table)
 Index Back

PL Mass Maintenance Steps

11/18/02 NRA (CN#PL880-1): Defined

  • Related Language Record: PL_MSMNTLSTEP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Prompt Table: PRCSRUNCNTL

    3 STEP Number(2,0) SMALLINT NOT NULL Step
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 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
    6 PL_XACTION_TYPE Character(4) VARCHAR2(4) NOT NULL 11/15/02 NRA - Created for Set Value actions

    Prompt Table: PL_XACTION_TBL

    7 DATE_DAYS_SLCT_FLG Character(1) VARCHAR2(1) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
    T=Date
    Y=Days Offset

    Default Value: T

    8 TARGET_DATE DateTime(26) TIMESTAMP 12/10/02 NRA (CN#PL880-1): Defined
    9 TARGET_DAY Signed Number(4,0) DECIMAL(3) NOT NULL TARGET_DAY
    10 TO_PRIORITY_RANK Number(3,0) SMALLINT NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
    11 TO_ORDER_STATUS Character(2) VARCHAR2(2) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
    05=Planned
    15=Firmed
    90=Cancelled
    12 TO_INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
    C=Cancelled
    O=Open
    13 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.
    14 TO_RTG_CODE Number(2,0) SMALLINT NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
    15 TO_VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

    Prompt Table: PL_PI_VNDSET_VW

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

    Prompt Table: PL_MMTOVNDID_VW

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

    Prompt Table: PL_MMTOVNDLOCVW

    18 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

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_BU_IN_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_PLNR_VW

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

    Default Value: B

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_BUYER_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_ITMGRP_VW

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: %EDITTABLE4

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_UTILIZ_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: %EDITTABLE5

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Default Value: D

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_BA_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_OPER_T_VW

    54 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    55 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

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

    Prompt Table: PL_OPER_D_VW

    59 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
    60 PLN_END_DT_TO DateTime(26) TIMESTAMP 12/10/02 NRA (CN#PL880-1): Defined
    61 START_FROM_DAY Signed Number(4,0) DECIMAL(3) NOT NULL START_FROM_DAY
    62 START_TO_DAY Signed Number(4,0) DECIMAL(3) NOT NULL START_TO_DAY
    63 END_FROM_DAY Signed Number(4,0) DECIMAL(3) NOT NULL END_FROM_DAY
    64 END_TO_DAY Signed Number(4,0) DECIMAL(3) NOT NULL END_TO_DAY
    65 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
    66 PRODAREA_OPRTN Character(4) VARCHAR2(4) NOT NULL PRODAREA_OPRTN

    Prompt Table: PL_OPER_T_VW

    67 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
    68 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

    Prompt Table: PL_MM_PRSTAT_VW

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

    Prompt Table: PL_OPER_N_VW

    70 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database

    Prompt Table: PL_PROD_BOM_VW

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

    Prompt Table: PL_OPER_N_VW

    72 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

    Prompt Table: PL_PROD_RTG_VW

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

    Prompt Table: PL_OPER_N_VW

    74 PRIORITY_RANK Number(3,0) SMALLINT NOT NULL Priority rank value of demand prioritization rule
    75 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

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

    Default Value: B

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

    Default Value: B

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

    Default Value: B

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

    Default Value: B

    80 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
    10=Open
    20=Completed
    30=Canceled
    40=Not Pegged
    81 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
    05=Planned
    15=Firmed
    90=Canceled
    82 VNDR_SETID_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_VNDSET_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_MM_VNDID_VW

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_MM_VNDLOC_VW

    88 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
    C=Cancelled
    I=In-Transit
    O=Open
    P=Picked
    R=Received
    89 SOURCE_BU_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_PI_BU_IN_VW

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

    Prompt Table: PL_OPER_T_VW

    92 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    93 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

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

    Default Value: B

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

    Default Value: B

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

    Default Value: B

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

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_OPER_T_VW

    100 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
    101 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
    C=Closed
    O=Open
    P=Pending
    X=Canceled
    102 SHIP_ID_OPRTN Character(4) VARCHAR2(4) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined

    Prompt Table: PL_OPER_T_VW

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

    Prompt Table: PL_OPER_N_VW

    105 SUCCESS_PCT Number(6,2) DECIMAL(5,2) NOT NULL Success Percent
    106 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed

    Y/N Table Edit

    Default Value: N