SF_CMP_AREA_TMP

(SQL Table)
Index Back

# 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
7 SELECT_CB Character(1) VARCHAR2(1) NOT NULL Select Check Box
N=No
Y=Yes

Y/N Table Edit