EG_ECO_CH_ASSY(SQL Table) |
Index Back |
|---|---|
Engineering ECO / Chg 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 | EG_ECO_TARGET |
Character(2) | VARCHAR2(2) NOT NULL |
Affects
01=Manufacturing 02=Engineering 03=Mfg & Eng |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_VW |
| 5 | ORIG_DATE_IN_EFF | Date(10) | DATE | Original Eff Date |
| 6 | ORIG_REV | Character(4) | VARCHAR2(4) NOT NULL |
Original Revision
Prompt Table: EN_REVISION |
| 7 | DATE_IN_EFFECT | Date(10) | DATE NOT NULL | 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 |
| 8 | EFF_REV | Character(4) | VARCHAR2(4) NOT NULL |
Effective Revision
Prompt Table: EN_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 |
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 |