SF_PRDNSCH_R_VW

(SQL View)
 Index Back

Production Schedule Record

5/10/99 WHS CN#SF800-28.0: Allow view to include InProcess production. 5/22/98, add NEW_PRDN_QTY to the view field list to be displayed. EYZ, 7.5 Releast Test EP95029-TR8G6 02/06/98 SCC: Made all keys consecutive. Moved Production ID up. 9/8/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement 06/23/97 MEG CN# SF750-1.0 Made production_type not a search key and not a list. Turned off those checkboxes. CN# EN800-3.0, Sep 21 98, Anna Added field BomCode

SELECT a.business_unit , a.prdn_area_code , a.inv_item_id , a.production_type , a.prdn_due_date , a.prdn_due_shift , a.production_id , a.new_prdn_qty , a.new_end_date , a.new_end_shift , a.prod_status , a.bom_code , a.rtg_code , a.ref_routing_item , a.scheduling_method , a.prdn_start_date , a.prdn_start_shift , a.new_start_date , a.new_start_shift , a.new_start_time , a.new_end_time , a.revision , a.expected_prdn_qty FROM PS_SF_PRDNID_HEADR a WHERE a.ma_prdn_id_flg = 'N' AND a.prod_status < '40'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PRDN_AREA

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

Prompt Table: SF_PA_NOID_VW

4 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

5 PRDN_DUE_DATE Date(10) DATE Prdn Due Date

Prompt Table: SF_PRDN_ED3_VW

6 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift

Prompt Table: SF_PRDN_ESH3_VW

7 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
8 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
9 NEW_END_DATE Date(10) DATE Due Date

Prompt Table: SF_PRDN_ED_VW

10 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift

Prompt Table: SF_PRDN_ESH_VW

11 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
12 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
13 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Prompt Table: EN_RTG_HDR_VW

14 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
15 SCHEDULING_METHOD Character(3) VARCHAR2(3) NOT NULL Scheduling Method
BWD=Backward
FWD=Forward
16 PRDN_START_DATE Date(10) DATE Prdn Start Date
17 PRDN_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Start Shift
18 NEW_START_DATE Date(10) DATE Start Date
19 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift
20 NEW_START_TIME Time(15) TIMESTAMP Start Time
21 NEW_END_TIME Time(15) TIMESTAMP Due Time
22 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_SRCH

23 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty