EN_ASSY_TRN_TMP

(SQL Table)
 Index Back

List of assemblies to transfer

Used by Engineering Transfers and BOM Mass Maintenance to temporarily store the assemblies to be processed. It is based on the run control request and may be an explicit list of assemblies, a range of assemblies or assemblies from an ECO. 05/21/99 LAJ...CN#EN800-3.0 Added BOM and RTG states and types. 11/22/99 HK Replaced process_instance with eip_ctl_id

# 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 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing
5 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
6 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
7 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
EN=Engineering
PR=Manufacturing
8 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown
9 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
10 MASS_MAINT_CODE Character(10) VARCHAR2(10) NOT NULL Mass Maintenance Code
11 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
12 EG_REQ_BOMCHG Character(1) VARCHAR2(1) NOT NULL Requires BOM Change
13 EG_REQ_RTGCHG Character(1) VARCHAR2(1) NOT NULL Requires Routing Change
14 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.
15 EG_REV_UP Character(1) VARCHAR2(1) NOT NULL Revision Up