EN_TRNS_TMP

(SQL Table)
 Index Back

Eng Transfer Tmp Tbl

This record is used by the EG Transfers and BOM Mass Maintenance processes. It temporarily stores information about the process. For 8.1, this table now contains one row for every BOM being processed, instead of just one row for the entire process. 03/13/00 LAJ...Added en_delete_temp to indicate if this BOM can be updated or just reported in the BOM Message Maintenance panelgroup. 05/04/00 LAJ...Added EIP_DTA_STATUS. This status field will be used by the Mass Maint Staged BOM Validation program to determine which BOMs are eligible for re-processing.

# 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 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 COPY_DIRECTION Character(2) VARCHAR2(2) NOT NULL Copy From/To
EE=Engineering to Engineering
EM=Engineering to Manufacturing
ME=Manufacturing to Engineering
6 FROM_BOM_STATE Character(2) VARCHAR2(2) NOT NULL From BOM State
7 TO_BOM_STATE Character(2) VARCHAR2(2) NOT NULL To BOM State
8 FROM_BOM_TYPE Character(2) VARCHAR2(2) NOT NULL From BOM Type
9 TO_BOM_TYPE Character(2) VARCHAR2(2) NOT NULL To BOM Type
10 FROM_RTG_STATE Character(2) VARCHAR2(2) NOT NULL From Routing State
11 TO_RTG_STATE Character(2) VARCHAR2(2) NOT NULL To Routing State
12 FROM_RTG_TYPE Character(2) VARCHAR2(2) NOT NULL From Routing Type
13 TO_RTG_TYPE Character(2) VARCHAR2(2) NOT NULL To Routing Type
14 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
15 EN_TRANSFER_SOURCE Character(1) VARCHAR2(1) NOT NULL Engineering Transfer Source
M=Mass Change
T=BOMs and Routings Transfer
16 BOM_TRANSFER_STAT Character(1) VARCHAR2(1) NOT NULL 02/01/00 LAJ Took the word "Transfer" out of the label, since we now display this field for BOM Mass Maintenance Error correction. Also added new translate (Update) to distiguish between the EG transfer process status and the BOM Mass Maintenance Status 05/18/00 LAJ Added new label id for BOM results. This is used by the Mass Maint staged results panelgroup.
E=Error
O=No Change
T=Transfer
U=No Errors
W=Warning
17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
19 EN_DELETE_TEMP Character(1) VARCHAR2(1) NOT NULL 02/01/00 LAJ Used by BOM Mass Maintenance process to indicate if the data should not be deleted from the intermediate processing tables when the process is completed. This will allow the user to later restart the process.
D=Delete Staged Results
U=Stage Results
20 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold