SF_CFG_OUT_VW (SQL View)	Index Back
Output Cfg Code View

SF_CFG_OUT_VW

(SQL View)

Output Cfg Code View

SELECT BUSINESS_UNIT , INV_ITEM_ID , CONFIG_CODE FROM PS_CP_CONFIG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 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.

3 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator