PL_MM_RPT_STEPS(SQL Table) |
Index Back |
---|---|
PL Mass Maintenance Step Rpt01/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 |