EN_TRN_SUB_EVW

(SQL View)
 Index Back

BOM Comp Subs msg view

Used in BOM_SYNC message definition.

SELECT 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MG_ITEM_OWN_VW

3 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing
4 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
5 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
6 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

8 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

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

Prompt Table: MG_ITEM_OWN_VW

10 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.
11 EFFDT_FROM Date(10) DATE NOT NULL Effective Date From
12 EFFDT_TO Date(10) DATE NOT NULL Effective Date To
13 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

Default Value: 1