BUSINESS_UNITMASS_MAINT_CODEMASS_MAINT_SEQEN_BOM_MMC_SRC_SEQEN_BOM_MMC_REF(SQL Table) |
Index Back |
|---|---|
BOM Mass Maint RefDesig Search11/97 LAJ CN#EG750-3.0 This record is a child table to EN_BOM_MMC and stores the reference designators for the parent Mass Maintenance Code. 04/21/99 LAJ CN#EN800-5.0 The "new" fields were moved to a new record (en_bom_mmc_ref2). This is because there can now be many "search" rows per "new" row. This record will have one row for each ref desig search. |
| # | 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 | REF_DESIG | Character(20) | VARCHAR2(20) NOT NULL | Reference Designators |