CFG_MAPTO_VW6 (SQL View)	Index Back
Configurator View of map between Configurator Schema, object names and attributes where object id begins with '6'

CFG_MAPTO_VW6

(SQL View)

Configurator

View of map between Configurator Schema, object names and attributes where object id begins with '6'

SELECT CFG_SCHEMA_ID ,CFG_MAPTO_ID , CFG_OBJECT_NAME , CFG_ATTRIBUTE FROM PS_CFG_MAPTO_TBL WHERE CFG_MAPTO_ID LIKE '06%'

Parent record: CFG_MAPTO_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator

2 CFG_MAPTO_ID Character(4) VARCHAR2(4) NOT NULL Database field for mapping ids to recurring price fields
0101=Package Components
0201=Manufactured Components
0301=Purchased Components
0401=Product Selector
0501=Routing Operations
0601=Recurring Price
0602=Recurring Frequency
0603=Frequency Description
Prompt Table: CFG_RPRICE_VW1

3 CFG_OBJECT_NAME Character(64) VARCHAR2(64) NOT NULL Attribute name column on Configurator Output tab and Price tabs

4 CFG_ATTRIBUTE Character(64) VARCHAR2(64) NOT NULL Values on Configurator Output tab for selecting attributes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CFG_SCHEMA_ID	Character(18)	VARCHAR2(18) NOT NULL	Schema ID displayed on several pages of Configurator
2	CFG_MAPTO_ID	Character(4)	VARCHAR2(4) NOT NULL	Database field for mapping ids to recurring price fields 0101=Package Components 0201=Manufactured Components 0301=Purchased Components 0401=Product Selector 0501=Routing Operations 0601=Recurring Price 0602=Recurring Frequency 0603=Frequency Description Prompt Table: CFG_RPRICE_VW1
3	CFG_OBJECT_NAME	Character(64)	VARCHAR2(64) NOT NULL	Attribute name column on Configurator Output tab and Price tabs
4	CFG_ATTRIBUTE	Character(64)	VARCHAR2(64) NOT NULL	Values on Configurator Output tab for selecting attributes