CFG_OBJTYPE_VW1(SQL View) |
Index Back |
---|---|
ConfiguratorView of pricing type for objects in the list price table, first column, Configurator Price tab |
SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CFG_OBJECT_TYPE' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE IN ('01','02') AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CFG_OBJECT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Configurator
01=Selection 02=Expression 03=Configuration Attribute 04=External Variable 05=Connections 06=Component 07=Connections 08=Selections Filtered List 09=Selections Filter Where 10=Selections Attributes 11=Package Components 12=Manufactured Components 13=Routing Operations 14=Purchased Components 15=Product Selector Default Value: 01 |
2 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |