SF_BOM_COMPS_VW

(SQL View)
 Index Back

SF BOM Component View

11/12/97 DDW CN# MG750-7.0 Added Source_Code to record and updated view text 11/30/97 DDW CN# MG750-6.0 Replaced QTY_PER with SF_QTY_PER. 12/05/97 FRD CN# MG750-7.0 omit components with sub-supply = 'Y' CN# EN800-3.0, 01/22/99 anna added bomcode 01/28/99 JNW (CN#SF800-13) add teardown_flag 06/22/99 SGL CN# EN800 8.0 removed BOM_TYPE = 'PR' from SQL so will search for all BOM types 09/29/02 pwf CN#PL880-1.0 Added INCR_REL_TYPE and INCR_REL_OFFSET to view.

SELECT a.business_unit , a.inv_item_id , a.bom_code , a.bom_state , a.bom_type , a.component_id , a.op_sequence , a.date_in_effect , a.date_obsolete , a.pos_nbr , a.qty_per , a.qty_code , a.yield , a.eco_id , a.pending_status , b.phantom_item_flag , a.sub_supply_flg , a.non_own_flag , a.teardown_flag , a.inv_item_size , a.inv_item_height , a.inv_item_length , a.inv_item_width , a.inv_item_weight , a.inv_item_volume , a.unit_measure_dim , a.unit_measure_wt , a.unit_measure_vol , b.issue_method , b.source_code , a.text254 , a.incr_cons_type , a.incr_cons_offset FROM ps_en_bom_comps a , PS_BU_ITEMS_INV b WHERE a.business_unit = b.business_unit AND a.component_id = b.inv_item_id AND a.bom_state = 'PR' AND a.sub_supply_flg = 'N'

# 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_APPR_VW

3 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
4 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing
5 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
6 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: MG_ITEM_APPR_VW

7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: EN_RTG_OPS

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

Prompt Table: EN_REV_EDT_VW

9 DATE_OBSOLETE Date(10) DATE NOT NULL Obsolete Date

Prompt Table: EN_REV_ODT_VW

10 POS_NBR Number(4,0) SMALLINT NOT NULL Position Number
11 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label 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 PHANTOM_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Phantom Item

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

18 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

19 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field
20 INV_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size
21 INV_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height
22 INV_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length
23 INV_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width
24 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight
25 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume
26 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

29 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
30 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning
31 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
32 INCR_CONS_TYPE Character(1) VARCHAR2(1) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time
33 INCR_CONS_OFFSET Number(16,4) DECIMAL(15,4) NOT NULL 07/22/02 EGS (CN#PL880-1): Added