EN_PDO_RTG1_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 routing code

EN_PDO_RTG1_VW

(SQL View)

Prod option prompt table view

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

SELECT DISTINCT a.business_unit , a.inv_item_id , a.bom_code , a.rtg_code 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

#	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