APS_WRKORDR_VW

(SQL View)
Index Back

APS Integ Workorder View


SELECT BUSINESS_UNIT , PRODUCTION_ID , PROD_STATUS , INV_ITEM_ID , PRODUCTION_TYPE , ORIG_PRDN_END_QTY , ORIG_UOM , BOM_CODE , RTG_CODE , ORIG_START_DATE , ORIG_END_DATE , PLAN_FROZEN_FLG , COMP_CLOSE_DT 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

Prompt Table: SP_BUMGOP_NONVW

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SF_PA_IT_ID_VW

5 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

6 ORIG_PRDN_END_QTY Number(12,4) DECIMAL(11,4) NOT NULL Expected Prdn Qty
7 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
8 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database

Prompt Table: %EDITTABLE

9 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Prompt Table: %EDITTABLE2

10 ORIG_START_DATE Date(10) DATE Original Start Date
11 ORIG_END_DATE Date(10) DATE Original Due Date
12 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes

Default Value: N

13 COMP_CLOSE_DT Date(10) DATE Date of Completion