SF_PRDN_HDR_VW

(SQL View)
 Index Back

Production ID's Header Record

04/47/97 CAM (CN# SF750-6.0) : Revise PRODUCTION_ID RowInit to include Scrap Inquiry panel group. 05/05/97 CAM (CN# SF750-7.0) : Same for Actual Hrs Inquiry. 05/20/97 CAM (CN# SF750-8.0) : Same for Earn Conv Cost Inquiry. 9/8/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement CN# EN800-3.0, Sep 21 98, Anna Added field BomCode

SELECT BUSINESS_UNIT , PRODUCTION_ID , PROD_STATUS , PRDN_AREA_CODE , INV_ITEM_ID , PRODUCTION_TYPE , ORIG_PRDN_QTY , ORIG_UOM , NEW_PRDN_QTY , NEW_UOM , BOM_CODE , RTG_CODE , REF_ROUTING_ITEM , SCHEDULING_METHOD , NEW_START_DATE , NEW_START_TIME , NEW_START_SHIFT , NEW_END_DATE , NEW_END_TIME , NEW_END_SHIFT , PRDN_START_DATE , PRDN_START_TIME , PRDN_START_SHIFT , PRDN_DUE_DATE , PRDN_DUE_TIME , PRDN_DUE_SHIFT , REVISION , COMPLETED_QTY , SCRAP_QTY , PERCENT_COMP , PICK_BATCH_ID , MA_PRDN_ID_FLG , PLAN_CHANGE_FLG , PLAN_FROZEN_FLG , LINK_TO_OM , BUSINESS_UNIT_OM , ORDER_NO , ORDER_INT_LINE_NO , CONFIG_CODE , PRINT_DOC , PRINT_COUNT , FROZEN_SUBSTITUTES , EXPECTED_PRDN_QTY , ORIG_PRDN_END_QTY , CUM_YIELD , SERIAL_IN_PRDN , TEXT254 FROM PS_SF_PRDNID_HEADR

# 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 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Default Value: NEXT

3 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
4 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PRDN_AREA

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

Prompt Table: SF_PA_IT_ID_VW

6 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

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 NEW_START_DATE Date(10) DATE Start Date
16 NEW_START_TIME Time(15) TIMESTAMP Start Time
17 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift
18 NEW_END_DATE Date(10) DATE Due Date
19 NEW_END_TIME Time(15) TIMESTAMP Due Time
20 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift
21 PRDN_START_DATE Date(10) DATE Prdn Start Date
22 PRDN_START_TIME Time(15) TIMESTAMP Prdn Start Time
23 PRDN_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Start Shift
24 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
25 PRDN_DUE_TIME Time(15) TIMESTAMP Prdn Due Time
26 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
27 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_SRCH

28 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
29 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
30 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
31 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
32 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

33 PLAN_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Change Indicator (Planning)

Y/N Table Edit

Default Value: Y

34 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Default Value: N

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

Y/N Table Edit

Default Value: N

36 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
37 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
38 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
39 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
40 PRINT_DOC Character(2) VARCHAR2(2) NOT NULL Print Prdn Documents
10=Do not Print
20=Ready for Printing
30=Printed
41 PRINT_COUNT Number(3,0) SMALLINT NOT NULL Print Count
42 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes
43 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
44 ORIG_PRDN_END_QTY Number(12,4) DECIMAL(11,4) NOT NULL Expected Prdn Qty
45 CUM_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Expected Yield %
46 SERIAL_IN_PRDN Character(1) VARCHAR2(1) NOT NULL Serial in Production
47 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text