SF_PRDN_AREA_IT

(SQL Table)
 Index Back

Production Area/Item

CN#EG750-4.0 dbe (Engineering Routings) - Added RTG_STATE to statements that reference EN_RTG* tables. 971107 cam (CN# SF750-15.0) : Add checks for lead time flag to RTG_CODE FieldEdit and SaveEdit. Change prompt table for INV_ITEM_ID to use MG_ITEM_OWN1_VW. CN#PL750-DI-GPENN-68 jnw (production area) - added net_change_flg and net_change_ep fields and sed to net_change_flg CN# EN800-3.0, Sep 21 98, Anna Added field BomCode Now, bomcode and rtgcode are key fields. 09/23/98 SCC CN#EN800-4.0: Added date_in_effect as key 07/06/1999 whs CN# MG800-4.0 - Hold and Discontinue logic

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_OWN1_VW

4 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

6 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

Prompt Table: EN_PDO_BOM_RTG

7 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

Prompt Table: EN_REV_SRCH

8 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label PRIMARY
N=No
Y=Yes

Default Value: N

9 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

Default Value: Y

10 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish

Default Value: ISS

11 PA_IT_STATUS Character(4) VARCHAR2(4) NOT NULL Production Area Status
ACT=Active
INA=Inactive

Default Value: ACT

12 PRDN_RATE_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/18/99 SCC CN#IC800: Add label RATE_QTY_PER_SHIFT
13 NET_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Production Planning Net Change

Default Value: N

14 NET_CHANGE_EP Character(1) VARCHAR2(1) NOT NULL Enterprise Planning Net Change

Default Value: N

15 PA_IT_PRIORITY Number(3,0) SMALLINT NOT NULL Production Priority
16 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
17 LOCK_BOM_RTG_FLG Character(1) VARCHAR2(1) NOT NULL Copy BOM/Routing Flag

Y/N Table Edit

Default Value: N

18 PRDN_SCH_DEFN_FLG Character(4) VARCHAR2(4) NOT NULL Prdn Sched Definition
CMP=Completion Date
STR=Start Date

Default Value: CMP

19 BEG_SEQ Character(3) VARCHAR2(3) NOT NULL Beginning Sequence
20 DISP_PEND_COMP_ISS Character(1) VARCHAR2(1) NOT NULL 12/22/03 MDS (CN#MG880) Create new display pending component issue flag.

Y/N Table Edit

21 DISP_COMP_ISS_DUE Character(1) VARCHAR2(1) NOT NULL 12/22/03 MDS (CN#MG880) Create new display outstanding component issue flag.

Y/N Table Edit

22 PRDN_AREA_ITEM_TXT Long Character CLOB Text