EN_PDO_DOC_VW (SQL View)	Index Back
Prod option prompt table view 07/25/00 cel - used as a prompt table within documentum copy .. to pull the effective date.

EN_PDO_DOC_VW

(SQL View)

Prod option prompt table view

07/25/00 cel - used as a prompt table within documentum copy .. to pull the effective date.

SELECT DISTINCT a.business_unit , a.inv_item_id , a.bom_code , a.rtg_code , a.date_in_effect FROM PS_EN_PDO_BOM_RTG a

# 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

3 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database

4 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

5 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

#	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
3	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
4	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
5	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