EN_TRN_SUB_TMP (SQL Table)	Index Back
BOM Comp Subs Transfer Table Used by EG transfer process and BOM Mass Maintenance process. 04/27/00 LAJ...DUP key works on eip_ctl_id because the rows will be manually inserted into the buffer when en_trn_cmp_tmp is loaded. Then the keys are assigned before any new rows are saved. The Dup key could be placed lower, like sub_item_id, but then the subrecord could not be used as is.

EN_TRN_SUB_TMP

(SQL Table)

BOM Comp Subs Transfer Table

Used by EG transfer process and BOM Mass Maintenance process. 04/27/00 LAJ...DUP key works on eip_ctl_id because the rows will be manually inserted into the buffer when en_trn_cmp_tmp is loaded. Then the keys are assigned before any new rows are saved. The Dup key could be placed lower, like sub_item_id, but then the subrecord could not be used as is.

# 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
Prompt Table: MG_ITEM_OWN_VW

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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table: %EDITTABLE

8 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
Prompt Table: %EDITTABLE2

9 DATE_IN_EFFECT Date(10) DATE NOT NULL 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
Prompt Table: EN_REV_EDT_VW

10 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
Prompt Table: MG_ITEM_OWN_VW

11 SUB_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr.

12 EFFDT_FROM Date(10) DATE NOT NULL Effective Date From

13 EFFDT_TO Date(10) DATE NOT NULL Effective Date To

14 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
Default Value: 1

#	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 Prompt Table: MG_ITEM_OWN_VW
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	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id. Prompt Table: %EDITTABLE
8	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence Prompt Table: %EDITTABLE2
9	DATE_IN_EFFECT	Date(10)	DATE NOT NULL	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 Prompt Table: EN_REV_EDT_VW
10	SUB_ITM_ID	Character(18)	VARCHAR2(18) NOT NULL	11/30/99 RML Added label "Substitute" Prompt Table: MG_ITEM_OWN_VW
11	SUB_PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr.
12	EFFDT_FROM	Date(10)	DATE NOT NULL	Effective Date From
13	EFFDT_TO	Date(10)	DATE NOT NULL	Effective Date To
14	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate Default Value: 1