BUSINESS_UNITMASS_MAINT_CODEMASS_MAINT_SEQPrompt Table: MG_ITEM_OWN_VW
Prompt Table: MG_ITEM_OWN_VW
A=Add Reference Designator
C=Change Reference Designator
D=Delete Reference Designator
EN_BOM_MMC_SUB2(SQL Table) |
Index Back |
|---|---|
BOM Mass Maint Comp Sub Update03/29/99 LAJ CN#EN800-1.0 This record is a child table to BOM mass maintenance search record. It allows the user to change component substitutes. 10/02/00 LAJ CN#MG801-2.0 Added Dup key on sub_itm_id. Otherwise, was not able to create a MMC where more than one item was added/changed/deleted as a substitute. |
| # | 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 | SUB_ITM_ID | Character(18) | VARCHAR2(18) NOT NULL |
11/30/99 RML Added label "Substitute"
Prompt Table: MG_ITEM_OWN_VW |
| 5 | 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. |
| 6 | EFFDT_FROM | Date(10) | DATE | Effective Date From |
| 7 | EFFDT_TO | Date(10) | DATE | Effective Date To |
| 8 | 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. |
| 9 | EN_NEW_SUB_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
03/30/99 LAJ...CN#EN800-1.0
Used by Mass Maintenance when a substititute item is being changed.
Prompt Table: MG_ITEM_OWN_VW |
| 10 | EN_NEW_SUB_PRI_NBR | Character(3) | VARCHAR2(3) NOT NULL | New Substitute Priority |
| 11 | EN_NEW_EFFDT_FROM | Date(10) | DATE | 03/30/99 LAJ...EN800-1.0 Used by BOM Mass Maintenance when changing effect dates on a component's substitute. |
| 12 | EN_NEW_EFFDT_TO | Date(10) | DATE | 03/30/99 LAJ...EN800-1.0 Used by BOM Mass Maintenance when changing effect dates on a component's substitute. |
| 13 | EN_NEW_CONV_RATE | Character(16) | VARCHAR2(16) NOT NULL | New Conversion Rate |
| 14 | 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 |