| # |
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
|
| 7 |
RTG_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Routing Type
PR=Production
RW=Rework
TD=Teardown
|
| 8 |
BOM_CODE |
Number(2,0) |
SMALLINT NOT NULL |
CN# EN800-3.0, anna 09/21
added new field to database
|
| 9 |
RTG_CODE |
Number(2,0) |
SMALLINT NOT NULL |
Routing Code
|
| 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 |
EG_REQ_BOMCHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires BOM Change
Y/N Table Edit
Default Value: N
|
| 16 |
EG_UPDATE_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Update Mode
01=Automatic / Schedule
02=Manual
Default Value: 02
|
| 17 |
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.
|
| 18 |
EG_ORIG_DATE |
Date(10) |
DATE |
Orig Sched Rel Date
|
| 19 |
EG_REL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Release Status
C=Canceled
P=Pending
R=Released
Default Value: P
|
| 20 |
EG_ECO_ALERT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ECO Pending Alert
Y/N Table Edit
Default Value: Y
|
| 21 |
EG_REQ_RTGCHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Routing Change
|