CP_CONFIG_PO_VW (SQL View)	Index Back
CP Configuration Code PO View This view was created to allow the updating of the CP_CONFIG record from within Order Entry. The BUSINESS_UNIT field creates conflicts with the OM BUSINESS_UNIT.

CP_CONFIG_PO_VW

(SQL View)

CP Configuration Code PO View

This view was created to allow the updating of the CP_CONFIG record from within Order Entry. The BUSINESS_UNIT field creates conflicts with the OM BUSINESS_UNIT.

select BUSINESS_UNIT, INV_ITEM_ID, CONFIG_CODE, CP_TEMPLATE_ID from PS_CP_CONFIG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: CP_ITM_CFGCD_VW

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

4 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field
Prompt Table: CP_TEMP_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: CP_ITM_CFGCD_VW
3	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
4	CP_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID Field Prompt Table: CP_TEMP_HDR