PL_PEGGING_REQ

(SQL Table)
 Index Back

Planning Reschedule Report

10/03/02 JC (CN#PL880-1): Added 12/10/02 JC (CN#PL880-1): Added PL_RESCHEDULES, PL_CANCELLATIONS

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

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 START_PLUGIN Character(1) VARCHAR2(1) NOT NULL START_PLUGIN
4 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

Prompt Table: SPL_DOMN_URL_VW

5 INCLUDE_CFG Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: N

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

Prompt Table: %EDITTABLE5

7 PL_PRODUCTION Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

8 PL_PURCHASES Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

9 PL_TRANSFERS Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

10 INCL_PL_PROD_ORD Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: Y

11 INCL_PL_PURCH_ORD Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: Y

12 INCL_PLAN_XFER Character(1) VARCHAR2(1) NOT NULL Planned Transfers

Y/N Table Edit

Default Value: Y

13 CLEAR_ALL_PB Character(1) VARCHAR2(1) NOT NULL Clear All the above check boxes.
14 SELECT_ALL_PB Character(1) VARCHAR2(1) NOT NULL Select All
15 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

Prompt Table: SP_PRBINS_NONVW

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

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

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

Prompt Table: PL_PI_PLNR_VW

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

Prompt Table: %EDITTABLE4

20 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

Prompt Table: PL_PI_ITMCAT_VW

21 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
22 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: PL_PI_ITMGRP_VW

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

25 PRIMARY_BUYER Character(30) VARCHAR2(30) NOT NULL Primary Buyer

Prompt Table: PL_PI_BUYER_VW

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Prompt Table: PL_PI_UTILIZ_VW

30 START_OPTION Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added 01/13/03 JC (CN#PL880-1): Added label START_DATE_OPTION
1=Date
2=Offset
31 PL_START_OFFSET Signed Number(6,0) DECIMAL(5) NOT NULL 10/03/02 JC (CN#PL880-1): Added 01/13/03 JC (CN#PL880-1): Added label OFFSET
32 START_DATE Date(10) DATE Start Date for Gen Standing PO
33 END_OPTION Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added
1=Date
2=Offset
34 PL_END_OFFSET Signed Number(6,0) DECIMAL(5) NOT NULL 10/03/02 JC (CN#PL880-1): Added 01/13/03 JC (CN#PL880-1): Added label OFFSET
35 END_DATE Date(10) DATE End Date
36 PL_PI_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL 10/29/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y