CFG_OBJTYPE_VW1

(SQL View)
Index Back

Configurator

View 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