EG_BOM_HDCM_VW

(SQL View)
 Index Back

EBOM Header Doc Maint VW

CN# EN800-3.0, Sep 21 98, Anna Added field BomCode

select a.business_unit, a.inv_item_id, a.bom_state, a.bom_type, a.bom_code, %subrec(dc_dc_sbr,a) from PS_EN_BOM_HDR_DC 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: MASTER_ITEM_TBL

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

Default Value: PR

5 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
6 DC_OBJECT_ID Character(16) VARCHAR2(16) NOT NULL Document Object ID
7 DC_FIXED Character(1) VARCHAR2(1) NOT NULL fixed to specific doc version
N=No
Y=Yes

Y/N Table Edit

Default Value: N

8 DC_OBJECT_NAME Character(254) VARCHAR2(254) NOT NULL Document Name
9 DC_TITLE Character(64) VARCHAR2(64) NOT NULL Title