EN_TRN_CMP_EVW

(SQL View)
 Index Back

BOM msg component view

Used in BOM_SYNC message definition. 10/09/02 PWF PL880-1.0 Removal of EP_OP_SEQ from record

SELECT BUSINESS_UNIT , INV_ITEM_ID , BOM_STATE , BOM_TYPE , BOM_CODE , COMPONENT_ID , OP_SEQUENCE , DATE_IN_EFFECT , DATE_OBSOLETE , POS_NBR , QTY_PER , QTY_CODE , YIELD , ECO_ID , PENDING_STATUS , SUB_SUPPLY_FLG , NON_OWN_FLAG , TEARDOWN_FLAG , ROLLUP_FLG , EN_SUBS_EXIST , INV_ITEM_SIZE , INV_ITEM_HEIGHT , INV_ITEM_LENGTH , INV_ITEM_WIDTH , INV_ITEM_WEIGHT , INV_ITEM_VOLUME , UNIT_MEASURE_DIM , UNIT_MEASURE_WT , UNIT_MEASURE_VOL , TEXT254 , INCR_CONS_TYPE , INCR_CONS_OFFSET , COMP_REV FROM PS_EN_TRN_CMP_TMP

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

Prompt Table: MG_ITEM_OWN_VW

3 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing
4 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
5 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
6 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
8 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
9 DATE_OBSOLETE Date(10) DATE NOT NULL Obsolete Date

Prompt Table: %EDITTABLE4

10 POS_NBR Number(4,0) SMALLINT NOT NULL Position Number
11 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
12 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

Default Value: ASY

13 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield

Default Value: 100

14 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
15 PENDING_STATUS Character(3) VARCHAR2(3) NOT NULL Status
ACT=Active
PEN=Pending

Default Value: ACT

16 SUB_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL Subcontract Supply

Y/N Table Edit

Default Value: N

17 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes

Y/N Table Edit

Default Value: N

18 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field

Y/N Table Edit

19 ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

20 EN_SUBS_EXIST Character(1) VARCHAR2(1) NOT NULL KPN 08/23/02: Added label PL_SUBS_EXIST
N=No
Y=Yes

Default Value: N

21 INV_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
22 INV_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
23 INV_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
24 INV_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
25 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
26 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume
27 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

Prompt Table: UNITS_TBL

28 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

Prompt Table: UNITS_TBL

29 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

Prompt Table: UNITS_TBL

30 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
31 INCR_CONS_TYPE Character(1) VARCHAR2(1) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time

Default Value: 1

32 INCR_CONS_OFFSET Number(16,4) DECIMAL(15,4) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
33 COMP_REV Character(4) VARCHAR2(4) NOT NULL 03/29/00 ST Created new field Component Revision.

Prompt Table: EN_REV_COMP_VW