PL_RESCHED_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 TOLERANCE_FLG Character(1) VARCHAR2(1) NOT NULL jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: %EDITTABLE5

6 PEGGED_FLG Character(1) VARCHAR2(1) NOT NULL Open Pegs

Y/N Table Edit

Default Value: N

7 UNPEGGED_FLG Character(1) VARCHAR2(1) NOT NULL 11/18/2004 NRA : Defined

Y/N Table Edit

Default Value: N

8 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: PL_PI_SHIPTO_VW

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

Prompt Table: PL_PI_VNDID_VW

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

Prompt Table: %EDITTABLE6

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

18 PL_EXTRA_DEMAND Character(1) VARCHAR2(1) NOT NULL 10/18/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

19 PL_STOCK_REQUESTS Character(1) VARCHAR2(1) NOT NULL 10/18/02 JC (CN#PL880-1): Added

Y/N Table Edit

Default Value: Y

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

Prompt Table: SP_PRBINS_NONVW

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

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

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

Prompt Table: PL_PI_PLNR_VW

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

Prompt Table: %EDITTABLE4

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

Prompt Table: PL_PI_ITMCAT_VW

28 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
29 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: PL_PI_ITMGRP_VW

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Prompt Table: PL_PI_BUYER_VW

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Prompt Table: PL_PI_UTILIZ_VW

37 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
38 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
39 START_DATE Date(10) DATE Start Date for Gen Standing PO
40 END_OPTION Character(1) VARCHAR2(1) NOT NULL 10/03/02 JC (CN#PL880-1): Added
1=Date
2=Offset
41 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
42 END_DATE Date(10) DATE End Date
43 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