SF_CMPL_AREA_VW

(SQL View)
Index Back

SELECT a.business_unit , a.prdn_area_code , a.inv_item_id , a.bom_code , a.rtg_code , a.date_in_effect FROM PS_SF_PRDN_AREA_IT a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
5 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
6 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