BUSINESS_UNITMASS_MAINT_CODEMASS_MAINT_SEQA=Add Reference Designator
C=Change Reference Designator
D=Delete Reference Designator
EN_BOM_MMC_REF2(SQL Table) |
Index Back |
|---|---|
BOM Mass Maint RefDesig Update04/21/99 LAJ CN#EN800-5.0 The "new" fields were moved here from en_bom_mmc_ref. This is because there can now be many "search" rows per "new" row. This record is a child table to EN_BOM_MMC and stores the "new" reference designators for the parent Mass Maintenance Code. |
| # | 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 | REF_DESIG | Character(20) | VARCHAR2(20) NOT NULL | Reference Designators |
| 5 | NEW_REF_DESIG | Character(20) | VARCHAR2(20) NOT NULL | New Reference Designator |
| 6 | EN_BOM_MMC_REF_FLG | Character(1) | VARCHAR2(1) NOT NULL |
11/97 LAJ CN#EN750-3.0
Reference Designator flag used in BOM Mass Maintenance. Specifies if the ref desig information is to be added, changed or deleted.
A=Add Reference Designator C=Change Reference Designator D=Delete Reference Designator |