BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
ECO_IDINV_ITEM_IDPrompt Table: MG_ITEM_VW
Prompt Table: EN_REVISION
01=Automatic / Schedule
02=Manual
Default Value: 02
Default Value: %date
EG_ECO_NW_ASSY(SQL Table) |
Index Back |
|---|---|
Engineering ECO / New Assembly |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | ECO_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_VW |
| 4 | EG_UDEF_STEP | Character(10) | VARCHAR2(10) NOT NULL | Eng Activity |
| 5 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 6 | ORIG_DATE_IN_EFF | Date(10) | DATE | Original Eff Date |
| 7 | REVISION | Character(4) | VARCHAR2(4) NOT NULL |
01/27/2000 RML Added "As of" label
Prompt Table: EN_REVISION |
| 8 | ORIG_REV | Character(4) | VARCHAR2(4) NOT NULL | Original Revision |
| 9 | EG_UPDATE_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Update Mode
01=Automatic / Schedule 02=Manual Default Value: 02 |
| 10 | EG_RELEASE_DATE | Date(10) | DATE NOT NULL |
07/31/00...LAJ
Added eg_release_date2 label id. This will be used on the ECO line status page.
Default Value: %date |
| 11 | EG_ORIG_DATE | Date(10) | DATE | Orig Sched Rel Date |