EN_BOMOUTCST_VW (SQL View)	Index Back
Bom Outputs/Costs view CEL: 2/1999: EN800-6.0 This view combines the en_bom_outputs table with the ce_itemcost1_vw which has the sub-totals for each item. This view is used in the Bom Costing panels. Please note that in order to get related displays to work with this view, that what is the inv_item_id within en_bom_outputs is called en_bomout_inv_item within this grid. The inv_item_id field is really corresponding to the mg_output_item field within en_bom_outputs. PWF 04/06/03 Used this %Round(%DecMult (A.MG_OUTPUT_QTY ,B.TL_COST),4) AS TL_EXPANDED_COST instead of A.MG_OUTPUT_QTY*B.tl_cost

EN_BOMOUTCST_VW

(SQL View)

Bom Outputs/Costs view

CEL: 2/1999: EN800-6.0 This view combines the en_bom_outputs table with the ce_itemcost1_vw which has the sub-totals for each item. This view is used in the Bom Costing panels. Please note that in order to get related displays to work with this view, that what is the inv_item_id within en_bom_outputs is called en_bomout_inv_item within this grid. The inv_item_id field is really corresponding to the mg_output_item field within en_bom_outputs. PWF 04/06/03 Used this %Round(%DecMult (A.MG_OUTPUT_QTY ,B.TL_COST),4) AS TL_EXPANDED_COST instead of A.MG_OUTPUT_QTY*B.tl_cost

SELECT DISTINCT A.BUSINESS_UNIT , A.MG_OUTPUT_ITEM AS INV_ITEM_ID , A.MG_OUTPUT_ITEM , A.MG_OUTPUT_TYPE , A.INV_ITEM_ID AS EN_BOMOUT_INV_ITEM , A.BOM_CODE ,B.RTG_CODE ,A.BOM_STATE ,A.BOM_TYPE , A.MG_OUTPUT_COST_PCT , A.MG_OUTPUT_QTY , A.DATE_IN_EFFECT , A.DATE_OBSOLETE , A.MG_OUTPUT_QTY_CODE , B.CE_COST_TYPE ,B.COST_VERSION , B.TL_COST , B.TL_LL_COST , %Round(%DecMult (A.MG_OUTPUT_QTY ,B.TL_COST),4) AS TL_EXPANDED_COST FROM PS_EN_BOM_OUTPUTS A , PS_CE_ITEMCOST1_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.MG_OUTPUT_ITEM = B.INV_ITEM_ID AND A.BOM_CODE = B.BOM_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 MG_OUTPUT_ITEM Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.

4 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste

5 EN_BOMOUT_INV_ITEM Character(18) VARCHAR2(18) NOT NULL Temp Inv Item Id - Bom Output

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

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

8 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing

9 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework

10 MG_OUTPUT_COST_PCT Number(3,0) SMALLINT NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item's cost percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the cost to make the BOM goes to each output (co-product).

11 MG_OUTPUT_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item quantity on a Bill of Materials. This value is assumed to be in the UOM of the output item it's associated to. KPN 08/23/02: Added label Quantity

12 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

13 DATE_OBSOLETE Date(10) DATE Obsolete Date

14 MG_OUTPUT_QTY_CODE Character(3) VARCHAR2(3) NOT NULL 01/28/98 (CN#EN800-6.0) LAJ...Created Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly
ORD=Order

15 CE_COST_TYPE Character(4) VARCHAR2(4) NOT NULL Cost Type

16 COST_VERSION Character(10) VARCHAR2(10) NOT NULL Cost Version

17 TL_COST Number(15,4) DECIMAL(14,4) NOT NULL This Level Cost

18 TL_LL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL This/Lower Level Costs

19 TL_EXPANDED_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL This Level expanded cost

#	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	MG_OUTPUT_ITEM	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
4	MG_OUTPUT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste
5	EN_BOMOUT_INV_ITEM	Character(18)	VARCHAR2(18) NOT NULL	Temp Inv Item Id - Bom Output
6	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
7	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
8	BOM_STATE	Character(2)	VARCHAR2(2) NOT NULL	BOM State EN=Engineering PR=Manufacturing
9	BOM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	03/26/00 RML Added a label "Type" PR=Production RW=Rework
10	MG_OUTPUT_COST_PCT	Number(3,0)	SMALLINT NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item's cost percentage on a Bill of Material. Since it is a percentage, it cannot store a value greater than 100. It is used to determine what percentage of the cost to make the BOM goes to each output (co-product).
11	MG_OUTPUT_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item quantity on a Bill of Materials. This value is assumed to be in the UOM of the output item it's associated to. KPN 08/23/02: Added label Quantity
12	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
13	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date
14	MG_OUTPUT_QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	01/28/98 (CN#EN800-6.0) LAJ...Created Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future. ASY=Assembly ORD=Order
15	CE_COST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Cost Type
16	COST_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Cost Version
17	TL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	This Level Cost
18	TL_LL_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This/Lower Level Costs
19	TL_EXPANDED_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This Level expanded cost