EN_AUTO_REV_TMP

(SQL Table)
Index Back

BOM Mass Maint Auto Rev

Used by BOM Mass Maintenance process to temporarily store which items will have revisions automatically created.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 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.
5 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
6 MASS_MAINT_CODE Character(10) VARCHAR2(10) NOT NULL Mass Maintenance Code
7 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
8 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.
9 EG_REV_UP Character(1) VARCHAR2(1) NOT NULL Revision Up