EN_STGERRBOM_VW (SQL View)	Index Back
Agile - stage BOM errors 2/20/03 RML Agile Integration

EN_STGERRBOM_VW

(SQL View)

Agile - stage BOM errors

2/20/03 RML Agile Integration

SELECT DISTINCT d.TEXT254 , a.EIP_CTL_ID , a.EIP_PROGRAM , b.business_unit , b.INV_ITEM_ID , b.COMPONENT_ID , c.MESSAGE_TEXT , b.MESSAGE_SET_NBR , b.MESSAGE_NBR , a.PUBID , a.ORIG_DT_TIMESTAMP FROM PS_EO_EIP_CTL a , PS_EN_BOM_ERR_VW b , PSMSGCATDEFN c , PS_EN_TRN_HDR_TMP d WHERE a.EIP_CTL_ID = b.EIP_CTL_ID AND b.MESSAGE_SET_NBR = c.MESSAGE_SET_NBR AND b.MESSAGE_NBR = c.MESSAGE_NBR AND a.EIP_CTL_ID = d.EIP_CTL_ID AND b.BOM_TRANSFER_STAT <> 'W'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

3 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

6 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

7 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

9 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

10 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
2	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
3	EIP_PROGRAM	Character(10)	VARCHAR2(10) NOT NULL	Enterprise Components EIP (enterprise integration point) program field 601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
7	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
8	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
10	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.