SF_BOM_CP_VW

(SQL View)
 Index Back

SF BOM Component View

/* CN# EN800-3.0, 01/22/99 anna added bomcode */

select a.business_unit, a.inv_item_id, a.bom_code, 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.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, a.text254 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.bom_type = 'PR'

# 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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: MG_ITEM_APPR_VW

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

Prompt Table: EN_RTG_OPS

6 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

7 DATE_OBSOLETE Date(10) DATE NOT NULL Obsolete Date

Prompt Table: EN_REV_ODT_VW

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

Default Value: ASY

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

Default Value: 100

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

Default Value: ACT

14 PHANTOM_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Phantom Item

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

16 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

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

26 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
27 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text