CFG_MAPTO_VW2(SQL View) |
Index Back |
|---|---|
ConfiguratorDownload function that is displayed when "Manufactured Components" 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 = '0201' |
| # | 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: 0201 |
| 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 |