EG_BOM_AUD9_VW (SQL View)	Index Back
BOM Audit-BOM code prompt 10/27/99 laj...CN#EN800-3.0 Created as prompt table for BOM code on BOM audit inquiry.

EG_BOM_AUD9_VW

(SQL View)

BOM Audit-BOM code prompt

10/27/99 laj...CN#EN800-3.0 Created as prompt table for BOM code on BOM audit inquiry.

SELECT DISTINCT business_unit , bom_code FROM PS_EG_BOM_AUDIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database