CFG_MAPTO_VW4(SQL View) |
Index Back |
---|---|
ConfiguratorDownload function that is displayed when "Product Selector" is selected in the Requested Properties for Configurator output |
SELECT CFG_SCHEMA_ID ,CFG_MAPTO_ID , CFG_OBJECT_NAME , CFG_ATTRIBUTE FROM PS_CFG_MAPTO_TBL WHERE CFG_MAPTO_ID = '0401' |
# | 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 Default Value: 0401 |
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 |