EN_BOM_MMC_HDR

(SQL Table)
Index Back

BOM Mass Maint Code Header

10/97 LAJ CN#EG750-3.0 This record stores the header information for a Mass Maintenance Code. 08/13/98 CN#MG800-3.0 HK Added Origin to the record. 04/02/99 LAJ CN#EG800-1.0 Added en_auto_rev for indicating if the mass maintenance code will be auto-generating revisions.

# 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

2 MASS_MAINT_CODE Character(10) VARCHAR2(10) NOT NULL Mass Maintenance Code
3 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
4 EN_AUTO_REV Character(1) VARCHAR2(1) NOT NULL 02/16/99 LAJ...CN#EG800-1.0 Yes/No field to indicate if new revisions should be created automatically.

Y/N Table Edit

Default Value: N

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description