EN_BOM_MMC_SUB (SQL Table)	Index Back
BOM Mass Maint Comp Sub Search 03/29/99 LAJ CN#EN800-1.0 This record is a child table to BOM mass maintenance search record. It allows the user to search by component substitutes. Due to the simultaneous enhancement (CN#EN800-5.0), this record needs to be separate from en_bom_mmc_sub2 to allow for a one to many relationship between the search and update information.

EN_BOM_MMC_SUB

(SQL Table)

BOM Mass Maint Comp Sub Search

03/29/99 LAJ CN#EN800-1.0 This record is a child table to BOM mass maintenance search record. It allows the user to search by component substitutes. Due to the simultaneous enhancement (CN#EN800-5.0), this record needs to be separate from en_bom_mmc_sub2 to allow for a one to many relationship between the search and update information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 MASS_MAINT_CODE Character(10) VARCHAR2(10) NOT NULL Mass Maintenance Code

3 MASS_MAINT_SEQ Number(3,0) SMALLINT NOT NULL Mass Maintenance Sequence

4 EN_BOM_MMC_SRC_SEQ Number(3,0) SMALLINT NOT NULL 04/23/99 LAJ CN#EN800-5.0 This is a new key for the search record in BOM Mass Maintenance. Since none of the fields are required on the component/output search panel, a new key was needed to allow multiple search rows.

5 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
Prompt Table: MG_ITEM_OWN_VW

6 EN_SRCH_SUB_PRINBR Character(3) VARCHAR2(3) NOT NULL 06/29/99 LAJ...CN#EN800-1.0 Used by Mass Maintenance when a substititute item is being changed.

7 EFFDT_FROM Date(10) DATE Effective Date From

8 EFFDT_TO Date(10) DATE Effective Date To

9 EN_SRCH_CONV_RATE Character(16) VARCHAR2(16) NOT NULL 06/29/99 LAJ...CN#EN800-1.0 Used by Mass Maintenance when a substititute item is being changed.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	MASS_MAINT_CODE	Character(10)	VARCHAR2(10) NOT NULL	Mass Maintenance Code
3	MASS_MAINT_SEQ	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Sequence
4	EN_BOM_MMC_SRC_SEQ	Number(3,0)	SMALLINT NOT NULL	04/23/99 LAJ CN#EN800-5.0 This is a new key for the search record in BOM Mass Maintenance. Since none of the fields are required on the component/output search panel, a new key was needed to allow multiple search rows.
5	SUB_ITM_ID	Character(18)	VARCHAR2(18) NOT NULL	11/30/99 RML Added label "Substitute" Prompt Table: MG_ITEM_OWN_VW
6	EN_SRCH_SUB_PRINBR	Character(3)	VARCHAR2(3) NOT NULL	06/29/99 LAJ...CN#EN800-1.0 Used by Mass Maintenance when a substititute item is being changed.
7	EFFDT_FROM	Date(10)	DATE	Effective Date From
8	EFFDT_TO	Date(10)	DATE	Effective Date To
9	EN_SRCH_CONV_RATE	Character(16)	VARCHAR2(16) NOT NULL	06/29/99 LAJ...CN#EN800-1.0 Used by Mass Maintenance when a substititute item is being changed.