EN_PDO_BR_PA

(SQL View)
 Index Back

Prdn Area for Prdn Option

09/25/98 SCC CN#EN800-4.0: Production Areas for Production Option

select a.business_unit, a.inv_item_id, a.bom_code, a.rtg_code, a.date_in_effect, prdn_area_code, %subrec(sf_pa_it_sbr,a) from PS_SF_PRDN_AREA_IT a

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_PDO_VW

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

Prompt Table: EN_BOM_HDRBC_VW

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

Prompt Table: SF_PRDN_AREA_VW

5 DATE_IN_EFFECT Date(10) DATE NOT NULL 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
6 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PA_ONLY_VW

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