EN_TRN_SUB_VW (SQL View)	Index Back
BOM sub trans tbl view 05/11/00 HK Created. This table is a view of en_trn_sub_tmp table. However, no DUP keys here. This is used in BOM_SYNC message.

EN_TRN_SUB_VW

(SQL View)

BOM sub trans tbl view

05/11/00 HK Created. This table is a view of en_trn_sub_tmp table. However, no DUP keys here. This is used in BOM_SYNC message.

SELECT EIP_CTL_ID ,BUSINESS_UNIT ,INV_ITEM_ID ,BOM_STATE ,BOM_TYPE ,BOM_CODE ,COMPONENT_ID ,OP_SEQUENCE ,DATE_IN_EFFECT ,SUB_ITM_ID ,SUB_PRIORITY_NBR ,EFFDT_FROM ,EFFDT_TO ,CONVERSION_RATE FROM PS_EN_TRN_SUB_TMP

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

8 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

9 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

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

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 Effective Date From

13 EFFDT_TO Date(10) DATE Effective Date To

14 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

#	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	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
8	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
9	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
10	SUB_ITM_ID	Character(18)	VARCHAR2(18) NOT NULL	11/30/99 RML Added label "Substitute"
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	Effective Date From
13	EFFDT_TO	Date(10)	DATE	Effective Date To
14	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate