PL_BOM_COMPS (SQL Table)	Index Back
Planning BOM Header Det-record Rag CN#SF800-12.0 Created Table. 10/27/99 lee - changed comp id prompt from mg_item_ncf2_vw to mg_itemmst_vw. this will allow planning items and exclude expensed items as comps.

PL_BOM_COMPS

(SQL Table)

Planning BOM Header Det-record

Rag CN#SF800-12.0 Created Table. 10/27/99 lee - changed comp id prompt from mg_item_ncf2_vw to mg_itemmst_vw. this will allow planning items and exclude expensed items as comps.

# 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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table: MG_ITEMMST_VW

4 DATE_IN_EFFECT Date(10) DATE NOT NULL 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

5 DATE_OBSOLETE Date(10) DATE NOT NULL Obsolete Date

6 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

#	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	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id. Prompt Table: MG_ITEMMST_VW
4	DATE_IN_EFFECT	Date(10)	DATE NOT NULL	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
5	DATE_OBSOLETE	Date(10)	DATE NOT NULL	Obsolete Date
6	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity