SF_PRDNSCH_D_VW

(SQL View)
Index Back

Production Schedule Detail

9/8/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement 9/19/97 jnw CN#PL700-DI-GPENN-52: Added NET_CHANGE_EP for era net change ehancement 10/8/97, eyz CN#EN750-1.0: Changed RTG_CODE RowInsert, REF_ROUTING_ITEM SaveEdit, PROD_STATUS FieldDefault so get_ref_item() is not called multiple times, to improve the performance. 11/24/97 SCC CN#PL750-DI-SCHEW-109: Add PROD_PRCS_STATUS 03/12/98 SCC CN#SCHEW-GP92Y: Add new_revision CN# EN800-3.0, Sep 21 98, Anna Added field BomCode 04/23/1999 WHS CN#SF800-18.0: Don't grey NEW_PRDN_QTY in RowInit of INV_ITEM_ID. 04/29/1999 whs cn#sf800-27.0: Don't grey PROD_STATUS when shedule is INPROCESS. New logic to edit a status change from INPROCESS. 10/30/2002 meg CN#MG880-YBO: Added expected_prdn_qty, adj_fixed_scrap, sf_yield_cost_flg, cum_yield, orig_prdn_end_qty.

SELECT a.business_unit , a.prdn_area_code , a.inv_item_id , a.production_type , a.production_id , a.prod_status , a.orig_prdn_qty , a.orig_uom , a.new_prdn_qty , a.new_uom , a.bom_code , a.rtg_code , a.ref_routing_item , a.scheduling_method , a.orig_start_date , a.orig_start_time , a.orig_start_shift , a.orig_end_date , a.orig_end_time , a.orig_end_shift , a.new_start_date , a.new_start_shift , a.new_start_time , a.new_end_date , a.new_end_shift , a.new_end_time , a.prdn_start_date , a.prdn_start_shift , a.prdn_start_time , a.prdn_due_date , a.prdn_due_shift , a.prdn_due_time , a.revision , a.completed_qty , a.scrap_qty , a.percent_comp , a.cum_yield , a.comp_close_dt , a.comp_close_time , a.lab_close_dt , a.lab_close_time , a.acctg_close_dt , a.acctg_close_time , a.pick_batch_id , a.ma_prdn_id_flg , a.plan_change_flg , a.net_change_ep , a.plan_frozen_flg , a.link_to_om , a.business_unit_om , a.order_no , a.order_int_line_no , a.cp_comp_seq , a.config_code , a.print_doc , a.print_count , a.prdn_created_dttm , a.last_dttm_update , a.prod_prcs_status , a.new_revision , a.processed_cd , a.process_instance , a.frozen_substitutes , a.trdn_orig_pid , a.expected_prdn_qty , a.adj_fixed_scrap , a.serial_in_prdn , a.sf_yield_cost_flg , a.orig_prdn_end_qty , a.text254 FROM PS_SF_PRDNID_HEADR a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Default Value: NEXT

6 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
7 ORIG_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Original Production Qty
8 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
9 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
10 NEW_UOM Character(3) VARCHAR2(3) NOT NULL Unit of Measure
11 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
12 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Prompt Table: EN_RTG_HDR_VW

13 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
14 SCHEDULING_METHOD Character(3) VARCHAR2(3) NOT NULL Scheduling Method
BWD=Backward
FWD=Forward
15 ORIG_START_DATE Date(10) DATE Original Start Date
16 ORIG_START_TIME Time(15) TIMESTAMP Original Start Time
17 ORIG_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Original Start Shift
18 ORIG_END_DATE Date(10) DATE Original Due Date
19 ORIG_END_TIME Time(15) TIMESTAMP Original DueTime
20 ORIG_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Original Due Shift
21 NEW_START_DATE Date(10) DATE Start Date
22 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift

Prompt Table: %EDITTABLE2

23 NEW_START_TIME Time(15) TIMESTAMP Start Time
24 NEW_END_DATE Date(10) DATE Due Date
25 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift

Prompt Table: %EDITTABLE2

26 NEW_END_TIME Time(15) TIMESTAMP Due Time
27 PRDN_START_DATE Date(10) DATE Prdn Start Date
28 PRDN_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Start Shift

Prompt Table: %EDITTABLE2

29 PRDN_START_TIME Time(15) TIMESTAMP Prdn Start Time
30 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
31 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift

Prompt Table: %EDITTABLE2

32 PRDN_DUE_TIME Time(15) TIMESTAMP Prdn Due Time
33 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_SRCH

34 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
35 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
36 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
37 CUM_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Expected Yield %
38 COMP_CLOSE_DT Date(10) DATE Date of Completion
39 COMP_CLOSE_TIME Time(15) TIMESTAMP Time of Completion
40 LAB_CLOSE_DT Date(10) DATE Labor Close Date
41 LAB_CLOSE_TIME Time(15) TIMESTAMP Labor Close Time
42 ACCTG_CLOSE_DT Date(10) DATE Accounting Close Date
43 ACCTG_CLOSE_TIME Time(15) TIMESTAMP Accounting Close Time
44 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
45 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes

Y/N Table Edit

46 PLAN_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Change Indicator (Planning)
47 NET_CHANGE_EP Character(1) VARCHAR2(1) NOT NULL Enterprise Planning Net Change
48 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Default Value: N

49 LINK_TO_OM Character(1) VARCHAR2(1) NOT NULL Link to Order Management

Default Value: N

50 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
51 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
52 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
53 CP_COMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Field
54 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
55 PRINT_DOC Character(2) VARCHAR2(2) NOT NULL Print Prdn Documents
10=Do not Print
20=Ready for Printing
30=Printed
56 PRINT_COUNT Number(3,0) SMALLINT NOT NULL Print Count
57 PRDN_CREATED_DTTM DateTime(26) TIMESTAMP Production Created DateTime
58 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
59 PROD_PRCS_STATUS Character(2) VARCHAR2(2) NOT NULL 3/1/99 crc CN#PL800-10.0 FPO added 2 new flags(T and U) for remote cal
C=Delete Comp List & Reschedule
D=Delete Comp List Only
N=No Action
R=Reschedule Only
S=Start Release -S
T=Start Release -T
U=Start Release -U

Default Value: N

60 NEW_REVISION Character(4) VARCHAR2(4) NOT NULL New Revision
61 PROCESSED_CD Character(1) VARCHAR2(1) NOT NULL Processed Code
E=Processed with Error
I=In Process
N=Not Processed
Y=Processed

Default Value: N

62 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
63 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes

Default Value: N

64 TRDN_ORIG_PID Character(10) VARCHAR2(10) NOT NULL 1/1/99 jnw (CN#SF800-13) added field
65 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
66 ADJ_FIXED_SCRAP Number(12,4) DECIMAL(11,4) NOT NULL Adjusted Fixed Scrap Qty
67 SERIAL_IN_PRDN Character(1) VARCHAR2(1) NOT NULL Serial in Production
68 SF_YIELD_COST_FLG Character(1) VARCHAR2(1) NOT NULL Yield Cost Flag
69 ORIG_PRDN_END_QTY Number(12,4) DECIMAL(11,4) NOT NULL Expected Prdn Qty
70 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text