| # |
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 |
ECO_STATE |
Character(2) |
VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order
CR=Engineering Chg Request
Default Value: CO
|
| 4 |
ECO_ASSY_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
New / Chg / Impacted Items
CH=Change
IM=Impacts
NW=New Item
Default Value: CH
|
| 5 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE
|
| 6 |
BOM_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
Default Value: PR
|
| 7 |
RTG_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Routing Type
PR=Production
RW=Rework
TD=Teardown
Default Value: PR
|
| 8 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
Prompt Table:
EN_BOM_HDRB3_VW
|
| 9 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
Prompt Table:
EG_ECR_RTGCD_VW
|
| 10 |
EG_ECO_TARGET |
Character(2) |
VARCHAR2(2) NOT NULL |
Affects
01=Manufacturing
02=Engineering
03=Mfg & Eng
Default Value: 02
|
| 11 |
ORIG_REV |
Character(4) |
VARCHAR2(4) NOT NULL |
Original Revision
Prompt Table:
EN_REV_SRCH
|
| 12 |
EFF_REV |
Character(4) |
VARCHAR2(4) NOT NULL |
Effective Revision
Prompt Table:
EN_REV_SRCH
|
| 13 |
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
|
| 14 |
ORIG_DATE_IN_EFF |
Date(10) |
DATE |
Original Eff Date
|
| 15 |
EN_AUTO_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
02/16/99 LAJ...CN#EG800-1.0
Yes/No field to indicate if new revisions should be created automatically.
Y/N Table Edit
Default Value: N
|
| 16 |
EG_REQ_BOMCHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires BOM Change
Y/N Table Edit
Default Value: N
|
| 17 |
EG_UPDATE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Update Mode
01=Automatic / Schedule
02=Manual
Default Value: 02
|
| 18 |
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.
|
| 19 |
EG_ORIG_DATE |
Date(10) |
DATE |
Orig Sched Rel Date
|
| 20 |
EG_REL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Release Status
C=Canceled
P=Pending
R=Released
Default Value: P
|
| 21 |
EG_ECO_ALERT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ECO Pending Alert
Y/N Table Edit
Default Value: Y
|
| 22 |
EG_REQ_RTGCHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Routing Change
Y/N Table Edit
Default Value: N
|
| 23 |
MASS_MAINT_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Mass Maintenance Code
Prompt Table:
%EDITTABLE2
|
| 24 |
MASS_MAINT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Maintenance Status
E=Error
N=
O=No Affect
P=Pending
S=Success
Default Value: P
|
| 25 |
EG_REV_UP |
Character(1) |
VARCHAR2(1) NOT NULL |
Revision Up
Y/N Table Edit
Default Value: N
|
| 26 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 27 |
EG_ECO_LN_REL_DTTM |
DateTime(26) |
TIMESTAMP |
01/10/00 LAJ CN#EN800-3.0
Contains the date/time that the ECO line was released to Manufacturing
|