EN_TRN_CMP_VW (SQL View)	Index Back
BOM Comp Transfer Tbl View 05/11/00 HK Created. This table is a view of en_trn_cmp_tmp table. However, no DUP keys here. This is used in BOM_SYNC message.

EN_TRN_CMP_VW

(SQL View)

BOM Comp Transfer Tbl View

05/11/00 HK Created. This table is a view of en_trn_cmp_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 ,DATE_OBSOLETE ,POS_NBR ,QTY_PER ,QTY_CODE ,YIELD ,ECO_ID ,PENDING_STATUS ,SUB_SUPPLY_FLG ,NON_OWN_FLAG ,TEARDOWN_FLAG ,ROLLUP_FLG ,EN_SUBS_EXIST ,INV_ITEM_SIZE ,INV_ITEM_HEIGHT ,INV_ITEM_LENGTH ,INV_ITEM_WIDTH ,INV_ITEM_WEIGHT ,INV_ITEM_VOLUME ,UNIT_MEASURE_DIM ,UNIT_MEASURE_WT ,UNIT_MEASURE_VOL ,TEXT254 ,INCR_CONS_TYPE ,INCR_CONS_OFFSET ,COMP_REV ,COPY_DIRECTION ,BUSINESS_UNIT_TO ,BOM_TRANSFER_STAT ,EN_MMC_UPDATE_FLG ,MASS_MAINT_CODE ,EN_MMC_SEQ_FLG01 ,EN_MMC_SEQ_FLG02 ,EN_MMC_SEQ_FLG03 ,EN_MMC_SEQ_FLG04 ,EN_MMC_SEQ_FLG05 ,EN_MMC_SEQ_FLG06 ,EN_MMC_SEQ_FLG07 ,EN_MMC_SEQ_FLG08 ,EN_MMC_SEQ_FLG09 ,EN_MMC_SEQ_FLG10 ,EN_MMC_SEQ_FLG11 ,EN_MMC_SEQ_FLG12 ,EN_MMC_SEQ_FLG13 ,EN_MMC_SEQ_FLG14 ,EN_MMC_SEQ_FLG15 ,EN_MMC_SEQ_FLG16 ,EN_MMC_SEQ_FLG17 ,EN_MMC_SEQ_FLG18 ,EN_MMC_SEQ_FLG19 ,EN_MMC_SEQ_FLG20 FROM PS_EN_TRN_CMP_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
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: %EDITTABLE3

10 DATE_OBSOLETE Date(10) DATE NOT NULL Obsolete Date
Prompt Table: %EDITTABLE4

11 POS_NBR Number(4,0) SMALLINT NOT NULL Position Number

12 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

13 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
Default Value: ASY

14 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield
Default Value: 100

15 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number

16 PENDING_STATUS Character(3) VARCHAR2(3) NOT NULL Status
ACT=Active
PEN=Pending
Default Value: ACT

17 SUB_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL Subcontract Supply
Y/N Table Edit
Default Value: N

18 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
Y/N Table Edit
Default Value: N

19 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field
Y/N Table Edit

20 ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: N

21 EN_SUBS_EXIST Character(1) VARCHAR2(1) NOT NULL KPN 08/23/02: Added label PL_SUBS_EXIST
N=No
Y=Yes
Default Value: N

22 INV_ITEM_SIZE Character(5) VARCHAR2(5) NOT NULL Item Size

23 INV_ITEM_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Height

24 INV_ITEM_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Length

25 INV_ITEM_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Width

26 INV_ITEM_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Item Weight

27 INV_ITEM_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Volume

28 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM
Prompt Table: UNITS_TBL

29 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
Prompt Table: UNITS_TBL

30 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
Prompt Table: UNITS_TBL

31 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

32 INCR_CONS_TYPE Character(1) VARCHAR2(1) NOT NULL 07/22/02 EGS (CN#PL880-1): Added
1=None
2=Over Time
Default Value: 1

33 INCR_CONS_OFFSET Number(16,4) DECIMAL(15,4) NOT NULL 07/22/02 EGS (CN#PL880-1): Added

34 COMP_REV Character(4) VARCHAR2(4) NOT NULL 03/29/00 ST Created new field Component Revision.
Prompt Table: EN_REV_COMP_VW

35 COPY_DIRECTION Character(2) VARCHAR2(2) NOT NULL Copy From/To
EE=Engineering to Engineering
EM=Engineering to Manufacturing
ME=Manufacturing to Engineering

36 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

37 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

38 EN_MMC_UPDATE_FLG Character(1) VARCHAR2(1) NOT NULL Mass Maintenance Update Flag

39 MASS_MAINT_CODE Character(10) VARCHAR2(10) NOT NULL Mass Maintenance Code

40 EN_MMC_SEQ_FLG01 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 1

41 EN_MMC_SEQ_FLG02 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 2

42 EN_MMC_SEQ_FLG03 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 3

43 EN_MMC_SEQ_FLG04 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 4

44 EN_MMC_SEQ_FLG05 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 5

45 EN_MMC_SEQ_FLG06 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 6

46 EN_MMC_SEQ_FLG07 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 7

47 EN_MMC_SEQ_FLG08 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 8

48 EN_MMC_SEQ_FLG09 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 9

49 EN_MMC_SEQ_FLG10 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 10

50 EN_MMC_SEQ_FLG11 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 11

51 EN_MMC_SEQ_FLG12 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 12

52 EN_MMC_SEQ_FLG13 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 13

53 EN_MMC_SEQ_FLG14 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 14

54 EN_MMC_SEQ_FLG15 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 15

55 EN_MMC_SEQ_FLG16 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 16

56 EN_MMC_SEQ_FLG17 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 17

57 EN_MMC_SEQ_FLG18 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 18

58 EN_MMC_SEQ_FLG19 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 19

59 EN_MMC_SEQ_FLG20 Number(3,0) SMALLINT NOT NULL Mass Maintenance Seq Flag 20

#	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: %EDITTABLE3
10	DATE_OBSOLETE	Date(10)	DATE NOT NULL	Obsolete Date Prompt Table: %EDITTABLE4
11	POS_NBR	Number(4,0)	SMALLINT NOT NULL	Position Number
12	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
13	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order Default Value: ASY
14	YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Component Yield Default Value: 100
15	ECO_ID	Character(10)	VARCHAR2(10) NOT NULL	ECO Number
16	PENDING_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status ACT=Active PEN=Pending Default Value: ACT
17	SUB_SUPPLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Subcontract Supply Y/N Table Edit Default Value: N
18	NON_OWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o N=No Y=Yes Y/N Table Edit Default Value: N
19	TEARDOWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	01/28/99 jnw (CN#SF800-13) added field Y/N Table Edit
20	ROLLUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. Y/N Table Edit Default Value: N
21	EN_SUBS_EXIST	Character(1)	VARCHAR2(1) NOT NULL	KPN 08/23/02: Added label PL_SUBS_EXIST N=No Y=Yes Default Value: N
22	INV_ITEM_SIZE	Character(5)	VARCHAR2(5) NOT NULL	Item Size
23	INV_ITEM_HEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Height
24	INV_ITEM_LENGTH	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Length
25	INV_ITEM_WIDTH	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Width
26	INV_ITEM_WEIGHT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item Weight
27	INV_ITEM_VOLUME	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Volume
28	UNIT_MEASURE_DIM	Character(3)	VARCHAR2(3) NOT NULL	Dimension UOM Prompt Table: UNITS_TBL
29	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM Prompt Table: UNITS_TBL
30	UNIT_MEASURE_VOL	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM Prompt Table: UNITS_TBL
31	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
32	INCR_CONS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	07/22/02 EGS (CN#PL880-1): Added 1=None 2=Over Time Default Value: 1
33	INCR_CONS_OFFSET	Number(16,4)	DECIMAL(15,4) NOT NULL	07/22/02 EGS (CN#PL880-1): Added
34	COMP_REV	Character(4)	VARCHAR2(4) NOT NULL	03/29/00 ST Created new field Component Revision. Prompt Table: EN_REV_COMP_VW
35	COPY_DIRECTION	Character(2)	VARCHAR2(2) NOT NULL	Copy From/To EE=Engineering to Engineering EM=Engineering to Manufacturing ME=Manufacturing to Engineering
36	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
37	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
38	EN_MMC_UPDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Mass Maintenance Update Flag
39	MASS_MAINT_CODE	Character(10)	VARCHAR2(10) NOT NULL	Mass Maintenance Code
40	EN_MMC_SEQ_FLG01	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 1
41	EN_MMC_SEQ_FLG02	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 2
42	EN_MMC_SEQ_FLG03	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 3
43	EN_MMC_SEQ_FLG04	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 4
44	EN_MMC_SEQ_FLG05	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 5
45	EN_MMC_SEQ_FLG06	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 6
46	EN_MMC_SEQ_FLG07	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 7
47	EN_MMC_SEQ_FLG08	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 8
48	EN_MMC_SEQ_FLG09	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 9
49	EN_MMC_SEQ_FLG10	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 10
50	EN_MMC_SEQ_FLG11	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 11
51	EN_MMC_SEQ_FLG12	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 12
52	EN_MMC_SEQ_FLG13	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 13
53	EN_MMC_SEQ_FLG14	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 14
54	EN_MMC_SEQ_FLG15	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 15
55	EN_MMC_SEQ_FLG16	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 16
56	EN_MMC_SEQ_FLG17	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 17
57	EN_MMC_SEQ_FLG18	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 18
58	EN_MMC_SEQ_FLG19	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 19
59	EN_MMC_SEQ_FLG20	Number(3,0)	SMALLINT NOT NULL	Mass Maintenance Seq Flag 20